Skip to content

Power BI Training in Singapore and India

Save 22% Save 22%
Original price Rs. 290,000.00
Original price Rs. 290,000.00 - Original price Rs. 290,000.00
Original price Rs. 290,000.00
Current price Rs. 225,000.00
Rs. 225,000.00 - Rs. 225,000.00
Current price Rs. 225,000.00
Power BI Training by Cloud Enabled Pte Ltd in Singapore and India
Course Summary

Power BI is quickly gaining popularity among professionals in data science as a cloud-based service that helps them easily visualize and share insights from their organizations’ data.

You’ll walk through Power BI, end to end, starting from how to connect to and import your data, author reports using Power BI Desktop, and publish those reports to the Power BI service. Plus, learn to create dashboards and share with business users–on the web and on mobile devices.

Course Objectives
  • Connect, import, shape, and transform data for business intelligence (BI)
  • Visualize data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop and Excel
  • Use natural language queries
  • Create real-time dashboards
Course Pre- requisites
  • Web and Java Application developer
Course Duration
  • 35 hours – 5 days
Course Outline

Power BI Introduction 

  • What is BI
  • What is Power BI
  • Different Products of Power Bi
    • Power BI Desktop
    • Power BI Pro
    • Power BI Premium
    • Power BI Mobile

Power Query – Introduction 

  • How to import data into Power Query from Excel file, Csv, Text Files?
  • How to import data into Power Query from MS Access file/ SQL, Oracle?
  • How to import data into Power Query from Web, PDF, Exchange Online
  • Loading data from Power Query back to Excel sheet, Power View
  • What happens to Power Query data when output changes?

Power Query – Data Transformation 

  • Text Functions
    • Upper, Lower, Sentence Case, Trim, Clean
    • Add Prefix , Add Suffix
    • Left, Right, Mid, Length,
  • Number Functions
    • Addition, Subtraction, Di
  • How to keep or remove – empty / duplicate rows, define header row, filter rows?
  • How to perform left, right, mid, len formulas on Text data inside Power Query
  • How to perform addition, subtraction, multiplication, division inside Power Query?
  • How to get date related information like Day name, month name, Year, Quarter, etc.?
  • Writing conditional IF type formulas inside Power Query using user interface.

 Power Query – Working on data from multiple sources 

  • No more manual copy and paste to append data from multiple sheets, files, etc.
  • What does it means to Duplicate or reference a Power Query
  • Creating dynamic inventory of all the files stored in a folder.
  • Workaround for issue while sharing files with Power Query

 Power Query – Appending Data

  • Append 100 Excel Sheets, Tables and Range in 4 button Clicks
  • Append 100 Excel Files, CSV Files, and SQL Tables in 6 button Clicks
  • Append 100 PDF Files into one Table in 6 button clicks

Power Query – I have stopped using VLOOKUP function – want to know why? 

  • Limitation of VLOOKUP and how to overcome them
  • Use Six different type of Joins as alternative to VLOOKUP
  • Perform complex CROSS join of multiple dataset with NO common field

Power Query – Learn basics of M Language 

  • Fundamentals of M Language and its characteristics
  • Learn using lot more M function for Text
  • How to use date function from M library
  • Performing complex conditional logic with AND / OR logic checking

Power Query – Apply the knowledge gained to real world datasets

  • How to convert multiple year financial data converted to tabular format
  • How to transform monthly payroll data for 1000s of employee with simple click of button
  • You data stacked up one above another – no worries Power Query is there for you
  • No more manually applying multiple items in filter drop downs
  • How data stored in rows can be converted into columns – more complex than transpose
  • Picking up data stored in multiple tables and getting discount amount
  • Dirty invoice data converted to perform sales analysis
  • Performing Sales analysis using data from multiple tables

Power Query – Increase your level with regards to M Language

  • Elements of Power Query M Language – Lists
  • Elements of Power Query M Language – Records
  • Elements of Power Query M Language – Tables
  • Recap of fundamental objects of Power Query

Power Query – Apply your M Language knowledge

  • Text files – ignore top / bottom rows and extract relevant data in the middle
  • Prepare Calendar table by providing Start and End date with all other information
  • Calculating ratio of Individual Sales to total sales inside Power Query
  • Second approach to applying multiple filters on a single column

Power Query – Advanced 

  • Conditional Column
  • Column from Examples
  • Create Table from Examples

Power Query – M functions 

  • Date Functions (Approx 30 functions)
  • Number Functions (20+ Functions)
  • Text Functions (20+ Functions)
  • Logical Functions (5 + Examples)
  • Other Functions

Power View – Introduction

  • What is Power View in Power BI?
  • Using Power BI Desktop Tool – Options
  • Report Visuals, Fields, Pages and Filters
  • Report, Data and Relationship Options
  • Working with Visualizations and PBI Canvas
  • Working with Enter Data, Get Data Options
  • Enter Data from Excel Files, Basic Reports
  • PBIX and PBIT File Formats. Differences
  • Designing Simple / Basics Reports in PBI
  • Visual Interactions in Power BI – Options
  • Spotlight Options with Visuals, Real-time Use
  • VIEW Options with Power BI Desktop Tool
  • Web View and Mobile View Options, Scaling
  • Table Visual and GRID Options for Display

