Syllabus

Power BI Desktop: Foundations and Setup

Business Intelligence

Introduction and Installation

  1. Introduction to Power BI:
    Understand what Power BI is and its core functionalities.

  2. Installing and Configuring Power BI Desktop:
    Learn how to download, install, and configure Power BI Desktop.

  3. Working with the Power BI Interface:
    Become familiar with the Power BI Desktop interface and its functionalities.

Data Ingestion and Transformation

  1. Connecting to Data Sources:
    Explore how to connect to various data sources (Excel, databases, etc.) within Power BI.

  2. Transformation & Cleaning:
    Grasp the concepts of data transformation and cleaning techniques in Power BI.

Data Modeling and Report Creation

Data Modeling

  1. Data Modeling:
    Understand the fundamentals of data modeling concepts in Power BI.

Report and Visualization Basics

  1. Creating Basic Visualizations:
    Discover how to build basic visualizations (charts, graphs) in Power BI reports.

  2. Creating Reports:
    Learn how to design and build reports using visualizations and data manipulation techniques.

  3. Formatting & Interactivity:
    Explore formatting options and techniques to enhance report aesthetics and interactivity.

  4. Sharing Reports & Dashboards:
    Discover different ways to share reports and dashboards with colleagues.

Advanced Analysis with DAX and Visualization

DAX for Advanced Calculations

  1. DAX Fundamentals:
    Learn the basics of DAX (Data Analysis Expressions) for advanced calculations and data manipulation.

  2. Creating Calculated Columns & Measures:
    Understand how to create calculated columns and measures to extend data analysis capabilities.

Advanced Visualization and Interaction

  1. Advanced Visualizations:
    Explore advanced visualizations (maps, funnels, etc.) available in Power BI.

  2. Filters & Slicers:
    Grasp the concepts and usage of filters and slicers for interactive data exploration.

  3. Drilldowns & Cross-Filtering:
    Learn how to implement drilldowns and cross-filtering for deeper data.

Power BI Service: Sharing and Collaboration

Publishing and Sharing

  1. Power BI Service Overview:
    Get introduced to the Power BI Service (online platform) and its functionalities.

  2. Publishing & Sharing Reports & Dashboards:
    Explore how to publish reports and dashboards to the Power BI Service.

Collaboration and Consumption

  1. Collaboration & Access Control:
    Understand how to collaborate with others and manage access control within the Power BI Service.

  2. Embedding Reports & Dashboards:
    Learn about embedding reports and dashboards in external applications.

  3. Consuming Content & Q&A:
    Discover how to consume shared content and use the Q&A feature for data exploration in the Power BI Service.