Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you'll learn how to implement RLS by using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.

Learn how to construct transactions to control the behavior of multiple Transact-SQL statements. You'll learn how to determine whether an error has occurred, and when to roll back statements.

Charts allow any audience to understand a topic and quickly make decisions. This course will teach you how to use chart elements to your advantage while creating visualizations based on various types of data.

This course offers a deep dive into addressing dataset incompleteness. From basic drop methods to intricate regression imputations, emerge equipped to tackle any missing data challenge with confidence.

This course shows how R’s capabilities can help you retrieve data from relational databases and make it available to R for adding value with other operations, such as analysis and visualization.

In this course, you’ll learn how to use Pandas index objects for advanced data analysis. You'll learn how to create and use numerical, interval, period, categorical, date-time, time-delta, and multi-indexing in Pandas to retrieve and manipulate data.

Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.

Explore how Microsoft Fabric enables you to ingest and orchestrate data from various sources (such as files, databases, or web services) through dataflows, notebooks, and pipelines.

Discover how to use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse. Fabric notebooks provide a scalable and systematic solution.

Learn how Azure Synapse Analytics integrates with other Azure Data and AI services.

Learn how to integrate Microsoft Purview with Azure Synapse Analytics to improve data discoverability and lineage tracking.

Transactions are great, but sometimes you need something more than total success or total failure. This course will teach you how to implement error handling to create sophisticated error handling flows.