Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

PL-300T00: Microsoft Power BI Data Analyst

If you are someone with existing SQL or SQL Server knowledge (or someone highly versed in different data repositories), this is the Power BI course for you. 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.

Description

Overview

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 non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.

Course Objectives

After completing this course, students will be able to:

  • Learn how Power BI services and applications work together
  • Explore how Power BI can make your business more efficient
  • Learn how to create compelling visuals and reports
  • Get date from external sources
  • Fix performance issues
  • Resolve data import errors
  • Apply data shape transformations to table structures
  • Combine queries
  • Create common date tables
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Design star schemas
  • Describe similarities of, and differences between, a calculated column and a measure
  • Add a date table to your model by using DAX calculations
  • Optimize DirectQuery models with table level storage
  • Design reports
  • Perform analytics
  • Create dashboards
  • Implement row-level security

Who Should Attend

The audience for this course are 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 Outline

Module 1: Discover Data Analytics

  • Overview of data analysis
  • Roles in data
  • Tasks of a data analyst

Module 2: Get Started Building With Power Bi

  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service

Module 3: Get Data In Power Bi

  • Get data from files
  • Get data from relational data sources
  • Create dynamic reports with parameters
  • Get data from a NoSQL database
  • Get data from online services
  • Select a storage mode
  • Get data from Azure Analysis Services
  • Fix performance issues
  • Resolve data import errors

Module 4: Clean, Transform, And Load Data In Power Bi

  • Shape the initial data
  • Simplify the data structure
  • Evaluate and change column data types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code

Module 5: Design A Data Model In Power Bi

  • Work with tables
  • Create a date table
  • Work with dimensions
  • Define data granularity
  • Work with relationships and cardinality
  • Resolve modeling challenges

Module 6: Add Measures To Power Bi Desktop Models

  • Create simple measures
  • Create compound measures
  • Create quick measures
  • Compare calculated columns with measures

Module 7: Add Calculated Tables And Columns To Power Bi Desktop Models

  • Create calculated columns
  • Learn about row context
  • Choose a technique to add a column

Module 8: Use Dax Time Intelligence Functions In Power Bi Desktop Models

  • Use DAX time intelligence functions
  • Additional time intelligence calculations

Module 9: Optimize A Model For Performance In Power Bi

  • Review performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Reduce cardinality
  • Optimize DirectQuery models with table level storage
  • Create and manage aggregations

Module 10: Design Power Bi Reports

  • Design the analytical report layout
  • Design visually appealing reports
  • Report objects
  • Select report visuals
  • Select report visuals to suit the report layout
  • Format and configure visualizations
  • Work with key performance indicators

Module 11: Configure Power Bi Report Filters

  • Apply filters to the report structure
  • Apply filters with slicers
  • Design reports with advanced filtering techniques
  • Consumption-time filtering
  • Select report filter techniques
  • Case study - Configure report filters based on feedback

Module 12: Enhance Power Bi Report Designs For The User Experience

  • Design reports to show details
  • Design reports to highlight values
  • Design reports that behave like apps
  • Work with bookmarks
  • Design reports for navigation
  • Work with visual headers
  • Design reports with built-in assistance
  • Tune report performance
  • Optimize reports for mobile use

Module 13: Perform Analytics In Power Bi

  • Introduction to analytics
  • Explore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Create what-if parameters
  • Use specialized visuals

Module 14: Create And Manage Workspaces In Power Bi

  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection

Module 15: Manage Datasets In Power Bi

  • Use a Power BI gateway to connect to on-premises data sources
  • Configure a dataset scheduled refresh
  • Configure incremental refresh settings
  • Manage and promote datasets
  • Troubleshoot service connectivity
  • Boost performance with query caching (Premium)

Module 16: Create Dashboards In Power Bi

  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Review Quick insights
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Configure data classification
  • Set mobile view

Module 17: Implement Row-Level Security

  • Configure row-level security with the static method
  • Configure row-level security with the dynamic method

Prerequisites

Successful Data 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

You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Administrator before taking this course.

Similar courses

Introduction to DAX for Power BI

Using Data Analysis Expressions to solve common business problems in Power BI

More Information
Microsoft Excel for Office 365: Intermediate

Start down the road to creating advanced workbooks and worksheets to help deepen understanding of organizational intelligence

More Information
Microsoft Excel for Office 365: Advanced

Put the full power of Excel right at your fingertips: collaborate, automate, and use conditional logic to construct and apply elaborate formulas and functions

More Information
Microsoft Excel for Office 365: Beginner

