Empower your data journey with Python! Learn Pandas, NumPy, and Matplotlib to wield the tools of data magic. Uncover insights, visualize trends, and conquer complex datasets with flair!
Week 7Data Visualisation with Power BI
- Introduction to Power BI
- Data Connectors
- Power Query Editor and Tools Power Query Editor
- Append Queries and Merge Queries
- Pivoting and Unpivoting of data
Week 8Advanced-Data Modeling and DAX in Power BI
- Data Modelling and Cardinality
- Cross Filter Direction
- Measures vs Calculated Columns
- Functions in DAX
- Cumulative Sales and Moving Average Using DAX
Week 9Visualizations and Dashboard Creation in Power BI
- ChatGPT for Measures
- Column Charts and Slicers
- Matrix vs Tables
- Cards, KPI and Gauge Chart
- Formatting a Dashboard
Project
ITC Hotels Revenue Analysis
ITC aims to develop a Power BI dashboard to analyze hotel booking data across metro cities. Determine occupancy rates, average revenue per room, and RevPAR to optimize revenue strategies.
Power BI Jam Session
Visual storytelling is crucial for any data analyst. In this jam session, discover how to leverage Power BI to create impactful reports, turn data into insights, and gain a competitive edge in interviews.