Data Analytics
Showing 37–48 of 298 results
Business Intelligence Data Analyst
BI Data Analysts use Python and SQL to query, analyze, and visualize data — and Tableau and Excel to communicate findings.
Business Machine Learning
This course uses a hands-on approach to introduce core concepts of data science. You will work on projects using real world data.
Catalog data artifacts by using Microsoft Purview
Register, scan, catalog, and view data assets and their relevant details in Microsoft Purview.
Choose a Power BI model framework
Describe model frameworks, their benefits and limitations, and features to help optimize your Power BI data models.
Clean, transform, and load data in Power BI
Power Query has an incredible number of features that are dedicated to helping you clean and prepare your data for analysis. You'll learn how to simplify a complicated model, change data types, rename objects, and pivot data. You'll also learn how to profile columns so that you know which columns have the valuable data that you're seeking for deeper analytics.
Combine multiple tables with JOINs in T-SQL
Explore T-SQL queries accessing data from multiple tables with various kinds of JOIN operations.
Combine query results with set operators
Learn how to use Transact-SQL to combine query results.
Complete Guide to Redis
Redis is an open-source, in-memory data structure store used as a database, cache, and message broker.
Configure databases for optimal performance
Implement tasks for both IaaS and PaaS to maintain indexes, and statistics. Explore the automatic tuning features of Azure SQL Database. Control database-level configuration options. Explore Intelligent Query Processing.
Configure SQL Server resources for optimal performance
Choose the appropriate size and storage options for your Azure SQL databases. Configure server resources such as tempdb. Understand the usage of Resource Governor.
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.
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.