PL-300: Microsoft Power BI Data Analyst Associate

$1,750.00

  • Duration: 3 Days
  • Mode of Delivery: Online -Instructor-led training
  • Job role: Data Analyst, Business User
  • Preparation for exam: PL-300
  • Cost: $1,750

The Power BI data analyst delivers actionable insights by leveraging available data and applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans and transforms the data, and then designs and builds data models by using Power BI. The Power BI data analyst provides meaningful business value through easy-to-comprehend data visualizations, enables others to perform self-service analytics, and deploys and configures solutions for consumption. Candidates for this exam should be proficient using Power Query and writing expressions by using DAX.

20 in stock (can be backordered)

Audience

This course is intended for a broad range of candidate backgrounds. It is suitable for data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. It is also suitable for candidates who develop reports that visualize data from the data platform technologies that exist on both on-premises and in the cloud.

Prerequisites

There are no prerequisites for taking this course, although experience working with data in Microsoft Excel and/or a basic understanding of databases and relational modeling is beneficial.

Skills Gained

After completing this course, students will be able to:
• Identify and retrieve data from data sources and understand the different connection methods.
• Optimize query performance.
• Profile and examine the data and apply data shape transformations.
• Develop a scalable and performance data model.
• Enhance the data model with DAX using measures, calculated columns and tables.
• Use variables and aggregations to optimize model performance.
• Design and create reports and dashboards.
• Select and add appropriate visualizations.
• Create paginated reports.
• Perform Advanced Analytics.
• Create and manage workspaces.
• Manage datasets and dataset refresh
• Apply row-level security

Course outline

Module 1: Get Started with Microsoft Data Analytics
This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.
Module Objectives:
At the end of this module, the students will be able to:
• Identify the different roles in the data space
• Identify the tasks that are performed by a Data Analyst
• Describe the Power BI landscape of products and services
• Tour the Power BI Service
Module 2: Prepare Data in Power BI
This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity and data storage, and understand the difference and performance implications
of importing or connecting directly to data.
Module Objectives:
At the end of this module, the students will be able to:
• Identify and retrieve data from different data sources
• Understand the different connection methods and their performance implications
• Optimize query performance
• Resolve data import errors
Module 3: Clean, Transform, and Load Data in Power BI
This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.
Module Objectives:
At the end of this module, the students will be able to:
• Apply data shape transformations
• Enhance the data structure
• Profile and examine the data
Module 4: Design a Data Model in Power BI
This module teaches you the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modeling issues, including relationships, security, and performance.
Module Objectives:
At the end of this module, the students will be able to:
• Understand the basics of data modeling
• Define relationships and their cardinality
• Implement Dimensions and hierarchies
• Create histograms and rankings
Module 5: Creating Model Calculations using DAX in Pow er BI
This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.
Module Objectives:
At the end of this module, the students will be able to:
• Understand DAX
• Use DAX for simple formulas and expressions.
• Create calculated tables and columns
• Build simple measures
• Work with Time Intelligence and Key Performance Indicators
Module 6: Optimizing Model Performance
In this module you are introduced to the steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.
Module Objectives:
At the end of this module, the students will be able to:
• Understand the importance of variables
• Enhance the data model
• Optimize storage
Module 7: Creating Reports
This module introduces you to the fundamental concepts and principles of designing and building a
report, including selecting the correct visuals, designing a page layout, and applying basic but critical
functionality This important topic of designing for accessibility is also covered.
Module Objectives:
At the end of this module, the students will be able to:
• Design a page layout
• Select and add appropriate visualization type
• Add basic report functionality
• Add basic report navigation and interactions
• Improve report performance
Module 8: Creating Dashboards
In this module you will learn about dashboards, and how to tell a compelling story through the use of dashboards. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.
Module Objectives:
At the end of this module, the students will be able to:
• Create a dashboard
• Understand real-time dashboards
• Enhance the dashboard usability
Module 9: Identify Patterns and Trends
This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.
Module Objectives:
At the end of this module, the students will be able to:
• Explore statistical summary
• Use the Analyze feature
• Identify outliers in the data
• Use the AI visuals
• Use the Advanced Analytics custom visual
Module 10: Create and Manage Workspaces
This module will introduce you to Workspaces, including how to create them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.
Module Objectives:
At the end of this module, the students will be able to:
• Create and manage a workspace
• Understand workspace collaboration
• Monitor usage and performance
• Distribute an App
Module 11: Manage Files and Datasets in Power BI
In this module you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.
Module Objectives:
At the end of this module, the students will be able to:
• Configure dataset refresh
• Create and work with parameters
• Manage datasets
• Troubleshoot gateway connectivity
Module 12: Row-level Security
This module teaches you the steps for implementing and configuring security in Power BI to secure
Power BI assets.
Module Objectives:
At the end of this module, the students will be able to:
• Understand aspects of Power BI security
• Configure static and dynamic row-level

