Overview of Data Analytics

Introduction to Power Bi

Installing Power BI Desktop

Very Imp. – Enable all preview features

Our first look at the interface

What is ETL?

ETL in Power BI

Connecting to a CSV File

Power Query Interface

Renaming Fields and Data Types

Column Data Quality

Column Profile and Distribution

Dropping and Preserving Rows and Columns

Split Columns

Format Tool

Merge Columns

Transform vs. Add Column

Extract Tool

Conditional Columns

Duplicating Columns and Adding Indexes

Date Tool

Numerical Tools

Statistics and Count Rows

Append Queries

Group

Pro Tip – Connect to a Folder!

Change the Data Source Settings

Loading a JSON File

Creating Calculated/Custom Columns

Quick Note on Custom Columns

Enable / Disable Load

Understanding Duplicate vs. Reference Queries

Resolve data import errors

Pro Tip – Wheel Icon in Applied Steps!

Configure Data Loading Settings

Data Cleaning and Preparation

Coming Soon

Data Modeling in Power BI

Coming Soon

Creating Relationships

Coming Soon

Normalization

Primary Keys

Foreign Keys

Fact and Dimension Tables

Star Schema

Snowflake Schema

What’s a Join?

Merge Queries

Cardinality

Configuring our Data Model

Create our own Fact and Dimension Tables from a De-normalized dataset

Understanding Data Source Privacy Levels

Practical: Setting Privacy Levels

Connecting to a Database

Change Data Source Settings: Credentials

Creating Parameters

Choose between Direct Query and Import Modes

Composite Models and Dual Storage Mode

Practical – Direct Query, Import and Dual Storage Modes

Configure table properties

Configure column properties

Understanding the Filter Direction

Auto-Date Time & Common Date Tables

Common Date Tables – Practical

Looking at our new semantic model

Understanding Visualizations

Coming Soon

Customizing Visuals

Coming Soon

Interactive Dashboard Creation

Coming Soon

Canvas Settings

Cards for KPIs

Pro Tip – Use the format painter

Clustered Column/Bar Chart

Stacked Bar Chart + Ribbon Charts

Line Charts

Line & Clustered Bar Chart

Line & Stacked Bar Chart (Combo Chart)

Area Chart & Stacked Area Chart

Stacked Area Chart – Variation

Pie Chart

Donut Chart

Treemap

Gauge

Scatter, Bubble and Dot Plot Chart

Tables

Matrix

Apply conditional formatting

Format – Properties Tab

Filters

Glimpse of Power BI Service for Header Icons and Filters

Slicers

New Slicers – List, Button and Text

Sync Slicers

Apply and customize a theme

Apply sorting to visuals

Create custom tooltips

Paginated Reports

What is DAX?

Taking a look at DAX resources

Calculated Columns using DAX

Text functions

Logical Functions

RELATED() Function

Understanding Implicit Measures

Implicit Measures

Explicit Measures

Create single aggregation measures

Use basic statistical functions

Understanding Iterator Functions

Use the CALCULATE() function

KEEPFILTERS()

REMOVEFILTERS() and ALL()

ALLSELECTED()

USERELATIONSHIP()

Create calculated tables using DAX

Introduction to Time Intelligence in Power BI

Implement Time Intelligence measures

Create Semi-additive measures

Create Calculation groups

Create a measure by using quick measures

Drill Down

Edit and configure interactions between visuals

Configure bookmarks

Group and layer visuals by using the Selection pane

Configure navigation for a report

Configure drill through navigation

Configure export settings

Design reports for mobile devices

Enable personalized visuals in a report

Design and configure Power BI reports for accessibility

Identify poorly performing measures, relations, and viz using Perform Analyzer

Improve performance by identifying and removing unnecessary rows and columns

Improve performance by reducing granularity & optimizing data types

Use the Analyze feature in Power BI

Use grouping

Use binning and clustering

Use AI visuals + detect outliers and anomalies

Use reference lines, error bars, and forecasting