Design and manage analytics solutions using Power BI

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.

AUDIENCE PROFILE

The audience for this course is data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted at those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.

Phone	Phone
Product	Microsoft
Code	PL-300T00(T)
Duration	3 Days
Price (baht)	12,000

About the course

COURSE OUTLINE

Module 1: Get Started with Microsoft Data Analytics

Explore the role of a data analyst and how Power BI tools transform data into impactful reports and dashboards that support trusted, data-driven decisions across the business.

Discover data analysis
- Learn about the roles in data.
- Learn about the tasks of a data analyst.
Get started building with Power BI
- How Power BI services and applications work together.
- Explore how Power BI can make your business more efficient.
- How to create compelling visuals and reports.
Introduction to end-to-end analytics using Microsoft Fabric
- Identify the capabilities of Microsoft Fabric.
- Implement Microsoft Fabric to meet your enterprise’s analytics needs.
Get started with Copilot in Power BI
- Use Copilot in Power BI during report development.
- Prepare semantic models for use with AI.
- Interact with data using natural language in Copilot Chat.

MODULE 02 Prepare data for analysis with Power BI

You’ll learn how to use Power Query to extract data from different data sources, choose a storage mode, and connectivity type. You’ll also learn to profile, clean, and load data into Power BI before you model your data.

Get data in Power BI
- Identify and connect to a data source
- Get data from a relational database, like Microsoft SQL Server
- Get data from a file, like Microsoft Excel
- Get data from applications
- Get data from Azure Analysis Services
- Select a storage mode
- Fix performance issues
- Resolve data import errors
Clean, transform, and load data in Power BI
- Resolve inconsistencies, unexpected or null values, and data quality issues.
- Apply user-friendly value replacements.
- Profile data so you can learn more about a specific column before using it.
- Evaluate and transform column data types.
- Apply data shape transformations to table structures.
- Combine queries.
- Apply user-friendly naming conventions to columns and queries.
- Edit M code in the Advanced Editor.
Choose a Power BI model framework
- Describe Power BI model fundamentals.
- Determine when to develop an import model.
- Determine when to develop a DirectQuery model.
- Determine when to develop a composite model.
- Choose an appropriate Power BI model framework.

MODULE 03 Model data with Power BI

Data modeling configures and shapes your prepared data to design a semantic model with the necessary relationships and calculations using Data Analysis Expressions (DAX). This process ensures accurate analysis and sets you up to create clear, impactful Power BI reports.

Configure a semantic model
- Set modeling options.
- Create and configure relationships.
- Configure table and column properties.
- Create hierarchies.
- Create quick measures.
- Create numeric range and field parameters.
Write DAX formulas for semantic models
- Describe the different DAX calculation types.
- Write DAX formulas.
- Describe DAX data types.
- Work with DAX functions.
Create DAX calculations in semantic models
- Create calculated tables.
- Create calculated columns.
- Create measures using DAX.
Use DAX time intelligence functions in semantic models
- Define time intelligence.
- Use common DAX time intelligence functions.
- Create useful intelligence calculations.
Create visual calculations in Power BI Desktop
- Understand visual calculations and how they differ from measures.
- Create visual calculations in Power BI Desktop.
- Use parameters in visual calculations.
Optimize a model for performance in Power BI
- Review the performance of measures, relationships, and visuals.
- Use variables to improve performance and troubleshooting.
- Improve performance by reducing cardinality levels.
- Optimize DirectQuery models with table level storage.
- Create and manage aggregations.

MODULE 04 Design effective reports in Power BI

Use data visualization and storytelling techniques to create insightful, dynamic Power BI reports that engage users, highlight key findings, and help inform decisions based on data.

Scope report design requirements
- Determine business goals.
- Identify your audience.
- Determine report types.
- Define user interface requirements.
- Define user experience requirements.
Design Power BI reports
- Report structure.
- Report objects.
- Different visualization types.
Enhance Power BI report designs for the user experience
- Design reports that present details and highlight key values.
- Build interactive reports with intuitive navigation and app-like experiences.
- Enhance user experience using bookmarks, visual headers, and built-in assistance.
- Incorporate specialized visuals to meet unique reporting needs.
Perform analytics in Power BI
- Create a 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.
- Use custom visuals for advanced analytics.
- Review Quick insights.
- Apply AI Insights.

MODULE 05 Manage and secure Power BI

Ensure content is accessible and distributed effectively in Power BI to foster collaboration and informed decision-making. Protect sensitive information with robust security, building trust across your organization.

Scope report design requirementsManage workspaces in Power BI serviceDetermine business goals.
- Describe the Power BI service and its building blocks.
- Create workspaces, assign license modes, and manage access.
- Publish reports to the Power BI service.

Manage semantic models in Power BI
- Manage data source connectivity and gateways.
- Configure semantic model refresh settings.
- Endorse semantic models.
- Analyze data dependencies.
- Configure query caching with Fabric or Premium capacities.
Choose a content distribution method
- Understand the different content distribution methods available in Power BI
- Create a Power BI app
- Apply data governance principles
- Track a report or dashboard
Create dashboards in Power BI
- Create a dashboard.
- Configure data alerts.
- Ask questions using Q&A.
- Review Quick insights
- Add a theme to the visuals in your dashboard.
- Pin a live report page to a dashboard.
- Set a mobile view.

Secure data access in Power BI
- Configure row-level security by using a static method.
- Configure row-level security by using a dynamic method.
- Use single sign-on (SSO) for DirectQuery sources
- Restrict access to Power BI model objects with object-level security.

Register for Training

Schedule

Start Date	End Date	Duration (days)	Price	Code