Financial Accountant Bundle
Target Positions:
Annual Salary 80-100K + Super
Suitable for:
* Assistant Accountant
* Financial Accountant
* Group Accountant
* Corporate Accountant
* Finance Manager
* Assistant Financial Controller
* Financial Controller
* Assistant Accountant
* Financial Accountant
* Group Accountant
* Corporate Accountant
* Finance Manager
* Assistant Financial Controller
* Financial Controller
Financial Accountant Bundle Course Outline:
Target Positions: Annual Salary 80-100K + Super
Financial Analyst Bundle
Target Positions: Annual Salary 100-120K
Suitable For :
* Financial Accountant
* Management Accountant
* Finance Business Partner
* Financial Analyst
* FP&A Analyst
* Commercial Analyst
* Financial Accountant
* Management Accountant
* Finance Business Partner
* Financial Analyst
* FP&A Analyst
* Commercial Analyst
Financial Analyst Course Outline:
Target Positions: Annual Salary 100-120K
Power BI & Business Analyst
Target Company Size:
Over 200 Millions turnover
Australia / USA listed Company
Target Positions:
* Finance Business Partner
* Financial Analyst
* FP&A Analyst or FP&A Manager
* Commercial Analyst
* Commercial Finance Manager
* Business Analyst
* Power BI Analyst
Power BI & Power Pivot Course Outline:
Annual Salary Expectation: 120-150K
 |
 |
 |
 |
|
P&L OLAP Cube KPI Modeling |
Using Multiple Fact Table |
|
Power Query- "M" Language |
|
|
Working With Multi-National Currencies |
Power Query COMPLEX TYPES |
|
Custom Calendar - Aggregation |
Context Evaluation 26-Jul-2020 |
|
Relationship Evaluation 02-Aug-2020 |
Power BI Desktop Table Visuals 09-Aug-2020 |
|
Power BI Costing 16-Aug-2020 |
Power BI Service Introduction 23-Aug-2020 |
|
Processing Project Performance 30-Aug-2020 |
Calculate Common Industry Metrics 06-Sep-2020 |
|
Data Model - Expanded Table 13-Sep-2020 |
Working With Granularity 20-Sep-2020 |
| Custom Calendar Period Comparison 27-Sep-2020 |
Custom Calendar - Overlapping Period 04-Oct-2020 |
|
Power BI Sales Analysis 11-Oct-2020 |
Many to many relationship 18-Oct-200 |
|
Computing Customer KPI 01-Nov-2020 |
Power Query Objects 08-Nov-2020 |
|
Evaluating Employment Measures 15-Nov-2020 |
OLAP Financial Statements 22-Nov-2020 |
|
BI Strategic Planning 29-Nov-2020 |
DAX Engine Optimization 06-Dec-2020 |
| Power BI DeskTop Matrix and Card Visuals 13-Dec-2020 |
Charts in Power BI Desktop 20-Dec-2020 |
|
Financial rate and revenue |
ABC Classification |
| Basket Pattern Analysis |
Power Query Plan |
| Understanding the Power Query M Language |
Structuring, Managing, and Parameterizing Queries |
| Power Query Formulas |
Row-Level Security |
| Formatting Charts in Power BI Desktop |
Dealing with Datasets |
| Maps in Power BI Desktop |
Filtering and Slcing Data In Power BI Desktop |
Power BI Service
| Power BI Components and Tools |
Power BI Service Content |
| Power BI Service Gateway | Import Data or Scheduled Refresh |
| DirectQuery |
Live Connection |
| Choosing the Right Connection Type |
Dashboard and Report Sharing |
| Workspaces as a Collaborative Environment |
Power BI Apps |
| Publish to Web |
Power BI Sharing Methods |
| Dynamic Row-Level Security |
Power BI Administrator Configuration |
| Power BI Licensing Guide |
Power BI Premium |
|
PowerPoint Integration with Power BI |
Power BI and Excel |
| Power BI Report Server |
Real-Time Streaming with Power BI |