Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
Requirements
Power BI Desktop 64 bit
Power BI Service or Power BI Pro licence for module 7.
14 Hours
Testimonials (7)
Although we received much information in such a short time, Shaun was extremely patient and understanding and provided support anytime we needed it.
Carmen - HARTING
Course - Power BI Basic
Trainer was open to answering questions and spend time with each individual trainee to provide required information.
Claudiu - HARTING
Course - Power BI Basic
An interactive and dynamic training that keeps one focused at all times
Delia - HARTING
Course - Power BI Basic
Very interactive. good hints to fasten and ease work in Power BI.
Oana - HARTING
Course - Power BI Basic
What I liked most about the training was Shaun's expertise. He is clearly an expert, and it was fantastic having him as our trainer. He really challenged us, providing a solid introduction to Power BI.
Michael - HARTING
Course - Power BI Basic
Very good explanation, very interactive, support in clarifying all the aspects. Nice Irish accent! :)
Georgiana Miclea - HARTING
Course - Power BI Basic
Interactive atmosphere, the trainer was very helpful, flexible and adapted the material with regards to the audience's needs.
