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.
<<1234>>