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
Testimonials (8)
Constructive exchanges
Cécile - Transdev Compagnie Axonaise
Course - Power BI
Machine Translated
The Trainer is professional. He can make me feel this program not too hard to use as I thought before training.
Benjaporn - Thai Asahi Kasei Spandex Co.,Ltd
Course - Power BI for Business Analysts
Dpt ilmu baru
Yani - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
The pace, activities and screen mirroring. Power Bi is new to me and I am looking forward to working with it more.
Michelle - Childhood Development Initiative CLG
Course - Creating Dashboards Using Microsoft Power BI
the personalized part during which I was able to work on my project and directly apply the elements of the training
Caroline - Schreder
Course - Power BI Dashboards
Machine Translated
Great pace during the training. very knowledgeable and teaching style
James - Gilead Sciences Ireland
Course - Excel to Power BI
What was very interesting in this training was the direct handling of the power bi tool. What was presented was very informative and provided a real answer to my problems, while trying to learn on the job. The trainer gave us keys to be better organized and structured in our files. Which is interesting if we have to give up our work. It would have taken a few more hours to produce our own report, that's the only downside.
Linedie - Transdev Nord
Course - Advanced Power BI
Machine Translated
The exercices