Data Virtualization is Easy with SQL Server Big Data Cluster
Explore data virtualization using SQL Server 2019 Big Data Cluster. Learn to access and analyze external data sources, implement data ingestion, and gain insights from a real project's lessons learned.
Analytics Spotlight - The New Analyst
Explore evolving analytics trends, skills, and technologies for business analysts. Learn to work with data science, improve data literacy, and embrace ambiguity in modern business intelligence.
SQL Isn't for Analysis - Why Everyone Needs OLAP Data Models
Explore the power of middle-tier modeling and calculation layers in data analysis, challenging the traditional "storage and charts" approach with case studies and clear explanations of their value.
An Azure Data Engineer's ETL Toolkit
Explore Azure's data movement and transformation options, comparing SSIS with Data Factory, Databricks, and Logic Apps. Learn ETL patterns and Data Flow features for scalable cloud migration.
Azure Data Studio - The New Frontier
Explore Azure Data Studio's features for managing data platforms, including dashboards, snippets, profiling, charting, and more. Learn when to use it over SQL Server Management Studio.
Microsoft Data Engineering Unplugged
Meet Microsoft's Data Engineering team, discuss SQL Server, Azure SQL, and data services. Gain insights into product development, engineering processes, and future plans. Engage directly with PMs in this interactive session.
JSON for the Data Mortals
Explore JSON in databases: learn its origins, investigate, manipulate, and validate JSON data using Microsoft SQL Server tools and example code.
Managing ETL Change Using BIMLScript
Automate ETL processes using BIMLScript and metadata to easily adapt to source file changes, demonstrated with US census data and applicable to SSIS and Azure Data Factory.
Presenting Big Data Clusters for SQL Server 2019
Explore SQL Server 2019's Big Data Clusters, combining open-source technologies with SQL Server for advanced analytics. Learn how containers and Kubernetes integrate Apache Spark, Hadoop, and SQL Server into a unified analytics solution.
Head to Head - SSIS Versus Azure Data Factory
Comparative analysis of SSIS and Azure Data Factory, exploring strengths, weaknesses, and real-world applications for data movement and transformation in SQL Server environments.
Code Like a Snake Charmer – Advanced Data Modeling in Python
Comprehensive Python data modeling tutorial covering extraction, cleaning, transformation, visualization, predictive modeling, validation, and deployment using popular libraries and Azure integration.
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.
Two Truths That's A Lie - Data Visualization Ethics
Explore data visualization ethics, examining how color and chart choices influence storytelling. Learn to create truthful, impactful visualizations while protecting your company's reputation.
Design Strategies and Advanced Data Visualization
Advanced techniques for effective data visualization, including accessibility design, data storytelling, and creating impactful reports and dashboards for diverse audiences.
Using Open Source Software to Collect Performance Metrics
Learn to set up an inexpensive system using Telegraf, InfluxDB, and Grafana to collect and visualize SQL Server performance metrics, aiding in troubleshooting and capacity planning.
Azure Machine Learning 101
Explore Azure ML's no-code approach to machine learning, from data preparation to model deployment, suitable for both beginners and experienced data scientists.
No-Code Custom Visuals! Can You Say Charticulator? - I Knew You Could
Explore Charticulator, an open-source tool for creating stunning Power BI custom visuals without coding. Learn to enhance your data visualization capabilities and unlock new possibilities in data presentation.
The Emerging Role of BI in Your Organization
Explore strategies for integrating Business Intelligence into your organization, including infrastructure configuration, leveraging Power Platform, and addressing key challenges and opportunities.
PowerApps and AI - A Flow of Location Events
Explore PowerApps and AI integration for location tracking, using Bing maps, Azure SQL, and Cognitive Services. Learn to create mobile apps with real-time alerts and location-aware web searches.
Text Mining & Sentiment Analysis Made Easy
Learn to analyze text data using Azure Cognitive Services and Power BI. Extract key phrases, derive sentiment scores, and create effective visual dashboards without needing advanced data science skills.
SQL and MongoDB - When Two Worlds Collide
Explore hybrid SQL-NoSQL solutions, focusing on integrating MongoDB with SQL Server. Learn scenarios, implementation techniques, and performance considerations for leveraging strengths of both database types.