This project is an end-to-end data analysis solution designed to extract critical business insights from Adventure Works Sales Data . We utilize excel and Power Query for data processing and analysis, Power BI for advanced querying, and structured problem-solving techniques to solve key business questions. The project is ideal for data analysts looking to develop skills in data manipulation.
- Tools Used: Power BI
- Goal: Handling Various business requirements with multiple dataset.
- Goal: Conduct an initial data exploration to understand data distribution, check column names, types, and identify potential issues.
- Analysis: Use Query(M -code) like
First Row as Header,group by, andRemove Duplicatesto get a quick overview of the data structure and statistics.
- Remove Duplicates: Identify and remove duplicate entries to avoid skewed results.
- Handle Missing Values: Drop rows or columns with missing values if they are insignificant; fill values where essential.
- Fix Data Types: Ensure all columns have consistent data types (e.g., dates as
datetime, prices asfloat). - Validation: Check for any remaining inconsistencies and verify the cleaned data.
- Business Problem-Solving:
- Most Revenue Generating product
- Overall Return Rate
- 1 st and 2 nd level analysis on what could have been the major reason for Return rate
- Top 10 Customers in terms of revenue
- This view was primarily made to get the down funnel understanding of how each product is working
- Shows use total profit generated, total orders, total revenue, total retunrs
- Also show us if we adjusted price how much revenue we increase
- This view helps to identify from region most of our revenue is generating
- Gives the Overview of an business to take an action on down funnel parameters
- A quick distribution view to understand multiple parameter performance(like many products are getting returned) and take actions accordingly.
- Helps to understand the customer purchasing pattern