Ankush Kumar Singh's Projects
SQL project to analyze online music store data This project is used to analyze the music playlist database. You can examine the dataset with SQL and help the store understand its business growth by answering simple questions. Database and Tools :- *Postgre SQL *PgAdmin4
Project Understanding: A data analyst sits between the business and the data. One of Accenture’s Managing Directors, Mae Mulligan, is the client lead for Social Buzz. She has reviewed the brief provided by Social Buzz and has assembled a diverse team of Accenture experts to deliver the project.
📈 Based on the report insights ,here are the outcomes of the sales :- 1️⃣ Women are more likely to purchase (65%) than men. 2️⃣ Maharashtra , Karnataka and Uttar Pradesh were the top contributors to sales (35%). 3️⃣ The adult age group (30-49 yrs) made the most contributions(50%). 4️⃣ Amazon, Flipkart and Myntra channels were the contributer.
Various steps were followed some of them are:-Step 1: Connecting Database (Excel, SQL, Web, Etc.) Step 2: Analyzing Tables & Relations Step 3: Data Cleaning - Power Query Editor DAX Step 4: Developing Visualization Models Step 5: Creating a Report and Pin to Dashboard
👋 Hi, I’m @ANKUSH KUMAR SINGH 👀 I’m interested in Data Analytics 🌱 I’m currently learning tolls like My SQL , Power BI, Advance Excel & Pythons currently i am looking for a job in the field of data .
Welcome to my work space
🎓 𝙇𝙚𝙖𝙧𝙣𝙞𝙣𝙜𝙨: •Performed data cleaning and manipulation. •Performed exploratory data analysis (EDA) using Python libraries. •Improved customer experience by identifying potential customers across different states, occupations, genders, and age groups.
Confirmed , Death & Recoverd Cases across the World.->Insight are as below⬇️ ->maximum number of confirmed cases is in US Region. (us confirmed cases = 1039909(MAX)). ->least confirmed cases are in Yemen Region. (Yemen confirmed cases = 6(MINIMUM)).
I have created a HR Analytics Dashboard on Power BI that shows the detailed attrition analysis of employees within an organization. The key learnings from this project include: -Data Cleaning -Data Processing -Data Visualization -Understanding DAX expressions and Measures use of KPIs, donut charts
This is a E-commerce site
Project Learnings: Created an interactive sales dashboard to track and analyse online sales data. Used complex parameters to drill down in worksheets and customization using filters and slicers Created connections, joined new tables, calculated to manipulate data and enabled user-driven parameters for visualizations.
Netflix Data Analysis Project
Call center Analysis, Customer Retention & Diversity & Inclusion
HTML5 , CSS & JS
Throughout the project, I honed my skills in data transformation, data modeling, and report building. I leveraged Power BI's robust capabilities to identify sales trends, analyze product performance, and gain valuable insights into our customer behavior.
There are 4 modules in this virtual experience programme. ♦ Framing the Business Scenario ♦ Choosing the Right Visuals ♦ Creating Effective Visuals ♦ Communicating Insights and Analysis
Successfully created My first Report based on the TechnoEdge sales dataset contains a wealth of information about the company's sales performance, including key metrics such as Sales, Quantity, Discount, and Profit. This report is to analyze performance by product and identify trends and opportunities.