Course Code: pbides
Duration: 16 hours
Prerequisites:

Level of familiarity with the topic:
Intermediate/Advanced


Prerequisites:
For the intermediate or advanced Power BI course, participants should have a very good
understanding of Power BI’s interface. Familiarity with Power BI Desktop and DAX is
essential, as this course builds upon that foundation. Additionally, having Microsoft Excel
knowledge can be beneficial, although it is not mandatory. If students have completed the
Power BI beginner course, they will be well-prepared for the intermediate level. Overall, an
eagerness to learn and explore data visualization concepts is key to success in these more
advanced courses.


The intermediate course is ideal for:

  • Business professionals seeking to deepen their data visualization skills
  • Analysts who need to dig deeper into DAX functionality.
  • Anyone who need to know how to optimize data models, and leverage advanced features.
Course Outline:

1. Advanced Data Loading and Transformation:

  • Query Editor Exploration: Dive deeper into Power Query Editor. Connect to diverse data
    sources, apply complex transformations, and clean data using the M language.
  • Data Fetching and Transformation: Learn advanced techniques for fetching data from
    databases, files, APIs, and applying intricate transformations.
  • Mastering Table Joins: Understand how to combine data from multiple tables using
    various join types based on common fields.

2. Data Modeling Excellence:

  • Data Model Schemas: Explore data modeling concepts in-depth. Understand how tables
    relate to each other, forming a coherent structure.
  • Creating Robust Relationships: Master the art of establishing relationships between
    tables for a powerful data model.
  • Advanced Calculations (Calculated Columns, Measures): Dive into more advance DAX
    (Data Analysis Expressions) language. Create calculated columns and measures to
    enhance your data analysis.


3. Sophisticated Visualizations:

  • Creating Complex Visuals: Build advanced visualizations beyond basic charts. Explore
    gauges, heatmaps, and custom visuals.
  • Fine-Tuning Visuals: Customize visualizations by adjusting colors, labels, and formatting
    for precision.
  • Drill-Down Techniques: Learn how to drill down into specific data points within visuals
    for deeper insights.
  • Enhancing Reports: Add and remove chart elements like legends, titles, and annotations
    to refine your reports.
  • AI-Driven Insights: Discover AI-powered visuals that elevate your reports’ impact.