Data Visualisation with Microsoft PowerBI Course

Introduction
In this course, you will be introduced to the key concepts in business intelligence (Bl), data analysis, and data visualization. Discover the capabilities of a self-service Bl solution and learn to create Power Bl Desktop queries and beautiful dashboards.

Who Should attend?
Data analysts, Business analysts, Business intelligence developers, SQL professionals Databases administrators, Data scientists and related professionals.

Class Activity Blocks
Activity 1: Exploring an Enterprise Bl Solution

Activity 2: Importing data in Excel data model

Activity 3: Transforming data in Power Query

Activity 4: Using Power Pivot in excel

Activity 5: Import Data into Power Bl

Activity 6: Transforming data using Query Editor

Activity 7: Shaping and Combining Data

Activity 8: Modeling Data

Activity 9: Creating a Power Bl Report

Activity 10: Creating a Power Bl Dashboard

Activity 11: Direct Connectivity

Activity 12: Using the Developer API

What you'll learn

Connect directly to data stores
Describe how to connect to Excel data
Perform Power Bl desktop data transformation
Describe Power Bl desktop modelling
Create Power Bl desktop visualizations
Implement the Power Bl service
Describe how to collaborate with Power Bl data
Setting up Gateways to automatically update Power Bl reports
Describe the Power Bl developer API
Describe the Power Bl mobile app
Course Modules

Module 1: Introduction to Self-Service Bl Solutions

Module 2: Introducing Excel Bl (Power Query & Power Pivot)

Module 3: Importing data in Power Pivot data model

Module 4: Shaping and Combining Data using Power Query

Module 5: Data Visualizations using Power Pivot

Module 6: Introducing Power Bl

Module 7: Power Bl Data connections

Module 8: Shaping and Combining Data in Query Editor

Module 9: Modeling Data

Module 10: Interactive Data Visualizations

Module 11: Introducing Power Bl service (SaaS)

Module 12: Creating Dashboards in Power Bl Service

Module 13: Sharing Power Bl report within and outside your teams

Module 14: Direct Connectivity

Module 15: Developer API

Module 16: Power Bl mobile app

Prerequisites
Basic knowledge of the Microsoft Windows OS and its core functionality
An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable
Familiarity with Microsoft Office applications (particularly Excel)

The 3 day course costs 450$ (280,500 FRW), Exclusive of a 16% V.A.T, The Cost includes all training fees, materials, lunch and refreshments as well as certificates and 6 month post training support.

Event Details
Event Date 26-02-2020 8:30 am
Event End Date 28-02-2020 4:00 pm
Cut off date 17-02-2020
Individual Price 450$ (280,500 FRW)
Location BCP Training Facilities, Kigali Rwanda.

How to register:
To register, send an email to: moc.acirfa-sbaltsacnepo@hcaertuo

You can also visit our website on www.opencastlabs-africa.com and fill an online application form and submit to us.

Contact Details:

Rwanda:

P.O Box 4543 Kigali

3rd Floor La Bonne Address House

Avenue de la Revolution

Tel: Kigali +250 788 470 532

The Training Coordination Office (Joab/Diana)
Capacity Building Division
Argwings Kodhek Road, opposite YAYA Center
P.o Box 30225 - 00100 , Nairobi, Kenya
Tel: +254 0204409651 Mobile: +254 723870644
Email : moc.acirfa-sbaltsacnepo@hcaertuo

Language

Participants should be reasonably proficient in English.

Fee Exceptions

All international participants will cater for their, travel expenses, visa application, insurance, accommodation and other personal expenses.

Accommodation

Accommodation is arranged upon request. For reservations contact us below.

Email: moc.acirfa-sbaltsacnepo@hcaertuo

Payment:

Payment should be transferred through bank 5 days before commencement of training.

Cancellation policy

All requests for cancellations must be received in writing.
Changes will become effective on the date of written confirmation being received.
The appropriate cancellation charge will apply

26th - 28th February, 2020: 26 February 2020 to 28 February 2020
Time: 08:30 - 16:00
Venue: BCP Training Facilities, Kigali Rwanda., Kigali
Cost: 450$ (280,500 FRW)

More info:

M.Peace Plaza, 5thFloor, Block B KN 4 Avenue de la Paix Kigali.