Welcome to the Power Pi project repository!
This project aims to analyze sales data using Power BI, applying various data analysis techniques to gain insights into sales performance.
- Utilized Power Query to clean the data:
- Removed duplicates and null values.
- Ensured consistent data types.
- Created an ID column using unique values of the product name for easy data connectivity.
- Analyzed sales data using DAX measures.
- Calculated key performance indicators (KPIs) for sales.
The analysis is visualized through various pages:
-
Main Page
- Contains general information about the data.
- Provides an overview of sales performance.
-
Product Subcategory Page
- Displays sales trends over the years for different product subcategories.
-
Region Page
- Allows users to analyze sales by region or state.
-
Data Cleaning and Preparation
- Renamed columns for clarity and consistency.
- Ensured uniform data types across columns.
- Removed duplicates and null values.
- Created an ID column using unique values of the product name.
-
Exploratory Data Analysis (EDA)
- Examined the distribution of key variables such as sales, order quantity, and pricing.
- Identified outliers or anomalies in the data.
-
Sales Analysis
- Analyzed sales performance over time using time-series analysis techniques.
- Investigated sales trends for different product categories and subcategories.
- Explored regional variations in sales.
-
Key Insights and Recommendations
- Identified top-selling products or categories.
- Highlighted areas for potential improvement or optimization.
- Provided actionable insights for stakeholders based on the analysis.
Feel free to explore the Power BI project and interact with the visualizations to gain insights into sales data.
- IBRAHIM SABER (https://github.com/ibrahimsaber1) - Project Lead
This project is licensed under the MIT License.