La Courses

Log In

MIM1016 Intensive Analysing Data With Power BI (5 Days)

Description

MIM1016 Intensive Analysing Data With Power BI (5 Days)

Overview

This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

  • 90% positive reviews (98)
  • 307 students

This program can be tailored to your specific business needs.

A little bit of personalization goes a long way. Ask us for a no-obligation Training Needs Analysis (TNA) so we can tailor this, or any other CSG program to meet your learning outcomes.

Contact Us
Objectives

At the end of the training, participants would be able to:

  • Ingest, clean, and transform data. 
  • Model data for performance and scalability. 
  • Design and create reports for data analysis. 
  • Apply and perform advanced report analytics. 
  • Manage and share report assets. 
  • Get familiar with paginated reports in Power BI.

5 Days

  • Data Analysts
  • Business Intelligence Professionals
  • Project Managers

Module 1: Get Started with Microsoft Data Analytics

Lesson 1.1: Data Analytics and Microsoft 
  • Introduction 
  • Overview of data analysis 
  • Roles in data 
  • Tasks of a data analyst 
  • Introduction 
  • Use Power BI 
  • Building Blocks of Power BI
  • Getting Started 

Module 2: Prepare Data in Power BI

Lesson 2.1: Get Data from Various Data Sources 
  • Introduction to getting data 
  • Get data from flat files 
  • Get data from relational data sources 
  • Get data from NoSQL 
  • Get data from applications 
  • Get data from Analysis Services
  • Select a storage mode 
  • Fix performance issues 
  • Optimize performance in Power Query 
  • Query folding
  • Identify and resolve data import errors
  • Prepare Data

Module 3: Clean, Transform, and Load Data in Power BI 

Lesson 3.1: Data Shaping
  • Introduction 
  • Identify column header and names 
  • Shaping table structure 
  • Pivot and Unpivot
  • Apply user-friendly value replacements 
  • Evaluate and change column data types 
  • Combine multiple tables into a single table 
  • Use Advanced Editor to modify m code
  • Profiling data
  • Loading Data

Module 4: Design a Data Model in Power BI

Lesson 4.1: Introduction to Data Modelling
  • Introduction to data modelling 
  • Joins and relationships 
  • Star schemas
  • Define and configure table and column properties 
  • Create a dates table 
  • Relationships and cardinality 
  • Create many-to-many relationships 
  • Modelling Challenges 
  • Combine queries
  • Create Model Relationships 
  • Configure Tables 
  • Review the model interface 
  • Create Quick Measures
  • Introduction to Dimensions and Hierarchies 
  • Role-playing dimensions 
  • Creating new Hierarchies 
  • Flatten out a parent-child hierarchy
  • Configure many-to-many relationships 
  • Enforce row-level security

Module 5: Create Measures using DAX in Power BI

Lesson 5.1: Introduction to DAX 
  • What is DAX 
  • Measures 
  • Calculated columns 
  • Columns vs measures 
  • Context 
  • The CALCULATE function 
  • Using relationships effectively 
  • Semi-additive Measures 
  • Time-Intelligence 

Module 6: Optimize Model Performance 

Lesson 6.1: Optimize the Model for Performance 
  • Introduction to performance optimization 
  • Use variables to improve performance and troubleshooting 
  • Performance Analyzer 
  • Review performance results 
  • Analyse query plans 
  • Reduce Cardinality 
  • Implement table granularity 
  • Introduction 
  • Implications of using DirectQuery 
  • Optimize performance
  • Introduction to Aggregations 
  • Creating aggregations 
  • Managing aggregations 

Module 7: Create Reports 

Lesson 7.1: Design a Report
  • Introduction 
  • Design a report layout 
  • Choosing effective visualizations 
  • Adding visualizations to reports 
  • Import a custom visual 
  • Add an R or Python visual 
  • Format and configure visualizations 
  • Basic Interactions 
  • Configure conditional formatting 
  • Design report navigation 
  • Design for accessibility 
  • Introduction 
  • Apply slicing, filtering, and sorting 
  • Performance tuning reports 
  • Commenting on reports 
  • Advanced interactions and drill throughs 
  • Add buttons, bookmark, and selections 
  • Key Performance Indicators 
  • Publish and export reports 

Module 8: Create Dashboards

Lesson 8.1: Create a Dashboard 
  • Introduction to Dashboards 
  • Add a dashboard theme 
  • Set mobile view 
  • Create a real-time dashboard 
  • Configure data alerts 
  • Pin a live report page to a dashboard 
  • Explore data by asking questions (The Q&A feature) 
  • Configure data classification 

Module 9: Create Paginated Reports in Power BI

Lesson 9.1: Paginated Report Overview 
  • Introduction to paginated reports 
  • When are they the right fit
  • Getting data 
  • Create a paginated report 
  • Work with Charts and tables 
  • Publish the report

Module 10: Perform Advanced Analytics

Lesson 10.1: Advanced Analytics 
  • Introduction to Advanced Analytics 
  • Explore Statistical summary 
  • Identify outliers 
  • Conduct Time-series analysis 
  • Using the Analyse feature 
  • Advanced analytics custom visuals 
  • Quick Insights 
  • Groupings and Binnings 
  • Clustering Techniques
  • Introduction 
  • The Q&A Visual 
  • AI Insights 
  • Key Influencer visual 
  • Decomposition tree visual

Module 11: Create and Manage Workspaces

Lesson 11.1: Creating Workspaces 
  • Introduction to Workspaces 
  • Create a Workspace 
  • Assign workspace roles 
  • Create Apps 
  • Configure and update a Workspace App 
  • Monitor usage and performance 
  • Development lifecycle strategy 
  • Viewing data lineage 
  • Data Protection 

Module 12: Manage Datasets in Power BI 

Lesson 12.1: Parameters 
  • Introduction to datasets and parameters 
  • Dynamic reports with parameters 
  • What-if parameter
  • Dataset scheduled refresh 
  • Incremental data refresh settings 
  • Manage and promote datasets 
  • Troubleshoot service connectivity with and without gateway

Module 13: Row-Level Security 

Lesson 13.1: Security in Power BI 
  • Security overview in Power BI 
  • Static Method 
  • Dynamic Method

Program Methodology

  • Hands-on Activities: Practical exercises to reinforce theoretical concepts.
  • Group Discussions: Opportunities for peer-to-peer learning and exchange of ideas.
  • Role Plays: Simulations of realistic situations to build practical skills.
  • Feedback Sessions: Reviews and reflections to encourage improvement.
  • Problem-solving Exercises: Develop critical thinking and decision-making skills.
  • Experiential Learning: Learning by doing, promoting active involvement.
  • Interactive Lectures: Engaging presentations by experts in the field.
  • Case Studies: Real-world scenarios for learners to apply their knowledge.
  • Quizzes & Tests: Regular assessments to track learning progress.

Choose a Training Partner that Stays Invested.

CSG is here for you before during and post trainings. Contact Us for customized training solutions or Explore our Programs.

Read our FAQs

Tell Us What You Need, We’ll Make it Happen

Welcome Back

Sign In

New here? Create an account.