Home > Vendors > microsoft > grc-101

Share

GRC-101 - An Analytical Journey with Power BI

This instructor-led adventurous workshop is designed for audiences to be equipped with the necessary knowledge and skills to kickstart their analytical journey with Microsoft Power BI. You will be guided from the stage of connecting data, transforming data, and visualizing your data.
 

Duration: 3.0 days

Enquire Now

Schedule

Singapore | 29 Nov 2023 - 01 Dec 2023 Singapore
Virtual ILT | 29 Nov 2023 - 01 Dec 2023 Singapore
Kuala Lumpur | 29 Nov 2023 - 01 Dec 2023 Malaysia
Virtual ILT | 29 Nov 2023 - 01 Dec 2023 Malaysia

Start learning today!

Click Hereto customize your Training

Objectives

After completing this course, students will be able to:

  • Describe key features of Microsoft Power BI
  • Understand how data are connected to Microsoft Power BI
  • Massage, cleanse, format and transform data
  • Visualizing data using reports and dashboards

Content

Module 1: Microsoft Power BI as a Service
  • What is Power BI?
  • The Power BI service and its ecosystem
  • Product and subscription information
  • Familiarizing with Microsoft Power BI app and service
Module 2: Getting to Know Your Data ·  Using Excel as a Power BI data source
  • Using databases as a Power BI data source
  • Essence of data modeling
  • Understanding the Power BI dataset
  • Importance of table relationships
  • Understanding the purpose of a Date table

Module 3:  Data Transformations in Power BI ·  Power BI Desktop queries (Power Query)
  • Cleansing data and transformations
  • Consolidation of data through appends and merges
  • Golden techniques of data consolidation in Power BI

Module 4: Making Use of Power Query Editor ·  Essence of M Formula language
  • Experimenting with data massaging with Power Query editor window
  • Custom functions using M Formula language
  • Common scenarios of efficient data transformation
Module 5: Projecting Your Data Through Visualizations ·  Creating Power BI reports
  • Creating Power BI dashboards
  • Selections and Bookmarks
  • Q&A feature of Power BI
  • AI visuals of Power BI
Module 6: Introduction to DAX ·  What is DAX?
  • Calculated columns vs. measures
  • What are quick measures?
  • Performing simple calculations
  • Generating a simple pivot table report using the calculations of DAX
  • Difference between M and DAX
Module 7:  A Step Above in Power BI ·  Microsoft AppSource
  • What are Power BI Apps and Custom Visuals?
  • What is Row-level Security (RLS)?
  • DirectQuery vs. Import connectivity modes
  • Options of embedding Power BI reports/dashboards
  • Power BI Premium… What you need to know

Audience

N/A

Prerequisites

This course is for beginners and users with little or no exposure of basic programming concepts, little or no knowledge of data warehouse schema, an awareness of key business priorities such as revenue, profitability, and financial accounting, and technically familiar with Microsoft Excel.

Certification

product-certification
This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Microsoft Popular Courses

ms-700t00

The Managing Microsoft Teams course is designed for those aspiring to be Microsoft 365 Teams Administrators to deploy, configure and manage Office 365 workloads

sc-900t00

This course provides foundational level knowledge on security, compliance, and identity concepts and related cloud-based Microsoft solutions.

az-204

Learn to create end-to-end solutions in Microsoft Azure in this 5-days official Microsoft course.

az-104

This course teaches IT Professionals how to manage their Azure subscriptions, secure identities, administer the infrastructure, configure virtual networking, co
Enquire Now
 
 
 
 
WBMYfX
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