Takk for at du sendte din henvendelse! En av våre teammedlemmer vil kontakte deg straks.
Takk for at du sendte din bestilling! En av våre teammedlemmer vil kontakte deg straks.
Varighet 7 timer
Kursplan
Overview of PL-300 certification
- Exam objectives and structure
- Skills measured and competency areas
- Preparation resources and study strategies
Data preparation for financial reporting
- Extracting and cleaning data using Power Query
- Combining multiple financial data sources
- Handling time-based and transactional data
Financial data modelling
- Designing data models for financial analysis
- Setting up relationships and hierarchies (accounts, cost centres, departments)
- Implementing measures for revenue, cost and profit tracking
Creating financial KPIs and calculations
- Key financial metrics: ROI, variance, margin and growth rate
- Using DAX for year-to-date and rolling calculations
- Designing custom KPIs for business performance analysis
Visualising financial insights
- Building executive dashboards and scorecards
- Using conditional formatting and key influencers visuals
- Creating visuals for variance, trend and cash flow analysis
Exam preparation and practice
- Review of common PL-300 questions and scenarios
- Case-based exercises using real exam topics
- Final review: best practices and test-taking strategies
Hands-on project: financial dashboard simulation
- Building a full financial analysis report for a sample company
- Integrating data modelling, measures and visuals
- Peer review and feedback session
Summary and next steps
Krav
- An understanding of Power BI data modelling and visualisation
- Experience working with financial data or reports
- Basic knowledge of DAX and Excel formulas
Audience
- Financial analysts preparing for the Microsoft PL-300 certification
- Business intelligence professionals focused on financial reporting
- Accountants and finance managers using Power BI for data-driven insights
Referanser (2)
Hvordan bruke relasjoner i Power BI, og forskjellene mellom kolonner og målinger
LEUNG Chun Hei - HAESL
Kurs - Advanced Power BI: Data Modeling, DAX, and Enhanced Analytics
Maskinoversatt
Treningmetode.
Ineshia Bilankulu - National Transmission Company South Africa
Kurs - Power BI: Basics to Advanced
Maskinoversatt
