Booking options
£2,493 - £2,899
£2,493 - £2,899
Delivered Online or In-Person
Delivered at your location
UK & International Requests Considered
Two days
All levels
This 3 full-day training 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.
Training Objectives
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
Target Audience
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.
Course Level
Basic or Foundation
Trainer
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.
POST TRAINING COACHING SUPPORT (OPTIONAL)
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
Accreditions And Affliations
We are proud to announce that Petroedge and PowerEdge, two leading training companies in the energy industry, is now called EnergyEdg...