(In increasing order of project's problem statement's complexity)
Analyze E-COMMERCE sales data and create an interactive dashboard to gain insights into sales performance, customer behavior, and product trends through visualizations using Power BI.
- Sales Performance Analysis
- Customer Behavior Insights
Analyze store sales data and utilize time series analysis for accurate sales forecasting. Present insights through an interactive Power BI dashboard.
- Data Cleaning and Processing
- Time Series Analysis
- Sales Forecasting
To provide revenue management insights from historical data set using Power BI.
- Transforming Data using power query
- Creating new metrics using DAX
- Showing Trends
- ToolTip Graphs for KPIs
- Multi variate visualisation
To provide sales management insights from historical data set of pizza sales using Power BI.
-
SQL Queries for KPI's, Timely Trend, % calculation and Sellers list
-
Connecting Power BI to SQL DB
-
Data Cleaning using Power Query
-
SQL Documentation
-
Data Processing, adding Trends, Charts and Insights in Power Bi
-
Easy Navigation, Button
- Power BI Desktop is to be Downloaded and Installed.
- The Repository be cloned.
- "_____.pbix" file is to be opened in Power BI.
- Interactive dashboard ready to be explored.