Requirements

• Microsoft Power BI Desktop (free download)
• This course is designed for PC/Windows users (currently not available for Mac)
• Experience with Excel is an added advantage
• but not a requirement

Description

Course Description: Microsoft Power BI - PizzaShop Analysis

Unlock the full potential of Power BI and master the top business intelligence tool with this course. Whether you're an experienced data professional or a newcomer to analytics, this course will equip you with the skills to turn raw data into meaningful insights.

THE COURSE PROJECT:

Step into the role of a Business Intelligence Analyst for PizzaShop, a fictional pizzeria business. Your task will be to transform data into professional-quality reports and dashboards, tracking key performance indicators (KPIs), analyzing trends, and identifying top customers. You’ll follow real-world processes that professionals use daily in business intelligence roles.

The course follows four key stages of the business intelligence workflow:

STAGE 1: Connecting & Shaping Data

Learn how to connect to various data sources and shape data using Power Query. You’ll master the tools to clean, transform, and prepare data for analysis. Topics include:

• Data connectors and storage modes

• Table transformations and data profiling tools

• Pivoting, unpivoting, and appending queries

STAGE 2: Building a Relational Data Model

Dive into data modeling best practices, focusing on creating relationships between tables to organize your data efficiently. You’ll cover:

• Database normalization

• Fact & dimension tables

• Star schemas and relationship cardinality

STAGE 3: DAX & Calculated Fields

Develop your skills in Data Analysis Expressions (DAX) to create calculated fields, measures, and complex expressions for data analysis. Key concepts include:

• Row and filter context

• Time intelligence patterns

• Conditional and logical functions

STAGE 4: Data Visualization & Reporting

Bring your data to life with powerful data visualizations. Learn to design interactive dashboards and reports that drive decision-making, using:

• Best practices for data visualization

• Interactive reports with slicers, drill-downs, and bookmarks

• Custom visualizations and Power BI service integration

With real-world assignments, you’ll not only learn the theory but gain hands-on experience in creating stunning Power BI reports tailored for business impact.

Ready to transform your data skills? Join the course and start building dynamic Power BI reports today!

Who this course is for:

• Individuals seeking a practical
• project-driven introduction to Microsoft Power BI Desktop
• Data analysts and Excel users aiming to enhance their skills in advanced data modeling
• dashboard design
• and business intelligence
• Aspiring data professionals eager to excel in using the leading business intelligence tool in the market.
• Students in search of a comprehensive
• engaging
• and highly interactive training approach
• Those aspiring to build a career in data analysis or business intelligence