Get a Quote
Course Enquiry
Contact Us

Microsoft Power BI Boot Camp Course Details


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  

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

Duration:

3 day

Price:

$800.00 If you are currently resident in South Africa you will need to pay VAT at 14%.   *Discount available

PC Hire:

$99   *Bring a PC

Note: information may change without notice.

Download Brochure:

Download Brochure

About Microsoft Power BI Boot Camp

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)

Course Outline


  •   Module 1: Introduction to power BI

o   What is power BI

o   Understanding the power BI architecture

o   Installing power BI desktop

o   Signup with the Power BI service

o   Understanding Power BI licencing

·        Module 2: Importing data using Power BI

o   Loading data from files and databases

o   Removing unwanted rows and columns

o   Transforming data

o   Cleansing and shaping data

o   Using functions and parameters

o   Discuss direct query and live query

o   Power Query best practice

·        Module 3: Enriching your data model with DAX

o   Understanding table relationships (Active vs inactive & single direction vs both)

o   Creating calculated columns and measures

o   Extending your model using date tables (Calculated table)

o   Create hierarchies

o   Change date and number formats

o   Understanding evaluation context

o   Time intelligence functions

o   Modelling best practice

·        Module 4: Visualisations

o   Chart types

o   Formatting charts

o   Understanding report, page and visual filters and slicers

o   Designing interactive reports

o   Enhanced reports with text boxes, annotation shapes and images

o   Custom visuals

o   Using report themes

o   Visualisation best practice

·        Module 5: Sharing report with the power BI Service

o   Publishing reports to the Power BI service

o   Understanding the difference between reports and dashboards

o   Creating schedules and alerts

o   Q&A

o   Keeping data up-to-date with scheduled refresh and the data gateway

o   Designing dashboards for mobile

o   Creating Power BI apps

o   Publish Power BI to web

 

Delivery Method

Instructor Led classroom based training. Scheduled classes are normally held in Woodmead - near to Sandton in Johannesburg, Gauteng, South Africa. Stationary and textbook included. Refreshments, including 2 tea breaks and a cooked meal for lunch are provided for full time courses. Contact hours are between 9am to 4pm.

Scheduled Dates


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

Start Date Duration  
Wed 20 Sep 2017 3 day Closed
Please call
Wed 11 Oct 2017 3 day Book Now
Wed 25 Oct 2017 3 day Book Now
Wed 1 Nov 2017 3 day Book Now
Wed 8 Nov 2017 3 day Book Now