Everything You Wanted to Know About Implementing Temporal Tables
Discover SQL Server's Temporal Tables: automate data history tracking, simplify time-based analysis, and explore new querying syntax for efficient data management and auditing.
Data Munging to Wrangling - 7 Steps to Mastering Data Preparation for Data Science
Discover essential techniques for data preparation in AI/ML projects. Learn to source, clean, and transform data effectively, enhancing the quality and predictive power of machine learning models.
Power BI Premium - Is it for Your Company and Worth It
Comprehensive overview of Power BI Premium features, benefits, and costs to help companies decide if it's the right investment for their data analytics needs.
Code Like a Snake Charmer - Introduction to Python
Learn Python basics, data manipulation, and integration with Microsoft tools for enhanced data analytics and machine learning capabilities.
Cosmos DB Develop Locally Deploy Globally
Learn to set up, use, and deploy CosmosDB for globally distributed, scalable database solutions. Explore JSON data loading, PowerBI visualization, and seamless cloud migration.
Budgeting with Power BI
Learn advanced budgeting techniques in Power BI, including previous year allocation, multi-step budgeting, and handling new product forecasts. Master DAX code for precise budget modeling and forecasting.
Think Like the Cardinality Estimator
Explore SQL Server's cardinality estimation process to optimize query performance. Learn how to influence physical operations, handle multiple predicates, and tackle complex query plans.
Machine Learning in C# - Introduction to ML.NET
Discover ML.NET: Build machine learning applications using C# and .NET. Learn data preparation, model evaluation, and deployment techniques for integrating ML capabilities into your .NET projects.
Implementing Data-Driven Storytelling Techniques in Power BI
Learn four data-driven storytelling techniques and their implementation in Power BI to create engaging, easy-to-consume reports with coherent structures that effectively communicate insights.
Power of Electric Snakes! PySpark for Big Data and Data Science
Learn to harness PySpark for big data analytics, covering RDDs, DataFrames, transformations, and machine learning. Gain practical skills for efficient data processing and analysis using Python and Spark.
Getting Started with Azure Data Studio
Learn to use Azure Data Studio: customize, create insights, use extensions, work with notebooks, and develop your own extensions. Master this cross-platform tool for data-related tasks and T-SQL editing.
Inside the VertiPaq Engine
Explore VertiPaq engine internals, database architecture, and optimization techniques for improved performance and compression in SQL Server Analysis Services Tabular, Power BI, and Power Pivot.
Designing Reports for Effective Storytelling
Learn effective digital storytelling techniques for creating impactful reports, focusing on color, contrast, layout, and design principles to convey information clearly and professionally.
Aggregation and Composite Model - Power BI Fast and Furious
Optimize Power BI performance with Aggregations and Composite Models. Learn techniques for analyzing terabytes of data in seconds, with live demos and practical tips for handling huge datasets efficiently.
Azure Synapse Analytics - A Data Lakehouse
Explore Azure Synapse Analytics, a unified service combining data warehousing and Big Data analytics. Learn about its features, scalability, and integration in modern data warehouses through demonstrations.
Designing Azure Data Science and AI Projects
Aprenda a diseñar proyectos de ciencia de datos e IA en Azure, desde la comprensión del negocio hasta la implementación, utilizando un enfoque práctico basado en equipo y las últimas tecnologías disponibles.
Deploying SQL Server Big Data Clusters
Learn to deploy SQL Server Big Data Clusters, demystify Kubernetes, and compare on-prem vs cloud deployments. Gain practical tools and scripts for immediate implementation.
Navigate Your Big Data Journey with AWS Big Data Services
Comprehensive guide to AWS big data services, covering data ingestion, warehousing, analysis, and visualization using tools like Jupyter notebooks and Amazon Redshift for effective data lifecycle management.
Data Analysis with Spark and Databricks in Azure Synapse
Comparing Spark and Databricks in Azure Synapse: use cases, costs, data types, processing volumes, and implementation demos. Learn when to choose Spark-based tools vs. alternatives like SQL on-demand or ELT.
Machine Learning, Artificial Intelligence, and Deep Learning Explained
Explore AI, ML, and DL with Buck Woody: learn key differences, use-cases, and implementation options, including SQL Server platform technologies.
Building a Security Dashboard for SQL Server
Learn to create a Power BI security dashboard for SQL Server, monitoring crucial security data and changes to ensure robust protection of your database systems.