Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.

This course covers the steps involved in setting up a SQL Server instance and a Databricks workspace in the same virtual network, and querying the database from a notebook.

This course will introduce basic methods to convert categorical variables into quantitative variables for analysis using Python. Without properly prepared data, your model is likely to be inaccurate or incomplete.

Join Luke Dion, vice president of engineering operations at Cox Automotive, as he shares his team’s data-driven approach to developing skills and driving engineering effectiveness amidst the sudden shift and uncertainty due to COVID-19.

In this course, you'll dive into DataFrame indexing with pandas. Follow Abby, a marketing analyst, as she navigates her marketing dataset. You'll learn reindexing, .loc, .iloc, data filtering techniques, and more through interactive demos.

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.

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.