An evening with Power BI CAT team

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

Fabric security: everything you need to know!

Learn how Microsoft Fabric makes sure your data is secure. Did you know for example that all data is encrypted by default? Or that you can configure MFA for all your users? Fabric offers many of these possibilities and more out of the box without most of us knowing! In this session you will learn everything to convince your security team

Understanding Zero Trust security

In this session we will look at what Zero Trust principles are. Zero Trust is the modern way to apply security. It assumes a breach, verifies every user, and enforces least privilege, giving users access only to the private applications and resources they need. It no longer secures the perimeter (the network boundaries) which doesn't scale in the modern world. We will see how it applies to your Microsoft services like Microsoft Fabric too.

The Power BI Engine in 20 minutes

In this action-packed session we will investigate how the Power BI engine works. From loading the data through M to its fast vertipaq engine.

The Power BI secret sauce: Security and governance

Learn how to convince your security team that Power BI's security and governance features are secure. It's baked in features that allow your org to upload your upload your data to the cloud and enable self-service in a safe and managable way.

Debugging common DAX and Model performance issues

In this session, we will explore real world DAX and Model performance scenario's. These scenarios range from memory pressure to high CPU load. Watch as we will dive into the model and improve performance by going through concrete examples.

Microsoft Power BI Premium: Building enterprise-grade models

Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through Microsoft Power BI. The session will focus on performance, scalability, and application lifecycle management (ALM).

Power BI security deep dive

One hot topic with Power BI is security, in this deep dive session we will look at all the aspects of security of Power BI, from users, logging to where and how your data is stored andleverage additional Azure services to secure it even more.

Understanding the Power BI data model

In this session we will look at all the important topics that are needed to get your Power BI modelling skills to the next level. We will cover the in memory engine, relationships, DAX filter context, DAX vs M and DirectQuery.

Developing For PowerBI

The Power BI Preview service offers developers a rich API service for anyone to interact with Power BI programmatically and create applications for Power BI. In this session we will introduce you to the Power BI developer story

Building Great Models for Crescent

SQL Server Code Name Denali Reporting Services will include Project Crescent for visualizing, interacting with and presenting data. Project Crescent. Come to this session to see how to make the most of this new tool.

One dataset and three use cases with Microsoft Fabric

Are you curious about how to leverage Open Data with Fabric? In this demo filled session, I will show you how I import World Bank Open Data into Fabric using different methods: Pipelines, Data factory Gen-II, Notebooks and a mix of all three. Then I will demonstrate how I do modelling using Warehouse, Power BI Dataset model and Notebooks. Finally, I will create stunning reports using Power BI. By the end of the session, attendees will get an idea of how each artifact would work, why one would use one over other artifacts, and understand how to create an end-to-end solution with Microsoft Fabric

Powering Up Your Power BI Development Workflow with Microsoft Fabric Notebooks

Are you excited about Microsoft Fabric and its Notebooks feature, but also feel overwhelmed by the different languages it supports, this session is for you. You will learn the basics of Python and Spark, and how to use Notebooks to write and run code. You will also discover how to leverage tools like CoPilot to assist you with code suggestions and corrections. Moreover, you will see how to use libraries like SemPy to enrich your Power BI development with advanced analytics. Join Prathy in this session and get ready to explore the possibilities of Notebooks in Microsoft Fabric.

Demystifying Power BI Slicers and filters

When it comes to Power BI Reports design, both slicers and filters have their own space and use cases. However, Slicers and filters are probably among the most frequently misused terms in Power BI design. In this session, we will start with what are Power BI Slicers and filters. What are the differences between and when to use what? We will investigate the pros and cons of each and how to get the best of both filters and slicers in Power BI. By the end of the session, attendees will get an overall view of Power BI slicers and filters in Power BI designing.

Power BI bookmarks in 20 minutes

In this 20 minute session, you will learn everything you need to know about bookmarks. We will start with creating your first bookmark to multiple bookmarks by understanding advanced settings that usually get overlooked. We will also look at how we can ease the design and Maintainance of bookmarks by using features like grouping, renaming, selection pane, and naming conventions. By the end of the session, you will learn to apply bookmarks like a pro!

Power BI Report design Tips and Tricks

A demo's filled session packed with tips and tricks to show how to transform usual Power BI reports to stunning reports

Introduction to PowerApps and Integration with Power BI

In this session, attendees learn about how to create PowerApps solutions, how to use PowerApps as data entry application for Power BI. How to integrate PowerApps in Power BI and Power BI in PowerApps.

Power BI deployment strategy for publishing and maintenance

It takes minutes to create and share Power BI reports and users who has relevant Power BI access can do many things in the PBI service. In this session, Prathy will show how having a deployment strategy helps maintaining Power BI service.

Deep Dive into SSIDB Catalog

A session to understand the available functionality of SSISDB Catalog