Course Name

PowerBI Data Analyst

Course Introduction

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

The course will show how to access and process data from a range of data sources including both relational and nonrelational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

Data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on premises.

Course Prerequisites

Analysts start this role with experience of working with data in the cloud.

Specifically:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.

Course Objectives

By the end of this course, you will 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
  • Create paginated reports in Power BI

Course Content

  • Module 1: Get Started with Microsoft Data Analytics
    • Explore the different roles in data
    • Identify the tasks that are performed by a data analyst
    • Describe the Power BI landscape of products and services
    • Use the Power BI service
  • Module 2: Prepare Data in Power BI
    • Identify and retrieve data from different data sources
    • Understand the connection methods and their performance implications
    • Use Microsoft Dataverse
    • Connect to a dataflow
  • Module 3: Clean, Transform & Load Data
    • Apply data shape transformations
    • Enhance the structure of the data
    • Profile and examine the data
  • Module 4: Design a Data Model in Power BI
    • Understand the basics of data modelling
    • Define relationships and their cardinality
    • Implement Dimensions and Hierarchies
    • Create histograms and rankings
  • Module 5: Create Model Calculations Using DAX
    • Understand Data Analysis Expressions
    • Use DAX for simple formulas and expressions
    • Create calculated tables and measures
    • Build simple measures
    • Work with Time Intelligence and Key Performance Indicators
  • Module 6: Optimise Model Performance in Power BI
    • Understand the importance of variables
    • Enhance the data model
    • Optimise the storage model
    • Implement aggregations
  • Module 7: Create Reports in Power BI
    • Design a report page layout
    • Select and add effective visualisations
    • Add basic report functionality
    • Add report navigation and interactions
    • Improve report performance
    • Design for accessibility
  • Module 8: Create Dashboards in Power BI
    • Create a Dashboard
    • Understand real-time Dashboards
    • Enhance Dashboard usability
  • Module 9: Enhance Reports for Usability and Storytelling in Power BI
    • Explain paginated reports
    • Create a paginated report
    • Create and configure a data source and dataset
    • Work with charts and tables
    • Publish a report
  • Module 10: Perform Advanced Analytics in Power BI
    • Explore statistical summary
    • Use the Analyse feature
    • Identify outliers in data
    • Conduct time-series analysis
    • Use the AI visuals
    • Use the Advanced Analytics custom visual
  • Module 11: Manage Datasets in Power BI
    • Create and work with parameters
    • Manage datasets
    • Configure dataset refresh
    • Troubleshoot gateway connectivity
    • Understand the aspects of Power BI security
    • Configure row-level security roles and group memberships
  • Module 12: Create and Manage Workspaces in Power BI
    • Create and manage a workspace
    • Understand workspace collaboration
    • Monitor workspace usage and performance
    • Distribute an App
    • Configure dataset refresh
    • Troubleshoot gateway connectivity
    • Understand the aspects of Power BI security
    • Configure row-level security roles and group memberships
L ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Get in touch

Contact the Impactful team if you need any assistance.

Course Introduction

This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.

The course will show how to access and process data from a range of data sources including both relational and nonrelational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Course Delivery Method

Our courses have flexible delivery options:

  • In-person classroom training at the Impactful training
    facilities

  • Virtual instructor-led training
  • Nationally: on-site at the client

Course Intended Audience

This course is intended for:

Data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI.

This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on premises.

Course Prerequisites

Analysts start this role with experience of working with data in the cloud.

Specifically:

  • Understanding core data concepts.
  • Knowledge of working with relational data in the cloud.
  • Knowledge of working with non-relational data in the cloud.
  • Knowledge of data analysis and visualization concepts.

Course Objectives

By the end of this course, you will 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
  • Create paginated reports in Power BI

Course Content

  • Module 1: Get Started with Microsoft Data Analytics
    • Explore the different roles in data
    • Identify the tasks that are performed by a data analyst
    • Describe the Power BI landscape of products and services
    • Use the Power BI service
  • Module 2: Prepare Data in Power BI
    • Identify and retrieve data from different data sources
    • Understand the connection methods and their performance implications
    • Use Microsoft Dataverse
    • Connect to a dataflow
  • Module 3: Clean, Transform & Load Data
    • Apply data shape transformations
    • Enhance the structure of the data
    • Profile and examine the data
  • Module 4: Design a Data Model in Power BI
    • Understand the basics of data modelling
    • Define relationships and their cardinality
    • Implement Dimensions and Hierarchies
    • Create histograms and rankings
  • Module 5: Create Model Calculations Using DAX
    • Understand Data Analysis Expressions
    • Use DAX for simple formulas and expressions
    • Create calculated tables and measures
    • Build simple measures
    • Work with Time Intelligence and Key Performance Indicators
  • Module 6: Optimise Model Performance in Power BI
    • Understand the importance of variables
    • Enhance the data model
    • Optimise the storage model
    • Implement aggregations
  • Module 7: Create Reports in Power BI
    • Design a report page layout
    • Select and add effective visualisations
    • Add basic report functionality
    • Add report navigation and interactions
    • Improve report performance
    • Design for accessibility
  • Module 8: Create Dashboards in Power BI
    • Create a Dashboard
    • Understand real-time Dashboards
    • Enhance Dashboard usability
  • Module 9: Enhance Reports for Usability and Storytelling in Power BI
    • Explain paginated reports
    • Create a paginated report
    • Create and configure a data source and dataset
    • Work with charts and tables
    • Publish a report
  • Module 10: Perform Advanced Analytics in Power BI
    • Explore statistical summary
    • Use the Analyse feature
    • Identify outliers in data
    • Conduct time-series analysis
    • Use the AI visuals
    • Use the Advanced Analytics custom visual
  • Module 11: Manage Datasets in Power BI
    • Create and work with parameters
    • Manage datasets
    • Configure dataset refresh
    • Troubleshoot gateway connectivity
    • Understand the aspects of Power BI security
    • Configure row-level security roles and group memberships
  • Module 12: Create and Manage Workspaces in Power BI
    • Create and manage a workspace
    • Understand workspace collaboration
    • Monitor workspace usage and performance
    • Distribute an App
    • Configure dataset refresh
    • Troubleshoot gateway connectivity
    • Understand the aspects of Power BI security
    • Configure row-level security roles and group memberships

Are you ready to start?

Certified global best practices in the new technologies…

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions