This repository contains a data analysis and visualization project developed in Power BI for an e-commerce company. The purpose of the project is to create an interactive dashboard that provides key insights into Year-to-Date (YTD) sales and supports strategic decision-making.
- Data Integration: Connected Power BI to MS SQL Server and flat files.
- Data Modeling: Created relationships between three tables.
- Data Cleaning: Used Power Query to prepare the data.
- Date Table: Generated a date table for time-series analysis.
- Time Intelligence Functions: Implemented DAX functions such as
TOTALYTD,SAMEPERIODLASTYEAR, etc. - Dynamic and Complex KPIs: Developed customized metrics.
- Advanced DAX Queries: Used functions like
CALCULATE,SUMX,FILTER, and others. - Conditional Formatting: Added dynamic icons to highlight trends.
- Insights Generation: Created charts and visuals for analytical insights.
A U.S.-based e-commerce company requested the development of a dashboard to analyze YTD sales data and generate actionable insights. The client requirements included:
- Main KPIs:
- YTD Sales, YTD Profit, YTD Quantity Sold, and YTD Profit Margin.
- Year-over-Year (YoY) growth with trend visualizations using sparklines.
- Category Analysis:
- YTD Sales, PYTD Sales, and YoY growth by customer category with trend icons.
- Regional Analysis:
- Sales performance by state and region.
- Identify best- and worst-performing regions.
- Product Analysis:
- Top 5 and Bottom 5 products based on YTD Sales.
- Shipping Analysis:
- Sales percentages by shipping method.
- Power BI: For data visualization.
- Power Query: For data cleaning and transformation.
- DAX (Data Analysis Expressions): For creating measures and custom calculations.
- SQL: For extracting data from an MS SQL Server database.
├── Dataset/
│ ├── sales_data.csv
│ ├── regions.xlsx
├── PowerBI_File/
│ ├── Ecommerce_Dashboard.pbix
├── README.md