Home > Vendors > microsoft > grc-110

Share

GRC-110 - Microsoft Power BI Data Preparation & Visualization Workshop

This instructor-led intensive Power BI workshop is designed for participants to be equipped with the necessary knowledge and skills to analyze data with Microsoft Power BI. You will be guided from the stage of connecting data, transforming data and visualizing your data.

Duration: 2.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training

Objectives

After completing this course, students will be able to:
  • Describe key features of a self-service BI solution 
  • Describe Power BI and its data sources 
  • Model, shape and combine data 
  • Describe Power BI visualizations 
  • Perform more advanced tasks with Power BI 
  • Understand other management and maintenance factors of Power B

Content

Module 1: Introduction to Data Visualization
  • What is data visualization? 
  • Why Power BI is the best data visualization solution! 
  • Power BI: The cloud service 
  • Lab 01 – Creating a simple Power BI report

Module 2: Preparing Your Data
  • Getting data from various sources
  • Resolving errors during data retrieval
  • Lab 02 – Import data into Power BI

Module 3: Cleansing and Transforming Data
  • Power BI Desktop queries (Power Query)
  • Cleansing data and transformations
  • Appending and merging data
  • Lab 03 – Shaping up and consolidating data

Module 4: Designing a Data Model
  • Understanding M Formula language 
  • Experimenting with data massaging with Power Query editor window 
  • Working with tables and relationships 
  • Lab 04 – Building and evaluating table relationships

Module 5: Calculations using DAX
  • Performing simple calculations to create new columns 
  • Creating measures 
  • Generating a simple pivot table report using the calculations of DAX 
  • Lab 05 – First steps to DAX

Module 6: Creating Power BI Reports
  • Designing a report 
  • Enhancing the report 
  • Using effective visuals on the report 
  • Lab 06 – Creating a report with interactions and formatting

Module 7: Creating Power BI Dashboard
  • How different is a dashboard to a report? 
  • Creating a dashboard 
  • Enhancing the dashboard 
  • Q&A features of Power BI dashboards
  • Lab 07 – Creating a dashboard with Q&A capabilities

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

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
 
 
 
 
3HMi5b
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy
➤