Power View- Hierarchies

  • Grouping and Binning with Fields
  • Bin Size and Biz Limits (Max, Min)
  • Creating Hierarchies. DrillDown Reports
  • Drill Thru Reports and Conditional Filters
  • Expand, Expand All Down, Goto Next Level
  • Drill Up, Drill Down. Exclude & Include
  • See Data, Export Data, See Records Options
  • Filters : Types and Usage in Real-time
  • Visual Filters, Page Filters, Report Filters
  • Drill-thru Filters with Hierarchy Levels
  • Basic, Advanced, TOP N Filters – Usage
  • Filtering at Category Level, Summary Level
  • Import and Direct Query with Power BI

Power View – Visuals 

  • Power BI Visualizations and Types
  • Fields, Formats and Analytics Options
  • Table Visuals and Properties, Filters
  • Data Bar and Data Scaling Options
  • Divergent Colors and Data Labelling
  • Conditional Formatting, Grid Lines
  • Matrix : Sub Totals, Drilldown Options
  • Row Groups and Column Groups in Matrix
  • Slicer – Single Select and Show All
  • Chart Reports – Types, Common Properties
  • Axis, Legend, Value and Tooltip Options
  • Stacked Bar Chart, Clustered Column Chart
  • Stacked Bar Chart, Stacked Column Chart
  • Clustered Bar Chart : Properties, Use
  • Clustered Column Chart : Properties
  • 100% Stacked Bar and Column Charts
  • Data Label Properties, Legend Properties

Power View – Advanced Visualization 

  • Line Chart, Area Chart Properties, Usage
  • Stacked Area Chart – Properties, Usage
  • Line and Stacked Column Charts Usage
  • Line and Clustered Column Chart Usage
  • Visual Fields, Shared Axis, Legend
  • Column Series and Column Axis in Lines
  • Join Types, Lines: Round, Bevel, Miter
  • Shapes and Markers in Power BI Visuals
  • X Axis, Y Axis Properties, Plot Area
  • Series, Custom Series and Legends
  • Ribbon Chart – Properties, Line Width
  • Match Series and Plot Area Options
  • Waterfall Chart – Sentiment Colors
  • Breakdown Count – Decrease / Increase
  • Scatter Chart – Play Area and Axes
  • Axis Values, Color Saturation, Legend
  • Line and Donut Charts – Properties

Power View – Supporting Elements for Visualization 

  • Data Point and Series Limitations
  • Tree Map, Funnel and Gauge Reports
  • Group and Values in Tree Map Visuals
  • Min. Max Values and Goal Indicators
  • Single Row Card and Multi Row Cards
  • Non-Interactive Visuals in MultiRow
  • Callout Values in KPI Reports and Use
  • Indicator, Trend and Target Goals in KPIs
  • Map Reports and Filled Map Reports
  • ArcGIS Maps – Latitudes and Longitudes
  • Using Buttons, Images in Power BI Canvas
  • Bookmarks in Power BI Desktop – Usage
  • Using Bookmarks with Buttons, Actions
  • Using Bookmarks for Visual Filters
  • Using Bookmarks for Page Navigations
  • Using Selection Pane with Bookmarks
  • Buttons, Images in Power BI Desktop

Power BI Service – Cloud 

  • Power BI Service (Cloud) Architecture
  • App Workspace Creation in Real-time
  • Publish Reports from Power BI Desktop
  • Reports, Datasets in Power BI Cloud
  • Creating Dashboards and Realtime Use
  • Pin Visuals and Pin LIVE Report Pages
  • Dashboard Creation with Tiles, Media
  • Tiles – Images, Web Content, Chapters
  • Subscriptions, Insights and Refresh
  • Metrics, Distribution Methods, Actions
  • Favorites, Shares, Dashboard Themes
  • Performance Inspector and QR Codes
  • Dataset Actions – Report Creation Options
  • Power BI LIVE Report Edits, Downloads
  • Quick Insights and PBIX Downloads

Power Pivot – Introduction 

  • Importing Data
  • Importing Data into Power Pivot
  • Importing Data from Relational Databases
  • Importing Data from Text Files
  • Reusing Existing Connections to Update the Model

Creating the Data Model 

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

Creating Calculations with DAX 

  • 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

Creating Measures with DAX 

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

Incorporating Time Intelligence 

  • Date-Based Analysis
  • Creating a Date Table
  • Time Period–Based Evaluations
  • Shifting the Date Context
  • Using Single Date Functions
  • Creating Semi-additive Measure
Training Delivery Mode

Online - Live Instructor Led training 

Due to Covid - we dont engage classroom training till situations are ok

Got Questions

Please email to and we will be happy to help

This course is designed , developed and delivered by Cloud Enabled Pte Ltd