THE COURSE :
This practical five day course is designed for
those who need to create business analytics using Microsoft Power BI.Power BI
Desktop is part of the suite of tools from Microsoft which enable data to be
analysed and published from a variety of sources. With Power BI Desktop, you
get a report authoring tool that enables you to connect to and query data from
different sources using the Query Editor. From the datasets, you build with
Query Editor you can create Reports and Visualizations or dashboards within
Power BI Desktop. Reports can then be published.By the end of the Adventure Works project, not
only will you have developed an entire business intelligence
tool from the ground up, but you will have gained the knowledge and confidence to
apply these same concepts to your own real-world analyses.
What you’ll learn
· Build
professional-quality business intelligence reports from the ground up
· Blend and
transform raw data into beautiful interactive dashboards
· Design and
implement the same B.I. tools used by professional analysts and data scientists
· Showcase your
skills with two full-scale course projects (with step-by-step solutions)
· Understand the
business intelligence workflow from end-to-end
· Learn from a
best-selling instructor and professional BI developer
Duration:
5 Days
Requirements
· Microsoft
Power BI Desktop (free download)
· This course is
designed for PC/Windows users (currently not available for Mac)
· Experience
with Excel Power Query, Power Pivot & DAX is a plus, but not required
Module one:Introduction to
Self-Service BI Solutions
· Introduction
to business intelligence
· Introduction
to data analysis
· Introduction
to data visualization
· Overview of
self-service BI
· Considerations
for self-service BI
· Microsoft
tools for self-service BI
Module Two:Connect &
Transform the Raw Data
· Intro to the
Query Editor
· Types of Data
Connectors
· Basic Table
Transformations
· Text, Number
& Date Tools
· Index
& Conditional Columns
· Grouping
& Aggregating Data
· Pivoting
& Unpivoting
· Modifying,
Merging & Appending Queries
· Connecting
to Folders
· Defining
Hierarchies & Categories
· Query Editing
Best Practices
Module Three:Build a Relational Data
Model
· Intro to
Database Normalization
· Data (“Fact”)
Tables vs. Lookup (“Dimension”) Tables
· Creating Table
Relationships
· “Star” vs.
“Snowflake” Schemas
· Active vs.
Inactive Relationships
· Relationship
Cardinality
· Connecting
Multiple Data Tables
· Filtering
& Cross-Filtering
· Hiding Fields
from Report View
· Data Modeling
best Practices
Module Four:Add Calculated
Fields with DAX
· Intro to Data
Analysis Expressions (DAX)
· Calculated
Columns vs. Measures
· Row Context
vs. Filter Context
· DAX Syntax
& Operators
· Common
Function Categories
· Basic Date
& Time Formulas
· Logical
& Conditional Statements
· Text, Math
& Stats Functions
· Joining Data
with RELATED
· CALCULATE, ALL
& FILTER Functions
· DAX Iterators
(SUMX, AVERAGEX)
· Time
Intelligence Formulas
· DAX Best
Practices
Module
Five:Design Interactive Reports
· Intro to the
Power BI Report View
· Adding Objects
& Basic Charts
· Formatting
& Filtering Options
· Matrix Visuals
· Slicers
& Timelines
· Cards
& KPIs
· Map
Visuals (Basic, Fill, ArcGIS)
· Treemaps,
Lines, Areas & Gauges
· Editing Report
interactions
· Adding
Drillthrough Filters
· Linking to
Report Bookmarks
· Using
“What-If” Parameters
· Managing
& Viewing Roles
· PREVIEW: Publishing
to Power BI Service
· Data Viz Best
Practices
General Notes
·
All our courses can be
Tailor-made to participants needs
·
The participant must be
conversant with English
·
Presentations are
well guided, practical exercises, web-based tutorials, and group work. Our
facilitators are experts with more than 10years of experience
·
Upon completion of
training, the participant will be issued with a Global King Project Management
certificate
·
Training will be done at
the Global King Project Management Centers (Nairobi Kenya, Mombasa Kenya,
Kigali Rwanda, Dubai ,Lagos Nigeria and More others).
·
A discount of 20% will
be given to more than 4 participants from same organization.
·
Course duration is
flexible and the contents can be modified to fit any number of
days.
·
Payment should be done
before commencement of the training, to the Global King Project Management
account, so as to enable us to prepare better for you.
·
For any inquiry
to: [email protected] or +254 114 830 889
·
Website: www.globalkingprojectmanagement.org
·
Tablet and Laptops are
provided to participants on request as an add-on cost to the training fee
·
The course fee for
onsite training includes facilitation training materials, 2 coffee breaks, a
buffet lunch, and a Certificate of successful completion of Training.
Participants will be responsible for their own travel expenses and
arrangements, airport transfers, visa application dinners, health/accident
insurance, and other personal expenses.
Start Date | End Date | Action | Duration | Location | Fee(Kes) | Fee(Us$) |
---|---|---|---|---|---|---|
09/01/2023 | 13/01/2023 | 5Days | Nairobi | 100000 | 1200 | |
06/02/2023 | 10/02/2023 | 5Days | Nairobi | 100000 | 1200 | |
03/04/2023 | 07/04/2023 | 5Days | Nairobi | 100000 | 1200 | |
01/05/2023 | 05/05/2023 | 5Days | Nairobi | 100000 | 1200 | |
26/06/2023 | 30/06/2023 | 5Days | Nairobi | 100000 | 1200 | |
24/07/2023 | 28/07/2023 | 5Days | Nairobi | 100000 | 1200 | |
18/09/2023 | 22/09/2023 | 5Days | Nairobi | 100000 | 1200 | |
16/10/2023 | 20/10/2023 | 5Days | Nairobi | 100000 | 1200 | |
06/03/2023 | 10/03/2023 | 5Days | Mombasa | 120000 | 1500 | |
29/05/2023 | 02/06/2023 | 5Days | Mombasa | 120000 | 1500 | |
21/08/2023 | 25/08/2023 | 5Days | Mombasa | 120000 | 1500 | |
13/11/2023 | 17/11/2023 | 5Days | Mombasa | 120000 | 1500 |