Alliance Micro Solutions provides certified and advanced degree computer instructors and consultants

Module 1: Explore Azure data services for modern analytics

• Describe the Azure data ecosystem for analytics

Module 2: Understand concepts of data analytics

• Describe types of data analytics
• Understand the data analytics process

Module 3: Explore data analytics at scale

• Explore data job roles in analytics
• Understand tools for scaling analytics solutions

Module 4: Introduction to Microsoft Purview

• Evaluate whether Microsoft Purview is appropriate for data discovery and governance needs.
• Describe how the features of Microsoft Purview work to provide data discovery and governance.

Module 5: Discover trusted data using Microsoft Purview

• Browse, search, and manage data catalog assets.
• Use data catalog assets with Power BI.
• Use Microsoft Purview in Azure Synapse

Module 6: Catalog data artifacts by using Microsoft Purview

• Describe asset classification in Microsoft Purview.

Module 7: Manage Power BI assets by using Microsoft Purview

• Register and scan a Power BI tenant.
• Use the search and browse functions to find data assets.
• Describe the schema details and data lineage tracing of Power BI data assets.

Module 8: Integrate Microsoft Purview and Azure Synapse Analytics

• Catalog Azure Synapse Analytics database assets in Microsoft Purview.
• Configure Microsoft Purview integration in Azure Synapse Analytics.
• Search the Microsoft Purview catalog from Synapse Studio.
• Track data lineage in Azure Synapse Analytics pipelines activities.

Module 9: Introduction to Azure Synapse Analytics

• Identify the business problems that Azure Synapse Analytics addresses.
• Describe core capabilities of Azure Synapse Analytics.
• Determine when to use Azure Synapse Analytics.

Module 10: Use Azure Synapse serverless SQL pool to query files in a data lake

• Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
• Query CSV, JSON, and Parquet files using a serverless SQL pool
• Create external database objects in a serverless SQL pool

Module 11: Analyze data with Apache Spark in Azure Synapse Analytics

• Identify core features and capabilities of Apache Spark.
• Configure a Spark pool in Azure Synapse Analytics.
• Run code to load, analyze, and visualize data in a Spark notebook.

Module 12: Analyze data in a relational data warehouse

• Design a schema for a relational data warehouse.
• Create fact, dimension, and staging tables.
• Use SQL to load data into data warehouse tables.
• Use SQL to query relational data warehouse tables.

Module 13: 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 14: Understand scalability in Power BI

• Describe the importance of building scalable data models
• Implement Power BI data modeling best practices
• Use the Power BI large dataset storage format

Module 15: Create and manage scalable Power BI dataflows

• Describe Power BI dataflows and use cases.
• Describe best practices for implementing Power BI dataflows.
• Create and consume Power BI dataflows.

Module 16: Create Power BI model relationships

• Understand how model relationship work.
• Set up relationships.
• Use DAX relationship functions.
• Understand relationship evaluation.

Module 17: Use DAX time intelligence functions in Power BI Desktop models

• Define time intelligence.
• Use common DAX time intelligence functions.
• Create useful intelligence calculations.

Module 18: Create calculation groups

• Explore how calculation groups work.
• Maintain calculation groups in a model.
• Use calculation groups in a Power BI report.

Module 19: Enforce Power BI model security

• Restrict access to Power BI model data with RLS.
• Restrict access to Power BI model objects with OLS.
• Apply good development practices to enforce Power BI model security.

Module 20: Use tools to optimize Power BI performance

• Optimize queries using performance analyzer.
• Troubleshoot DAX performance using DAX Studio.
• Optimize a data model using Tabular Editor.

Module 21: Understand advanced data visualization concepts

• Create and import a custom report theme.
• Create custom visuals with R or Python.
• Enable personalized visuals in a report.
• Review report performance using Performance Analyzer.
• Design and configure Power BI reports for accessibility.

Module 22: Monitor data in real-time with Power BI

• Describe Power BI real-time analytics.
• Set up automatic page refresh.
• Create real-time dashboards.
• Set up auto-refresh paginated reports.

Module 23: Create paginated reports

• Get data.
• Create a paginated report.
• Work with charts and tables on the report.
• Publish the report.

Module 24: Provide governance in a Power BI environment

• Define the key components of an effective BI governance model
• Describe the key elements associated with data governance
• Configure, deploy, and manage elements of a BI governance strategy
• Set up BI help and support settings

Module 25 : Monitor and audit usage

• Discover what usage metrics are available through the Power BI admin portal
• Optimize use of usage metrics for dashboards and reports
• Distinguish between audit logs and the activity logs

Module 26 : Broaden the reach of Power BI

• Describe the various embedding scenarios that allow you to broaden the reach of Power BI
• Understand the options for developers to customize Power BI solutions
• Learn to provision and optimize Power BI embedded capacity and create and deploy dataflows
• Build custom Power BI solutions template apps

Module 27 : Build reports using Power BI within Azure Synapse Analytics

• Describe the Power BI and Synapse workspace integration
• Understand Power BI data sources
• Describe optimization options
• Visualize data with serverless SQL pools

Module 28 : Design a Power BI application lifecycle management strategy

• Outline the application lifecycle process.
• Choose a source control strategy.
• Design a deployment strategy.

Module 29 : Create and manage a Power BI deployment pipeline

• Articulate the benefits of deployment pipelines
• Create a deployment pipeline using Premium workspaces
• Assign and deploy content to pipeline stages
• Describe the purpose of deployment rules
• Deploy content from one pipeline stage to another

Module 30 : Create and manage Power BI assets

• Create specialized datasets.
• Create live and DirectQuery connections.
• Use Power BI service lineage view.
• Use XMLA endpoint to connect datasets.

Module 1: Explore Azure data services for modern analytics

• Describe the Azure data ecosystem for analytics

Module 2: Understand concepts of data analytics

• Describe types of data analytics
• Understand the data analytics process

Module 3: Explore data analytics at scale

• Explore data job roles in analytics
• Understand tools for scaling analytics solutions

Module 4: Introduction to Microsoft Purview

• Evaluate whether Microsoft Purview is appropriate for data discovery and governance needs.
• Describe how the features of Microsoft Purview work to provide data discovery and governance.

Module 5: Discover trusted data using Microsoft Purview

• Browse, search, and manage data catalog assets.
• Use data catalog assets with Power BI.
• Use Microsoft Purview in Azure Synapse

Module 6: Catalog data artifacts by using Microsoft Purview

• Describe asset classification in Microsoft Purview.

Module 7: Manage Power BI assets by using Microsoft Purview

• Register and scan a Power BI tenant.
• Use the search and browse functions to find data assets.
• Describe the schema details and data lineage tracing of Power BI data assets.

Module 8: Integrate Microsoft Purview and Azure Synapse Analytics

• Catalog Azure Synapse Analytics database assets in Microsoft Purview.
• Configure Microsoft Purview integration in Azure Synapse Analytics.
• Search the Microsoft Purview catalog from Synapse Studio.
• Track data lineage in Azure Synapse Analytics pipelines activities.

Module 9: Introduction to Azure Synapse Analytics

• Identify the business problems that Azure Synapse Analytics addresses.
• Describe core capabilities of Azure Synapse Analytics.
• Determine when to use Azure Synapse Analytics.

Module 10: Use Azure Synapse serverless SQL pool to query files in a data lake

• Identify capabilities and use cases for serverless SQL pools in Azure Synapse Analytics
• Query CSV, JSON, and Parquet files using a serverless SQL pool
• Create external database objects in a serverless SQL pool

Module 11: Analyze data with Apache Spark in Azure Synapse Analytics

• Identify core features and capabilities of Apache Spark.
• Configure a Spark pool in Azure Synapse Analytics.
• Run code to load, analyze, and visualize data in a Spark notebook.

Module 12: Analyze data in a relational data warehouse

• Design a schema for a relational data warehouse.
• Create fact, dimension, and staging tables.
• Use SQL to load data into data warehouse tables.
• Use SQL to query relational data warehouse tables.

Module 13: 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 14: Understand scalability in Power BI

• Describe the importance of building scalable data models
• Implement Power BI data modeling best practices
• Use the Power BI large dataset storage format

Module 15: Create and manage scalable Power BI dataflows

• Describe Power BI dataflows and use cases.
• Describe best practices for implementing Power BI dataflows.
• Create and consume Power BI dataflows.

Module 16: Create Power BI model relationships

• Understand how model relationship work.
• Set up relationships.
• Use DAX relationship functions.
• Understand relationship evaluation.

Module 17: Use DAX time intelligence functions in Power BI Desktop models

• Define time intelligence.
• Use common DAX time intelligence functions.
• Create useful intelligence calculations.

Module 18: Create calculation groups

• Explore how calculation groups work.
• Maintain calculation groups in a model.
• Use calculation groups in a Power BI report.

Module 19: Enforce Power BI model security

• Restrict access to Power BI model data with RLS.
• Restrict access to Power BI model objects with OLS.
• Apply good development practices to enforce Power BI model security.

Module 20: Use tools to optimize Power BI performance

• Optimize queries using performance analyzer.
• Troubleshoot DAX performance using DAX Studio.
• Optimize a data model using Tabular Editor.

Module 21: Understand advanced data visualization concepts

• Create and import a custom report theme.
• Create custom visuals with R or Python.
• Enable personalized visuals in a report.
• Review report performance using Performance Analyzer.
• Design and configure Power BI reports for accessibility.

Module 22: Monitor data in real-time with Power BI

• Describe Power BI real-time analytics.
• Set up automatic page refresh.
• Create real-time dashboards.
• Set up auto-refresh paginated reports.

Module 23: Create paginated reports

• Get data.
• Create a paginated report.
• Work with charts and tables on the report.
• Publish the report.

Module 24: Provide governance in a Power BI environment

• Define the key components of an effective BI governance model
• Describe the key elements associated with data governance
• Configure, deploy, and manage elements of a BI governance strategy
• Set up BI help and support settings

Module 25 : Monitor and audit usage

• Discover what usage metrics are available through the Power BI admin portal
• Optimize use of usage metrics for dashboards and reports
• Distinguish between audit logs and the activity logs

Module 26 : Broaden the reach of Power BI

• Describe the various embedding scenarios that allow you to broaden the reach of Power BI
• Understand the options for developers to customize Power BI solutions
• Learn to provision and optimize Power BI embedded capacity and create and deploy dataflows
• Build custom Power BI solutions template apps

Module 27 : Build reports using Power BI within Azure Synapse Analytics

• Describe the Power BI and Synapse workspace integration
• Understand Power BI data sources
• Describe optimization options
• Visualize data with serverless SQL pools

Module 28 : Design a Power BI application lifecycle management strategy

• Outline the application lifecycle process.
• Choose a source control strategy.
• Design a deployment strategy.

Module 29 : Create and manage a Power BI deployment pipeline

• Articulate the benefits of deployment pipelines
• Create a deployment pipeline using Premium workspaces
• Assign and deploy content to pipeline stages
• Describe the purpose of deployment rules
• Deploy content from one pipeline stage to another

Module 30 : Create and manage Power BI assets

• Create specialized datasets.
• Create live and DirectQuery connections.
• Use Power BI service lineage view.
• Use XMLA endpoint to connect datasets.