Power BI

Learning Objective 1: Connect & Transform the Raw Data

• Intro to the Query Editor

• Types of 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 Best Practices

Learning Objective 2: Build a Relational Data Model

• Intro to Database Normalization

• Data ("Fact") Tables vs. Lookup ("Dimension") Tables

• Creating Table Relationships

• "Star" vs. "Snowflake" Schemas

• Active vs. Inactive Relationships

• Relationship Cardinality

• Connecting Multiple Data Tables

• Filtering & Cross-Filtering

• Hiding Fields from Report View

• Data Modeling best Practices

Learning Objective 3: Add Calculated Fields with DAX

• Intro to Data Analysis Expressions (DAX)

• Calculated Columns vs. Measures

• Row Context vs. Filter Context

• DAX Syntax & Operators

• Common Function Categories

• Basic Date & Time Formulas

• Logical & Conditional Statements

• Text, Math & Stats Functions

• Joining Data with RELATED

• CALCULATE, ALL & FILTER Functions

• DAX Iterators (SUMX, AVERAGEX)

• Time Intelligence Formulas

• DAX Best Practices

Learning Objective 4: Design Interactive Reports

• Intro to the Power BI Report View

• Adding Objects & Basic Charts

• Formatting & Filtering Options

• Matrix Visuals

• Slicers & Timelines

• Cards & KPIs

• Map Visuals (Basic, Fill, ArcGIS)

• Treemaps, Lines, Areas & Gauges

• Editing Report interactions

• Adding Drillthrough Filters

• Linking to Report Bookmarks

• Managing & Viewing Roles

• PREVIEW: Publishing to Power BI Service

• Data Viz Best Practices

Learning Objective 5: Power BI cloud

• Publish Reports from Power BI Desktop

• Reports, Datasets in Power BI Cloud

• Creating Dashboards and Realtime Use

• Pin Visuals and Pin LIVE Report Pages

• Dashboard Creation with Tiles, Media

• Tiles - Images, Web Content, Chapters

• Subscriptions, Insights and Refresh

• Metrics, Distribution Methods, Actions

• View Related & Featured Dashboards

Project

Create visualizations for a multi-national company with locations in Canada, Mexico and the United States.and get insights into data and take business decisions .