Introduction

It has been said that 80% of data analysis is spent on the process of cleaning and preparing the data. In this course we introduce some relatively-new additions to the R programming language; dplyr and ggplot2. In combination these provide a powerful toolkit to make the process of manipulating and visualizing data easy and intuitive.

Further Microsoft Power BI is a business intelligence technology from Microsoft that gathers and processes your data, analyzes and provides data driven insights that enables managers, business analysts and key decision makers to make informed decisions real time. It allows one to ask questions and get answers about their data. Users of Power BI are able to create interactive dashboards and insights by self-interacting with the technology. 

Duration

10 Days

Who Should Attend

This course is aimed at professionals who need to analyze and visualize data utilizing Microsoft Power BI.

COURSE LEVEL: Foundation

Objective of the course

• Connect, import, shape, and transform data for business intelligence (BI) 
• Model data with Power BI desktop
• Custom create data visualizations and style reports for lucid data representation
• Visualize data, author reports, and schedule automated refresh of your reports 
• Create and share dashboards based on reports in Power BI desktop 
• Share and collaborate with data with Power BI
• Understand Power BI Data Analysis Expression(DAX), and its functions

Course Outline

1. Data Manipulation using R

• How R enables reproducible research
• What constitues a tidy dataset
• "Piping" commands together to form a workflow
• Subseting and filtering datasets using dplyr
• Producing summary statistics from a dataset
• Joining datasets using dplyr
• The grammar of graphics approach to plotting used in ggplot2
• Producing publication-ready graphics using ggplot2

1. Analyzing and Visualizing Data using Microsoft Power BI

Introduction to Power BI 

• Components of Power BI
• Features of Power BI
• Power BI workflow
• Self Service ETL (Extract Transform Load)
• Setup and Configuration of Power BI

Connecting to Data Sources

• Excel
• Online sources
• SQL 

Data Transformation: Data Management and Data Cleaning in Power BI (Power Query)

• Using first rows as headers
• Rename fields & replacing data values in cells, rows
• Changing data types & change order of columns
• Un-pivoting columns
• Grouping and splitting column into multiple 
• extract feature (before /after delimiter)
• Adding new columns
• Filters and parameters
• View native queries vs unfold queries

Modeling 

• Table relationship (one to one, one to many, many to many)
• Data Analysis Expression (DAX)
• Measures and calculated Columns
• Mastering DAX using quick measures

Visualization and Charts (Power View)

• Stacked bar chart and stacked column chart
• Clustered bar chart and clustered column chart
• Line chart & area chart
• Line and clustered column chart
• Line and stacked column chart
• Ribbon & waterfall chart
• Funnel & tree map visuals
• Pie-chart and doughnut chart
• Table chart and matrix chart
• Slicer, gauge, card visuals
• Map and filled map
• ArcGIS maps for Power BI
• KPI
• Q & A visual
• Fine tune your visualization using parameters and slicers
• Deciding on when to use a particular visual

Building and Sharing a Dashboard

• Workspace
• Datasets
• Reports
• Create Dashboard
• Modify and update Dashboard
• Share your Dashboard
• Power Q&A and Insights

Data Security in Power BI

• Configuring row level security
• Setting up user roles

Configuring Data Refresh

• Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
• Understand & configure data management gateways
• Configuring & scheduling data refresh

Power BI for Mobile

• Configuring Power BI for Mobile
• Visualize dashboards and report on Power BI Mobile
• Commenting on eports and dashboards in Power BI Mobile

Excel Power BI

• Power Query and Power Pivot on Excel
• Visualize and Edit Power BI reports using excel analyzer
• Building reports on Excel and Publishing to Power BI service

Course Administration Details:

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

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

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email:[email protected].  

Mob: +254 715 077 817/+250789621067

TAILOR- MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817/+250789621067.

Mob: +254 792516000, +254 792516010 ,or mail [email protected]/[email protected]

PAYMENT

Payment should be transferred to IRES account through bank on or before start of the course

Send proof of payment to [email protected]/[email protected]

DOWNLOADABLE DOCUMENTS: