In just two days, the training course “Microsoft Power BI Fundamentals” will teach you how to improve your reporting using Microsoft’s free, self-service business intelligence solution.
You’ll learn how to import and transform data from Excel and any other source, create complex data models, and prepare appealing, interactive, and up-to-date reports.
Attendance fee
Customers of Lucanet Group receive a 10% discount.
Partners of Lucanet Group receive a 20% discount.
Discounts are not combinable.
Target group
- This workshop is aimed at anyone wanting to get to grips with Microsoft Power BI for the first time.
- No previous knowledge of Microsoft Power BI is required, but basic Excel skills would be helpful.
What you'll learn
- How to import, validate, and transform data from various sources
- How to link tables, create a data model, and calculate measures
- How to create appealing, informative, and interactive reports
- Best practice solutions
- Tips and tricks from experienced trainers and consultants
Note: The course is available for use in the Lucanet Learning Space for a maximum duration of 12 months. Once this period is up, you should have worked through all the learning modules, downloaded any learning material you want to keep, and completed the course.
Further training on Microsoft Power BI
Course procedure
Note: The registration deadline is 14 days before the start of the live training (subject to available spots).
Agenda/content
1. Introduction to Power BI
- Understanding the concept behind Power BI and its possible uses
- Understanding Power BI in the context of other Microsoft products
- Introduction to Power BI Desktop
2. ETL process using the Power Query Editor
- Familiarizing yourself with the Power Query Editor’s user interface
- Importing data (Excel, csv/txt, folders, SharePoint, web, databases, etc.)
- Validating, transforming, and enriching data
3. Data modeling
- Understanding the basics of data modeling
- Creating a Power BI Desktop data model
- Defining relationships, the filter direction, and cardinality between tables
4. Measures and DAX
- Using quick measures
- Introduction to the Data Analysis Expressions (DAX) programming language including functions for text, date, time intelligence, etc.
- Implementing column-based calculations using DAX
- Implementing measures using DAX
5. Reports
- Internalizing the basics of report design
- Learning about a range of common visuals, including charts and cards
- Understanding filter options, data slicers, and the cross-filtering feature
- Creating reports/report pages