Dashboard Designing - From 0 to Hero
Transform raw data into actionable insights with Power BI. Learn data modeling, visual slicing, report creation, and advanced features for effective dashboard design.
Modelado y carga de datos con SSAS
Explora el papel de SSAS en Azure para soluciones BI, aprende sobre modelado y carga de datos, y descubre cómo visualizar información con Power BI y Excel.
Text Analytics API with Cognitive Services - Achieving AI Analytics
Learn to analyze feedback using Azure Cognitive Services, transforming data from Dynamics 365 to create insightful models and gain valuable AI-driven analytics insights.
CosmosDB
Aprenda a transferir conhecimentos de SQL Server para CosmosDB, explorando semelhanças e diferenças entre as bases, com foco em projeto e modelagem específicos do CosmosDB. Demonstrações práticas incluídas.
Designing for Azure Data Warehouse Performance - Cloud
Learn Azure Data Warehouse design principles for optimal performance, covering architecture, data modeling, and practical considerations to balance current and future needs.
Power BI From 0 to Hero - Analytics
Comprehensive Power BI tutorial covering data loading, modeling, report design, and advanced features. Learn to create impactful visualizations and leverage Power BI's full potential for data analysis.
Bad Designs Have Consequences
Explore real-world SQL database design pitfalls, their consequences, and learn from 15 years of experience to avoid common mistakes and improve your database architecture.
Roles and Responsibilities of the Azure Data Engineer
Explore the role of Azure Data Engineer, including key responsibilities, required skills, and relevant Azure services. Learn how to align your career path with the Microsoft certification.
Eliminating Anti-Patterns and RBAR for Faster Performance
Learn to boost SQL Server performance by identifying and fixing schema and code design issues, focusing on real-world examples and reproducible workloads to achieve faster query execution and better scalability.
Modern Excel - The Supercomputer Hiding on Everyone’s Desktop
Discover game-changing Excel tools for data-driven decisions. Learn multi-source import, rapid data shaping, portable formulas, and insightful reporting techniques to supercharge your spreadsheet skills.
Innovative Data Modeling for Cool Data Warehouses
Explore agile data warehouse modeling techniques beyond traditional norms. Learn to build flexible, auditable solutions adaptable to various industries, leveraging MDM and Azure for enhanced performance and data integration.
Data Modeling and Prototyping in Power BI Desktop
Explore rapid data modeling and prototyping using Power BI Desktop. Learn to connect, cleanse, and model data from various sources, creating quick reports for project approval without licensing costs.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
Aggregations in Power BI
Explore high-performance data analysis using Power BI Aggregations. Compare with Analysis Services, learn implementation strategies, and understand architectural approaches for optimized analytical solutions.
Handling Role Playing Dimensions in Tabular Models
Explore various methods for implementing role-playing dimensions in tabular models, including DAX expressions, with a focus on model maintainability and user experience in data analysis.
Introducing Azure Synapse Analytics - The End-to-End Analytics Platform
Explore Azure Synapse Analytics, a comprehensive platform integrating relational and big data systems for efficient data ingestion, preparation, modeling, and serving in a unified workspace.
Data Modeling and Partitioning Patterns in Azure Cosmos DB
Explore key strategies for effective data modeling and partitioning in Cosmos DB, using real-world examples to optimize performance and scalability in NoSQL database design.
Localizing Reports in Power BI
Learn to localize Power BI reports, including content translation, currency conversion, and language settings for global audiences. Explore options for multi-language support and automated translation using Azure Cognitive Services.
What's Your Bacon Number - An Introduction to Graph Databases
Explore graph databases using IMDB data to calculate Bacon Numbers. Learn graph theory, database types, and practical applications with Azure Cosmos DB and Gremlin API.
Normalization Beyond Third Normal Form
Explore higher Normal Forms in database design, debunking myths and enhancing your skills. Learn to identify, check, and understand the consequences of violations for improved database architecture.
Microsoft Power BI for the Data Engineer
Explore Power BI's capabilities for enterprise-grade insights, performance, governance, and security over massive datasets. Learn simplified data modeling and visualization techniques for actionable insights.