Accounting and Finance > Power BI® - Business Data Analytics - Virtual Instructor Led Training (VILT)

About this Virtual Instructor Led Training (VILT)

This Virtual Instructor Led Training (VILT) course will introduce participants to the Microsoft Power BI® software solution for extracting, manipulating, visualising and analysing data. This is a very practical, hands-on course that takes participants through a series of exercises which help users understand the Power BI® environment, how to use the key areas of functionality, and how to apply the tools it contains to design and produce analyses of their own data.

The first two days focus on learning the key concepts and practising these using clean, simple datasets. The third day provides participants with the opportunity to apply what they’ve learned to their own data. This makes the course far more relevant and meaningful for them, it allows our facilitator to help them structure their data models, queries and DAX formulas correctly, and it allows our facilitator to help them solve any additional problems that may arise but which were not covered as part of the standard the course. In addition, at the end of the day, each participant walks away with something of real, practical use for their job role. Many previous participants have remarked that they obtained the most value from the course during the third day because otherwise, they wouldn’t be able to do what they need to do.

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.

Microsoft® PowerBI® is a trademark of Microsoft Corporation in the United States and/or other countries.

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.

The VILT course will be delivered online in 3 full-day sessions comprising 7.5 hours per day, inclusive of breaks. Course Duration: 3 Full-Day Sessions, 7.5 Hours per Session (22.5 Hours in total).

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 about post training coaching support and fees applicable for this.

Learn what past participants have said about EnergyEdge training courses

Having attended a number of Power BI courses, for this course the presenter appeared to have the most in-depth ad practical knowledge of the software. This meant questions could be answered accurately and quickly, and with practical application in mind.

Occidental Petroleum Corporation

This is a superb course that managed to translate complex concepts (e.g. data cleansing, star-schema model, etc.) into something that is easily understandable by end users. The focus on data cleansing and data relationships building at the start of the course is a rarity compared to similar courses

Occidental Petroleum Corporation

Power BI is a useful and effective tool to share data in a comprehensive manner. The trainer was good in presenting the Power BI mechanism.

Manager Contracts, MISC Berhad

Trainer was knowledgeable and communicated well, training materials was good, and I am able to understand and execute Power BI after the training

Executive, Proposal, MISC Berhad

Thank you PetroEDGE for organizing a well-structured virtual training!

Executive Proposal, MISC Berhad