Sunesis Consulting

A Sunesis Consulting Academy Masterclass

Data Analysis & Visualization with Power BI

About This Course

Loaded with real-life business scenarios along with quizzes and projects to build, this course will give you the solid understanding required to gain absolute control over your data and visualize it aesthetically. We will not only train you on how to design dashboards, but we will also acquaint you with data modeling, and data transformations, train you on how to write DAX, configure calculated columns and measures, assign roles, and ultimately share your dashboards with your team or clients.

What you will learn

Course Prerequisite

Curriculum

Mode of training - Fully Online
  • Self Service BI
  • Power Pivot
  • Power Query
  • Power View
  • Power Map
  • Power BI
  • The Value Proposition
  • Licensing and Pricing
  • Market Positioning
  • Overview of the Cloud Service
  • Building a CFO Dashboard
  • Dashboard Flow and Navigation
  • Using the Demo Samples
  • How to use Q&A (Natural Language Queries)
  • Obtaining Value from Quick Insights
  • Publish to web (Embedded View)
  • Exporting Reports to PowerPoint
  • Overview of Power BI Desktop
  • Technical Options & Settings
  • Monthly Updates
  • Data Modeling 101
  • Building a Robust Star Schema
  • Importing Data from various sources
  • Query Editor Overview
  • Using Direct Query
  • Understanding Query Design & the ETL Process
  • Query Building Best Practice
  • Understanding Applied Steps
  • Data Transformations
    ᵒ Cleaning data (covers many different methods)
    ᵒ Merging Datasets
    ᵒ Unpivoting Data
    ᵒ Combining Files from a Folder
    ᵒ Appending Datasets
    ᵒ Creating Columns from Examples
  • Using a Dynamic Fiscal Calendar Table
  • Creating & Using Parameters
  • Creating Relationships
  • Handling Multiple Relationships with the Fact Table
  • Default Summarization of Fields
  • Custom Sorting of Columns
  • Data Types & Formatting
  • Build an example of Time Intelligence Report
  • Introduction to DAX
  • Implicit Vs Explicit Measures
  • Creating Calculated Measures & Calculated Columns
  • Commonly Used DAX Functions
    ᵒ Sum, Average, Count, DistinctCount
    ᵒ Time Intelligence (MTD, QTD, YTD, Prior Year)
    ᵒ Understanding Calculate and the filter context
    ᵒ IF, HasOneValue
    ᵒ Using a Safe Divide Function
    ᵒ UserRelationship Function
    ᵒ Using the Blank() Function
  • Copying and Moving Measures
  • Using Quick Measures
  • Build a Monthly Trend Report
  • Dynamic Headings & Dates
  • Types of Slicers and Filters
  • Understanding KPI cards
  • Building Tabular Reports
  • Table vs Matrix Visuals
  • Types of Conditional Formatting
  • Adding Drill Downs
  • Using Focus Mode
  • Viewing the Underlying Data Driving a Visualization
  • Customizing Report Visual Interactivity
  • Exporting Data from Power BI
  • Explain the Increase or Decrease in Visuals
  • Build a Qty Shipped Vs Qty Sold Report
  • Optimizing Report Slicers
  • Building a Year Over Year Report
  • Choosing Visuals Based on Context
  • Using Custom Visuals
  • Optimizing the use of Maps
  • Optimizing Waterfall Charts
  • Getting Value from Scatter, Ribbon & Bullet Charts
  • Moving away from 1 Dimensional Story telling
  • Adding & Optimizing Tool Tips
  • Using the Format Painter
  • Visual Alignment Tips
  • Custom Page Sizing
  • Using Logos & Custom Icons
  • Making Enhancements with Shapes and Lines
  • Formatting Tips & Tricks
  • Best Practice Guidelines and Development Tips
  • Removing or Hiding Data Model Redundancies
  • Understanding Row Level Security
  • Creating and Testing Security Roles
  • Publishing Models to the Cloud Service
  • Adding Users to Security Defined Roles
  • Basic Sharing of Dashboards & Reports
  • Creating App Workspaces
  • Collaborating on Reports
  • Publishing Organizational Apps for Distribution of Content
  • Adding Users & Editing Workspaces
  • Connecting to Apps
  • Organizational Content Packs
  • Role of a Power BI Cloud Service Administrator
  • Overview of the Data Gateway
  • Scheduling Data Refreshes
  • Refreshing On Demand
Share This :
Power BI Masterclass

What is Power BI?

Course details

Dates

KES. 19,800 / VAT Incl

The discounted fee above ends on
31st July 2022

Thinking of having in-house training for your staff?

Fill out your contact details below so we can get in touch with you regarding your training requirements.