This project focuses on analyzing the overall performance of "Adventure Works", a fictional global manufacturing company specializing in cycling equipment and accessories.
PowerBI
- Data Extraction
- Data Cleaning
- Data Transformation
- Data Modeling
- Data Visualization
I undertook this project as part of the "Microsoft Power BI Desktop for Business Intelligence (2023)" course by Maven Analytics on Udemy. So you can find the dataset here
- Connecting with datasources and shaping data in Power Query.
- Creating table relationships and designing the data models.
- Creating measures using DAX formulas.
- Designing interactive dashboard and report pages for visulisation.
Key insights about the busniess were generated on the below aspects-
- π Analyzed KPIs (sales, revenue, profit, returns)
- πΊοΈ Compared regional performance
- π Studied product-level trends and forecasts
- π― Identified high-value customers
π Executive Summary
ποΈ Product Details
π¨βπ©βπ§βπ¦ Customer Details
Thank you for your interest and time. Feel free to give your valuable suggestions and connect with me on https://www.linkedin.com/in/harshitt-gahlaut/