Training PL-300T00: Microsoft Power BI Data Analyst

Training Overview

This training covers the various methods & best practices that are in line with business & technical requirements for modeling, visualizing, & analyzing data with Power BI. The training will show how to access & process data from the range of data sources, including both relational & non-relational sources. Finally, this training will also discuss how to manage & deploy reports & dashboards for sharing & content distribution.

Duration: 3 Days

 

Prerequisites

A successful data analysts start this role with experience working with data in the Cloud.

Specifically:

  • Understanding core data concepts.
  • Understanding of working with relational data in the Cloud.
  • Understanding of working with non-relational data in the Cloud.
  • Understanding of data analysis & visualization concepts.

Audience Profile

The audience for this training is data professionals & business intelligence professionals who want to understand how to accurately perform data analysis using Power BI. The training is also targeted toward those who develop reports that visualize data from the data platform technology that exists both in the Cloud & on-premises.

 

Content Outline

Discover data analysis

  • Learning about the roles in data.
  • Learning about the tasks of a data analyst.

Get data in Power BI

  • Identifying & connecting to a data source
  • Getting data from a relational database, like Microsoft SQL Server
  • Getting data from a file like Microsoft Excel
  • Getting data from applications
  • Getting data from Azure Analysis Services
  • Select a storage mode
  • Fix performance issues
  • Resolve data import errors

Clean, transform, & load data in Power BI

  • Resolve inconsistencies, unexpected or null values, & data quality issues.
  • Applying user-friendly value replacements.
  • Profiling data so you can learn more about a specific column before using it.
  • Evaluating & transform column data types.
  • Apply data shape transformations to table structures.
  • Combine queries.
  • Apply user-friendly naming conventions to columns & queries.
  • Edit M code in the Advanced Editor.

Design a data model in Power BI

  • Create common data tables
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Design star schemas

Introduction to creating measures using DAX in Power BI

  • Build quick measures.
  • Create calculated columns.
  • Use DAX to build measures.
  • Discover how context affects DAX measures.
  • Use the CALCULATE function to manipulate filters.
  • Implement time intelligence by using DAX.

Optimize a model for performance in Power BI 

  • Review the performance of measures, relationships, & visuals.
  • Use variables to improve performance & troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table-level storage.
  • Create & manage aggregations.

Work with Power BI visuals

  • Add visualization items to reports.
  • Choose an effective visualization.
  • Format & configure visualizations.
  • Import a custom visual.
  • Add an R or Python visual.

Create a data-driven story with Power BI reports

  • Design a report layout.
  • Add buttons, bookmarks, & selections.
  • Design report navigation.
  • Use basic interactions.
  • Use advanced interactions & drill-through.
  • Configure conditional formatting.
  • Apply slicing, filtering, & sorting.
  • Publish & export reports.
  • Comment on reports.
  • Use a Performance analyzer to tune reports.
  • Optimize reports for mobile use.

Create dashboards in Power BI

  • Setting a mobile view.
  • Adding a theme to the visuals in your dashboard.
  • Configure data classification.
  • Add real-time dataset visuals to your dashboards.
  • Pin a live report page to a dashboard.

Perform analytics in Power BI 

  • Explore statistical summary.
  • Identify outliers with Power BI visuals.
  • Group & bin data for analysis.
  • Apply clustering techniques.
  • Conduct time series analysis.
  • Use the Analyze feature.
  • Use advanced analytics custom visuals.
  • Review Quick insights.
  • Apply AI Insights.

Work with AI visuals in Power BI

  • Use the Q&A visual.
  • Find important factors with the Key influencers visual.
  • Use the Decomposition Tree visual to break down a measure.

Create & manage workspaces in Power BI 

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

Manage datasets in Power BI 

  • Creating dynamic reports with parameters.
  • Creating what-if parameters.
  • Using a Power BI gateway to connect to on-premises data sources.
  • Configuring a scheduled refresh for a dataset.
  • Configure incremental refresh settings.
  • Manage & promote datasets.
  • Troubleshoot service connectivity.
  • Boost performance with query caching (Premium).

