Upon completion of this training course, participants will be able to:

• Confidently use the Power BI^® solution, including Power BI^® Desktop, PowerBI^®.com and the Power BI^® Gateway
• Extract data from a variety of data sources and manipulate the data extracted so it is ready for analysis
• Combine data sources together and gain an introductory understanding of the M language
• Write formulas using the DAX language for generating custom columns, measures and tables
• Design reports and dashboards using a wide range of both built-in and custom visuals
• Publish reports and dashboards to PowerBI^®.com
• Share reports and dashboards with others using PowerBI^®.com
• Customize reports and dashboards so that different user groups automatically see their own personalized views

This training course is intended for:

• Financial Analysts
• Accountants
• Budgeting and planning specialists
• Treasury
• Risk Managers
• Strategic Planners

This is an introductory course and although it does not assume any prior experience with Power BI^®, participants will gain much more from the course if they have at least used Power BI^® a little prior to attending. Participants who have taught themselves Power BI^® will also benefit from attending as the course will fill-in a number of gaps in their knowledge and will also extend what they know. A general understanding of databases, Excel formulas, and Excel Pivot Tables is useful though not essential. Comprehensive course notes, exercises and completed solutions are included.

• Intermediate

Your expert course leader has a Masters (Applied Finance & Investment), B.Comm (Accounting & Information Systems), CISA, FAIM, F Fin and is a Microsoft Certified Excel Expert. He has over 20 years’ experience in financial modelling, forecasting, valuation, model auditing, and management reporting for clients throughout the world. He is skilled in the development and maintenance of analytical tools and financial models for middle-market companies to large corporates, at all levels of complexity, in both domestic and international settings.

He has trained delegates from a wide variety of Oil & Gas companies including Chevron, Woodside, BHP Billiton, Petronas, Carigali, Shell, Nippon, Eni, Pertamina, Inpex, and many more. He provides training in financial modelling for companies throughout the Asia, Oceania, Middle East and African regions.

Before his current role, he spent 6 years working in the Corporate and IT Consulting divisions of a large, multinational Chartered Accounting firm.

He is the author of a number of white papers on financial modelling on subjects such as Financial Modelling Best Practices and Financial Model Auditing.

Highlights from his oil and gas experience include:

• Development of economic models to assist Decision Analysts modelling for a wide range of scenarios for multinational oil & gas assets.
• Auditing and further development of life of project models for Chevron’s Strategic Planning Division analysing their North West Shelf assets.
• Development of business plan and budgeting models for multinational oil & gas assets.
• Development of cash flow and taxation models for a variety of oil gas companies.
• Consulting on Sarbanes Oxley spreadsheet remediation and risk assessment.

To further optimise your learning experience from our courses, we also offer individualized “One to One” coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster.
Request for further information post training support and fees applicable