Get Started. It's Free
or sign up with your email address
Power BI by Mind Map: Power BI

1. Transforming Data

1.1. Entering data from scratch

1.2. Import from common sources

1.2.1. Excel files

1.2.2. CSV files

1.2.3. SQL Server databases

1.2.3.1. Import mode

1.2.3.2. Direct query mode

1.2.4. SSAS

1.2.4.1. Import mode

1.2.4.2. Live Connection mode

1.2.5. Web (REST)

1.2.6. Hierarchical sources - JSON/XML

1.3. Select columns

1.3.1. Remove columns

1.3.2. Remove other columns

1.3.3. Choose columns

1.4. Adding columns

1.4.1. Indexes

1.4.2. Custom

1.4.3. From examples

1.5. Transforming columns

1.5.1. Pivoting/unpivoting

1.5.2. Groupping

1.5.3. Changing data types

1.5.4. Splitting / merging

1.6. Renaming columns / dataset

1.7. Refresh

1.7.1. Full or partial refresh

1.7.2. Excluding queries from refresh

1.8. Duplicating / referencing queries

1.9. Using parameters and creating custom functions

1.10. Merging queries

1.11. M

1.11.1. M reference

2. Visualization & Storytelling

2.1. Generic visual functionality

2.1.1. Specifying fields

2.1.2. Formatting

2.1.3. Filtering (visual level, page level, report level)

2.1.4. Drill through

2.2. Most used standard visuals

2.2.1. Bar charts

2.2.2. Line / area charts

2.2.3. Table / matrix

2.2.4. Combined bar / line

2.2.5. Scatterplot

2.2.6. Card / multi-row card / KPI

2.2.7. Pie / donut

2.2.8. Treemap

2.2.9. Geo maps

2.3. Drill down / up

2.4. Slicers (different types)

2.5. Importing custom visuals

2.5.1. Marketplace

2.5.2. Files

2.6. Most used custom visuals

2.6.1. Text search

2.6.2. Bullet chart (with goals)

2.6.3. Word cloud

2.6.4. Histogram

2.6.5. Power KPI

2.6.6. Venn diagram

2.6.7. Ultimate variance

2.7. Changing report sizes & formatting pages

2.8. Using desktop vs. mobile report layouts

2.9. Report pages as tooltips

2.10. Asking questions to create visuals

2.11. Bookmarking

2.12. Navigation buttons

2.13. Syncing slicers across multiple pages

3. Modeling

3.1. Linking entities & managing relationships

3.2. Adding calculated columns

3.3. Adding calculated measures

3.4. Adding groups & hierarchies

3.5. Creating tables from scratch

3.6. Setting field formats

3.7. Setting field categories (geo, URLs, etc.)

3.8. Quick measures

3.9. Editing field descriptions

3.10. Specifying default sorting

3.11. DAX

3.11.1. DAX reference

4. Cloud Service

4.1. Publishing reports to the cloud

4.2. Creating dashboards

4.2.1. Mobile layout for dashboards

4.2.2. Enabling Q&A and tile workflow

4.3. Navigating Reports, Dashboards and Datasets (using workspaces)

4.4. Q&A

4.5. Quick insights

4.6. Sharing reports / dashboards

4.7. Creating and managing alerts and subscriptions

4.8. Dashboard settings

4.9. Dataset settings

5. Secure Gateway

6. Mobile App