Microsoft BI

Contact Us
  • Welcome to this Course
  • Understanding the Power BI Tools
  •  Initial Project 13 Installing Power BI Desktop and Connecting to Data
  •  Initial Project 23 Working in the Query Editor
  •  Initial Project 33 Working in the Data Model and Creating a Visualization
  •  How to use the Attached Project Files
  • An Overview of the Workflow in Power BI Desktop
  •  Introducing the Different Views of the Data Model
  •  Taking a Closer Look at the Query Editor Interface
  •  Before we Dive Deeper Recommended Settings
  • Just to be sure What is the Query Editor
  •  Connecting Power BI Desktop to our Data Sources
  •  Editing Rows
  •  Understanding Append Queries
  •  Editing Columns
  •  Replacing Values
  •  Formatting Data
  •  Pivoting and Unpivoting Columns
  •  Splitting Columns
  •  Creating a New Group for our Queries
  •  What we Achieved until Now and How to Continue
  •  Introducing the Star Schema
  •  Duplicating and Referencing Queries
  •  Creating the DIM Region Table
  •  Entering Data Manually
  •  Merging Queries
  •  Finishing the DIM Region Table
  •  Introducing the DIM AgeGroup Table
  •  Creating an Index Column
  • Module Introduction
  •  Query Editor vs. Data Model
  •  Introducing and Understanding Relationships
  •  Editing Relationships
  •  Understanding Cardinality
  •  Cross Filter Selection and Many-To-Many Relationships
  •  Active Properties
  •  Understanding the differences between the M-Language and DAX
  •  M vs. DAX applied Calculated Columns
  •  DAX – Basic information
  •  Calculated Columns vs. Measures
  •  Introducing DAX-Measures
  • Module Introduction
  •  Understanding the Interface of the Report View
  •  Creating our First Visualizations
  •  Editing Interactions and Adding Tooltips
  •  Adding Color Saturation
  •  Understanding Hierarchies and Adding Drill-Down
  •  Formatting Charts and Sorting
  •  Introducing Slicers
  •  Adding Treemaps and Tables
  •  Applying different Filter Types
  •  Creating Multi-Row Cards
  •  Understanding Combined Visualizations and Waterfalls
  • Module Introduction
  •  Continuing our Work and why we need Power BI Service
  •  Comparing Power BI Free Pro and Premium
  •  Logging in to Power BI Service
  •  Understanding the Interface
  •  Importing our Data from Power BI Desktop to Power BI Service
  •  Understanding the Dataset Menu
  •  Working on Reports
  •  Introducing Dashboards
  •  Exploring our Workspace
  • Understanding Gateways
  •  Comparing Personal and On-Premise Gateway and Installing a Gateway
  •  Working alone or Collaborating with Colleagues
  •  Collaborating in App Workspaces
  •  Sharing the Results
  •  Publishing the App
  •  Content Packs from Online Services
  •  Power BI Mobile Installing and Understanding the Mobile App
  •  One Last Thing Excluding Datasets from Sharing