Power BI Complete Course

Introduction

• Business Intelligence Introduction
• Getting started power BI
• Differentiate Power BI and Tableau
• Advantages of power BI
• Features of power BI
• Architecture
• Components of power BI
• Data extraction from various data sources (SQL, Access, Excel, Oracle, Web etc.)
• Relationship
• Data handling
• Power BI installation

Data Source

• Step by step data extraction from different sources
• Data Type Handling
• Change the Data Type
• Data Transform and Shapes
• Data Model
• Data Load

Building Blocks

• Dataset
• Visualization
• Report
• Dashboard
• Tiles

Power Query

• Query editor
• Change the query as per requirement
• Query data preview
• Refresh data
• M Query Language

Power Pivot

• Data Model
• Data Filter
• Visualization level filter
• Calculated field
• Slicer
• Group and Ungroup

Power Map

• Types of Maps
• Geographical data view
• ArcGIS

Power View

• Reports (Drill down, Drill through)
• Dashboard
• Tiles
• Charts (Column, Bar, Pie, Line, Doughnut, Funnel, Gauge Charts etc)
• Formatting

Dax Functions

Aggregate Functions

• MIN
• MAX
• Average
• SUM
• SUMX

Counting Functions

• DISTINCTCOUNT
• COUNT
• COUNTA
• COUNTROWS
• COUNTBLANK

Logical Functions

• AND
• OR
• NOT
• IF
• IFERROR

TEXT Functions

• REPLACE
• SEARCH
• UPPER
• FIXED
• CONCATENATE

DATE Functions

• DATE
• HOUR
• WEEKDAY
• NOW
• EOMONTH

INFORMATION Functions

• ISBLANK
• ISNUMBER
• ISTEXT
• ISNONTEXT
• ISERROR

DAX Calculation Types

• Calculated columns
• Calculated measures

Data Management Gateway

• On premises Gateway
• Schedule data refresh

Publish your report using power BI services

• Publish report
• Share report with stackholder