План на курса
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
Изисквания
- An understanding of Power BI
- Experience with Power BI
Oтзиви от потребители (8)
Конструктивен обмен
Cécile - Transdev Compagnie Axonaise
Course - Power BI
Machine Translated
Треньорът е професионалист. Той може да ме накара да почувствам, че тази програма не е твърде трудна за използване, както си мислех преди тренировка.
Benjaporn - Thai Asahi Kasei Spandex Co.,Ltd
Course - Power BI for Business Analysts
Machine Translated
Получете нови знания
Yani - PT. Becton Dickinson Indonesia
Course - Power BI for Developers
Machine Translated
Темпото, дейностите и отразяването на екрана. Power Bi е нов за мен и очаквам с нетърпение да работя повече с него.
Michelle - Childhood Development Initiative CLG
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
персонализираната част, по време на която успях да работя по моя проект и директно да приложа елементите на обучението
Caroline - Schreder
Course - Power BI Dashboards
Machine Translated
Страхотно темпо по време на тренировката. много опитен и стил на преподаване
James - Gilead Sciences Ireland
Course - Excel to Power BI
Machine Translated
Това, което беше много интересно в това обучение, беше директното боравене с инструмента power bi. Това, което беше представено, беше много информативно и даде истински отговор на проблемите ми, докато се опитвах да се уча в работата. Обучителят ни даде ключове, за да бъдем по-добре организирани и структурирани в нашите файлове. Което е интересно, ако трябва да се откажем от работата си. Щяхме да отнеме още няколко часа, за да изготвим собствен доклад, това е единственият недостатък.
Linedie - Transdev Nord
Course - Advanced Power BI
Machine Translated
Упражненията
Romain MEYER - Everience
Course - Power BI Basic
Machine Translated