Learning Notes on Power BI

1. Data discovery with Power BI desktop

Power BI get started documentation - Power BI | Microsoft Learn

2. Transforming data

Transform, shape, and model data in Power BI - documentation - Power BI | Microsoft Learn

　　2.1 Basic transform

　　2.2 Add column from example

　　2.3 Appending queries

　　2.4 Merging queries

　　2.5 Combine files

　　2.6 Reading and understanding M (Click and jump to M Query Learning)

　　M is much more powerful than the graphical interface of Power Query.

　　2.7 Writing basic M

　　2.8 Variables, parameters and templates

　　2.9 Writing parameters in M

　　2.10. Other query features

3. Creating the data model

Use Modeling view in Power BI Desktop - Power BI | Microsoft Learn

　　3.1 Modeling basic

　　3.2 Model enhancement (click and jump to content of Model enhancement)

　　3.3 What if parameter[YCS1] 

　　　　　　Use what-if parameters to visualize variables - Power BI | Microsoft Learn

4. Creating calculated columns and tables

　　4.1 DAX Basic Data Analysis Expressions (DAX) Reference - DAX | Microsoft Learn
　　4.2 Navigation functionUse quick measures for common and powerful calculations - Power BI | Microsoft Learn
　　4.3 Calculated tablesUsing calculated tables in Power BI Desktop - Power BI | Microsoft Learn

Some common DAX table functions might use:

DISTINCT
VALUES
CROSSJOIN
UNION
NATURALINNERJOIN
NATURALLEFTOUTERJOIN
INTERSECT
CALENDAR
CALENDARAUTO

5. Creating calculated measures

　　5.1 Measure basicsTutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn

　　5.2 Time intelligence functionsTime intelligence functions (DAX) - DAX | Microsoft Learn

6. Creating basic reports

Create reports and dashboards in Power BI - documentation - Power BI | Microsoft Learn

Visualization types in Power BI - Power BI | Microsoft Learn

7. Creating interactive reports

Part 1, Add visualizations to a Power BI report - Power BI | Microsoft Learn

　　7.1 Adding slicers for filters

　　7.2 visualizing tabular data

　　7.3 visualizing data trends

　　7.4 visualizing categorical and trend data together

　　7.5 visualizing geographical data with maps

　　7.6 visualizing goal tracking[YCS2]

 　　　　　　Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

　　7.7 using custom visuals[YCS3] 

　　　　　　Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn

　　7.8 digital storytelling[YCS4]  (click and jump to digital storytelling learning)

　　　　　　Create a data-driven story with Power BI reports - Training | Microsoft Learn

　　　　　　Use advanced interactions and drill through

　　　　　　To enable the visual interaction controls, select a visualization, go to the Format tab in the ribbon, and then select Edit interactions.

　　7.9 other features

8. Using the Power BI Service[YCS5] 

　　　　　　Focus on publishing & sharing

Tutorial: Get started creating in the Power BI service - Power BI | Microsoft Learn

　　8.1 Deploying to the power bi service

　　8.2 setting up workspaces

　　8.3 creating dashboards

　　8.4 Using Q&A

　　8.5 Publishing an APP

　　8.6 Subscriptions and Alerts

　　8.7 Excel Integration

　　8.8 Export and Embed Options

9. Refreshing the Data

Data refresh in Power BI - Power BI | Microsoft Learn

　　9.1 Scheduling a Data Refresh

10. Mobile BI

　　10.1 Power BI Mobile Overview

　　10.2 Designing Reports and Dashboards for Mobile

　　10.3 Interacting with Power BI ,Mobile APP

-----------------------------Advanced Power BI------------------------------

1. R Integration

　　1.1 Installation and Configuration
　　1.2 R Scripting Basics

　　1.3 R for Data Cleansing

　　1.4 Check if File Exists

2. M Query

Power Query M formula language reference - PowerQuery M | Microsoft Learn

　　2.1 The M Syntax

　　2.2 #shared

　　2.3 M Query Basics

　　2.4 Variables and Parameters

　　2.5 Expanding Lists

　　2.6 M Query Functions

3. Advanced Data Modeling[YCS6] 

　　　　Model relationships in Power BI Desktop - Power BI | Microsoft Learn

　　3.1 Filtering

　　3.2 Cross-Filtering and Time Intelligence

　　3.3 Many to Many with DAX

　　3.4 Creating a Bridge Table

　　3.5 Role Playing Tables with DAX

　　3.6 Role Playing Tables without DAX

　　3.7 Mismatched Granularies

　　3.8 Weighted Allocation

4. Query Folding

　　4.1 Basics

　　4.2 Beyond the Basics

5. xVelocity

　　5.1 Overview

　　5.2 Vertipaq Analyzer

　　5.3 Column Cardinality

　　5.4 Calculated Columns

6. Advanced Visualizations[YCS7] [YCS8] 

　　　　Power BI features

　　　　Create a data-driven story with Power BI reports - Training | Microsoft Learn

　　6.1 Digital Storytelling

　　6.2 Bookmarks

　　6.3 Selection Pane

　　6.4 Drillthrough

　　6.5 Visuals with DAX

　　6.6 Custom Visuals

　　6.7 Custom Themes

7. Power BI Administration

　　7.1 Data Refresh Overview

　　7.2 Scheduling Data Refresh

　　7.3 Implementing Row Level Security

　　7.4 Implementing Dynamic Security

8. Power BI Embedded

---

 [YCS1]Use what-if parameters to visualize variables - Power BI | Microsoft Learn

 [YCS2]Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn

 [YCS3]Main sources for acquiring Power BI custom visuals - Power BI | Microsoft Learn

 [YCS4]Create a data-driven story with Power BI reports - Training | Microsoft Learn

 [YCS5]Focus on publishing & sharing

 [YCS6] [YCS6]Model relationships in Power BI Desktop - Power BI | Microsoft Learn

 [YCS7]Power BI features

 [YCS8]Create a data-driven story with Power BI reports - Training | Microsoft Learn