Course Outline
Module 1 :Getting data organised
Grouping tables
Append tables to a query
Module 2 : Advanced Power Query M language
When to use M and when to use DAX
Create a date table in Power Query Editor
Module 3 : Advanced data refreshing
Data refresh
Gateways
Installing a gateway
Adding data sources
Scheduled refresh using gateway
Module 4 : Time intelligence
SAMEPERIODLASTYEAR function
DATEADD function
PARALLELPERIOD function
TOTALYTD and TOTALMTD functions
Module 5 : DAX and filter contexts
FILTER function
ALL function
ALLSELECTED function
CROSSFILTER function
DIVIDE function
Variables in DAX
Ranking with RANKX
What-if parameters
LOOKUPVALUE function
Module 6 : Advanced report features
Creating a hierarchy for a non-date field
Drill-through
Report tooltips
Grouping and binning
Installing custom visuals
Module 7: Perform analytics in Power BI
You will learn how to use Power BI to perform data analytical functions, how to identify outliers in your data, how to group data together, and how to bin data for analysis. You will also learn how to perform time series analysis. Finally, you will work with advanced analytic features of Power BI, such as Quick Insights, AI Insights, and the Analyze feature.
Learning objectives
In this module, you will:
Explore statistical summary.
Identify outliers with Power BI visuals.
Group and bin data for analysis.
Apply clustering techniques.
Conduct time series analysis.
Use the Analyze feature.
Use advanced analytics custom visuals.
Review Quick insights.
Apply AI Insights.
Module 8: Implement row-level security
Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you will learn how to implement RLS by using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.
Learning objectives
In this module, you will:
Configure row-level security by using a static method.
Configure row-level security by using a dynamic method.
Summary and Next Steps
Requirements
Audience
- Power BI for Beginner
Testimonials (7)
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
Constructive exchanges
Cécile - Transdev Compagnie Axonaise
Course - Power BI
Machine Translated
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