In this project, I developed an interactive sales dashboard for a superstore using Power BI. The objective was to visualize sales data effectively, track key performance indicators (KPIs), and uncover trends to support strategic business decisions.
To create an interactive dashboard in Power BI that provides a comprehensive analysis of superstore sales data, highlighting key performance metrics, trends, and actionable insights to aid in decision-making.
Developed a comprehensive sales dashboard in Power BI. Imported and cleaned sales data, created calculated columns and measures, and designed various visualizations (line charts, bar charts, pie charts, maps). Implemented interactive features such as slicers, filters, tooltips, and drill-throughs. Presented key insights into sales trends, regional performance, product analysis, and customer segments.
Power BI:
To import data, for data cleaning, data modeling, DAX calculations, and interactive dashboard creation.
Data Visualization:
Line charts, bar charts, pie charts, maps, treemaps, slicers, filters, tooltips, and drill-throughs.
Data Source:
Extracted sales data from a superstore dataset, which typically includes fields such as order date, sales, profit, customer segment, region, product category, and sub-category.
Data Cleaning:
Imported the dataset(csv format) into Power BI. Cleaned the data by handling missing values, removing duplicates, and ensuring consistency in date formats and categorical data.
Relationships:
Established relationships between tables (e.g., orders, customers, products, and regions) to enable comprehensive analysis.
Calculated Columns and Measures:
Created calculated columns and measures using DAX (Data Analysis Expressions) to perform custom calculations and aggregations such as total sales, total profit, and sales growth.
Displayed key performance indicators such as total sales, total profit, and average days for delivery.
By Time: Visualized sales trends over time using line charts to show monthly, quarterly, and yearly sales.
By Region: Used maps and bar charts to analyze sales distribution across different regions of the country.
By Category: Employed stacked bar charts and treemaps to display sales and profit by product category and sub-category.
By Segment: Showed sales performance by customer segment using pie charts and clustered bar charts.
Visual Consistency: Ensured consistent use of colors, fonts, and layout to enhance readability and user experience.
This project showcased my ability to leverage Power BI for advanced data visualization and analysis. The interactive dashboard provided valuable insights into sales performance, helping stakeholders make data-driven decisions to enhance business strategy and operations.