Provides a foundation for Excel knowledge and skills

More Information
Microsoft Outlook for Office 365/2019: Advanced

Builds upon the foundational knowledge presented in the Microsoft Outlook for Office 365/2019: Part 1 course and will help you customize a communication system well-suited to your work style

More Information
Microsoft Access 2019/2021: Intermediate

Expand basic database management skills

More Information
Microsoft Word for Office 365: Intermediate

Tackle more advanced features of Word

More Information
Microsoft Power BI: Data Analysis Practitioner

Analyze business data, visualize insights, and share those insights across the enterprise

More Information
Microsoft Project 2019/2021: Advanced

This course is designed to familiarize you with some of the advanced features and functions of Microsoft Project so you can use it effectively and efficiently in a real-world environment

More Information
Microsoft Project 2019/2021: Beginner

Use Microsoft Project effectively and efficiently in a real-world environment.

More Information
Microsoft Excel for Office 365/2021: Data Analysis with Power Pivot

Gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data

More Information
Microsoft Excel for Office 365/2021: Data Analysis with PivotTables

Use the advanced PivotTable functionality in Excel to analyze your raw data

More Information
Microsoft PowerPoint for Office 365: Advanced

Create presentations that not only stand out from the crowd, but also don't consume all of your available time

More Information
Microsoft PowerPoint for Office 365: Beginner

How do you grab and maintain an audience's focus when you're asked to present important information? By being clear, organized, and engaging. And, that is exactly what Microsoft® PowerPoint® can help you do.

More Information
Microsoft SharePoint for Site Owners (Modern)

SharePoint provides tools to create and manage a corporate intranet, facilitate content sharing and collaboration, and enable users to create, access, store, and track documents and data in a central location

More Information
Tableau Part 2

In this course, you will perform advanced data visualization and data blending with Tableau.

More Information
Microsoft Word for Office 365: Advanced

Includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production.

More Information
Microsoft Word for Office 365: Beginner

You will learn fundamental Word skills

More Information
Microsoft Outlook for Office 365/2019: Beginner

Use Outlook to compose and handle your email communications and to manage your calendar, contacts, and tasks.

More Information
Microsoft Access 2019/2021: Beginner

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

More Information
PL-400T00: Microsoft Power Platform Developer

The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes.

More Information
Formatting Technical Documents

Work with formatting options such as styles and section breaks to automate and troubleshoot document content including table of contents, list of figures, and more.

More Information
Microsoft® Teams® for Business Users

Course Objectives: In this course, you will use Microsoft Teams to communicate and collaborate with your colleagues. You will: Send messages to colleagues using Teams. Call and meet with people in Teams. Lead a meeting. Configure your Teams environment. Share files and app content. Create and configure Teams.

More Information
Microsoft® SharePoint® Modern Experience: Site Basics

Course Objectives: In this course, you will use a typical SharePoint team site to work collaboratively with other team members. You will: Launch a SharePoint site and navigate among the pages and resources provided by the site. Use SharePoint lists to track and view information. Use document libraries to store and organize documents. Find, share, and archive content stored in SharePoint. Author documents as a member of a SharePoint team site.

More Information
Introduction to R for Data Analysis

R is a functional programming environment for business analysts and data scientists. It's a language that many non-programmers can easily work with, naturally extending a skill set that is common to high-end Excel users. It's the perfect tool for when the analyst has a statistical, numerical, or probabilities-based problem based on real data and they've pushed Excel past its limits.

More Information
Introduction to Programming with Python®

This course is designed for people who want to learn the Python programming language in preparation for using Python to develop software for a wide range of applications, such as data science, machine learning, artificial intelligence, and web development.

More Information
Data Wrangling with Python

This course teaches concepts by deep-dive on-hand exercises. Throughout the course, you will learn data wrangling with hands-on exercises and activities. You’ll find checklists, best practices, and critical points mentioned throughout the lessons, making things more interesting.

More Information
Building Data Analytics Solutions using Amazon Redshift

In this course, you will build a data analytics solution using Amazon Redshift, a cloud data warehouse service.

More Information
Data Warehousing on AWS

In this course, you will learn new concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS.

More Information
Building Data Lakes on AWS

In this course, you will apply data lake methodologies in planning and designing a data lake, articulate the components and services required for building an AWS data lake, secure a data lake with appropriate permission, ingest, store, and transform data in a data lake and query, analyze, and visualize data within a data lake.

More Information
Building Batch Data Analytics Solutions on AWS

In this course, you will learn to build batch data analytics solutions using Amazon EMR, an enterprise-grade Apache Spark and Apache Hadoop managed service.

