Powerful Visualization Using Power Bi

Course Objectives

Microsoft Power BI will help you analyze your organization’s data and uncover insights and trends. This course will show you how to link and model data in Power BI and create visual reports that reveal data insights.

Target Audience

• Sales Executive / Managers
• Business Analysist
• Resource Planning Team
• Project Managers
• Purchasing Manager
• Financial Executive / Managers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Modules

Lesson 1: Getting Started

• Connecting to an Excel Workbook
• Connecting to a Database
• Connecting to Text/CSV
• Viewing All Connection
• Managing Data Sources

Lesson 2: Working with Data

TOPIC A: Transforming and Cleaning Data

• Using Data View
• Cleaning Irregularly Formatted Data
• Managing Columns

TOPIC B: Using the Query Editor

• Opening the Query Editor
• Using the Query Settings Pane
• Using Merge Queries
• Using Append Queries

TOPIC C: Data Modeling

• Creating a New Table
• Creating a New Calculated Column
• Creating a New Measure

TOPIC D: Managing Relationships

• Using the Relationships View
• Creating Relationships
• Editing Relationships
• Deleting Relationships
• Using the Manage Relationships Dialog

Lesson 3: Working with Reports and Visualizations

TOPIC A: Creating a Report with Visualizations

• Using the Visualizations Pane
• Using the Fields Pane
• Creating a Visualization
• Interacting with Visualizations
• Changing the Visualization Type
• Moving and Resizing Visualizations

TOPIC B: Doing More with Visualizations

• Formatting Visualizations
• Viewing Visualization Data
• Using Focus Mode and Spotlight
• Removing a Visualization

TOPIC C: Managing Report Pages

• Showing and Hiding Pages
• Adding, Deleting & Renaming Pages

TOPIC D: Changing Report View Options

• Setting Page View Options
• Customizing Your View
• Using Phone vs Desktop Layout

TOPIC E: Working with Visualizations

• Understanding Drill through Options
• Changing Category and Summarization Options
• Arranging Visualizations
• Editing Interactions
• About Custom Visualizations

TOPIC F: Adding Static Objects to a Report

• Inserting Pictures
• Inserting Text Boxes
• Inserting Shapes
• Working with Static Objects

Lesson 4: Getting Various Types of Visualizations

TOPIC A: Matrixes, Tables, and Charts

• Creating a Table
• Creating a Matrix
• Overview of Chart Types
• Creating Charts

TOPIC B: Maps

• Creating a Treemap
• Creating a Bubble Map
• Creating a Filled Map

TOPIC C: Cards, Gauges, and KPIs

• Creating a Card
• Creating a Gauge
• Creating a KPI

TOPIC D: Slicers

• Creating a Slicer
• Using Slicers
• Customizing Slicer Display
• Changing Slicer Mode
• Changing Slicer Orientation