Power BI (Business Intelligence)

by Elite Indigo Claim Listing

Power BI is quickly gaining popularity among professionals in data science as a cloudbased service that helps them easily visualise and share insights from their organisations' data.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Elite Indigo Logo

img Duration

2 Days

Course Details

Power BI is quickly gaining popularity among professionals in data science as a cloudbased service that helps them easily visualise and share insights from their organisations' data.

This training covers the core elements needed to get an understanding of what Power BI can do. It also provides Excel users the power to draw information out of multiple sources, links it together and performs calculations.

Trainees will learn how to connect and merge data with Power BI Desktop, the powerful data analysis, and visualisation software. This training will be using mini-lectures and hands-on learning to cover data transformation and modelling on Day 1.

For Day 2, the trainees will learn the data visualization techniques and direct connectivity concepts using Power BI Desktop.

 

Objectives:

  • Connect, import, shape and transform data for business intelligence
  • Create an interactive dashboard based on a report in Power BI Desktop
  • Visualise data and automate refresh of your designed reports

 

Course Outline:

  • Module 1 (Day 1)
  • Training Overview
  • Introduction to Power BI
  • Power BI Desktop, Power Query and
  • Power Pivot
  • Connecting to a Database
  • Basic Transformation
  • Managing Query Groups
  • Splitting Columns
  • Changing Data Types
  • Working with Dates
  • Removing and Reordering Columns
  • Conditional Columns
  • Merge Queries
  • Module 2: Day 2
  • Concepts of Data Visualisation
  • Pie and Treemap
  • Hierarchiccal Axis and Concatenating
  • Bar Chart with Line
  • Analytics Pane
  • Clustering
  • Slicer
  • Focus Mode and See Data
  • Data Slicer
  • Map Visualisations
  • Table and Matrix
  • Scatter Chart
  • Waterfall
  • Gauge, Card and KPI
  • Query Dependency View
  • Enter Data
  • Query Parameters
  • Lab 1: Used Case
  • Managing Data Relationships
  • Creating Calculated Columns
  • Optimising Models for Reporting
  • Creating Calculated Measures
  • Creating and Managing Hierarchies
  • Time Intelligence
  • Manually Typing in a Data Table
  • Include/ Exclude, Grouping/ Binning
  • Lab 2: Used Case
  • Colouring Charts Shape, Textbooks
  • and Images
  • Gridlines and Snap to Grid
  • Page Layout and Formatting
  • Visual Relationship
  • Categories with No Data
  • Default Summarisation and
  • Categorisation
  • Positioning, Aligning and Sorting
  • Visuals
  • Custom Hierarchies
  • Working with Excel and Direct
  • Connectivity
  • Lab 3: Used Case
  • George Town Branch

    51, Jalan Nuri 6, George Town

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy