Training Course on Data Analytics using Microsoft Excel and Power BI

Data analytics is the collection, transformation, and organization of data in order to draw conclusions, make predictions, and drive informed decision making. Companies need data analysts to sort through this data to help make decisions about their products, services or business strategies. Microsoft Power BI gathers and processes your data, analyzes and provides data-driven insights that enable managers, business analysts and key decision makers to make informed decisions in real-time. Enroll in this Microsoft Excel and Power BI training and gain critical skills on easy-to-comprehend data visualizations and learn how to analyze big data.

Training Course on Data Analytics using Microsoft Excel and Power BI
Data Analytics using Microsoft Excel and Power BI
Ms Excel PowerBI
PowerBIExcel
PlayPause
previous arrowprevious arrow
next arrownext arrow

Data Analytics using Microsoft Excel and Power BI

Target Participants

This training is designed for professionals who want to build their capacity in the field of data analytics using Microsoft Excel and Power BI.

What you will learn

By the end of the course the learner should be able to:

  • Understand the importance of data analytics
  • Gain an immersive understanding of the practices and processes in data analytics
  • Understand how to clean and organize data for analysis using Excel and Power BI
  • Learn key analytical skills and tools
  • Learn to apply advanced techniques in data modeling
  • Understand how to complete analysis and calculations using Excel and Power BI
  • Learn how to visualize and present data findings in dashboards, presentations and reports.

Course duration

5 days

Course Outline

Module 1: Introduction

Introduction to Power BI 

  • Uses of Power BI
  • Components of Power BI
  • Features of Power BI
  • Power BI workflow
  • Self Service ETL (Extract Transform Load)
  • Download and Install BI Desktop
  • Setup and configuration of Power BI 

Understanding Power BI Screen

  • Report, data and relationship
  • Add, rename, duplicate, hide and delete pages 

Connecting to Data Sources

  • Getting data from excel files
  • Getting data from text files
  • Loading data from multiple data sources
  • Removing unwanted columns from tables 

Module 2: Data Transformation

Data Cleaning and Management in Power BI (Power Query)

  • Setting up the header row (using the first rows of the data)
  • Renaming fields
  • Changing/replacing data values
  • Changing data types
  • Changing the order of columns
  • Pivoting and un-pivoting data
  • Grouping and splitting columns
  • Extracting data
  • Adding new fields/columns 

Power BI Filters 

  • Slicer
  • Basic filters
  • Advanced filters
  • Top N Filters
  • Filters on measures
  • Page level filters
  • Report level filters
  • Drill through filters
  • Generating queries (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

Module 3: Visualization and Charts (Power View)

Power BI Charts

  • Clustered and stacked column Chart
  • Clustered and stacked bar Chart
  • Introducing natural-language queries
  • Importing custom visuals
  • 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

Other visualization

  • 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

Module 4: Power BI Dashboards

Building and Sharing a Dashboard

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

Best Practices for Power BI Dashboards

  • Dashboard best practices
  • Understanding relationship
  • Dashboard actions
  • Add reports to a dashboard
  • Add title to dashboard
  • How to add image to dashboard
  • Add video to dashboard
  • Add web content to dashboard
  • Dashboard settings
  • Delete a dashboard
  • Pin report to a dashboard 

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 

Module 5: Other Topics

Data Security in Power BI

  • Configuring row level security
  • Setting up user roles

Power BI for Mobile

  • Configuring Power BI for Mobile
  • Visualize dashboards and report on Power BI Mobile
  • Commenting on reports 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

Sharing Power BI Work

  • Inviting users (internal and external) to see a dashboard (share dashboard)
  • Share a report
  • Sharing workspace
  • Data refresh in Power BI

Training Schedule – Africa

Country
City
Dates
Kenya
Nairobi
Rwanda
Kigali
Uganda
Kampala
Kenya
Mombasa
South Sudan
Juba
South Africa
Pretoria
Ethiopia
Addis Ababa

Training Schedules per Continent

Africa    (7)Asia      (4)

America (5)Europe (3)

Training Approach for Microsoft Excel and Power BI Course

This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.

Training manuals and additional reference materials are provided to the participants.

Certification on Microsoft Excel and Power BI

Upon successful completion of this course, participants will be issued with an internationally recognized certificate. Altum Training and Research Institute is NITA certified. Read more.

Tailor-Made Course on Microsoft Excel and Power BI

This course can be tailored to meet organization-wide needs. In order to learn more, contact us at info@altumtrainings.com.

Payment

The training fee covers tuition fees, learning materials, and training venue. In addition, we arrange accommodation and airport transfer for registered participants upon request.

Payment should be sent to our bank account before start of training and proof of payment sent to info@altumtrainings.com

Here are our other areas of trainings that you may also wish to see…

Project Management

M&E Courses

Accounting & Finance

GIS/Remote Sensing

Share this training on Microsoft Excel and Power BI with your friends:

Other Trainings Courses on Research and Data Management: