- Duration: 10 weeks
1. Explore Azure data services for modern analytics
Understand analytics solutions in the Azure data ecosystem. Explore the architecture of a scalable analytics solution to meet business needs.
Click here to know more
2. Understand concepts of data analytics
Explore key concepts of data analytics, including types of analytics, data, and storage. Explore the analytics process and tools used to discover insights.
Click here to know more
3. Explore data analytics at scale
Describe data analytics at scale and understand the roles of a data team. Learn about the responsibilities of an enterprise data analyst and what tools are available to build scalable solutions.
Click here to know more
4. Introduction to Microsoft Purview
In this module, you’ll evaluate whether Microsoft Purview is the right choice for your data discovery and governance needs.
Click here to know more
5. Discover trusted data using Microsoft Purview
Use Microsoft Purview Studio to discover trusted organizational assets for reporting.
Click here to know more
6. Catalog data artifacts by using Microsoft Purview
Register, scan, catalog, and view data assets and their relevant details in Microsoft Purview.
Click here to know more
7. Manage Power BI assets by using Microsoft Purview
Improve data governance and asset discovery using Power BI and Microsoft Purview integration.
Click here to know more
8. Integrate Microsoft Purview and Azure Synapse Analytics
Learn how to integrate Microsoft Purview with Azure Synapse Analytics to improve data discoverability and lineage tracking.
Click here to know more
9. Introduction to Azure Synapse Analytics
Learn about the features and capabilities of Azure Synapse Analytics – a cloud-based platform for big data processing and analysis.
Click here to know more
10. Use Azure Synapse serverless SQL pool to query files in a data lake
With Azure Synapse serverless SQL pool, you can leverage your SQL skills to explore and analyze data in files, without the need to load the data into a relational database.
Click here to know more
11. Analyze data with Apache Spark in Azure Synapse Analytics
Apache Spark is a core technology for large-scale data analytics. Learn how to use Spark in Azure Synapse Analytics to analyze and visualize data in a data lake.
Click here to know more
12. Analyze data in a relational data warehouse
Relational data warehouses are a core element of most enterprise Business Intelligence (BI) solutions, and are used as the basis for data models, reports, and analysis.
Click here to know more
13. Choose a Power BI model framework
Describe model frameworks, their benefits and limitations, and features to help optimize your Power BI data models.
Click here to know more
14. Understand scalability in Power BI
Scalable data models enable enterprise-scale analytics in Power BI. Implement data modeling best practices, use large dataset storage format, and practice building a star schema to design analytics solutions that can scale.
Click here to know more
15. Create and manage scalable Power BI dataflows
Create Power BI transformation logic for reuse across your organization with Power BI dataflows. Learn how to combine Power BI dataflows with Power BI Premium for scalable ETL, and practice creating and consuming dataflows.
Click here to know more
16. Create Power BI model relationships
Power BI model relationships form the basis of a tabular model. Define Power BI model relationships, set up relationships, recognize DAX relationship functions, and describe relationship evaluation.
Click here to know more
17. Use DAX time intelligence functions in Power BI Desktop models
By the end of this module, you’ll learn the meaning of time intelligence and how to add time intelligence DAX calculations to your model.
Click here to know more
18. Create calculation groups
In this module you’ll learn what calculation groups are, explore key features and usage scenarios, and learn to create calculation groups.
Click here to know more
19. Enforce Power BI model security
Enforce model security in Power BI using row-level security and object-level security.
Click here to know more
20. Use tools to optimize Power BI performance
Use tools to develop, manage, and optimize Power BI data model and DAX query performance.
Click here to know more
21. Understand advanced data visualization concepts
Create cohesive, inclusive, and efficient Power BI reports to effectively communicate results.
Click here to know more
22. Monitor data in real-time with Power BI
Describe real-time analytics in Power BI using automatic page refresh, real-time dashboards, and auto-refresh in paginated reports.
Click here to know more
23. Create paginated reports
Paginated reports allow report developers to create Power BI artifacts that have tightly controlled rendering requirements. Paginated reports are ideal for creating sales invoices, receipts, purchase orders, and tabular data. This module will teach you how to create reports, add parameters, and work with tables and charts in paginated reports.
Click here to know more
24. Provide governance in a Power BI environment
Power BI governance is a set of rules, regulations, and policies that define and ensure the effective, controlled, and valuable operation of a BI environment. In this module, you’ll learn the fundamental components and practices necessary to govern a Power BI tenant.
Click here to know more
25. Facilitate collaboration and sharing in Power BI
You’ve created dashboards and reports. Perhaps you want to collaborate on them with your coworkers. Or maybe you’re ready to distribute them more widely. What’s the best way to collaborate and share them? In this module, we compare your options.
Click here to know more
26. Monitor and audit usage
Usage metrics help you understand the impact of your dashboards and reports. When you run either dashboard usage metrics or report usage metrics, you discover how those dashboards and reports are being used throughout your organization, who’s using them, and for what purpose. Knowing who is taking what action on which item in your Power BI tenant can be critical in helping your organization fulfill its requirements, like meeting regulatory compliance and records management. This module outlines what is available in usage metrics reports and audit logs.
Click here to know more
27. Provision Premium capacity in Power BI
Power BI Premium is a dedicated, capacity-based offering. Learn about the differences between Power BI Pro and Power BI Premium, and how Power BI Premium manages capacity resources. Featured tools you can use with Power BI premium are also covered.
Click here to know more
28. Establish a data access infrastructure in Power BI
Working with on-premises data sources requires configuring a gateway between Power BI and the on-premises data source. This module examines how to work with gateways and SQL Server Analysis Services (SSAS) data sources that are used either for scheduled refresh or for live connections.
Click here to know more
29. Broaden the reach of Power BI
You can broaden the reach of Power BI by sharing your reports beyond your Power BI environment. You can publish reports to the public internet, embed reports in Microsoft Teams or in PowerApps, and place BI reports in a SharePoint online web part. There’s also a special version of Power BI service called Microsoft Power BI Embedded (PBIE) which allows application developers to embed fully interactive reports into their applications without having to build their own data visualizations and controls from scratch.
Click here to know more
30. Automate Power BI administration
Cmdlets are functions written in PowerShell script language that execute commands in the Windows PowerShell environment. Running these cmdlets will allow you to interact with your Power BI Platform without having to go through the admin portal in a web browser. Combine these cmdlets with other PowerShell functions to write complex scripts that can optimize your workflow.
Click here to know more
31. Build reports using Power BI within Azure Synapse Analytics
In this module, you will learn how you can build Power BI reports from within Azure Synapse Analytics.
Click here to know more
32. Design a Power BI application lifecycle management strategy
The use of OneDrive, Git repositories, and Power BI deployment pipelines allows us to follow application lifecycle management techniques. This reduces administrative overhead and provides continuity in the development process.
Click here to know more
33. Create and manage a Power BI deployment pipeline
Deployment pipelines enable creators to develop and test Power BI content in the Power BI service before the content is made available for consumption by users. It offers creators improved productivity, faster delivery of content updates, and reduced manual work and errors. The tool is designed as a pipeline with three stages: development, test, and production.
Click here to know more
34. Create and manage Power BI assets
Creating shared data assets for your analytics environment provides structure and consistency. Maintaining those assets is as important, and XMLA endpoint provides additional administrative capabilities.
Click here to know more
Leave feedback about this
You must be logged in to post a comment.