Scribd
Upload
10 views3 pages

Power BI: Comprehensive Guide & Tutorials

The document provides a comprehensive guide to Power BI, covering its components, benefits, and installation. It includes detailed instructions on data acquisition and transformation using Power Query, data modeling techniques, visualization creation, and the use of DAX language. Additionally, it discusses publishing and sharing reports, along with hands-on projects for practical application.

Uploaded by

Balagangadhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
10 views3 pages

Power BI: Comprehensive Guide & Tutorials

The document provides a comprehensive guide to Power BI, covering its components, benefits, and installation. It includes detailed instructions on data acquisition and transformation using Power Query, data modeling techniques, visualization creation, and the use of DAX language. Additionally, it discusses publishing and sharing reports, along with hands-on projects for practical application.

Uploaded by

Balagangadhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

POWER BI CONTENT:

Introduction to Power BI
1. What is Business Intelligence (BI)?

2. Overview of Power BI & its Components (Power BI Desktop, Service, Mobile)

3. Benefits of Power BI and Power BI vs Traditional Reporting Tools

4. Components and Power BI Desktop – Installation

5. Power BI Interface & Navigation

6. Building Blocks

7. Demo – Sample Power BI Reports

8. Creating a Simple Report

II) Get Data & Transform Data with Power Query


1. Get and edit Data – An ETL Tool (Extract, Transform, Load)

2. Get data from SAP ECC DATA BASE

3. Get data from SAP HANA DATA BASE

4. Get data from SAP EWM DATA BASE

5. Get data from SQL SERVER

6. Get data from Access And CSV

7. Get data from Website And Xls

8. Understanding Power Query Editor

9. Load vs Direct Query

10. Append Queries

11. Merge Queries

12. Filtering Rows

13. Split Columns based of Delimiter, Merge Columns

14. Eliminating Columns

14. Fixing Metadata issues

15. Creating Custom Column based on the Conditions

16. Refresh Queries

17. Introduction to M Query Language


III) Data Modelling
1. Introduction to Data Modeling

2. Creating Relationship between tables

3. Building a data model and Star Schema vs Snowflake Schema

a. Hiding columns from Reporting View

b. Sorting and Formatting

c. Creating Hierarchies

4. Create Calculated columns – M Language

5. Creating a Date Dimension

6. Create Robust Data Models Intuitively

IV) Power BI Visualizations


1. Introduction to visuals in Power BI

2. Create and customize simple visualizations

3. Recommended Charts for your data set

4. Bar Charts and Column Charts

5. Line Charts and funnel C harts

6. Pie Charts and Donut Charts

7. Tree Charts and Maps

8. Combination Charts

9. KPI and Card Charts

10. Table and Matrix Views

11. Buttons and Bookmarks

12. Adding Text box, Shapes and Images to Reports

13. Creating Stunning Dashboard & Interactive Reports in few clicks

14.

V) Slicing and Dicing


1. Filters

2. Slicers

3. Parameters

4. Manage Interaction between objects


5. Drill down/Roll Up

VI) Introduction to DAX Language


1. Introduction to DAX Functions

2. DAX Syntax

3. DAX Data Types

4. DAX Operators

5. DAX Functions

a. Logical Functions

b. Aggregate Functions

c. Date and Time Functions

d. Text Functions

e. Mathematical Functions

f. About Calculate Function

VII) Publishing and Sharing Power BI Reports


1. Publish from Power BI Desktop

2. Dazzle Executives with real time Analytics

3. Working with Power BI Service

a. On Web

b. On Mobile/Tab

4. Export Data from a Visualization

5. Sharing Dashboards.

6. Empower Stakeholders to Dazzle their Data Through Sharing

7. Refreshing Datasets

8. Manage Roles.

Viii Projects & Hands-On


 End-to-End Sales Dashboard

 HR Analytics Dashboard

 Financial & KPI Reporting Dashboard

 Real-Time Streaming Dashboard

You might also like