Compare Azure, and on-premises tools for monitoring and measuring performance. Determine critical metrics. Understand the purpose of a baseline for comparative analysis. Configure extended event sessions for tracing activities.

This course will teach you how to design a data model with Power BI.

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.

The process of creating a complicated semantic model in Power BI is straightforward. If your data is coming in from more than one transactional system, before you know it, you can have dozens of tables that you have to work with. Building a great semantic model is about simplifying the disarray. A star schema is one way to simplify a semantic model, and you learn about the terminology and implementation of them in this module. You will also learn about why choosing the correct data granularity is important for performance and usability of your Power BI reports. Finally, you learn about improving performance with your Power BI semantic models.

This learning path introduces the foundational components of designing scalable tabular models using Power BI. This learning path helps you prepare for the Azure Enterprise Data Analyst Certification.

This learning path introduces a design process to design and deliver compelling Power BI reports. It begins by describing a proven design process created by leading report design experts. The process encompasses phases to understand the report users and their requirements, explore pleasing report designs, and develop reports all the way into production.

A well-crafted exploratory data analysis research plan can make a big difference in a data scientist's work being implemented in their organization. In this course, you will learn the foundational components and how to deliver a successful analysis.

This course will teach you how to create an exploratory data analysis research plan to get started on the path to making the best data-driven decisions for your company.

Organizations increasingly need someone to make sense out of all the “Big Data” they are generating. This course will teach you how to identify the signals hidden in your datasets and choose visualizations that tell compelling, interesting stories.

Trigger your learning instincts and find out how to create and test AFTER and INSTEAD OF triggers in SQL Server. This course will teach you how to effectively write and use DML triggers in SQL Server.

With the right data model, you can build high-performing reports while reducing the complexity of DAX queries. This course teaches you how to enrich your data model by creating calculated columns and tables, set up the Q&A, and implement security.

Transform and load data, define semantic model relationships and calculations, create interactive visuals, and distribute reports using Power BI.