Course Outline

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 Modeling

  • Designing data models for financial analysis
  • Setting up relationships and hierarchies (accounts, cost centers, 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

Visualizing 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 modeling, measures, and visuals
  • Peer review and feedback session

Summary and Next Steps

Requirements

  • An understanding of Power BI data modeling and visualization
  • 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
 7 Hours

Delivery Options

Private Group Training

Our identity is rooted in delivering exactly what our clients need.

  • Pre-course call with your trainer
  • Customisation of the learning experience to achieve your goals -
    • Bespoke outlines
    • Practical hands-on exercises containing data / scenarios recognisable to the learners
  • Training scheduled on a date of your choice
  • Delivered online, onsite/classroom or hybrid by experts sharing real world experience

Private Group Prices RRP from £1900 online delivery, based on a group of 2 delegates, £600 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.

Contact us for an exact quote and to hear our latest promotions


Public Training

Please see our public courses

Testimonials (5)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories