План на курса
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
Изисквания
- 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
Отзиви от потребители (5)
Това, че треньорът питаше от време на време за нашите стъпки, работата беше разделена между стаите. И така, получихме възможност да работим в малка група.
Alina - Sustainalytics
Курс - Microsoft Power Automate
Машинен превод
Съдържанието беше трудно, но тези допълнителни усилия, които трябваше да положа, ми помогнаха да запомня и разбера по-добре power BI.
Melvin - TLI Group
Курс - Power BI DAX Fundamentals
Машинен превод
Обсъждане на нашите проблеми
Rr Dwi Putri Periska Sari - PT. Becton Dickinson Indonesia
Курс - Power BI for Developers
Машинен превод
What most impressed me was the coach's openness regarding the change in content, as well as the approach that was previously prepared to meet our actual needs.
Ernesto Sitoe Junior - Electricidade de Mocambique
Курс - Advanced Power BI
Машинен превод
Втория ден като Power Bi е толкова приятен инструмент и очевидно Костас го познава много добре, беше толкова приятно да се научим повече за този инструмент. Злополучно, първо трябва да видим Power pivot в Excel, който не е толкова приятен за работа, но е определено задължителен за разбиране на работата на Power Bi, и това прави Power Bi да изглежда супер кул :)
Anne-Cecile Jacquot - Ameropa
Курс - Excel to Power BI
Машинен превод