Fundamentals of Microsoft Power BI


Out of stock

SKU: 15 Category:


We are at capacity for this course, more dates will be available in near future

Fundamentals of Microsoft Power BI

( Basic-Intermediate)

By Yashar Monsefi

Course Syllabus:
POWER BI OBJECTIVE #1: Connect & Transform the Raw Data
  • Intro to the Power BI Query Editor
  • Types of Power BI Data Connectors
  • Basic Table Transformations
  • Text, Number & Date Tools
  • Index & Conditional Columns
  • Grouping & Aggregating Data
  • Pivoting & Unpivoting
  • Modifying, Merging & Appending Queries
  • Connecting to Folders
  • Defining Hierarchies & Categories
  • Query Editing & Power BI Best Practices
POWER BI OBJECTIVE #2: Build a Relational Data Model
  • Intro to Database Normalization
  • Data (“Fact”) Tables vs. Lookup (“Dimension”) Tables
  • Creating Power BI Table Relationships
  • “Star” vs. “Snowflake” Schemas
  • Active vs. Inactive Relationships
  • Relationship Cardinality
  • Connecting Multiple Data Tables
  • Filtering & Cross-Filtering
  • Hiding Fields from the Power BI Report View
  • Data Modeling & Power BI best Practices
POWER BI OBJECTIVE #3: Add Calculated Fields with DAX
  • Intro to Data Analysis Expressions (DAX)
POWER BI OBJECTIVE #4: Design Interactive Power BI Reports
  • Intro to the Power BI Report View
× How can I help you?