Implement row-level security

  • Configuring row-level security by using a static method.
  • Configuring row-level security by using a dynamic method.

 

  • Learning about the roles in data.
  • Learning about the tasks of a data analyst
  • Identifying & connecting to a data source
  • Getting data from a relational database, like Microsoft SQL Server
  • Getting data from a file like Microsoft Excel
  • Getting data from applications
  • Getting data from Azure Analysis Services
  • Select a storage mode
  • Fix performance issues
  • Resolve data import errors
  • Resolve inconsistencies, unexpected or null values, & data quality issues.
  • Applying user-friendly value replacements.
  • Profiling data so you can learn more about a specific column before using it.
  • Evaluating & transform column data types.
  • Apply data shape transformations to table structures.
  • Combine queries.
  • Apply user-friendly naming conventions to columns & queries.
  • Edit M code in the Advanced Editor.
  • Create common data tables
  • Configure many-to-many relationships
  • Resolve circular relationships
  • Design star schemas
  • Build quick measures.
  • Create calculated columns.
  • Use DAX to build measures.
  • Discover how context affects DAX measures.
  • Use the CALCULATE function to manipulate filters.
  • Implement time intelligence by using DAX.
  • Review the performance of measures, relationships, & visuals.
  • Use variables to improve performance & troubleshooting.
  • Improve performance by reducing cardinality levels.
  • Optimize DirectQuery models with table-level storage.
  • Create & manage aggregations.
  • Add visualization items to reports.
  • Choose an effective visualization.
  • Format & configure visualizations.
  • Import a custom visual.
  • Add an R or Python visual.
  • Design a report layout.
  • Add buttons, bookmarks, & selections.
  • Design report navigation.
  • Use basic interactions.
  • Use advanced interactions & drill-through.
  • Configure conditional formatting.
  • Apply slicing, filtering, & sorting.
  • Publish & export reports.
  • Comment on reports.
  • Use a Performance analyzer to tune reports.
  • Optimize reports for mobile use.
  • Setting a mobile view.
  • Adding a theme to the visuals in your dashboard.
  • Configure data classification.
  • Add real-time dataset visuals to your dashboards.
  • Pin a live report page to a dashboard.
  • Explore statistical summary.
  • Identify outliers with Power BI visuals.
  • Group & bin data for analysis.
  • Apply clustering techniques.
  • Conduct time series analysis.
  • Use the Analyze feature.
  • Use advanced analytics custom visuals.
  • Review Quick insights.
  • Apply AI Insights.
  • Use the Q&A visual.
  • Find important factors with the Key influencers visual.
  • Use the Decomposition Tree visual to break down a measure.
  • Distribute a report or dashboard.
  • Monitor usage & performance.
  • Recommend a development life cycle strategy.
  • Troubleshoot data by viewing its lineage.
  • Configure data protection.
  • Creating dynamic reports with parameters.
  • Creating what-if parameters.
  • Using a Power BI gateway to connect to on-premises data sources.
  • Configuring a scheduled refresh for a dataset.
  • Configure incremental refresh settings.
  • Manage & promote datasets.
  • Troubleshoot service connectivity.
  • Boost performance with query caching (Premium).
  • Configuring row-level security by using a static method.
  • Configuring row-level security by using a dynamic method.

Certification

 

The Power BI data analyst delivers actionable insights by leveraging available data & applying domain expertise. The Power BI data analyst collaborates with key stakeholders across verticals to identify business requirements, cleans & transforms the data, & then designs & 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, & deploys & configures solutions for consumption. Professionals for this exam should be proficient in using Power Query & writing expressions by using DAX.

Skills measured

  • Prepare the data (15-20%)
  • Model the data (30-35%)
  • Visualize & analyze the data (30-35%)
  • Deploy & maintain assets (10-15%)


Required exams: Exam PL-300: Microsoft Power BI Data Analyst

FAQs

Microsoft Power BI is a business intelligence platform that generally provides nontechnical business users with various tools for aggregating, analyzing, visualizing & sharing data. Users can easily download an application for Windows 10, which is generally called Power BI Desktop, & native mobile apps for Windows, Android & iOS devices.

 

To download Power BI Desktop, go to the Power BI Desktop download page & select Download Free. Also, for download options, select See download or language options. Users may also Download Power BI Desktop from the Power BI service. Select the Download icon in the top menu bar & after that, select Power BI Desktop.

 Power BI is a powerful tool where even beginners can create useful dashboards & insights. This means that many, for many Power BI users, the investment is simply not worth it.

The demand for BI (Business Intelligence) & Decision Making will not dip in the near future. Definitely, no other BI tool is going to overcome Power BI’s dominance in the next ten years. Also, Power BI is simple to use as well as it is excellent for data visualization. Moreover, the product is a Microsoft product.

To attend the training session, you should have operational Desktops or Laptops with the required specification, along with a good internet connection to access the labs. 

We would always recommend you attend the live session to practice & clarify the doubts instantly & get more value from your investment. However, if, due to some contingency, you have to skip the class, Radiant Techlearning will help you with the recorded session of that particular day. However, those recorded sessions are not meant only for personal consumption & NOT for distribution or any commercial use.

 

 

 Radiant Techlearning has a data center containing the Virtual Training environment for the purpose of participant hand-on-practice. 

Participants can easily access these labs over Cloud with the help of a remote desktop connection. 

Radiant virtual labs provide you the flexibility to learn from anywhere in the world & in any time zone. 

 

The learners will be enthralled as we engage them the real-world & industry Oriented projects during the training program. These projects will improve your skills & knowledge & you will gain a better experience. These real-time projects will help you a lot in your future tasks & assignments.

 

Send a Message.


  • Enroll