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

None.