Schedule

Click on the following link to see the current Course Schedule
Our minimum class-size is 3 for this course.
If there are no scheduled dates for this course, it can be customized to suit the time and skill needs of clients and it can be held online, at a rented location or at your premises.
Click on the following link below to arrange for a custom course: Enquire about a course date

Product Information

Power Platform is comprised of four key products: Power Apps, Power Automate, and Power BI and Power Virtual Agents.

Power Apps
Power Apps provides a rapid low code development environment for building custom apps for business needs. It has services, connectors, and a scalable data service and app platform (Common Data Service) to allow simple integration and interaction with existing data. Power Apps enables the creation of web and mobile applications that run on all devices.
People use apps for every area of their lives, and business should be no exception. Most out-of-the-box solutions do not meet exact business needs or integrate well with other business programs. Power Apps ease users into app development with a simple interface so that every business user or pro developer can build custom apps.

Power Automate
Power Automate lets users create automated workflows between applications and services. It helps automate repetitive business processes such as communication, data collections, and decision approvals. Don’t waste important productive hours on drafting the same email for a weekly update or walking approvals through. Not only for the individual user, Power Automate allows for the creation of enterprise-grade process automation. Power Automate simple interface allows every level of user to automate work tasks from beginners to seasoned developers.

Power BI
Power BI (Business Intelligence) is a business analytics service that delivers insights for analyzing data. It can share those insights through data visualizations which make up reports and dashboards to enable fast, informed decisions. Power BI scales across an organization, and it has built-in governance and security allowing businesses to focus on using data more than managing it.
You can consider Power BI as the analysis and insights leg of the Power Platform. It takes business data and allows you to display it in ways that make the most sense to users. A Power BI dashboard could potentially replace a standing meeting to report on company metrics such as sales data, progress against goals, or employee performance.

Power Virtual Agents
Power Virtual Agents enables anyone to create powerful chatbots using a guided, no-code graphical interface, without the need for data scientists or developers. Power virtual agents address many of the major issues with chatbot building. It eliminates the gap between subject matter experts and the development teams building the chatbots. It removes the complexity of exposing teams to the nuances of conversational AI and the need to write complex code. It minimizes the IT effort required to deploy and maintain a custom conversational solution by empowering subject matter experts to build and maintain their own conversational solutions.

Additional Information and FAQs

CERTFICATE OF COMPLETION: Participants will receive a certificate of completion at the end of a course. This is not an official certification for the product and/or software. Our courses do indicate the appropriate certification exam(s) that the participant can sit. Data Vision Systems does not provide certification or deliver the certification exams. Participants are responsible for arranging and paying for the certification exams on the appropriate certification body.

CANCELLATION POLICY: There is never a fee for cancelling seven business days before a class for any reason. Data Vision Systems reserves the right to cancel any course due to insufficient registration or other extenuating circumstances. Participants will be advised prior to doing so.

Reviews

There are no reviews yet.

Be the first to review “PL-300: Microsoft Power BI Data Analyst Associate”

Your email address will not be published. Required fields are marked *