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.

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

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 Excel 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
04/08/2024 - 04/08/2024
10:00 AM - 06:00 PM
Eastern Standard Time
Online Virtual Class
USD $770.00
Enroll