Power BI学习目录

目录

1. Data discovery with Power BI desktop

2. Transforming data

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

2.7 Writing basic M

2.8 Parameters and templates

2.9 Writing parameters in M

2.10. Other query features

3. Creating the data model

3.1 Modeling basic

3.2 Model enhancement

3.3 What if parameter

4. Creating calculated columns and tables

4.1 DAX Basic,

4.2 Navigation function,

4.3 Calculated tables

5. Creating calculated measures

5.1 Measure basics,

5.2 Time intelligence functions

6. Visualizing data

7. Creating basic reports

8. Creating interactive reports

8.1 Adding slicers for filters

8.2 visualizing tabular data

8.3 visualizing data trends

8.4 visualizing categorical and trend data together

8.5 visualizing geographical data with maps

8.6 visualizing goal tracking

8.7 using custom visuals

8.8 digital storytelling

8.9 other features

9. Using the Power BI Service

9.1 Deploying to the power bi service

9.2 setting up workspaces

9.3 creating dashboards

9.4 Using Q&A

9.5 Publishing an APP

9.6 Subscriptions and Alerts

9.7 Excel Integration

9.8 Export and Embed Options

10. Refreshing the Data

10.1 Scheduling a Data Refresh

11. Mobile BI

11.1 Power BI Mobile Overview

11.2 Designing Reports and Dashboards for Mobile

11.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

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

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

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

---

---

1. Data discovery with Power BI desktop

2. Transforming data

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

2.7 Writing basic M

2.8 Parameters and templates

2.9 Writing parameters in M

2.10. Other query features

3. Creating the data model

3.1 Modeling basic

3.2 Model enhancement

3.3 What if parameter

4. Creating calculated columns and tables

4.1 DAX Basic,

4.2 Navigation function,

4.3 Calculated tables

5. Creating calculated measures

5.1 Measure basics,

5.2 Time intelligence functions

6. Visualizing data

7. Creating basic reports

8. Creating interactive reports

8.1 Adding slicers for filters

8.2 visualizing tabular data

8.3 visualizing data trends

8.4 visualizing categorical and trend data together

8.5 visualizing geographical data with maps

8.6 visualizing goal tracking

8.7 using custom visuals

8.8 digital storytelling

8.9 other features

9. Using the Power BI Service

9.1 Deploying to the power bi service

9.2 setting up workspaces

9.3 creating dashboards

9.4 Using Q&A

9.5 Publishing an APP

9.6 Subscriptions and Alerts

9.7 Excel Integration

9.8 Export and Embed Options

10. Refreshing the Data

10.1 Scheduling a Data Refresh

11. Mobile BI

11.1 Power BI Mobile Overview

11.2 Designing Reports and Dashboards for Mobile

11.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

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

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

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