Course Code:
pwrbibasic
Duration:
14 hours
Prerequisites:
Power BI Desktop 64 bit
Power BI Service or Power BI Pro licence for module 7.
Overview:
This instructor-led, live training (online or onsite) is aimed at beginner-level users who with to learn Power BI.
Format of the Course
- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
Course Outline:
Module 1: Basics
- Course structure and content
- Download: project files
- Introduction to the course project
- Important information about the course
Module 2: Introduction to Microsoft in Power BI
- Presentation of Power BI Desktop and its components
- Download, Installation and Power BI Desktop settings
- Important: settings and options
- Power BI Service and mobile application
Module 3: Connecting and modeling data in Microsoft Power BI Desktop
- Types of data connectors in Power BI Desktop
- Query Editor (Power Querry)
- Data import from Excel and CSV
- Basic table transformations in Power BI Desktop
- Working with TEXT type tools
- Working with NUMERIC type tools
- Working with DATE and TIME instruments
- Generating conditional and index type columns
- Data grouping and aggregation
- Pivot / Unpivot in Power BI
- Data fusion in Power Query (Merge)
- Pasting data in Power Query (Append)
- Import from a Folder
- Modification of data sources and refresh (Refresh)
Module 4: Creating links between tables and data models in Power BI Desktop
- What is a Data Model?
- DATE type tables and DIMENSION type tables
- Creating Relationships between tables
- Management and editing of relationships between tables
- Cardinality of relationships; Filter Flow
- Connecting several DATA type tables
Module 5: Data analysis with DAX calculations in Power BI
- Introduction to DAX (Data Analysis Expressions) + SYNTAX
- Intro DAX – Calculated Columns
- Intro DAX – Measures
- The filter context of the Measures
- Categories of DAX functions
- Date and Time functions
Module 6: Data visualization in Power BI
- Introduction to the "Report" Mode
- Inserting visuals in Power BI
- Visual formatting options
- Filtering options
- Explore data with the Matrix visual
- Data filtering using Slicers
- Displaying the values using the Card and KPI visuals
- Editing interactions between reports
Module 7: Power BI Service and integration with Teams
- Publishing reports from Power BI Desktop in Power BI Service
- Creating Dashboards from published reports
- Sharing options with team members using Microsoft Teams
- Sharing and collaboration in Power BI Service
- Data export: Excel, PowerPoint, PDF
Sites Published: