Data Analysis & Dashboarding with Power BI

COURSE PLAN

Course Outline – Power BI

Any data, anywhere, anytime Power BI is a cloud-based business analytics service that gives you a single view of your most critical business data. Monitor the health of your business using a live dashboard, create rich interactive reports with Power BI Desktop and access your data on the go with native Power BI Mobile apps. It’s easy, fast, and free.

Section I: Building Models in Power Pivot

  • Why Use Power Pivot?
  • The xVelocity In-memory Analytics Engine
  • Enabling Power Pivot for Excel
  • Exploring the Data Model Manager Interface

  • Importing Data from Relational Databases
  • Importing Data from Text Files
  • Importing Data from a Data Feed
  • Importing Data from an OLAP Cube
  • Reusing Existing Connections to Update the Model

  • Discovering and Importing Data
  • Transforming, Cleansing, and Filtering Data
  • Merging and Shaping Data
  • Grouping and Aggregating Data
  • Inserting Calculated Columns

  • What Is a Data Model?
  • Creating Table Relations
  • Creating a Star Schema
  • Understanding When to Denormalize the Data
  • Creating Linked Tables
  • Creating Hierarchies
  • Making a User-Friendly Model

  • What Is DAX?
  • Implementing DAX Operators
  • Working with Text Functions
  • Using DAX Date and Time Functions
  • Using Informational and Logical Functions
  • Getting Data from Related Tables
  • Using Math, Trig, and Statistical Functions
  • Tips for Creating Calculations in Power Pivot

  • Measures vs. Attributes
  • Creating Common Aggregates
  • Mastering Data Context
  • Altering the Query Context
  • Using Filter Functions
  • Creating KPIs

  • Date-Based Analysis
  • Creating a Date Table
  • Time Period–Based Evaluations
  • Shifting the Date Context
  • Using Single Date Functions
  • Creating Semi-Additive Measures

  • Pivot Table Fundamentals
  • Slicing the Data
  • Adding Visualizations to a Pivot Table
  • Working with Pivot Charts
  • Using Multiple Charts and Tables
  • Using Cube Functions

Section II: Building Interactive Reports and Dashboards with Power BI Desktop

  • Setting Up the Power BI Environment
  • Getting, Cleaning, and Shaping Data
  • Creating Table Relationships
  • Adding Calculations and Measures
  • Incorporating Time-based Analysis

  • Creating Tables and Matrices
  • Constructing Bar, Column, and Pie Charts
  • Building Line and Scatter Charts
  • Creating Map-Based Visualizations
  • Linking Visualizations in Power BI
  • Drilling Through Visualizations

  • Creating a User-Friendly Model
  • Publishing Power BI Desktop Files to the Power BI Service
  • Adding Tiles to a Dashboard
  • Sharing Dashboards
  • Refreshing Data in Published Reports

Use Case 1: Reseller Sales Analysis

  • Load the Data
  • Create the Model
  • Create Calculated Columns
  • Create Measures
  • Create the Dashboard

Use Case 2: Sales Quota Analysis

  • Load the Data
  • Create the Model
  • Create Measures
  • Create the Report

Use Case 3: Sensor Analysis

  • Load the Data

  • Writing Queries with M
  • Creating and Using Parameters
  • Creating and Using Functions

  • Using Custom Visuals
  • Implementing Geo-spatial Analysis
  • Implementing Row-Based Security
  • Creating Templates and Content Packs

COURSE DURATION

Total Course Duration: 36 Hours
Per Class Duration: 3 Hours

RELATED COURSES

AUTHORIZATION

COURSE RESOURCE PERSON

MOHAMMAD SHIHAB UDDIN
SENIOR TECHNICAL TRAINER (PROGRAMMING)

View Profile

MD. FOYSAL WAHID
SENIOR TECHNICAL TRAINER
(PROGRAMMING)

View Profile

MUNTASIR MOSTAFA JAMAL
TECHNICAL TRAINER (PROGRAMMING)

View Profile
UPCOMMING BATCH
register now
CLICK HERE