Course Catalog  > Data & Databases  > Data Visualization  > Power BI
WA3315

Data Visualization and Decision Making for Business Analysts with Power BI Training

This course teaches business analysts how to use Power BI to make business decisions by visualizing and analyzing data properly.
Request Information
Request On-Site or Customized Course Info
Course Details

Duration: 1 day

Learn the differences between Business Analysts and Data Analysts and what is relevant to the Business Analyst role.

Objectives

  • Import data from different data sources.
  • Create reports.
  • Working with different visualizations
  • Understanding story telling with data
  • Working with filters, slicers, bookmarks, and selections
  • Implementing drill down and drillthrough in reports
  • Predicting data using line chart
  • Identify outliers using scatter chart
  • Using advanced analytics visuals

Audience

The course is intended for Business Analysts rather than Data Analysts. Business Analysts must concentrate on visualizing and analyzing data to make decisions.

Prerequisites

Familiarity with Excel is useful but not necessary.

Course Outline
  • Get Started with Microsoft Data Analytics
    • Data Analytics and Microsoft
    • Getting Started with Power BI
    • After completing this module, students will be able to:
    • Explore the different roles in data
    • Identify the tasks that are performed by a data analyst
    • Describe the Power BI landscape of products and services
  • Getting Data in Power BI
    • Import data from CSV
    • Formatting Exacel spreadsheet before importing data
    • Import data from Excel spreadsheet
    • Import data from Web
    • Import data from SQL Server
    • Import data from CSV
  • Getting started with report designing in Power BI
    • Design a report
    • Working with tables and matrix
    • Working with charts
    • Working with filters and slicers
    • Working with cards
    • Working with map
  • Enhancing the report in Power BI
    • Understanding conditional formatting options
    • Working with databars, sparklines, and indicators
    • Working with sync slicers
    • Adding drillthrough to the report
    • Working with tooltip popup
    • Implementing story telling with bookmarks, buttons, and selections
  • Working with Advanced Visuals
    • Identifying outliers with scatter chart
    • Forecasting values using line chart.
    • Working with decomposition tree to facilitate in the decision-making process.
    • Identifying key influencers
    • Using Q&A to ask questions based on your data.
    • Adding KPIs to reports