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.
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.
Learn how to create data types in Power BI and consume them in Excel
The video is not available to view online.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
How to design data strategy and choose the right database for modern cloud applications.
The video is not available to view online.
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.
A guide to available services and solutions for timeseries data
After understanding the basics, lets take the next step in data modeling in Power BI!
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!
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.
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.
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.
Understand how to get started with any machine learning project using Databricks AutoML
Overview to some of the more popular Azure Data Engineering services used to analyze data
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.
Learn how to unlock massive datasets for interactive analysis, accelerating time to insight, and reducing TCO.
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.
"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.
DW Automation and Design Best Practices
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.
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
In this session you will learn how to keep you data up to date i Power BI.
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?
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>>