Curs Power BI

Module

MODUL 1: USING EXCEL AS A DATA SOURCE FOR POWER BI

Connecting to Files
Importing Excel Files
Updating Files in Power BI
Data Refresh

MODUL 2: INTRODUCTION TO POWER BI

What is Power BI
Understanding Power BI Tools: Power BI Desktop, Power BI Service, Power BI Mobile and Power BI for Developers

MODUL 3: AN INTRODUCTION TO POWER BI DESKTOP

Workflow in Power BI Desktop
Taking a closer look at the Query Editor Interface
Introducing the Different Views of the Data Model

MODUL 4: QUERY EDITOR

An Introduction to the Query Editor
Connecting Power BI Desktop to our Data Sources
Editing Rows
Understanding Append Queries
Editing Columns
Replacing Values Formatting Data
Pivoting and Unpivoting Columns
Splitting Columns
Duplicating and Referencing Queries
Merging Queries
Creating an Index Column
Creating Contitional Columns
Performing Basic Mathematical Operations

MODUL 5: WORKING ON OUR DATA MODEL:

Data & Relationship View Query Editor vs. Data Model
Introducing and Understanding Relationships
Editing Relationships
Understanding Cardinality
Cross Filter Selection and Many-to-Many relationships
Understanding the differences between the M-Language and DAX
M vs. DAX applied: Calculated Columns
DAX – Basic information
DAX and Calculated Columns
Calculated Columns vs. Measures
Introducing DAX-Measures

MODUL 6: WORKING IN THE REPORT VIEW TO VISUALIZE OUR

RESULTS
Operatori matematici si ordinea operatiilor(adunare, scadere, inmultire, impartire, procent)Understanding the Interface of the Report View
Creating our First Visualizations
Editing Interactions and Adding Tooltips
Adding Data Colors
Understanding Hierarchies and Adding Drill-Down
Formatting Charts and Sorting
Introducing Slicers
Adding Treemaps and Tables
Applying different Filter Types
Understanding Combined
Visualizations and Waterfalls