Sessions & Content

Search
Content Type
Conference
Tags
A low cost serveless synapse data platform Eivind Halmøy Wolden
If you like writing SQL and need a cheap data platform in Azure, this session is for you. This session will describe the architecture for a metadata driven, minimalistic Azure data platform using Synapse Analytics (serverless SQL) and data lake. You will get to know when this works well, and when it does not.
The video is not available to view online.
Analyzing Big Data in Azure cloud using Spark and Databricks Maria Zakourdaev
During this session, we will talk about Azure Databricks' key features, and typical scenarios where Spark can fit, will see a lot of demos and I will share my top list of Azure Databricks best practices.
The video is not available to view online.
Building and using Organizational data types Lars Andersen
Learn how to create data types in Power BI and consume them in Excel
The video is not available to view online.
CALCULATE evaluation order Renato Lira
In this session I’ll show you a practical, visual and less verbose steps that are performed to evaluate the CALCULATE expression that has multiple filters/modifiers.
The video is not available to view online.
Data modeling for experts with Power BI Marc Lelijveld
Want to level up your Power BI data modeling skills? During this session you will learn how to deal with different source groups, storage modes and composite models in Power BI. Also, how to avoid redundant measures by implementing calculations groups and the challenge that comes when you combine calculation groups with remote and local Power BI models.
The video is not available to view online.
DAX in 20 Minutes - The Hard Parts Eugene Meidinger
One of the biggest hurdles in learning how to use Power BI is the DAX modeling language. While it looks simple, like Excel formulas, it requires a who set of mental models to use effectively. In this session, we'll cover all the roadblocks to getting started with DAX.
The video is not available to view online.
Do You Speak English? Localized Reports with Power BI Markus Ehrenmueller-Jensen
Create a Power BI report where the user can choose the display language of headers and content.
The video is not available to view online.
Don't be scared with Hybrid, they are only tables… Bruno Mairos
Hybrid Tables in Power BI - Do you have the courage to mess with them? Jump in and together let's chop the data in static, incremental and instable data that is changing every second…
The video is not available to view online.
Financial Statements with Power BI - Part 1 P&L/BS Bob Duffy
I will show the “secret sauce” to financial modelling for General Ledger (GL) structures such as Profit and Loss and Balance Sheet. included is PBIX so you can follow.
The video is not available to view online.
How changes to Azure Synapse Analytics impact data architecture designs Ginger Grant
Explore the changes that have been made to Azure Synapse Analytics and how this has changed it’s use over time. We will review how these feature additions have impacted the methods used for transforming, storing, and querying data so that you can evaluate whether it would be a good fit for your data environment.
The video is not available to view online.
How to improve Q&A in Power BI Laura Graham-Brown
In this session we will go through a number of techniques to get closer to that natural language that Q&A visuals offer.
The video is not available to view online.
Keeping historical data in tables forever – mission (im)possible! Margarita Naumova
Let’s discover some solutions for keeping historical data in the database when you receive near to impossible requirements like storing data in same tables forever and being able to edit and query them at the same time, of course keeping the response at its best. Based on a real project case the session walks you through the design process from the start to the reaching of the final solution and making the client (and developers) happy.
The video is not available to view online.
Lessons learned from optimizing enterprise data models Nikola Ilic
What should you do when DirectQuery is the ONLY available option? How to reduce the data model size, while at the same time satisfying business requirements? I'll share tips, tricks and workarounds learned and implemented in real-life scenarios on enterprise data models.
The video is not available to view online.
Lessons learned from refactoring multi terabyte databases for the last 10 years Sergey Olontsev
Database refactoring could be tricky sometimes. To learn more about it come to my session, where I will tell you about different situations and scenarios I've came across during the last 10 years. I will share my experience; traps, you easily can get into, and what solutions did I choose to come over it.
The video is not available to view online.
Make your data shine - Data storytelling with Power BI visual reports Madzy Stikkelorum
An introduction to the concepts of data storytelling, and how to apply these concepts in a Power BI Visual Report.
The video is not available to view online.
Model Creation in Azure AutoML and Ingestion Through Excel Lewis Prince
We will go through a brief introduction to what Machine Learning is and some of its applications. we will then explore why AutoML should be used by all; as a great starting point for anyone new to Machine Learning, as well as a time saving tool for those more experienced. Finally, we will expose a model as an endpoint and understand how we can use it. Specifically in this case how to use it in excel via VBA. Technologies I will demonstrate are: - Azure Machine Learning Studio - VS code (with Azure Machine Learning Studio extension) - Python - VBA
The video is not available to view online.
Never ETL again, thanks to Synapse Link. Really? Ben Weissman (he/him)
Let's take a look at Synapse Link - it's capabilities and restrictions! Synapse Link is Microsoft's new solution to push your OLTP data in near-real time to Azure Synapse for analytical purposes.
The video is not available to view online.
Power Automate 101 Alexander Klein
Microsoft Power Automate, previously Microsoft Flow, is cloud software that enables employees to create and automate workflows and tasks across multiple applications and services without the help of developers.
The video is not available to view online.
Power BI - Call REST API Iuliana Tuhasu
This session is a live demo on how to call a REST endpoint and parse the resultant JSON in Power BI.
The video is not available to view online.
Power BI Composite and Hybrid Models Alex Whittles
Take Power BI to the next level to support real-time and BIG data, and find out how hybrid and composite models can open up unlimited flexibility and scalability.
The video is not available to view online.
Power BI Datamart - What, How and Why? Marthe Moengen
In this short session, we will go through the what, how and why of Power BI Datamarts. What is this feature you can find in Power BI Service? How can you use it to model your data, improve control and enable self-service? Why should you use Power BI Datamarts?
The video is not available to view online.
Power BI Meets Programmability – TOM, XMLA, and C# Kristyna Hughes
Come and learn how to leverage C# to programmatically create and manage columns, measures, hierarchies, and translations within existing data models in Power BI using the XMLA endpoint. Happy coding!
The video is not available to view online.
Power BI Model Development Best Practices in a Team Mathias Thierbach
The session presents and explains the components required to establish a highly effective team developing Power BI models: Processes, Tools, Deployment Automation, and Documentation. Attendees will be able to take away plenty of proven ideas and patterns, including a source control based development model, a change management system using release pipelines, and a CI/CD setup providing automation at all possible stages. The key focus will be on the right processes to implement within the team.
The video is not available to view online.
Simplify your Data Models and your Life with Calculation Groups Shannon Lindsay
When you start noticing that you're duplicating the same DAX in lots of measures, calculation groups can come to the rescue. They may sound scary and complicated, but in this session we'll show you that they are really very approachable and incredibly useful. You'll learn what they are and how to create them and we'll explore key features and usage scenarios. Once you see how much they can simplify your life, you'll start looking for excuses to use calculation groups in all your models!
The video is not available to view online.
Supercharge Power BI Tooltips Reid Havens
Discover secrets of tooltip design in Power BI. Learn how to upgrade your tooltips with DAX, add dynamic charts to report page tooltips, and add design elements to information/help tooltips.
The video is not available to view online.
Supercharge Power BI with Azure Synapse Analytics Mathias Halkjaer
In this session we will cover how to architect an end-to-end enterpise analytics platform so that we utilize the best of both worlds. The extremely versatile ETL capabilities of Synapse and the powerful data modelling in Power BI.
The video is not available to view online.
Synapse Q&A with PG Mark Pryce-Maher
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.
The video is not available to view online.
The Metadata Driven Data Warehouse Ruth Pearson
Tired of writing the same old Insert/Update/Delete statements over and over? Is your pipelines folder overflowing? Need to get your new data warehouse up and running as fast as possible? Metadata (data about data) comes to the rescue and in this session we’ll show you how.
The video is not available to view online.
Thē wönderfűl wôrld of ćollåtions, eñcodingß and téxt sţoræge Mladen Prajdic
Once you get to talking or thinking about characters, collations, encodings, sort orders, diacritics, code pages, etc, a brain melt is what you end up with. In this session we'll look at what all of these things are, how they all fit together.
The video is not available to view online.
Using Automated ML models in Azure Synapse Analytics Anupama Natarajan
In this session, you will get to learn how to enrich your data in spark tables with models created using Automated ML in Azure Synapse Analytics. We will be looking at a demo where we will create regression and classification models using Automated ML and how to use these models for prediction in Azure Synapse Analytics.
The video is not available to view online.
What is the right database for you? Ajinkya Soitkar
How to design data strategy and choose the right database for modern cloud applications.
The video is not available to view online.
3 things you don’t want to store in a database (but sometimes have to) Gianluca Sartori
Some types of data are a very bad fit for a database. Join me to see how to survive with a database full of data that should not be stored there. I will demonstrate how to deal with billions of rows of logs without trashing the database, how to store millions of pictures effectively and how to deal with dynamic attributes in a sensible way.
About time: how to work with timeseries in Azure Benjamin Kettner
A guide to available services and solutions for timeseries data
Advanced data modeling with Power BI Marc Lelijveld
After understanding the basics, lets take the next step in data modeling in Power BI!
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them Nikola Ilic
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
An evening with Power BI CAT team Prathy Kamasani
SQL bits and London Power BI user group are brining a Q&A panel with some of Power BI CAT team members to ask everything about Power BI. Join us with your questions
The video is not available to view online.
An Introduction to Lambda Architectures Richard Munn
A short intro to Lambda Architectures - what they mean, what they are, and how you can use them in your solutions
The video is not available to view online.
Architectural blueprints for the Modern Data Warehouse Just Blindbæk
This session will walk you through three different ways to set up an affordable Azure based Data Warehouse solution. Covering pros and cons with each of the architectures.
AutoML: An Introduction To Get You Started Gavita Regunath
Understand how to get started with any machine learning project using Databricks AutoML
Azure Data Engineering services used to analyze data Kevin Chant
Overview to some of the more popular Azure Data Engineering services used to analyze data
Azure SQL Database - A true story journey from migration, through synchronization and beyond. Pieter Vanhove
You will be challenged with a case study to design a solution using Azure SQL Database capabilities. At the end of this session, you will better understand the possibilities to migrate on-premises databases to Azure SQL Database. You will learn how to synchronize data across different environments and get more insights on how to troubleshoot issues in Azure SQL Database. This is a hands-on, open discussions and team work kind of session (not a traditional slideshow).
The video is not available to view online.
Big data analytics with Power BI Christian Wade
Learn how to unlock massive datasets for interactive analysis, accelerating time to insight, and reducing TCO.
Complex access in Power BI with Row-Level Security Mathias Halkjaer
In this session, you will tag along the journey of working towards a solution to this problem. We will touch upon topics like automated workflows with Power Automate, Active Directory Security Groups, Decoupled Datasets and Security Tables, all combined with Row-Level Security to bring them all together.
The video is not available to view online.
Designing Data Visualisations that can be understood "in the blink of an eye" Adam Vero
"Don't force me to *think*!" - how to help people find insights in information more easily by making well-informed design decisions.
The video is not available to view online.
EDW Automation in Synapse SQL Pools Bob Duffy
DW Automation and Design Best Practices
How to model and partition data in a distributed NoSQL database for cloud scale Theo van Kraay
In this session we will take the relational data model for a simple e-commerce application and migrate it to a horizontally partitioned, NoSQL database. Along the way you will learn the concepts, techniques and technologies needed to model for a horizontally partitioned NoSQL database that will allow your application to achieve millisecond response times with near unlimited size and scalability.
The video is not available to view online.
Is HTAP the future? Scott Bell
Hybrid Transactional Analytical Processing solve the age old problem of integrating operational processes with analytical capabilities within a single system. Find out what they're and how they deliver value
Keeping your data fresh in Power BI Patrick LeBlanc
In this session you will learn how to keep you data up to date i Power BI.
Lessons Learned: Implementing Azure Synapse Analytics in a Rapidly-Changing Startup Cathrine Wilhelmsen
What happens when you mix one rapidly-changing startup, one data analyst, one data engineer, and one hypothesis that Azure Synapse Analytics could be the right tool of choice?
Looking under the hood of the parquet format André Kamman
Understanding how the parquet format works helps with understanding why it can help you retreive your data fast, or perhaps why you struggle to get the desired performance out of your design.
<<12>>