La Courses

Log In

MIM1013 Analysing Data with Power BI (2 Days)

Description

MIM1013 Analysing Data with Power BI (2 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.

  • 93% positive reviews (31)
  • 271 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.

2 Days

  • Data analysts and business intelligence professionals 
  • Business professionals working with large datasets 
  • IT professionals involved in data analysis and visualization 
  • Individuals seeking to enhance their data analysis skills using Power BI Desktop 

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

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.