Fabric Power Hour

What's new in Power Query in Power BI, Fabric and Excel?

Find out about new Power Query features in Power BI Desktop, Fabric Dataflows and Excel.

Connect Excel to Power BI data with Live Connected Tables

In this session you'll learn how to create Live Connected Tables and what the advantages and disadvantages of using them are.

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

Fabric Direct Lake Deep Dive

Learn how the new Direct Lake mode for Power BI in Microsoft Fabric works

BI Power Hour

Be AMAZED by the silliest product demos you've ever seen! LAUGH! CRY! Reconsider your career choices!

Query folding in Power Query

Find out what query folding is, why it's important for performance and what can stop it happening.

Performance Tuning Power Query And Dataflows In Power BI

Performance tune Power Query in Power BI and Power BI Dataflows

Creating Tables In Power Query And M Using #table()

Generate tables of data using the #table M function in Power Query

Power BI: Business Intelligence Strategy, Vision, & Roadmap

Power BI enables customers and partners to do more with their data. Come to this session to learn about the latest information about our strategy, vision, and roadmap for Power BI. 

Performance tuning Power BI dataset refresh

So your dataset is taking too long to refresh. What can you do? In this presentation you’ll learn about all the different components that can contribute to slow refresh performance such as the data sources you’re using,

Advanced analytics features in Power BI

In this session you’ll learn about some of these advanced analytical features in Power BI, including: the Analytics pane on visuals; the Key Influencers visual and other AI features.

Top tips for the accidental Power BI administrator

In this session you'll learn real-world experience from Microsoft's Customer Advisory Team about what you need to manage and administer Power BI.

Introduction To Dataflows In Power BI

Learn how dataflows can be used to load data in Power BI.

Using Analysis Services MD as a Data Source for Power BI

Learn how to get the most of your SSAS MD cubes when using Power BI as a front-end

Introduction to Azure Analysis Services

Learn to build Analysis Services models in the cloud

Building A Reporting Solution Using Power Query

See how to use Power Query to build a detail-level reporting solution

Power Query: Beyond The Basics

An in-depth session on advanced Power Query functionality and the M language

DAXMD: SSAS Multidimensional meets DAX and Power View

This session looks at the most significant new functionality to be added to SSAS Multidimensional in recent years: support for the DAX language and Power View.

Advanced Security with Analysis Services Multidimensional

This session will cover advanced security topics in the Analysis Services Multidimensional model.

Fun with Scoped Assignments in MDX

This session will introduce the concept of scoped assignments in MDX and show how they can be used to solve various calculation problems.

Basic BISM

This session explains what the BI Semantic Model in SQL Server Denali is, how it is related to Analysis Services, and provides a brief introduction to the new Tabular model.

Implementing Common Business Calculations in DAX

This session will introduce the basic concepts of the new multidimensional calculation language, DAX, and show how to implement several common calculations in it

Common Analysis Services design mistakes and how to avoid them

Learn about the most frequently made Analysis Services design mistakes, the problems they cause, and how to fix them or not make them in the first place

Nose-Dive Narratives: Slide Karaoke 2024

Get ready to wrap up a serious day of learning with a dash of humor, spontaneity, and friendly competition! SQLBits presents "Slide Karaoke" where SQLBits speakers reveal their hidden talents while vying for bragging rights. This session promises to be a one-of-a-kind experience that will leave you in stitches and awe, and the speakers scrambling for their non-existent notes!

Fabric Product Group - Ask us Anything

Come and join the Fabric Product Group for one of our fireside chats. Bring your questions because we have all the answers!!

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

A Deep Dive into Microsoft Fabric Data Warehouse

Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.

Synapse Q&A with PG

SQLBits' has brought members of the Azure Synapse Program Group to Wales to ask YOUR questions. Bring your questions for: Dedicated SQL Pools, Serverless SQL Pools, Spark Pools, Pipelines, Kusto and everything else Synapse related.

Lightning Talks

5 minute lightning talks from your favourite speakers

Dedicated SQL Pools : How some stuff 'really' works

Session covering table distributions, partitioning , RSC and materialised views.

