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!
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
Learn how to unlock massive datasets for interactive analysis, accelerating time to insight, and reducing TCO.
DW Automation and Design Best Practices
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.
SQL Server is a complete Machine Learning platform - learn a complete process to use it from data ingestion to model deployment.
We must realize that patterns which were valid 10 years ago are less likely to work now, like cursor logic, xml usage, or storing all in db v/s using NoSQL. From global industry trends to specific database patterns, this session is a combination of best practices, good and bad patterns, tips, and tricks which I give to customers in my work as a consultant.
Introduction of areas for partitioning for Beginners
Level up your Power BI capability by using calculation groups to simplify time intelligence (WTD, MTD, etc) and more
Take Power BI to the next level to support BIG data, as well as layering logic over the top of an existing cube or dataset for unlimited flexibility.
During this session, the core concepts of Power BI Dataflows will be explained, and we'll discuss how Power BI Dataflows could alleviate some of the specific problems you might be experiencing in your current architecture.
Building a dashboard using Serverless SQL Pools in a performant way