Welcome to the PwC Power BI Analyst Project, a comprehensive data analysis and visualization project using Power BI. This project demonstrates proficiency in data transformation, modeling, visualization, and insights generation based on a real-world business scenario.
This project is part of the PwC Power BI Analyst case study, where we analyze business data to derive meaningful insights and improve decision-making. It involves:
- π Data Cleaning & Transformation (Power Query)
- π Data Modeling & Relationships
- π Interactive Dashboards & Reports
- π DAX Measures & Calculations
- π Business Insights & Recommendations
The dataset used in this project includes:
- Sales Transactions
- Customer Demographics
- Market Trends
- Performance Metrics
- Microsoft Power BI β Data Visualization & Reporting
- Power Query β Data Cleaning & Transformation
- DAX (Data Analysis Expressions) β Custom Calculations & Measures
- Excel / CSV β Data Storage & Import
β Sales Performance Analysis: Trends in revenue, product demand, and sales regions. β Customer Segmentation: Identifying customer groups based on demographics and buying behavior. β Market Trend Analysis: Visualizing market growth and key influencing factors. β Profitability Insights: Understanding revenue streams and cost structures. β KPI Dashboards: Interactive dashboards highlighting key performance indicators.
- Download the Power BI File: Clone this repository or download the
.pbix
file. - Open in Power BI: Load the file using Microsoft Power BI Desktop.
- Explore the Dashboards: Navigate through interactive reports and visualizations.
- Customize & Extend: Modify data sources, update DAX measures, or add new visualizations.
(Add screenshots of your Power BI dashboards here to showcase the visuals)
Through this project, you will gain hands-on experience in:
- Working with real-world business data.
- Building data models and defining relationships.
- Writing effective DAX calculations.
- Creating interactive dashboards for decision-making.
Feel free to contribute to this project by improving visualizations, optimizing DAX measures, or adding new insights!
This project is open-source under the MIT License.
For any queries, feel free to reach out via GitHub Issues or connect on LinkedIn.