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

Check out more Power BI courses in Malaysia

Orbitage Logo

Big Data for Telecommunications

This program develops hands-on skills in big data analytics highlighting its importance for the telecommunications industry and how the outputs of analysis can be used to give competitive advantage.

by Orbitage [Claim Listing ]
GKK Consultants Sdn Bhd Logo

Big Data Foundation

The Big Data Foundation Certification is essential for everyone working with Big Data. This certification provides an understanding of Big Data, potential data sources that can be used to solve real world problems, and an overview of data mining and its capabilities.

by GKK Consultants Sdn Bhd [Claim Listing ]
Gem Consultancy Logo

Data Analytics

Data Analytics training is offered by Gem Consultancy. We emphasise on practical training through setting conditions for how learner can practice what they have learned and performance be evaluated.

by Gem Consultancy [Claim Listing ]
DreamCatcher Logo

Microsoft Power BI Made Simple For Finance And Hr Professionals

New and powerful ways to start your dashboard reporting by using Power BI Desktop in organized and easy steps. This is designed by an Accountant who is well versed in financial analysis and your reporting needs.

by DreamCatcher [Claim Listing ]
Asian Banking School (ABS) Logo

Foundation In Big Data Analytics For The Banking Sector

With the proliferation of data analytics initiatives by various governments, businesses and social media platforms, it becomes paramount to understand the fundamentals of Big Data Analytics and its applications to the banking sector.

by Asian Banking School (ABS) [Claim Listing ]

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