Data Visualization with Power BI

Introduction

Power BI is a data visualization tool to present their performance and progress updates to management more effectively as compared to simple tables of numbers. With Power Bi, you can create an interactive dashboard to analyze and present business performance to management.

Who Should Attend

Managers and Executives in Sales, Marketing, Finance, HR, Supply Chain who have no or minimal experience in data visualization.

Learning Objectives

Upon completion of the course, participants will be able to:

1. Create a Dashboard
2. Create and organize multiple visualizations
3. Update your visuals automatically
4. Data Story Telling

Course Outline

• Orientation to Power BI Interface
  • The 3 major component of Power BI: Report, Data and Model

• Understanding Data
  • What is Data?
  • 6 types of data you must know
  • The type of data relating to business

• Getting data from different sources
  • Excel Files
  • CSV
  • JSON
  • XML
  • SQL

• Tranforming Data
  • Organizing your data for modelling
  • Delete Rows and Columns
  • Changing Type of Data
  • Filters
  • Sorting Data
  • Extract Data
  • Unpivot Columns
  • Merge Queries
  • Append Queries

• Data Modelling
  • Connecting multiple sets of data
  • Introduction to DAX
  • Creating Measures
  • Creating Calculated Columns
  • Creating a Date Table

• Common Charts and their intended purposes
  • Bar Chart
  • Column Chart
  • Map Chart
  • Pie Chart
  • Bubble Chart
  • Cards
  • Slicers
  • Drill down
  • Focus

• Formating elements of the charts
  • Headers
  • Titles
  • Background

• 3 types of filters in Visualization
  • Visual filter
  • Page filters
  • All Pages filter

• Sharing your reports
  • PDF
  • PowerPoint
  • Interactive Report on the web
  • Interactive Report on Mobile

Program Dates

• 30-31 Jan 2023 (Mon and Tue)
• 03-04 Apr 2023 (Mon and Tue)
• 26-27 Jun 2023 (Mon and Tue)
• 14-15 Aug 2023 (Mon and Tue)
• 09-10 Nov 2023 (Thu and Fri)

Mode of Delivery

• Classroom training

Course Duration

• 2 days (7 hours each day) – 9 am to 5pm

Price

$900 per pax

________________________

If you need further clarifications, please send us a message using the form here and we will reply you ASAP.