top of page
Background (2).png

Microsoft Power BI

WHAT YOU WILL LEARN

This one-day express training is designed to equip participants with quick-start skills on Microsoft Power BI. It covers the essential steps from getting data to generating a report quickly. This overview training is best for participants who want to know Microsoft Power BI as promptly as possible and dive right into creating a report or dashboard immediately.


OBJECTIVES

After completing this workshop, participants will be able to:

  • Start familiarizing with Power BI Desktop

  • Get data from a variety of sources, especially Microsoft Excel

  • Perform simple data cleansing and transformation

  • Start visualizing data using a variety of visual types in a Power BI report


PREREQUISITES

This workshop is for beginners and users with little or no exposure to 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. Simply put, it is for every walk of life!


COURSE CONTENTS


Module 1: Getting to Know Your Data

  • What is Power BI, and how does it connect to your data?

  • Using Excel as a familiar source of data

  • Understanding the Power BI data model

  • Understanding the importance of table relationships


Module 2: Data Transformation Using Power Query

  • Creating a query in Power BI Desktop

  • Simple data transformation using Power Query

  • Consolidating data in Power Query Editor

  • The M language


Module 3: Simplified DAX For You!

  • What is DAX?

  • Calculated columns vs. Measures

  • Performing simple calculations


Module 4: Visualizing Your Data

  • Creating a simple Power BI report

  • Creating a simple Power BI dashboard

  • Get to know the popularly used visuals

  • Basic report design features

Assessment

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

Data Analysis Expressions (DAX)

This assessment consists of 20 multiple choice questions related to Microsoft DAX language, a formula language used for data analysis and modeling in various Microsoft products, including Power BI. The questions cover a range of DAX functions and concepts, such as calculating running totals, filtering tables, concatenating strings, and returning related values. Each question has four options, and the correct answer is provided for each. This assessment is designed to test the participant's understanding of the DAX language and their ability to apply it in practical scenarios.
Take Assessment
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

Microsoft Power BI

This assessment is designed to test your knowledge and understanding of Microsoft Power BI, a business intelligence tool that enables users to connect, analyze, and visualize data from various sources. The assessment includes 20 multiple choice questions covering topics such as data modeling, visualization, formulas, and features of Power BI Desktop and Power BI Premium. The questions are intended to provide a pre-assessment of your knowledge level and help you identify areas where you may need to improve your skills.
Take Assessment

Related Courses

GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

GRC-101: An Analytical Journey with Microsoft Power BI

RM3,300.00

ILT/VILT

Empower team members to discover insights hidden in your data with Microsoft Power BI courses.

 

Microsoft Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards. It is part of Microsoft Power Platform.

 

Gain expertise to amplify your insights and the value of your data with GRC's custom-developed Power BI course.

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • SBL-Khas Claimable

 

Download Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 or may check out the entire Power Platform training series and blogs at Honing Your Skills On Microsoft Power Platform.

Learn more
GRC-103FT Microsoft Power Platform End-To-End Discovery Workshop (Fastrack).png

PL-300T00: Microsoft Power BI Data Analyst

RM2,800.00

ILT/VILT

Discover the Microsoft Certified: Power BI Data Analyst Associate credential.

 

If you are a data analyst or developer who frequently works with data, having the Microsoft Certified: Power BI Data Analyst Associate certification on your résumé is a valuable asset.

 

This Power BI certification not only recognizes your skill set but also helps your organization distinguish itself from others. It confirms that you possess the necessary abilities to assist businesses in optimizing their data assets using Power BI.

 

In today's digital age, subject matter experts with Power BI proficiency are at the forefront of the technological revolution. These experts are capable of making new sources of information more accessible, understandable, and useful to organizations of all sizes.

 

By obtaining this Power BI certification, you are validating your Power BI data skills and standing out in a world where the demand for this expertise is rapidly increasing.

 

For customized and hands-on Microsoft Power BI training, you may refer to An Analytical Journey with Microsoft Power BI

 

Training Duration: 3 Days

  • Certificate Of Completion Available
  • Group Private Class
  • VILT Class Available
  • SBL-Khas Claimable

 

Download Course Outline

 

Looking for function and formula for Power BI, may visit Conquering DAX 2019 or may check out the entire series and blogs at Honing Your Skills On Microsoft Power Platform

Learn more

Dynamics 365