Skip to main content

Microsoft Power BI Boot Camp

TRAINING COURSE

Microsoft Power BI Boot Camp

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 R
Microsoft Power BI Desktop Advanced Course
Microsoft Power Query
Microsoft PowerBI Dashboard User Course
MySQL
MySQL Administration
Oracle SQL Intermediate to Advanced
PLSQL
PostgreSQL
PostgreSQL Administration
PostgreSQL for Business Intelligence and Mass-data-analysis
Problem Solving and Decision Making
Problem-Solving SAQA US242817
Python Pandas and Jupyter ETL and Data wrangling
Python Regression
R, Into the Tidyverse (Data Wrangling and ETL)
Regression with R
SQL
SQL Online
Statistics with R

COURSE TRAINERS

Bernard Niewoud

Lawrence Maoka Mark Badham Michael Johnson

CUSTOMERS

Vector Logistics

Details

You are an experienced business user of reports and dashboards and understand the role that reporting plays in the decision-making process of your organisation. You need to build reports and dashboards with the minimum involvement of the IT Department, using diverse data sources, for deployment on internal servers, Microsoft OneDrive, Web interfaces, tablets, and smartphones. You create reports and dashboards on an advanced level and / or make these available to colleagues for use on their own dashboards. You need a tool to support the process of creating these reports, and to manage the data and visualizations required by other reports and dashboards. The visualizations may be charts, tables, matrices, text boxes, slicers, etc Your company may use Microsoft Power BI, Microsoft SQL Server, Microsoft SSRS or MS Excel Dashboards Come and learn how to use Microsoft Power BI (Business Intelligence) On completion of the Microsoft Power BI BootCamp and Microsoft Power BI Advanced Courses, delegates may also write the PL-300: Microsoft Power BI Data Analyst Exam Online.

In this three-day course, attendees will learn the fundamentals of creating their own 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
  • Modeling your data with DAX
  • 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)
Fulltime 3 day R 7,647.00 Get a Quote
Webinar 3 day R 5,547.00 Get a Quote

Discounts Available

Save up to 10% by booking and paying 10 business days before the course.

Brochure:

Download Brochure


Information may change without notice.

Audience

It is intended for use by non-IT staff, including both Line and Senior Managers, Personal Assistants, Business Analysts, BI Specialists, and Knowledge Workers.

Pre-Requisites

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: Enriching your data model with DAX
    • Understanding table relationships (Active vs inactive & single direction vs both)
    • Creating calculated columns and measures
    • Extending your model using date tables (Calculated table)
    • Create hierarchies
    • Change date and number formats
    • Understanding evaluation context
    • Time intelligence functions
    • Modeling best practice
  • Module 4: Visualisations
    • Chart types
    • Formatting charts
    • Understanding report, page, 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 5: Sharing report 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
    • 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

To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.

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.

Start Date End Date Branch Status  
Mon 29 Jan 2024 Wed 31 Jan 2024 Fourways Scheduled

Book Webinar

Mon 26 Feb 2024 Wed 28 Feb 2024 Fourways Scheduled

Book Webinar

Mon 25 Mar 2024 Wed 27 Mar 2024 Fourways Scheduled

Book Webinar

Mon 22 Apr 2024 Wed 24 Apr 2024 Fourways Scheduled

Book Webinar

Mon 20 May 2024 Wed 22 May 2024 Fourways Provisional Enquire
Wed 19 Jun 2024 Fri 21 Jun 2024 Fourways Provisional Enquire
Mon 15 Jul 2024 Wed 17 Jul 2024 Fourways Provisional Enquire
Mon 12 Aug 2024 Wed 14 Aug 2024 Fourways Provisional Enquire
Mon 9 Sep 2024 Wed 11 Sep 2024 Fourways Provisional Enquire
Mon 7 Oct 2024 Wed 9 Oct 2024 Fourways Provisional Enquire
Mon 4 Nov 2024 Wed 6 Nov 2024 Fourways Provisional Enquire
Mon 2 Dec 2024 Wed 4 Dec 2024 Fourways Provisional Enquire
Submit Enquiry