More Information
55315: Introduction to SQL Databases

In this course you will describe key database concepts in the context of SQL Server, characterize database languages used in SQL Server, describe data modeling techniques, discuss normalization and denormalization techniques, distinguish relationship types and effects in database design, describe the effects of database design on performance, and define commonly used database objects.

More Information
55366: Querying Data with Transact-SQL

In this course, you will create single table SELECT queries, create multiple table SELECT queries, insert, update, and delete data, query data using built-in functions, create queries that aggregate data, create subqueries, create queries that use table expressions, use UNION, INTERSECT, and EXCEPT on multiple sets of data, implement window functions in queries, use PIVOT and GROUPING SETS in queries, use stored procedures in queries, add error handling to queries, and use transactions in queries.

More Information
55321: SQL Server Integration Services

In this course you will, create sophisticated SSIS packages for extracting, transforming, and loading data, use containers to efficiently control repetitive tasks and transactions, configure packages to dynamically adapt to environment changes, use Data Quality Services to cleanse data, successfully troubleshoot packages, create and manage the SSIS Catalog, deploy, configure, and schedule packages, secure the SSIS Catalog.

More Information
R Programming for Data Science (v1.0)

This course will teach you the fundamentals of programming in R to get you started. It will also teach you how to use R to perform common data science tasks and achieve data-driven results for the business.

More Information
55316: Administering a SQL Database

In this course you will authenticate and authorize users, assign server and database roles, authorize users to access resources, use encryption and auditing features to protect data, describe recovery models and backup strategies, backup and restore SQL Server databases, automate database management, configure security for the SQL Server agent, manage alerts and notifications, managing SQL Server using PowerShell, trace access to SQL Server, monitor a SQL Server infrastructure, and import and export data.

More Information
Building Modern Data Analytics Solutions on AWS

In this course, you will learn how to leverage AWS data Services to store, process, analyze, stream, and query data to make decisions with speed and agility at scale, how to modernize data solutions end to end, and obtain skills to put your data to work to make better, more informed decisions, respond faster to the unexpected, and uncover new opportunities.

More Information
DP-300T00: Administering Microsoft Azure SQL Solutions

This course provides students with the knowledge and skills to administer a SQL Server database infrastructure for cloud, on-premises and hybrid relational databases and who work with the Microsoft PaaS relational database offerings. Additionally, it will be of use to individuals who develop applications that deliver content from SQL-based relational databases.

More Information
Getting the Most from Your Spreadsheets with GenAI

In this course, you will use generative AI to assist you as you work with spreadsheets.

More Information
Programming and Data Wrangling with VBA and Excel

In this course, you will develop and deploy VBA modules to solve business problems.

More Information
Microsoft Office 365 Online (with Teams for the Desktop)

This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint®, and Excel®—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps including Yammer™, Planner, and Delve® that can be used in combination by teams for communication and collaboration.

More Information
Hands-on Practical Python for Data Wrangling & Transformation

This introductory and beyond level course is for technical users newer to Python who want to learn advanced data handling and transformation skills, using the latest tools and techniques. The course is approximately 50% hands-on to 50% lecture ratio, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Student machines are required.

More Information
CompTIA Data+ Certification (Exam DA0-001)

CompTIA Data+ is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making that gives learners the confidence to bring data analysis to life.

More Information
SQL Querying: Fundamentals

In this course, you will compose SQL queries to retrieve desired information from a database.

More Information
SQL Querying: Advanced

In this course, you will work with advanced queries to manipulate and index tables. You will also create transactions so that you can choose to save or cancel the data entry process.

More Information
Introduction to SQL Databases 10985WV (55356)

This 2-day entry-level course examines the services and features of Microsoft SQL 2022. (This is NOT a SQL querying course, SQL Querying syntax will not be discussed). The content focuses on database tables, adding and changing data, creating and using stored procedures, entity relationships, and indexes.

More Information
Data Analysis Fundamentals

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information
Using Data Science Tools in Python

In this course, you will use various Python tools to load, analyze, manipulate, and visualize business data.

More Information
Getting the Most from Your Documents with GenAI

In this course, you will use generative AI tools to help you develop text and images that you can use in your word processor or desktop publishing application.

More Information
Crystal Reports 2020: Part 2

In this course, students will create complex reports & data sources using the tools in Crystal Reports 2020. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency.

More Information
Crystal Reports 2020: Part 1

In this course, students will create a basic report by connecting to a database and modifying the report's presentation.

More Information

Press enter to see more results