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.

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.

Explore SQL automation for scheduled tasks, and automatic alerts for SQL Server and Azure SQL Managed Instance.

Learn how to navigate the Power BI service, create and manage workspaces and related items, and distribute reports to users.

The Power BI cloud service makes it so much easier to share and collaborate on your reports. This course will teach you how to leverage the workspaces feature of the Power BI app as preparation for the PL-300 exam.

This course covers the important aspects of working with Jupyter notebooks, including installation and the role of kernels, magic functions, and running shell commands. In addition, the power of cloud-hosted Jupyter notebooks is explored on AWS, Microsoft Azure as well as the Google Cloud Platform.

In this module you'll learn what calculation groups are, explore key features and usage scenarios, and learn to create calculation groups.

Microsoft Power BI dashboards are different than Power BI reports. Dashboards allow report consumers to create a single artifact of directed data that is personalized just for them. Dashboards can be composed of pinned visuals that are taken from different reports. Where a Power BI report uses data from a single semantic model, a Power BI dashboard can contain visuals from different semantic models.

The DAX modeling language allows complete control over the data in your visuals in Power BI. This course will teach you how to create new measures that filter and aggregate data in ways that are impossible without DAX.

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.

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.

Learn how to use Stored procedures to group T-SQL statements so they can be used and reused whenever needed. You may need to execute stored procedures that someone else has created or create your own.