This project involves analyzing sales data using SQL for querying and data preparation, followed by creating interactive visualizations using Power BI. The aim is to extract actionable insights from raw sales data, such as understanding sales trends, top-performing products, and customer segmentation.
Data Analysis: Performed data analysis using SQL queries to gain insights from raw sales data. Data Visualization: Utilized Power BI to build dashboards and visualizations, enabling easy interpretation of sales performance. Insights: Extracted key insights such as sales trends, customer behavior, and regional performance.
SQL: Used to query, filter, and aggregate sales data. Power BI: For creating interactive dashboards and visualizations. Excel: Used for data preprocessing or storage before importing into Power BI.
SQL for Data Analysis: Performed advanced SQL queries, including joins, subqueries, aggregations, and window functions. Power BI Visualization: Developed interactive dashboards and charts, providing insights into sales performance. Data Cleaning: Applied necessary cleaning steps to prepare raw data for analysis and visualization. Data Storytelling: Converted complex data into easy-to-understand visual insights that drive decision-making.
├── 1_Sales_Insights_Power_BI.pbix # Power BI file (.pbix) for the visualization
├── 1_Sales_Insights_Power_BI.pdf # PDF containing data visuals
├── 1_Sales_Insights_Power_BI.sql # Sales data in SQL
```bash