GRC-101: An Analytical Journey with Microsoft Power BI

This GRC-101: An Analytical Journey with Microsoft Power BI custom developed 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.

PRO Tip: As a leading business intelligence tool, Power BI provides business users with the power and flexibility they need to work with data. To get the most out of it, learn to Avoid These 10 Power BI Mistakes.

After completing this Power BI 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

This Power BI 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.

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
   

GRC-102: Conquering DAX 2019

This GRC-102: Conquering DAX 2019 workshop is a complete course about the DAX language. DAX is the native language of Power BI, Power Pivot for Excel, and SSAS Tabular models in Microsoft SQL Server Analysis Services. The training is aimed at users of Power BI, Power Pivot for Excel, and at Analysis Services developers that want to learn and master the DAX language. This DAX training course covers the latest version of DAX 2019.

GRC-104: Intensive Data Modeling For Microsoft Power BI Creators

This intensive Power BI data modeling workshop is a complete course about building the most optimal data models for your Power BI reports. It introduces the audience to the basic techniques of shaping data models in Power BI. It offers many real-world examples that will help you look at your reports in a different way – pretty much like experienced data modelers do.

GRC-105: Microsoft Power BI Advanced Dashboard Design Concepts And Strategies

This 2-day Power BI dashboard design course is designed for Power BI creators who wish to learn how to create beautiful and effective dashboards, while avoiding all the common design pitfalls and mistakes.

PL-300T00: Microsoft Power BI Data Analyst

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.

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.

Turn your data into immediate impact.

Do more with less using an end-to-end BI platform to create a single source of truth, uncover more powerful insights, and translate them into impact with these recommended resources:

• The Common Questions and Answers for Power BI
• Why POWER BI makes your reporting life easier?
• Low-Code Datamart with Microsoft Power BI
• The Future Of Enterprise Analytics Is Power BI And Azure
• Microsoft Power BI: Creating Meaningful Data Reports
• Real-Time Streaming In Microsoft Power BI
• How Do You Extract The True Value Of Your Data With Power BI?