Mastering the Art of Visualization with Power-BI

Program Overview

This course will help the students in creating meaningful visualizations, converting raw data into meaningful and concrete information. They would be able to perform multiple tasks on any given data, like creating charts, graphs, geographic analysis using map features, KPI’s and many more.

The ETL (Extraction, Transformation and Loading) operations can be augmented using M-Query or Power Query features of Power BI Desktop. The DAX functionality of Power-Bi leverages the users to perform complex operations on datasets, data wrangling and massaging the data for sharing through Power BI Service platform which is handy for key stakeholders in decision making.

Power BI provides interactive visualizations with self-service business intelligence capabilities. Where end users can create reports, dashboards by themselves, without having to depend on any information from Reporting staff or database administrator.

Power BI is a straightforward tool; anyone can learn this who has a basic understanding of Excel. Learning Power BI is recommended for anyone who works with massive data and handles many reporting tasks regular basis.  Power BI is one of the leading Business intelligence tools, gaining more and more popularity because of it’s easy to access, sharing capabilities also it’s economical pricing.

During the session, attendees will be working on real time business scenarios and case studies, exclusively prepared for enhancing analytical, preparation of impactful visualizations, and logical thinking capabilities.

Learning Outcomes

Upon completion of this program, participants will:

Intended Audience

Program Outline

  • Introduction to POWER BI
    • Power BI as a BI Application
    • Setting the learning objectives
  • Table
  • Matrix
  • Stacked Bar Charts and switching Themes for reports
  • Clustered and 100% Stacked Bar Chart
  • Line and Area Charts
  • Combo Charts (Line and Column Charts)
  • Importing from Excel & Creating our First Visualization
  • Viewing Data
  • Focus Mode and Different Visualizations
  • Saving Visualization to the Desktop and to the Power-Service Formatting Font and
  • Font Size
  • Formatting Colors
  • Stylistic Options
  • Positioning
  • Visualizations
  • Align Visuals
  • Configuring, Summarization both default and in a specific visualization
  • Changing number and date formatting
  • Adding text Boxes Images and Shapes
  • Basic Filters- Visual level, page level and report level
  • Advanced Filters
  • Top N Filter
  • Slicers
  • Sort Visuals
  • Bookmark for reports and updating the view
  • Drill through
  • Buttons and Actions
  • Enable Natural Language Query (Ask QnA)- Creating your suggested QnA
  • Tooltip Pages
  • Ribbon Charts
  • Waterfall Charts
  • Scatter,Bubble and Dot Charts
  • Pie Chart and Donut Chart
  • Treemaps
  • Funnel Chart
  • Importing a custom visual
  • Maps
  • Formatting Maps
  • Adding Data Categories
  • Filled maps, Conditional Formatting and Color Blindness
  • Creating Hierarchies

Other courses you may be interested in

Want to know more?

Please fill the form below if you would like to talk to us about this course and your needs. We will get back to you within 24 hours.

First Name*
Last Name*
Tel No
Leave a message