Add This to Your Data Analysis Toolkit
Certified MS Power BI Professional (CPBIP)™ Training Course*
How to Use Power BI and Power Query to Create Incredible Data Visualizations
Power BI (including Power Query & Power Pivot) are the biggest Excel news items in the last 10 years. They give Excel users the power to draw information out of multiple sources, link it together then perform calculations on it that can then be sliced & diced any way you want.
This hands-on course is focused on real-world techniques utilising the amazing capabilities of Power Query, Power Pivot and Power BI.
The course covers the core elements needed to get an understanding of what Power BI, Power Pivot and Power Query can do. You will use Power Query to extract and shape data and then load it into Power Pivot. You will build a complex Power Pivot Model from scratch, write DAX formulas and set up interactive reports.
Then, the course delves deeper into all of the topic areas demonstrating how to get the most from these amazing tools. You will learn extra advanced Power BI features, get a more in-depth understanding of Power Query and Power Pivot reporting techniques.
Glad I attended...The course was presented professionally and is internationally recognised as a good course.
Contract Manager-Procurement, Overseas AST Co, UAE
You now have valuable skills in:
Understand how Power BI builds on the functionality of Excel’s native tools, such as PivotTables, slicers and key analytical functions so you can easily create powerful data visualizations for reports and dashboards.
Be able to import data from a variety of electronic sources and relate them quickly to deliver key information in minutes not weeks so you can compile data from multiple sources and get new insights that were hard to generate before.
Best practices in database design, realising the power of the Data Model by using LOOKUP lists and efficient database design
Power BI’s Data Analysis Expressions (DAX) language
Why Ethan Hathaway?
There are LOTS of training providers in the market, so why choose Ethan Hathaway?
Ethan Hathaway has established itself as a reputable training partner for over a decade to top companies all over the world.
Our philosophy is to make YOU as valuable as can be both in your career and your employer.
Ethan Hathaway is also a British Accreditation Council (BAC) accredited international Centre.
To become BAC accredited, we undergo a rigorous inspection and assessment to show our devotion and commitment to ensuring we provide YOU with a quality training result.
Not many other training providers can say they have gone through this process or commitment.
- Agenda highlights
- Who should enroll
Certified Power BI Professional Course Highlights
INTRODUCTION TO POWER BI
- Power BI & PowerPivot Introduction
- In-depth Power BI & Power Pivot Models
- In-Depth Power Query
- Power BI Desktop & POWERBI.com
POWER QUERY (Get & Transform) FOR EXCEL and POWER BI DESKTOP
- Power Query Introduction Refresher
- In-depth Power Query
- Advanced Technique with Power Query and an Introduction to M language
On the morning of day three, you’ll work on producing reports with your own data sets (you’ll have coaching from the Instructor as well). If you don’t or can’t bring your own data sets, sample data sets will be provided to you to use.
Certification Task-Based Assessment
This training is a task-based certification. In the second half of the third day, you’ll be asked to successfully perform specific tasks with Power BI.
Certification is based upon successful completion of these tasks.
***Download the course information booklet for the FULL details of what’s covered.***
*Disclaimer: this course is not endorsed or affiliated with Microsoft.
What You Need to Bring:
You will need to bring a laptop computer to perform all the course exercises.
This training is non-industry specific and may be applied across various industries.
Excel users & analysts that focus on extracting, re-organizing and analyzing data
Excel users & analysts involved in creating visualizations & data modelling
Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards
- Excel users & analysts that focus on extracting, re-organizing and analyzing data
- Excel users & analysts involved in creating visualizations & data modelling
- Anyone interested in saving huge amounts of time in automating the work involved in creating recurring reports and dashboards
- Technical Data Managers
- Data Analysts
- Data Technicians
- Data Quality Specialists
- Data Systems Admins
- Data Operators
This is an beginner to intermediate level course
Here’s what past clients say about our courses:
“Very open interaction & discussion. Materials very relevant for my work. Many cases which help to put things into perspective.
Very good speaker as he used to be bank’s structurer, so plenty of practical knowledge. Speaker explained very well & easy to understand.” – M.J., Standard Chartered Bank
About the instructor: “He was excellent in teaching and always keen to answer all our questions. I like how he link up theory and real life application.” – C. W.J., Commerzbank
“The course was excellent and exceeded my expectation.” – A.A., Saudi Aramco, Saudi Arabia
“The speaker has a very good knowledge and she explain the main concept very clear, very straight forward.” – C.A., Treasury, Royal Bank of Scotland (RBS), Hong Kong
“What I liked most about this training was the Trainer and her professional approach…I am pleased with the course and all the arrangements.” – S.R.N., Finance Manager, Oman Oil Company, Oman
“Excellent! Nice class and participants…What I liked most about this training course was the many exercises and case studies so I can understand more clearly day by day.” – I., Bank Rakyat Indonesia, Indonesia
“Excellent…Trainer well organized and thoroughly walk thru the materials from basic to more challenging topic.” – C.J., Standard Chartered Bank, Thailand
Your Investment Is...
3-Full days in-person/virtual training of our standard course coverage, no certification needed.
Send up to a maximum of 20 people.
+ $397 certification fee per person
3-Full days in-person/virtual training of our standard course coverage, with certification option.
Certification includes 2 exam attempts per person & first year's charter membership upon successful certification.
Send up to a maximum of 20 people.
Frequently Asked Questions
Click Here for Answers to Frequently Asked Questions (FAQ)
Q: Is there an exam?
A: No, the assessment is based upon your final project deliverables which you will complete by the end of the course.
Q: What is the required grade to pass the assessment?
A: You must achieve a 100% error-free R-Project to become certified.
Q: What are the system requirements?
- A PC or a MAC computer (Compatible with an Windows or Mac O/S computer)
- Works on iPad and iPhone
- Web Browser Software such as the latest Firefox or Internet Explorer or Safari or Chrome
- Intenet connection (It is highly recommended that you have a high-speed Internet connection such as broadband/DSL)
- Computer Speakers or headphones (for courses that include audio and video)
Q: Am I guaranteed employment if I become Certified?
A: No. There is no certification, qualification or training course that can guarantee employment.
While we hope this certification can help you get a leg up on competition, it is no guarantee of future employment.
Q: Am I guaranteed to pass the assessment?
A: No. There is no guarantee you will pass the exam.
The certification project is an unbiased project assessment meant to objectively evaluate a potential delegate's learning and ability to successfully complete a project deliverable.
Q: Can I get a refund for the online course?
A: No, we do not issue refunds on online courses nor the certification exams.
If we find you have a valid reason to ask for credit, we are happy to offer you credit towards future products/services at our discretion.
Q: Are scholarships available?
A: Currently we do not offer any scholarships.
Under certain circumstances, we may offer a payment plan for eligible individuals.
Q: Is this Certification internationally recognized?
A: Recognition is a subjective-thing. However, Ethan Hathaway is a globally recognized training provider to multinational companies and government agencies.
We also work with industry experts and professionals on our Board of Advisors to ensure the courses are relevant for the current market.
And finally, we are a British Accreditation Council (BAC) accredited international training centre.