Cloud Warehouse Monitoring - Snowflake Case Study
Discover essential strategies for monitoring cloud data warehouse costs, security, and performance, with practical insights applicable across platforms like Snowflake for better governance and optimization.
Data Encryption and Security in BigQuery - End-to-End Process
Master end-to-end data encryption in BigQuery, from application-level security to query-time decryption, ensuring sensitive data remains protected while maintaining accessibility.
Working with BigQuery and DataForm - Streamlining Data Management and Transformation
Streamline data management with BigQuery and DataForm. Learn setup, optimization, and automation for efficient, scalable data pipelines and transformations.
Azure Data Engineering Tools: Choosing Between Data Factory, Databricks, and Synapse Analytics
Explore Azure data engineering tools: Data Factory, Databricks, and Synapse Analytics. Learn their strengths, use cases, and how to choose the right one for your project.
Power BI and Azure Synapse Analytics - Creating a Unified Analytics Solution
Embark on a unified analytics journey using Power BI and Azure Synapse Analytics. Learn essential techniques to create powerful data solutions and gain valuable insights.
Gathering Requirements for Your Star Schema
Collaboratively design dimensional models with business users for effective star schema requirements gathering and data visualization.
7 Things I Wish I'd Known Before Building a 60TB Data Warehouse on a Dedicated Pool
Discover key insights and lessons learned from building a 60Tb data warehouse on Azure Dedicated Pool. Explore challenges, solutions, and best practices for large-scale data management.
Your First Flight with Data Factory in Microsoft Fabric
Explore Data Factory in Microsoft Fabric through a rapid tour, understanding its value for data integration in organizations.
Fabric Direct Lake Deep Dive in Power BI
Explore the new Direct Lake mode for Power BI in Microsoft Fabric, understanding its functionality and applications in data analysis.
Load Testing Fabric: Determining Hold Capacity for Large Datasets
Discover techniques for testing Fabric's capacity to handle large-scale data processing, from ingestion to PowerBI visualization, for enterprise-level workloads.
Fabric Direct Lake Deep Dive in Power BI
Explore the new Direct Lake mode for Power BI in Microsoft Fabric, understanding its functionality and applications in data analysis.
Star Schema ALL the Things! But Why? - Practical Design Decisions in Data Modeling
Explore practical star schema design, from source to model to report. Learn best practices, test methodologies, and assess performance impacts in data modeling.
From SSIS to Synapse to Fabric - A Data Architect's Case Study
Explore a real-world EDW automation framework migration journey from SSIS to Synapse to Fabric. Learn migration processes, lessons, improvements, and unit testing strategies for data architects.
Analytics Architectures on Microsoft Fabric
Explore diverse analytics architectures, their pros and cons, and how Microsoft Fabric supports their implementation for effective data analysis.
Behind the Hype - Architecture Trends in Data
Explore data architecture trends with a seasoned engineer, separating hype from strategic value in industry buzzwords and innovations.
Navigating Microsoft Fabric - Choosing the Right Workload for Your Needs
Choose the right Microsoft Fabric workload for your business needs and understand current limitations in this informative session led by experienced Microsoft program managers.
Roche's Maxim of Data Transformation - By Example
Explore Roche's Maxim through practical examples, learning to optimize data transformation processes for improved efficiency and effectiveness in data management.
From Raw Data to an Interactive Data App in an Hour - Powered by Snowpark Python
Develop a Streamlit data app to visualize advertising ROI using Snowpark Python. Learn data ingestion, transformation, ML modeling, and interactive visualization techniques.
The Missing Manual - Everything You Need to Know About Snowflake Optimization
Optimize Snowflake cost and performance with deep insights into architecture, billing, virtual warehouses, micro-partitioning, caching, and best practices for configuration and query writing.
A Deep Dive into the dbt Manifest
Explore dbt's manifest.json file, its production, and applications in data pipelines. Learn about deployment configurations, quality enforcement, and streamlined development workflows using real-world examples.
Data Warehouses are Gilded Cages - What Comes Next
Explore DuckDB's potential to revolutionize data analytics, shifting from centralized warehouses to powerful local processing. Learn how this approach can enhance efficiency and user control in data management.