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 Boot Camp
Microsoft Power BI Desktop Advanced
Microsoft Power Query
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
Working with data in a team can be tough. You need to share and communicate insights and make sure each team member has easy access to the information they need. Power BI Dashboards make these tasks simple and visually appealing but building them from scratch can be a little intimidating. Our Power BI Dashboard course is designed to help teams build and collaborate their own dashboards using their actual data. By the time you leave the course, you’ll have ready-to-use dashboards and a team that knows how to use them. This course is custom designed for each team, so group bookings are essential.
The course:
- Makes use of the Microsoft PowerBI.com web-based application to create basic reports and dashboards. The reports and dashboards can be shared both inside and outside of the company
- Focuses on the skills that will be needed by dashboards users to compile reports and dashboards, and share the dashboards with colleagues and clients
- Covers the basic built-in visualizations in detail, with the relevant exercises
- Covers the advanced built-in functionality for visualization as demonstrations and as self-study sections
- Gives some guidelines for report and dashboard design
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 | 2 day | ZAR 5,500.00 | Get a Quote | |
| Live Virtual Training | 2 day | ZAR 4,500.00 | Get a Quote |
Discounts Available
Save up to 10% by booking and paying 10 business days before the course.
Brochure:
Customer Testimonials
RCL Foods Sugar & Milling
The presentation and practical applications would have liked more practical exercises or more work related exercises. - Overall good.
RCL Foods Sugar & Milling
i can now see how i can use this for work and be able to deliver powerful data analytics to the business.
RCL Foods Sugar & Milling
Very practical
RCL Foods Sugar & Milling
I am not familiar with this environment.
NinetyOne SA (Pty) Ltd
Excellent course.
RCL Foods Sugar & Milling
The course was straight to the point
Audience
This is a bespoke course for specific audiences and is therefore not on our public schedule. This course needs to be customised to the unique settings of a business and will, therefore, be quoted on separately. The possible audience includes the executive team, their personal assistants, divisional heads, line managers, as well as personnel who need to receive alerts on changes in data.
Pre-Requisites
Delegates must have a working knowledge of Microsoft Windows, and either Microsoft Edge, Microsoft IE, or Google Chrome. Delegates should be able to use one of the Microsoft Office applications on a basic level. Delegates should have some experience in doing reporting.
It is assumed that anyone coming on this course will have Windows installed on their computer and that they will not bring a MacBook to training with no Windows in parallel, as Power BI is a Windows app and is not designed to work on a MacBook.
Course Outline / Curriculum
"Course Outline":
- Overview of Business Intelligence and PowerBI
- Microsoft Self-Service Business Solution
- Microsoft PowerBI applications
- Using Data Sources:
- Data Sources available
- Uploading Excel workbook
- Uploading CSV file
- Uploading a Web page containing tables
- Accessing a SQL Server database
- Accessing Microsoft PowerBI.com web-based application
- Login
- Review the structure of the application
- Accessing the first dashboards
- Use Built-in Visualizations and Formatting to create Reports
- Data Structure of the sample database
- Tables
- Table granularity
- Matrices
- Cards
- Multi-level cards
- Switching between table types
- Basic charting and the Bar chart
- Column chart
- Line chart
- Pie chart
- Adjusting charts
- New visualizations
- Enhancing charts
- Clustered charts
- 100% Stacked charts
- Text boxes
- Page background color
- Interacting with the data
- Drilling down
- Slicers
- Using charts to slice data
- Filtering data
- Dashboards
- Working with a Dashboard
- Using the PowerBI application for Android
- Create an alert
- Additional visualizations
- Donut charts
- Funnel charts
- Scatter charts
- Bubble charts
- Waterfall charts
- Line and stacked column charts
- Maps
- Gauges
- Custom visualizations
- Bubble chart play axis
- Best Practice for Dashboard design
- Optional: Data sources and data manipulation
- Accessing a SQL Server database
- Refresh data
- Split data columns imported from a CSV file
- Close
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.