Skip to main content
Get a Quote
Course Enquiry
Contact Us
Microsoft Power BI Boot Camp

RELATED COURSES


TRAINERS FOR COURSE


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)

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
  • Modelling 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 four delegates. We remain committed to offering training that is fast, focused and effective.

Delivery Method Duration Price (excl. VAT)
Fulltime 3 day R 7,887.00
Webinar 3 day R 5,547.00

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

No prior experience with Power BI or other BI tools is required, some experience with excel is desirable but not mandatory.

If you don't have admin rights on your computer please request your IT department to pre-install Power BI Desktop from https://aka.ms/pbidesktopstore

Course Outline / Curriculum

  •   Module 1: Introduction to power BI
    • What is power BI
    • Understanding the power BI architecture
    • Installing power BI desktop
    • Signup with the Power BI service
    • Understanding Power BI licencing
  • 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
    • Modelling 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
    • Visualisation 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 refresh 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 four delegates. We remain committed to offering training that is fast, focused and effective.

Start Date End Date Branch Status  
Mon 24 Jan 2022 Wed 26 Jan 2022 Not Applicable Scheduled

Book Webinar

Mon 24 Jan 2022 Wed 26 Jan 2022 Not Applicable Scheduled

Book Webinar

Mon 14 Feb 2022 Wed 16 Feb 2022 Not Applicable Scheduled

Book Webinar

Mon 21 Feb 2022 Fri 25 Feb 2022 Not Applicable Scheduled

Book Webinar

Wed 23 Mar 2022 Fri 25 Mar 2022 Not Applicable Scheduled

Book Webinar

Mon 4 Apr 2022 Wed 6 Apr 2022 Not Applicable Scheduled

Book Webinar

Mon 2 May 2022 Wed 4 May 2022 Not Applicable Provisional
Mon 30 May 2022 Wed 1 Jun 2022 Not Applicable Scheduled

Book Webinar

Mon 27 Jun 2022 Wed 29 Jun 2022 Not Applicable Provisional
Mon 25 Jul 2022 Wed 27 Jul 2022 Not Applicable Provisional
Mon 22 Aug 2022 Wed 24 Aug 2022 Not Applicable Provisional
Mon 19 Sep 2022 Wed 21 Sep 2022 Not Applicable Provisional
Mon 17 Oct 2022 Wed 19 Oct 2022 Not Applicable Provisional
Mon 14 Nov 2022 Wed 16 Nov 2022 Not Applicable Provisional
Mon 12 Dec 2022 Wed 14 Dec 2022 Not Applicable Provisional