SQLBits Courses

Using ALLEXCEPT or ALL/VALUES in DAX Calculations

Optimize DAX calculations by mastering when to use ALL/VALUES instead of ALLEXCEPT for improved performance and clarity in data analysis.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Realtime Streaming of Flight Data with Microsoft Fabric

Stream and analyze real-time aircraft data using Microsoft Fabric, showcasing Eventstream, KQL database, and Power BI for visualizing flight patterns above SQLBits venue.

• YouTube
• 44 minutes
• Self-Paced
• Free Video

Navigating Data Governance in the Age of Generative AI

Explore LLMs' impact on data analytics, their advantages, and governance challenges. Gain insights to effectively integrate AI into data strategies while maintaining proper oversight.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Upgrade to First Class with Calculation Groups for Power BI

Master Calculation Groups in Power BI Desktop and Tabular Editor. Explore creation techniques, functionality, and best practices for implementing multiple Calculation Groups effectively.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Reducing Costs and Building New Analytics Capabilities in Power BI with Power Automate

Streamline data analytics tasks using Power Automate to reduce transformation time and improve analyst efficiency in Power BI.

• YouTube
• 20 minutes
• Self-Paced
• Free Video

Flight of Innovation: Enhancing On-Prem and Multi-Cloud SQL Instances with a Cloud Cockpit

Extend Azure's features to your entire SQL estate, regardless of location or platform, using Azure Arc for comprehensive management and innovation.

• YouTube
• 22 minutes
• Self-Paced
• Free Video

Navigating the Skies of Data: A Flight Through Feature Stores

Explore Feature Stores' role in streamlining ML projects, acting as a control tower for efficient feature management in data processes.

• YouTube
• 20 minutes
• Self-Paced
• Free Video

The Swiss Cheese Security Pattern - Building Secure Data Architectures

Adopt a multi-layered approach to data security, minimizing risks through strategic architecture and mindset shifts in asset protection.

• YouTube
• 46 minutes
• Self-Paced
• Free Video

Mastering Rapid Power BI Development with ChatGPT - A Deep Dive

Leverage ChatGPT to enhance Power BI development, generating power queries, images, cmdlets, and complex DAX with SVG and CSS for rapid and efficient data visualization.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks

Explore Microsoft Fabric Notebooks: Learn Python, Spark basics, and advanced analytics with SemPy. Enhance Power BI development using CoPilot for code assistance.

• YouTube
• 52 minutes
• Self-Paced
• Free Video

The Hitchhiker's Guide to Navigating Power BI

Master Power BI navigation: internal reports, app transitions, and web portal optimization. Enhance user experience with service integration and essential tools like Drill Through and Bookmarks.

• YouTube
• 50 minutes
• Self-Paced
• Free Video

Data Leadership: Navigating Security, Governance, and Ethical Decision-Making in the Digital Skies

Explore robust data protection, governance, and leadership strategies, focusing on OneLake, Purview, and modern security approaches for seamless, secure digital operations.

• YouTube
• 40 minutes
• Self-Paced
• Free Video

How to Conduct a Transact-SQL Code Review

Discover best practices for Transact-SQL code reviews, enhancing performance and efficiency in your SQL Server projects through improved code acceptance testing.

• YouTube
• 49 minutes
• Self-Paced
• Free Video

Disaster Recovery Strategies for SQL Server

Explore SQL Server disaster recovery strategies, including technologies and implementation methods, to effectively plan for and manage data recovery during outages.

• YouTube
• 47 minutes
• Self-Paced
• Free Video

Version Control Your Solutions Using Azure DevOps - Even the Smallest Ones

Learn to version control solutions using Azure DevOps, enhancing collaboration and tracking changes for projects of all sizes.

• YouTube
• 50 minutes
• Self-Paced
• Free Video