Data Visualization Using MS Power BI

Data Visualization Using MS Power BI

Data Visualization Using MS Power BI 1920 1080 GCSS Inc.

Introduction

This live webinar on MS Power BI has been prepared for those wishing to understand the powerful features of Microsoft Power BI considering that Microsoft Power BI is gaining its popularity as a visualization tool.

Gain an overview of how Power BI can be explored and used to produce powerful and insightful reports. You’ll go from scratch to scratch as you learn how this common business intelligence platform is used through practical exercises. First, you will learn how to load and transform data confidently with Power Query and data models, before diving into visualizations using the drag and fall functionality of Power BI. You will also learn how to download reports and make your reports fully interactive. Finally, you will upgrade your skills to create customized calculated columns and fields using DAX formulas to better analyze your data.

You learn how to modify and format a wide variety of visualizations through hands-on activities before heading into data sorting and hierarchy, which helps you to excel in your studies. Finally, you can learn how the information in your reports is filtered by location and how these filters interconnect and communicate with other visuals within your report.

Learning Objectives

  • At the conclusion of this course, participants are expected to be conversant of the transition process of extracting their data sources, cleaning their data (or transforming their data), and loading it into MS Power BI Desktop for modeling purposes.
  • The final completion proof is that they will be able to view their reports using their mobile devices (and in like manner view those same data visualization using their desktop or laptop-based computers).

Who Should Attend

This course is intended to introduce participants to a step-by-step hands-on training workshop on MS Power BI.

  • Everyone who is willing to LEARN, ENHANCE and EXPAND their current understanding with MS Power BI

Program Duration

3 days, 3 hours each day

Program Outline/Course Overview

Day 1

  • What is a Power BI?
  • What are the various applications within the power BI family?
  • What are the roles of each member of the Power BI family?
  • A brief overview of the various data sources that can be processed using MS power BI
  • Navigating the MS power BI menu
  • Understanding data view, report view and model view
  • Understanding filter pane, visualization pane, and table pane
  • Getting data
  • Getting Excel data
  • Getting CSV data

Day 2

  • Connecting to a SQL table
  • Performing extract transform load (ETL) on data
  • Understanding extract transform load (ETL) capabilities
  • Cleaning data
  • Transforming data
  • Applying clean data for data visualization
  • Viewing columns using data view
  • Understanding the fields data section
  • Using the right chart for the right purpose
  • Understanding the right chart
  • Using selected custom visuals
  • Creating pages for data visualization
  • Creating calculated columns
  • Understanding calculated columns

For a complete course outline, email trainings@gcssinc.com

Download Sustainability Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Resiliency Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Productivity Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.

Download Sociability Services Profile

FREE DOWNLOAD

Send download link to:

I confirm that I have read and agree to the Privacy Policy.

Subscribe to get exclusive content and recommendations every month. You can unsubscribe anytime.