Reporting on 1.4B rows with Serverless SQL Pools

Building a dashboard using Serverless SQL Pools in a performant way

Azure Synapse Analytics: Evolving Azure SQL Data Warehouse

In this session we explore Azure Synapse Analytics, we will dive into this limitless analytics service and explore how it brings together enterprise data warehousing and Big Data analytics.

Modernizing & Migrating Your Data Warehouse w/ Azure Synapse

This session will dive into how to successfully migrate to Azure Synapse, all the way from code conversion to enterprise grade developer tooling, with real customer examples for product and migration experts.

Azure Machine Learning from the ground up

Azure Machine Learning is a fully managed cloud service for predictive analytics. In this 1hour session, we will run through; ML Studio,using data, Creating and running Experiments, visualising results, R , publishing and using experiments.

Building a SSMS Add-in; The Agony and Ecstasy

We will travel back in time a bit to SQL 2005 to see how SSMS Add-ins worked, then jump forward to the present day were we will go through the process of writing a SSMS Add-in for R2.

The Fundamentals of DAX Contexts

Explore the heart of DAX with this unique session, as I take you on an African Safari-themed adventure, where stunning wildlife photography serves as the backdrop for understanding the intricacies of DAX contexts. We'll encounter row and filter contexts, just like wild creatures in their natural habitat. Through captivating visuals, you'll uncover how these contexts shape DAX calculations and measure outcomes. Whether you're a data analyst or a business intelligence enthusiast, this session ensures a memorable and educational experience. Understanding DAX Contexts is your gateway to mastering DAX while enjoying the captivating beauty of African wildlife. Don't miss this opportunity to embark on your DAX adventure.

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

5 Things You Can Do to build better looking reports

Power BI Design is a lot like an art form, a mythical beast to many IT professionals. We’re generally inclined to think very analytically about our jobs, and creativity does not always come naturally. Thankfully, there are some patterns we can apply to design reports which are clean, uncluttered, and user friendly. Learn the science behind design, and a series of logical steps to follow to ensure that your reports always meet the mark.

The Fundamentals of DAX Contexts

Understanding how DAX determines evaluation context is a critical skill for a Power BI Developer. Writing anything other than the most simple measures requires this skill. In this session we'll explore Filter Context and Row Context individually, and how they combine to form Evaluation Context. We'll have a look at a number of simple measures and visualise how the context affects them.

"Whats in a Name?", Data Stories to Impress the Bard

Data on its own is useful, but boring. Data in story form makes people sit up and take notice. Learn to craft effective stories and maximise the impact of your data communication.

Power BI Report Design for the Aesthetically Challenged

Have you ever looked at other people's Power BI reports, and wondered how they look so good? Designing an aesthetically pleasing report does not require a graphic designer, just the lessons you'll take away from this session.

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

Driving alerts and actions on your data

In this session you will learn how to drive actions on data using the new Data Activator experience in Microsoft Fabric

Building and using Organizational data types

Learn how to create data types in Power BI and consume them in Excel

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 1st Leg

Let's explore CSS Selectors so that we can do some web scraping in Power Query with Power BI, m code in Dataflows Gen 2, and PySpark Notebooks - All in the Azure cloud within Microsoft Fabric.

Service Dogs in the Cabin - Web Scraping Puppy Data with Microsoft Fabric - 2nd Leg

Let's take what we learned about CSS Selectors in the previous so that we can do some web scraping in Power Query, m code, and PySpark - All in the Azure cloud within Microsoft Fabric.

Contextualizing timeseries data with graphs

Discover the power of graphs in Kusto, the scalable database engine for Azure Data Explorer, and how to create and query them with a simple and intuitive syntax

Scale your business in real-time using ML in Microsoft Fabric Real-time Analytics

Technical deep-dive session on using Machine Learning on real-time data to scale your business operations

Fabric Power Hour

The famous Power BI Power Hour returns, but this time it has expanded to cover the whole of Fabric!

The What and the Why of Microsoft Fabric Real-time Analytics

Join this session to discover possibilities with MIcrosoft Fabric Real-time Analytics.