RELATED COURSES
Advanced SQL
Analysing Data with Excel
Critical Thinking
Data Modelling with M and Power Query
Data Visualization with Python
Data Visualization with R
Excel Dashboards and Power Pivot
GIS ESSENTIALS – “Getting Spatially Enabled”
Introduction to Statistics
Machine Learning with Python
Machine Learning with R
Microsoft Power BI Desktop Advanced Course
Microsoft Power Query
Microsoft PowerBI Dashboard User Course
MySQL
MySQL Administration
PLSQL
PostgreSQL
PostgreSQL Administration
PostgreSQL for Business Intelligence and Mass-data-analysis
Problem Solving and Decision Making
Problem-Solving SAQA US242817
Python Dashboards with plotly Dash
Python Pandas and Jupyter ETL and Data wrangling
Python Regression
Python Statistical Modelling
Python Statistics
Python Web Apps with Flask MVC Framework
R, Into the Tidyverse (Data Wrangling and ETL)
Regression with R
SQL
Statistics with R
Details
Microsoft Power BI is a comprehensive business intelligence (BI) platform designed to empower organizations to extract maximum value from their data. It transforms raw data into interactive and visually compelling insights, facilitating informed decision-making at all levels.
Organizations can empower their workforce to achieve significant success through Power BI training. This training equips employees with data analysis skills, enabling them to:
- Make informed decisions: Data becomes the driving force behind every level, fostering better choices.
- Streamline workflows: Processes become more efficient as insights guide resource allocation.
- Boost productivity: Employees empowered to analyze data independently contribute to a more productive environment.
- Gain a competitive advantage: Data-driven insights fuel strategic business decisions.
Successful completion of the Microsoft Power BI BootCamp and Advanced Courses prepares participants to write the PL-300: Microsoft Power BI Data Analyst Exam.
In this three-day course, attendees will learn the fundamentals of creating rich interactive reports and sharing their insights with others.
We will cover:
- An Introduction to Power BI
- Importing and cleansing data for use in the model
- Creating interactive reports
- Sharing your reports with others
Delivery Methods
Leading Training is focusing on providing virtual training courses for the foreseeable future and will only consider in-person and classroom training on request, with a required minimum group size of six delegates. We remain committed to offering training that is fast, focused and effective.
| Delivery Method | Duration | Price (excl. VAT) | ||
|---|---|---|---|---|
| Classroom | 3 day | ZAR 8,250.00 | Get a Quote | |
| Live Virtual Training | 3 day | ZAR 6,750.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
World Vision International
I Liked learning that course because that very better nice, i have opportunity to know other forms for do my job, its a good for my other performance with my work.
Vector Logistics
Great knowledge about the subject and other subjects as well, impressed me.
Vector Logistics
The company advised that we should use Leading Edge. I am not sure if they are a service provider to our company. Besides the display issues, the staff were friendly and accommodating.
Tronox KZN Sands
The course was very informative and the Lawrence was very informed about the content of the course. He also had a great willingness to assist ensuring we are all on the same page, even though we did move on a bit fast.
Tronox KZN Sands
The inter-activeness of the course and the course material
ChemCol Holdings Pty Ltd
Trainer was extremely patient and super clued up. He handled quite a lot of people via an online platform and I think it was done super well. It was Laurence Maoka. Thank you Laurence - you were super patient!
Audience
It is intended for use by non-IT staff, including both Line and Senior Managers, Business Analysts, BI Specialists, and Knowledge Workers.
Pre-Requisites
- Basic Understanding of Data Concepts: Familiarity with concepts such as data types, data sources, data manipulation, and data visualization can be helpful.
- Proficiency in Microsoft Excel: Since Power BI is closely integrated with Excel, having a solid understanding of Excel functions, formulas, and data analysis features can provide a strong foundation.
- A laptop with Power BI installed
IMPORTANT:
Please note that Power BI is a Microsoft app and as such, it is not designed to work on a MacBook. PowerBI Desktop is a Windows-only app. So Mac users will have to use parallels. You cannot use a laptop that does not have Windows installed. If you only have a MacBook to work on and you want to do the course, we can hire a laptop for you to use at your own cost. Please speak to your salesperson to assist you.
Course Outline / Curriculum
- Module 1: Introduction to Power BI
- What is Power BI
- Understanding the power of BI architecture
- Installing Power BI desktop
- Signup with the Power BI service
- Understanding Power BI licensing
- Module 2: Importing data using Power BI
- Loading data from files and databases
- Removing unwanted rows and columns
- Transforming data
- Cleansing and shaping data
- Using functions and parameters
- Discuss direct query and live query
- Power Query best practice
- Module 3: Building Data Model
- Building Relationships
- Working with Complex Relationships
- Usability Enhancements
- Data Model Performance
- Module 4: Enriching your data model with DAX
- Creating calculated columns and measures
- Understanding filter context
- Time intelligence functions
- Role Playing Table with Dax
- Dax Best Practice
- Module 5: Visualising Data
- Chart types
- Formatting charts
- Understanding reports, pages, and visual filters, and slicers
- Designing interactive reports
- Enhanced reports with text boxes, annotation shapes, and images
- Custom visuals
- Using report themes
- Visualization best practice
- Module 6: Digital Storytelling with Power BI
- Configuring drill through
- Capturing report views with bookmarks
- Combining object visibility with bookmarks
- Report pages as tooltips
- Module 7: Sharing reports with the Power BI Service
- Publishing reports to the Power BI service
- Understanding the difference between reports and dashboards
- Creating schedules and alerts
- Q&A
- Setting up row-level security
- Keeping data up-to-date with scheduled refreshes and the data gateway
- Designing dashboards for mobile
- Creating Power BI apps
- Publish Power BI to Web
Schedule Dates and Booking
There are currently no scheduled dates.
Please note that this course needs a minimum of 6 delegates to schedule a course. You can choose to be added to the waiting list by clicking the button below, and we will contact you when we have enough delegates interested. Should we not get enough delegates, we will refund or credit your paid booking.
Should you need this course urgently, the following options are available:
- Pay for 6 delegates (whether you have them or not) and we will schedule the course as soon as possible.
- If you have fewer delegates and cannot pay for 6, we can negotiate a shortened course where some of the time will be spent in blended learning - watching videos and doing tutorials and exercises with some contact time with the trainer. We would want to discuss what your core needs are so that we cover those aspects. You need to have paid for 3 delegates at least.