Training

Data Analysis & Visualization in Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Data Analysis & Visualization in Power BI

Duration: 3 days | 18 hours

Available delivery methods:

Classroom

Connect, Integrate, Model and Visualize Business Data Reliably!

Course Information

This is a three day training  for delegates looking for a way to unify various data sources, usually with millions of rows and create measures that can give a single source of truth of the business health, all in a familiar environment, MS Excel.

It allows delegates to grasp a broad understanding of data analysis using Power BI. A powerful Microsoft tool with a collection of business analytics tools, which permits a series of data-based tasks to be completed, including desktop modelling and visualization, and data transformation.

Key areas covered on the course include:

Session 1: Getting Started

  • The Microsoft Business Intelligence environment (overview of Power Query, Power Pivot & Power BI)
  • Understanding how Power BI Desktop is organized-the interface

Session 2: Data Acquisition and Transformation (ETL) using Power BI Desktop

  • Importing data from various sources
  • The Query Editor: Tidying up the data model
  • Combine various data sets -merge versus append queries using examples

Session 3: Data Modeling -Integrate from multiple sources

  • Introduction to columnar table relationships
  • Cardinality and cross-filtering
  • Practice creating a data model
  • Understanding differences between measures and calculated columns
  • Custom sorting of columns such as month names
  • Hiding tables and columns

Session 4: Enrich Your Data with Calculations -Must-Know DAX Functions

  • Time intelligence functions and their applications
  • Other useful DAX functions

Session 5: Compelling Data Visualizations

  • The Report Canvas
  • Modern visuals
  • Custom formatting visuals -customize properties
  • Adding interaction

Session 6: Report Distribution

  • Uploading data/report to Power BI cloud
  • Creating a dashboard through pinning and Q&A
  • Sharing and Mobility

Prerequisites

This course is widely attended by SQL Server report creators with intentions of expanding their skills in the field.

What is Microsoft Power BI?

Microsoft Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.  

What’s included in this course?

3 days’ worth of Instructor-led, practical and interactive training, a course pack including all presentation slides, and a certificate.

 Learners taking this course are.

  • Data Analysts
  • Business Analysts
  • Marketing Analysts
  • Process Analysts
  • Financial Analysts 

What key skills will I gain in this course?

  • SQL
  • Data Analysis
  • Microsoft Power BI

Do you offer In-house corporate training?

We offer corporate trainings for a minimum number of 6 participant at your preferred venue.

Find out more


Or call us now
+254 20 222 95 66
+254 716 56 88 99
+254 732 56 88 99

 

Interested in our training courses?

Get 20% off!

...on select training bundles.

Our Best Selling Courses

Microsoft Excel - Essentials

Become more effective in your reporting processes. Gain useful data manipulation skills!

Advanced Analysis & Visualization in Excel

Make the process of “Data to Decisions” efficient and cost effective.

Analytics for Finance Professionals in Excel

Drive productivity, efficiency, transparency and lower risk as a Finance professional.

Advanced PowerPoint

For professional, engaging in presentations that yield results.

Microsoft Excel - Intermediate

Become more effective in your reporting processes. Gain useful data manipulation skills!

Report Automation with Excel VBA/Macros

Get ahead of others! Automate the mundane tasks and create stunning reports with greater flexibility.

Microsoft Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

Microsoft Excel - Advanced

Connect, Integrate, Analyze and Visualize data like a pro!

Advanced Excel + Financial Modelling & Forecasting in Excel

Efficiently build an effective and robust financial model based on real-world financial modelling challenges.

Data Analysis & Visualization in Power BI

Connect, Integrate, Model and Visualize Business Data Reliably!

R for Data Science

Python for Data Science

Are you ready to transform your business?

Contact Us

0716 56 88 99

Pin It on Pinterest