Plan Szkolenia
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
Wymagania
- An understanding of Power BI
- Experience with Power BI
Opinie uczestników (9)
dużo praktyki w trakcie szkolenia
Katarzyna Grześkowiak - mTab Sp. z o.o.
Szkolenie - Power BI - wizualizacja danych
dyskusja na temat legalnosci umieszczania danych w chmurze i dobre praktyki przy modelowaniu i raportowaniu.
Szkolenie - Microsoft Power BI Data Analyst (szkolenie autoryzowane PL-300)
Constructive exchanges
Cécile - Transdev Compagnie Axonaise
Szkolenie - Power BI
Trener jest profesjonalny. Potrafi sprawić, że czuję, że ten program nie jest zbyt trudny w użyciu, jak myślałem przed treningiem.
Benjaporn - Thai Asahi Kasei Spandex Co.,Ltd
Szkolenie - Power BI for Business Analysts
Przetłumaczone przez sztuczną inteligencję
Zdobywanie nowej wiedzy
Yani - PT. Becton Dickinson Indonesia
Szkolenie - Power BI for Developers
Przetłumaczone przez sztuczną inteligencję
Tempo, działania i dublowanie ekranu. Power Bi jest dla mnie nowością i nie mogę się doczekać dalszej pracy z nim.
Michelle - Childhood Development Initiative CLG
Szkolenie - Creating Dashboards Using Microsoft Power BI
Przetłumaczone przez sztuczną inteligencję
the personalized part during which I was able to work on my project and directly apply the elements of the training
Caroline - Schreder
Szkolenie - Power BI Dashboards
Great pace during the training. very knowledgeable and teaching style
James - Gilead Sciences Ireland
Szkolenie - 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.