קורס Power BI

• Overview of Power BI Desktop

Getting data

• Getting started with Power BI Desktop

• Connect to data sources in Power BI Desktop

• Clean and transform your data with the Query Editor

• More advanced data sources and transformation

• Cleaning irregularly formatted data

Modeling

• Introduction to modeling your data

• How to manage your data relationships

• Create calculated columns

• Optimizing data models

• Create calculated measures

• Create calculated tables

• Explore your time-based data

Visualizations

• Introduction to visuals in Power BI

• Create and customize simple visualizations

• Combination charts

• Slicers

• Map visualizations

• Matrixes and tables

• Scatter charts

• Gauges and single number cards

• Modify colors in charts and visuals

• Shapes, text boxes, and images

• Page layout and formatting

• Group interactions among visualizations

• Duplicate a report page

• Summarization and category options

• Interactive

• Visual hierarchies and drill-down

Exploring data

• Introduction to the Power BI service

• Quick insights in Power BI

• Create and configure a dashboard

• Ask questions of your data with natural language

• Share dashboards with your organization

• Display visuals and tiles full screen

• Edit tile details and add widgets

• Install and configure a gateway

Publishing and sharing

• Introduction to apps, security, and groups

• Publish Power BI Desktop reports

• Print and export dashboards and reports

• Manually republish and refresh your data

• Introducing Power BI Mobile

• Create groups in Power BI

• Build Apps

• Use Apps

• Update Apps

• Publish to web

Introduction to DAX

• Introduction to DAX

• DAX calculation types

• DAX functions

• Using variables in DAX expressions

• Table relationships and DAX

• DAX tables and filtering