Installing and setting up Power BI desktop - IICS India

[{"Value":"","Discard":false,"Expires":9999999999}] Installing and setting up Power BI desktop - IICS India

Course Content

PowerBI

0/63

Installing and setting up Power BI desktop

About the data and way forward

Getting data from a CSV file

Getting data from SQL DB

Getting data from all files in a folder

Getting data from XML file

Introduction to Power Query Editor

Important checks before we transform data

Merging and Appending Queries Theory

Appending queries

Merging queries

Manage rows and columns

Replace Values option

Pivoting and unpivoting theory

Pivoting and Unpivoting

Format text options

Number Transformations

Date Time Transformations

Add column – Column from examples

Add a custom column

Conditional and index column

Introduction to Model View

Creating and Modifying Relationships

Cardinality and Cross filter direction

Fact and Dimensions tables

Star and Snowflake Schemas

Data Pane and the Properties Pane

Bar chart and Column chart in Power BI

Clustered bar chart and stacked bar chart

Formatting options in a chart

General formatting options

Small multiples, Tooltips and Drill Through

Line and Area Chart

Combination chart or Combo chart

Pie and Donut chart

Scatter chart and Bubble chart

Add further analysis tab

Table and Matrix Visuals

Card and Multi-row card

Hierarchies in Power BI

Map charts in Power BI

Conditional formatting of charts

Introduction to DAX

DAX syntax and Row and filter context

Types of operators and functions

Demonstration of new columns and new measures

Using explicit measures to create new measures

IF function with logical operators

Count and Distinct count functions

RELATED function

CALCULATE function

Introduction to reports

Formatting report page and creating a page template

Slicers on report page

Drill-through for report pages

PowerBI

0% Complete