Power BI

Power BI Data Analysis

Module: PBI-101

  • Power BI Tools
  • Working in the Query Editor
  • Data Model and Creating a Visualization
  • Overview of the Workflow
  • Different Views of the Data Model
  • Query Editor Interface
  • Recommended Settings

Module: PBI-102

  • Connecting Power BI Desktop to our Data Sources
  • Editing Rows
  • Append Queries
  • Editing Columns
  • Replacing Values
  • Formatting Data
  • Pivoting and Unpivoting Columns
  • Splitting Columns
  • New Group
  • Star Schema
  • Duplicating and Referencing Queries
  • DIM Table
  • Entering Data Manually
  • Merging Queries
  • Index Column
  • Duplicating Columns and Extracting Information
  • FACT Population Table
  • Mathematical Operations
  • Improving Performance and Loading Data into the Data Model

Module: PBI-103

  • Query Editor vs. Data Model
  • Relationships
  • Cardinality
  • Cross Filter Selection
  • Many-To-Many Relationships
  • Active Properties
  • M-Language and DAX
  • Calculated Columns vs. Measures
  • DAX-Measures
  • Categorizing Data

Module: PBI-104

  • Report View
  • Visualizations
  • Interactions
  • Tooltips
  • Hierarchies
  • Drill-Down
  • Formatting Charts
  • Sorting
  • Slicer
  • Treemaps
  • Tables
  • Filter Types
  • Multi-Row Cards
  • Combined Visualizations and Waterfalls

Module: PBI-105

  • Power BI Service
  • Importing our Data from Power BI Desktop to Power BI Service
  • Dataset Menu
  • Reports
  • Dashboards
  • Workspace
  • Gateways
  • Sharing the Results
  • Publishing the App
  • Excluding Datasets from Sharing
  • Import JSON Data
  • Import Data from REST APIs
  • Import Data from MySQL Server

Leave your comment; I love them!

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s