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
Introduction
- Overview of Power BI features and architecture
- Advanced tools and data analysis in Power BI
Getting Started
- Installing Power BI and other components
- Workflow for preparing reports and dashboards
- Overview of the interface
Power Query – importing the data
- Types of connectors
- Query folding
- Extracting data from different sources:
- Flat files
- Whole folders of data
- Websites
- Working with unstructured files
- Advanced techniques in Power Query
- Merging and appending the tables
- Pivoting and Un-Pivoting of the data
- Automated columns from examples
- Working with inconsistent tables
- Tables decomposition
- Best practices in analyzing text
- Basics of M language
Data Model – why do you need one?
- What is data model?
- Data model normalization
- 2 main types of tables
- Relationship cardinality
- One to many
- One to one
- Many to many
- Filter flow – logic behind the engine
- How to create hierarchy?
- Data modelling best practices
DAX – the best tool to make your date useful
- What is DAX and why is to so good?
- What is a difference between measure and calculated column? Which one should I use?
- Filter context vs. Row Context
- How to create measure table?
- Variables in measures
- How to create variables?
- Why you should use variables?
- How to handle errors and debug with variables?
- Scalar functions
- Basic aggregation functions
- Iterator functions
- SWITCH function – better IF
- How you can use COALESCE function?
- Advanced CALCULATE use:
- The modifiers
- REMOVEFILTERS and KEEPSFILTERS functions with examples
- What is a Pattern?
- Table and Filter functions
- Most common table functions
- Difference and examples of using VALUES and DISTINCT functions
- How to incorporate SELECTEDVALUE to your report?
- ALLEXCEPT
- ALLSELECTED
- Why you should now SUMMARIZE?
- Different ways to generate new data for your report
- Table joins:
- How to CROSSJOIN tables?
- EXCEPT and INTERSECT with examples
- How you can use UNION function
- Relationships Functions:
- What is the difference between physical and virtual relationship?
- RELATED and RELATEDTABLE
- How to use USERELATIONSHIPS?
- Advanced concept of time intelligence
- How to prepare Fiscal and non-standard calendars for your model?
Advanced visualization techniques:
- How to prepare your own color pallet for your report?
- How to build a theme for all your reports?
- How to create great slicer panel?
- Learn to create compelling graphs that do not lie
- Learn to distinguish between good, bad and wrong visualization
- The simplest recipe to make your report look good
- Interactive Scenario Analysis for your users
- Forecast and trend lines for better data recognition
- Drilling up and drilling down
- Why you should use parameters?
- Bookmarks as your allies in data visualization
Requirements
- An understanding of Power BI
- Experience with Power BI
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
The content was tough but that extra effort I had to put helped me remember and understand power BI better.
Melvin - TLI Group
Course - Power BI DAX Fundamentals
Discussing about our issues
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
What I liked the most was the coach's openness regarding the change in content as well as the approach that was previously prepared to accommodate our real needs
Ernesto Sitoe Junior - Electricidade de Mocambique
Course - Advanced Power BI
The second day as Power Bi is a really friendly tool, and clearly Costas knows it very well, it was really good to learn about that tool. Unfortunately we have to see Power pivot in excel first which is really not user friendly but definitely a must see first in order to understand how Power Bi works, and it makes Power Bi look super cool :)
Anne-Cecile Jacquot - Ameropa
Course - Excel to Power BI
The second day was very interesting. It was a good training to see some possibilities within Power BI; but mostly you learn then while you work with Power BI. Fact is also that the training base has all access rights and everything works, but as soon as you try to connect to the live system, it does not work and this makes the knowledge transfer a bit difficult.
