Sessions List Part 2 is released. Total 100 Sessions. Part 3 will be released in August 1st Week.
Important Notes. Please Read Carefully.
- Sessions List Part 2 is released. Total 100 Sessions. Part 3 will be released in August 1st Week. In total DPS 2021 will have 120+ sessions.
- With 120+ sessions DPS 2021 is a focused learning event On Microsoft Data Platform, Advanced Analytics & Artificial Intelligence. DPS 2021 brings you the finest & latest content from world’s best trainers (Microsoft + MVPs + Industry Veterans).
- Data Platform Summit 2021 has multiple parallel tracks: Architecture, Database Administration, Database Development, Business Intelligence & Advanced Analytics, Data Science (AI/ML), Industry Solution and Professional Development
- There might be minor adjustments to the sessions, agenda & schedule without any prior notice.
- Errors/Corrections? Write to speakers[at]dataplatformgeeks.com
- Learn More about DPS 2021 Registration.
- The training classes of DPS (8 hrs online training) has limited seats. Learn more about Training Classes.
Sessions 100 of 150
| SessionType | SessionTitle | SpeakerName | Track | Abstract |
|---|---|---|---|---|
| Keynote | SQL Edge To Cloud | Bob Ward, Anna Hoffman, Buck Woody | Keynote | SQL is everywhere you need it from the IoT Edge to your data center to public clouds. With all of these options, it can be difficult to know which to choose and why each option may be right for your data needs. In this presentation, we'll review with you all the current released and preview versions of SQL from the edge to the cloud. We'll compare each of them and discuss why you want to get ahead of the curve by understanding what is possible with the modern SQL data platform. We'll discuss the technical details of some of these options so you can understand what SQL "flavor" fits your company's needs. This session will include some demos to highlight key innovations with SQL. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Getting Beyond the Basics with Azure Machine Learning | Kevin Feasel | Data Science (AI/ML) | Azure Machine Learning offers a low-code approach to performing machine learning tasks, but what happens when you need to do something a little more complex? In this talk, we will go beyond the Azure Machine Learning designer and show how to use Azure Machine Learning in a code-first environment. We will understand how the Pipeline metaphor works within code and use that to generate and deploy models, as well as writing outputs to locations such as an Azure SQL Database. For deployment, we will see the differences between batch and real-time inference. We will also review how Azure Machine Learning handles model registration and versioning. This talk assumes some basic familiarity with Azure Machine Learning and the Python language. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Building Event-Driven Microservices with the Azure Cosmos DB Change Feed | Leonard Lobel | Development | The change feed in Azure Cosmos DB is one of the most overlooked features of Microsofts globally distributed, massively scalable, multi-model database service. Similar to the transaction log of a relational database, the change feed gives you a continuous record of changes as they occur. It therefore serves as an excellent event source for a wide range of cloud-based microservices. In this demo-filled session aimed at developers and data professionals alike, youll learn how to leverage the change feed and build event-driven microservices with Azure Functions to achieve replication, denormalization, notifications, materialized views, and data archival. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Simplify data management with partitioning | Uwe Ricken | Development | The times of small database systems are now over. Even "small" systems already provide databases with several 100 GB data volume. It can be a real challenge for the DBA to complete the daily maintenance tasks, data backup, consistency checks, ... in a reasonable time frame. With the help of partitioning (also a feature of the Standard Edition since SQL 2016), considerable advantages in ETL processes, maintenance and backup / recovery can be achieved. The main area of application for partitioning is the optimization of the load paths for complex DWH solutions and the maintenance of large databases (statistics, indexes, backups, restores). The very strongly demo-based session shows partitioning scenarios that let the DBA do alternative things again and encourage ETL developers to dance the joys. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Monitoring SQL Server on Linux performance with Performance Co-Pilot and Grafana | Louis Imershein | Data Administration | Recent advancements in open source projects make it easier than ever to do much more than just basic performance monitoring of SQL Server on modern Linux systems. In this talk we'll look into two tools which have recently been enhanced to support SQL Server on Linux: Performance Co-Pilot (PCP), and Grafana. PCP is a lightweight system performance analysis toolkit. Metrics are provided to PCP through Performance Metric Domain Agents (PMDAs). The PMDAs provide special-purpose modules that allow PCP to collect a wide range of specialized metrics. Recently, a PMDA for SQL Server was introduced as well as an ansible playbook to deploy and configure the PMDA across multi-server Linux environments. While PCP is used to collect metrics, Grafana is the web-based open source tool to display performance graphs and notify you of the unexpected. The new SQL Server Performance Dashboard for Grafana displays not only SQL Server data, but also important Linux system graphs that you can use to identify trouble spots. By the time youre done with this talk youll understand: how to use PCP and Grafana to identify SQL Server on Linux performance problems and track down solutions. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Zero downtime database deployments | Alex Yates | Development | You understand that big bang deployments are painful, but each deploy may disrupt users, so you are restricted to tight deployment windows for your database. The consequences of missing your windows aren't worth thinking about - but it gets more difficult each time. In order to move to smaller, more frequent and more reliable deployments you need to demonstrate that you can safely deploy during business hours - without disrupting users. In this session we'll discuss the most popular strategies: Blue/Green and Canary deploys, Cluster Immune Systems and Feature Toggles. Then we'll discuss the fundamental changes that we need to make to the way we think about database "deployments" and "releases" in order to support these strategies. We will finish with a SQL Server demo that uses a feature flag and the expand/contract model to support backward compatibility and safe, fast rollback options. |
| Deep-Dives - 120 mins (105 mins + 15 mins Q&A) - Slides + Demos | Business Analysis with T-SQL | Dejan Sarka | Development | No matter if you use SQL Server on premises, Azure SQL Database, or Azure Synapse Analytics, you might have a feeling that the main language for these services, the T-SQL language, is somehow obsolete and not capable enough for the need of the modern analytics. This session will show you the opposite. You can make advanced business analytics also with T-SQL, you do not need to use R, Python, or some other currently fashionable language for every single in-depth view in your data. In addition, you can get magnitudes better performance inside a database management system when in statistical languages and engines. You will learn how to use T-SQL for queries that you might already be familiar with, for aggregating queries. But this is only to warm you up. Then you will learn how to do hazard and survival analysis, market basket analysis with association rules using different measures like support and confidence, and even sequential market basket analysis, when there is a sequence in the basket. Then the session introduces the look-alike model, which is a mixture of k-nearest neighbor and decision trees algorithms. The session finishes with Bayesian inference implemented with T-SQL. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Data Science Made Easier with Azure ML Studio & Power BI | Pragati Jain | Data Science (AI/ML) | In this session we will start with creating a simple predictive model in a no-code environment - Azure ML Studio. This will be further followed by connecting Power BI to this published prediction model and using it to generate output reports as results. The session will cover the following details: Start with creating a cluster in Azure ML Studio followed by importing a dataset and exploring the dataset Creating an Automated Machine Learning Run Deploying the best model Connecting Azure Machine Learning model to Power BI Creating a report with visualisations in Power BI Publishing and enabling automated dataset refresh Clean up Azure resources in the end |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | How to Audit SQL Server for Free | Josephine Bush | Data Administration | Are you tired of not knowing who's changing what on your SQL Servers? Maybe your company cant afford to buy third-party auditing tools, but there's no need to buy expensive auditing tools if you can't afford them or don't want to use them. You can know about everything changing on your SQL Servers without having to pay for a tool. By auditing with the built-in features of SQL Server Audit, you can report on usage to auditors, change user permissions or passwords without breaking functionality, and/or understand your workload to migrate parts or all of your database to the cloud or other database technologies. This session will help you understand how to use SQL Server Audit. You will also learn how to compile the results in a central location for easy reporting and learn how to email audit findings with a SQL Agent job. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | How to achieve the best performance and scalability on your Azure SQL Database using the Hyperscale | Vitor Fava | Architecture | In this session let's discuss Hyperscale, an Azure SQL Database tier that allows us to create a high-performance environment for OLTP intensive workload scenarios. We'll understand the architecture of Hyperscale and how we can create and configure the replicas to redirect any intensive report to avoid any issues on your production environment |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Insight Discovery - how to define business requirements for a successful cloud data & analytics project | James Broome | Business Intelligence & Advanced Analytics | Many data projects fail to deliver the impact they should for a simple reason - they focus on the data. In this session, James explains a different way of thinking that will set up your data & analytics projects for success. Using an iterative, action-oriented, insight discovery process, he will demonstrate tools and techniques that will help you to identify, define and prioritize requirements in your own projects so that they deliver maximum value. He'll also explore the synergy with modern cloud analytics platforms like Azure Synapse, explaining how the process and the architecture actively support each other for fast, impactful delivery. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | The ML Heros Secret Weapon: AutoML | Daron Yondem | Data Science (AI/ML) | If you are into development, you know that we love to automate things we don't want to do. Do you still want to work on training the same model over and over using different features or hyperparameters to preventing over-fitting? I did not think so. Let's see how AutoML can help you. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Querying Azure Log Analytics with Kusto | Paul Ou Yang | Data Administration | To detect performance anomalies, suspicious activity, or error patterns of your Azure resources such as Azure SQL, you dont need to be a Data Scientist, all you need is Azure Log Analytics and Kusto. In this session, you will learn how to configure your Azure resources to send data to an Azure Log Analytics workspace and leverage the built-in time-series and machine learning Kusto functions to detect changes in the behavior of your resources. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Power BI Performance - 7 deadly sins! | Nikola Ilic | Business Intelligence & Advanced Analytics | Congratulations! You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more... And, if you feel lost, I don't blame you - I've also been there! That's why this session is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering. We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | An Hour of SQL Server Big Data Clusters Demos | Bob Pusateri | Data Administration | Attend this session and gain a better understanding of the capabilities and use cases of SQL Server Big Data Clusters, a new feature in SQL Server 2019 that combines the SQL Server relational engine with HDFS and Spark. Through this all-demo session, you will see how to work with a SQL Server Big Data Cluster, and a variety of the tasks that can be easily performed on one. If you like to learn by observing instead of just looking at slides, this is the session for you! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Becoming a Person of Influence | Jason Hunt | Professional Development | We all want to live lives that matter, but just how do we make a positive difference? Some believe that you must have an impressive title to do so, but that is a mistake. The best leaders recognize that no matter where you are in the organization, you have influence - and intentionally using that influence to make a positive difference makes you a leader. This is a highly engaging and powerful session on leadership, breaking this complicated subject down into four simple components: A heart that cares, a head that connects, hands that collaborate, and feet that show courage. Whatever your vocation or aspiration, master these four and watch your influence lead to a greater positive impact in the lives of others - at home, at work, and in every other area of life. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Tips & Tricks for creating Paginated Reports based on Power BI datasets | Ferenc Csonka | Business Intelligence & Advanced Analytics | Power BI is a world-class BI and data analytics tool with stunning interactive data visualization features, but in many business use cases companies need to produce multi-page printouts from their Power BI reports on paper and/or send them in PDF/Excel format to their customers. Power BI Paginated Reports based on the matured and well-known SSRS (SQL Server Reporting Services) technologies can be created from existing Power BI datasets using the Power BI Report Builder tool and can be published to Power BI Service. The recently released PPU (Premium Per User) license and Power BI Embedded Gen2 will also help to have an increasing number of paginated reports in the Power BI ecosystem. Moreover, Paginated Reports visual in Power BI also helps and accelerates the implementation of paginated reports based on existing Power BI datasets. Therefore, in this session, we will present several tips & tricks how to create paginated reports using existing Power BI datasets available in the Power BI Service and also from your Power BI Desktop, how to reproduce the different Power BI visuals in a paginated report, how to create analytical lines in a paginated report, how to handle parameters, especially multi-value parameters in DAX queries, how to enable for the end-users to select which Power BI report pages should be included in the final printout, how to create printouts with portrait and landscape pages, etc. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Building a Production Environment for Azure Arc enabled Data Services | Chris ADKIN | Data Administration | Thinking of transforming your on-premises SQL Server estate to a farm of Azure Arc managed SQL Server instances ?, and you want the setup to be production grade, then this session is for you, it will cover Kubernetes distro options, storage plugin options, options for backup and restore, load balancing and everything that you need to consider in order to build a production grade environment. This session assumes that attendees will have a basic working knowledge of containers and Kubernetes. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure DevOps and Database Deployment Automation | Grant Fritchey | Data Administration | Automation is a fundamental aspect when adopting a DevOps-style deployment process. Learn how you can use Azure DevOps tools to automate your database deployments successfully. Topics include the challenge of supporting more than one database system, deployments in Azure SQL Database, Postgres and Maria DB. We'll also show how you can use Azure DevOps to deploy to an on-premises database. All the databases you have under management can have their deployments automated. Come to this session to learn how. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | No Code Custom Visuals in Charticulator | Mike Carlo | Business Intelligence & Advanced Analytics | Learn how to use the most advanced custom visual from the Microsoft team - Charticulator. A Long time fan and massive advocate for the Charticulator app Mike Carlo will guide you through how to use and build visuals within the Charticulator app. Learn how to make simple visuals all the way to highly complex and stylized versions. |
| Deep-Dives - 120 mins (105 mins + 15 mins Q&A) - Slides + Demos | Visualization Magic in the Age of Numbers & Science | Reid Havens | Business Intelligence & Advanced Analytics | Power BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you'll be able to leverage in your company's reports to take them to the next level. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Using clustered columnstore indexes efficently | Thomas Grohser | Data Administration | Clustered column stores are a great feature that if used correctly can save a lot of space and increase the performance of your reporting and analytical queries. But it needs do be designed and configured correctly and the data needs to be loaded in a certain way to make if effective. This session will demonstrate how to partition, model, select data types and insert data into a clustered column store and how to write queries to get the data out as efficient and quickly as possible. It will also tell you all the things you unfortunately can not (or should not) do with a clustered column store index. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Govern Power BI and the rest of your data estate with Azure Purview | Craig Bryden | Architecture | A modern data estate will consist of many different components. You could have a wide range a data services which may be Databases, Data Lakes, Power BI, and many more. Keeping track of what assets your organization has and exposing that to your stakeholders is not easy. Azure Purview is Microsoft's latest Data Catalog product that is going to help you discover, manage, and expose these assets to your users. Join Craig for a discussion on what Data Catalogs are, how Purview works, and how it will help you. |
| Deep-Dives - 120 mins (105 mins + 15 mins Q&A) - Slides + Demos | Now where did THAT estimate come from? | Hugo Kornelis | Development | The SQL Server Query Optimizer makes its plan choices based on estimated rowcounts. If those estimates are wrong, the optimizer will very likely produce a poor plan. And theres nothing you can do about it. Or is there? In this session, you will learn exactly where these estimates come from. You will gain intimate knowledge of how statistics are built and maintained and how they are used to estimate row counts. But you will also learn how filters and joins influence those estimates. Though the focus of this session is on understanding the causes of bad estimates, you will also learn ways to fix the problems and get better estimates and hence, better performing queries. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Bad Decisions Revealed: How our Emotional Brain Wins Over our Thinking Brain Every Single Time! | Tammy Guns | Professional Development | Do you ever wonder why supposedly smart people seem to make not so smart decisions? We are far more controlled by our emotional brain than our thinking brain. We all KNOW how to be at our ideal weight and yet few of us are able to maintain that goal. We all KNOW how to engage in behaviors that are supportive of our health and yet we fail to do so on a consistent basis. We all KNOW what to do in many areas of our life and how it benefits us, but we fail to take action. Why? We are actually incentivized to make bad decisions in the immediate time frame. This presentation will help uncover and demystify our curious behaviors that seem to be counterproductive to our desired goals. You wont want to miss out on these simple tips and tricks for a better future starting NOW! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Help!! My SQL Server database is not performing well! | Michelle Gutzait | Development | Too often you see database issues, especially as your databases grow. In this session, Michelle will talk about the main SQL Server Development Best Practices for optimized performance as well as remedies to resolve performance bottlenecks due to data growth. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Parallelism in Microsoft SQL Server | Torsten Strauss | Professional Development | SQL Server can execute queries in parallel which can sometimes improve the performance of your queries. However, parallelism has its own challenges; therefore, we will look at the concept of parallel executions to understand when it makes sense to run a query on more than one thread. We deal with topics such as CXPacket, threads, workers, execution context, branches, MAXDOP, Cost threshold for parallelism, NUMA nodes and the iterators that SQL Server can implement in the execution plan to enable parallelism. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Building a Data Lake with Azure Synapse Analytics | Warner Chaves | Business Intelligence & Advanced Analytics | Synapse Analytics is Microsoft Azure's premier data analytics service, combining the power of MPP warehousing, serverless execution, Spark and pipelines. With tight storage integration, flexible compute and massive scale, Synapse is a great platform to build an enterprise data lake and unlock the value of both structured and unstructured data. In this session we will focus on Synapse's capabilities to read and analyze raw data sitting in Azure Data Lake storage. We will cover best practices on how to organize your data lake, how to process the data and ways to expose this data to outside tools and consumers. |
| Deep-Dives - 120 mins (105 mins + 15 mins Q&A) - Slides + Demos | All You Wanted to Know About Collations | Erland Sommarskog | Development | Collations is a topic that tends to confuse SQL Server professionals. It is not that the implementation of collations in SQL Server is extremely confusing, but computer people are not always well versed in human languages and character encodings, and therefore it can be a big surprise that V and W could be considered equal or that i and I could be different in a case-insensitive comparison. In this light-minded presentation I cover what a collation controls and I explain what all the funny components in a collation name like Latin1_General_100_CI_AS_KS_WS_SC_UTF8 actually mean. I illustrate this by giving examples of how they work with different languages. I provide some tricks you can apply to overcome some traps related to collations. I give particular attention to the UTF-8 collations added in SQL 2019. Finally, I discuss how the choice of collations can affect performance. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Starting with Azure SQL Edge on Raspberry Pi | Hasan Savran | Industry Solution | Azure SQL Edge is a containerized application that runs on either an ARM64 or an x64-based processor. SQL Database Edge is optimized specifically for IoT and edge workloads running on resource-constrained interactive devices such as cameras, scanners, IoT gateways, and light-weight edge servers. You need to be familiar with many different technologies to make Azure SQL Edge work. We will start with the history of IOT and continue with available Azure IOT features you need to use to install Azure SQL Edge into an IOT device. We will explore Linux tools and command that you need to know to enable IOT functionalities of your device. Hasan will share his experience with installing and connecting Azure SQL Database Edge to Raspberry Pi. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Getting Started with Extended Events | Kathi Kellenberger | Data Administration | Over the years, many DBAs have avoided using Extended Events and continued using Trace. At first, this made sense because Extended Events had no user interface and you had to know XML to work with it. Eventually, Microsoft added a GUI, but many folks continued to use familiar tools. In this session learn how to transition from Trace to Extended Events. Youll find that its easy when you take the right approach. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Mastering Query Store | Deepthi Goguri | Data Administration | Are you facing performance issues due to the parameter sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query? Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature. Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sounds amazing, right? Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this Awesome feature! |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Docker Deep Dive | Andrew Pruski | Data Administration | Running SQL Server in a Docker container has many benefits (and drawbacks!) that we as SQL professionals should be aware of. In this demo heavy session we'll dive deeper into running SQL Server in Docker containers. We'll cover: - What exactly is container isolation? Container networking Persisting data for SQL Server in Docker containers Building custom SQL Docker images Running SQL containers with Docker Compose This session is for anyone who has run SQL Server in a container and wants to learn more about the platform |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Quicker, faster and easier Power BI datasets using Power BI Premium Per User/Premium | Gilbert Quevauvilliers | Business Intelligence & Advanced Analytics | ? In this presentation I will explain what Power BI Premium per user is and what is the difference between Power BI Premium. I will then go through and demonstrate the advantages with tips and tricks on how to use PPU for quicker, faster and easier deployments by using the new 3rd Party Tools. I will demonstrate the following tools and how they can enable you to do more in a shorter amount of time Tabular Editor ? Creating Measures ? Formatting of all DAX Measures ? Creating Calculation Groups ? And more ALM Toolkit ? Granular Deployment of new columns ? Granular deployment of new or existing measures ? Updating Power Query and deploying the changes. ? And more DAX Studio ? Creating measures to test ? Testing measure performance ? Understanding what is taking up memory in your dataset And more |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Serverless SQL Pool in Azure Synapse Analytics | Armando Lacerda | Business Intelligence & Advanced Analytics | Azure Synapse Analytics is a collection of data processing engines. In this session Armando Lacerda will demo how the Serverless SQL pool, which is part of Synapse Analytics, can be used with Power BI to implement data exploration on top of a data lake. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Serverless Azure data handling | Benjamin Kettner | Development | How can serverless services help you when building a data application in Azure? What serverless services exist and how do they align with the requirements of data applications? How can you use them and how do they interact? In this all-demo-session (1 slide only) we will show you how to build a data processing pipeline using serverless services. you will learn some details that will help you to build a modern datawarehouse in Azure or any other application that handles volumes of data. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | SQL Assessment - Microsoft's Best Practices Checker | Taiob Ali | Data Administration | Do you want to get the current 204 suggested best practices from the SQL Server Team and evaluate your environments? These best practices are available for all instances, from your Data Center to the cloud. In this all demo session (Yes, no slides), I will show you both the "what" and "how" to use the SQL assessment API. You will learn if a setting is changed after your initial check. How to customize your checks and create your own rules that fit your environments? The demo will use SQL assessment API, PowerShell cmdlets, and the new 'SQL Assessment' extension in Azure Data Studio to export assessment results in a SQL table and create an HTML report. At the end of this session, you will be equipped with the toolset to set up and run your own assessment, create customized rules, and determine your compliance score against suggested best practices. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | IoT Data: From Edge to Cloud - OPC/UA data Journey using Azure IoT Environment | Jorge Maia | Professional Developement | Come to a journey of the data from sensors, PLCs, and industrial hardware with OPC/UA, passing through transformation and filtering on the Edge, Its ingestion on the cloud, and finally presenting a Time Series model. In this session, you will see how to connect an Azure IoT Edge device to an OPC/UA server, subscribe to data, transform the payload to have a smooth path on IoT services in the cloud, and then present data as a Time Series on the Time Series Insights. After this presentation, you will understand the architecture of the solution that you will need to reproduce with a clear understanding of pitfalls and challenges. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Data Modelling in Azure Cosmos DB | Will Velida | Development | Modelling your data correctly is vital when building efficient applications that use Azure Cosmos DB. Proper data modelling allows us to easily scale our Cosmos DB resources as our applications grow. Many developers fall into the trap of thinking that just because Azure Cosmos DB is a NoSQL service, we don't need to spend time modelling our data. Lack of attention to proper data modelling in Azure Cosmos DB can lead to poor performing apps that can't scale and are expensive to run. In this session, we will cover: - Why you should model your data correctly for NoSQL databases and how this is different to relational data modelling. - When you would reference entities in NoSQL vs embedding entities in your documents. - How partitioning and collections factor in when modelling our data and how we can design our collections accordingly. By the end of this session, attendees will be empowered with data modelling techniques that they can use to build highly scalable and successfully applications that use Azure Cosmos DB. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | I Can See the Future! Forecasting from Scratch for Fun and Profit | Andy Parkerson | Business Intelligence & Advanced Analytics | Forecasting for many businesses is done more by gut feel than science. How much product to buy, how much revenue to expect, how many calls will come in -- these questions often are answered by some quick Excel formula that doesn't account for trends or seasonality. We will examine the Holt-Winters exponential triple smoothing (ETS) algorithm for forecasting, both for its excellent results and for its ease of implementation. We will also dive into optimization algorithms -- genetic, particle-swarm, and Nelder-Mead -- to best identify initial constants. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | EDW Automation and Design Best Practices | Bob Duffy | Business Intelligence & Advanced Analytics | Star schema can be very slow to develop an expensive to maintain. You need to add a column to a dimension or a new Fact table. Does that take hours, weeks, an entire development sprint, or is this just too expensive to even think about ? In this session we will recap good design best practices and demo how to use meta data to build an EDW which scores highly on Agility, Extensibility, Performance, Design Complexity, Conformity and Supportability using SQL Dedicated Pools in Synapse. Concepts are applicable to many other platforms too. Come along if you are a data Architect or Engineer looking to see how we build for and measure architectural principles such as agility and extensibility. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | From Report to Interactive Data Application with Power BI | Markus Ehrenmueller-Jensen | Business Intelligence & Advanced Analytics | Reports were yesterday data applications own the future! In this demo rich session you will learn how to leverage Power BI Desktops interactive features to transform your existing reports into highly interactive applications which allow the report user to discover the data in an easy way. You will learn about: Bookmarks, Drilling, Drill-through, Tooltips, What-if parameters and more! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | How to do Real-Time Analytics Using Apache Kafka and Azure Data Explorer | Neils Berglund | Development | The de facto standard for real-time event streaming is Apache Kafka, and a lot of businesses are streaming tons of data; business events, IoT/telemetry events, etc. The problem is how we can perform analytics and get business insight into the data we are streaming over Kafka. The answer to this is Azure Data Explorer (ADX). Azure Data Explorer is a fast, fully managed data analytics service for real-time analysis on large volumes of data streaming from applications, websites, IoT devices, and more. It is a big-data analytics database that allows ingestion of event streams from, among others, Apache Kafka. In this "demo-heavy" session, we see how we stream event data from Apache Kafka (running on Confluent Cloud in Azure) into Azure Data Explorer. Some of the topics we cover: * Overview of Apache Kafka and Confluent Cloud. * Introduction to Azure Data Explorer. * Ingestion of data from Kafka into ADX. * Analyse ingested data in ADX. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Training a ChatBot to Success | Ruma Mukherjee | Data Science (AI/ML) | Chatbots have the potential to support customer interactions with significantly better coverage, availability and responsiveness at much lower cost. However, in real life, introduction of chatbots in any new industry or domain is often not smooth and seamless. The primary reason is that customers have been habituated to speaking with human staff and expect similar levels of engagement and warmth. Fluid conversational styles and personalized interactions are often not demonstrated by most chatbots and this leads to disruption and customer dissatisfaction. A smooth human to machine transition is thus a critically important goal for designers of a chatbot. The biggest challenge that needs to be tackled by chatbot designers is the accurate and effective determination of user intents by understanding user messages. Chatbot builders use various techniques to gather, curate and even generate example conversations that are used for training. But these are typically seen to fall short in their ability to capture the wide diversity of human communication. The most common issues are as follows :- i) Sparsity and skewness of data with regard to the wide variety of intents and their disambiguation ii) Inability to handle new topics and new interaction styles aka cold start ii) Ineffective generation of training data to compensate for i) and ii) The talk will involve the use of automation and advanced NLP and Search techniques to overcome some of the above limitations and thus evolve chatbots to more meaningful conversational AI. Effective tools and techniques such as social and multimode learning, feedback learning, crowd sourcing, historical data and knowledge base search, data augmentation, resolution for unbalanced classes, multibots will be discussed and their role in training for enhanced conversation experience will be covered. The author will bring in valuable insights derived from her rich experience in building multiple chatbots in her profession. She will talk about the common pitfalls to avoid as part of chatbot training and offer tips for optimal leverage of available training data. She will illustrate effective techniqiues that have been adopted in practice across organizations for delivering state-of-the-art chatbots in production environments. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | The Data Talks Back: Speech & Language AI for the Data Professional | Matt Gordon | Data Science (AI/ML) | AI is, was, and will be a part of our world for a long time to come. The Speech and Language areas of Azure Cognitive Services provide powerful opportunities for data professionals to enable richer reporting, create chatbots to answer repetitive questions, or just bolster their resume for their next job. Even though my day-to-day job is a DBA/Data Architect, I've worked with these AI technologies for years to provide instant information to my employees, enable richer interactions on internal and external websites, and easily localize apps and documentation to local languages. Want to know more about AI and how it can help you? Attend this session. Want to know more about AI and how it can help you level up in your career? Attend this session. Want to know more about how much fun it is to play with Language and Speech in Cognitive Services? Attend this session. Let's kickoff your AI journey together! |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Data Lakehouse Architecture with Azure Synapse Analytics | David Alzamendi | Architecture | What are Data Lakehouses? When and why should you use this design pattern? How are they different from Data Warehouses? This session will answer these questions and expand on how new architecture design patterns can help you solve some of your business problems and prepare for the future. You may have heard about Data Lakes and data warehouses, but as technology evolves, there are new design patterns like Data Lakehouses that you should take into account when building data solutions. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Power BI: Modernizing Obsolete Semantic Models | Thimantha Vidanagamage | Business Intelligence & Advanced Analytics | Are you an owner of a semantic model which was developed before Power BI dataflows were introduced? It is time to modernize your semantic model by integrating dataflows. In this lightning talk, I will take you through the process of integrating dataflows into your existing Power BI semantic models. By the end of the session, you will have an understanding on how to modernize your existing semantic models in Power BI by integrating dataflows. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Power BI Universe - Mapping the hive | Tom Martens | Business Intelligence & Advanced Analytics | In this session, an Azure-based solution will be created that maps your Power BI tenant. This solution, of course, also contains a Power BI report that is part of this solution, allows you to see the data sources that are fueling your datasets, how many workspaces exist, and a lot more. This solution uses Power Shell, Azure Automation, Power BI Rest APIs, and some Azure-based storage. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Why Data Governance is important and how you can start immediately with Azure Purview | Wolfgang Strasser | Architecture | Collecting data is one part of the story. To know your data estate is another part. Let's see how Azure Purview can help you to manage and govern your data estate and bring it to another level. No matter if the data resides in a database, SAP, Power BI or a datalake - Azure Purview can scan and help you classify your data estate. Join this session if you want to know how Azure Purview can be a solid part of your data cataloging strategy and how easy it is to start with your Azure Purview environment. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Enough of the Azure Pipeline GUI demos for Data Platform deployments | Kevin Chant & Sander Stad | Development | I'm sure plenty of you have being there before. Hoping to see some YAML being used for real-life scenarios CI/CD deployments in Azure DevOps, only for the demos shown to be GUI based using the Classic Editor. Well fear not, for in this session we will cover how to use YAML in Azure DevOps for your CI/CD deployments. In this advanced session we will show you how to use YAML for Microsoft Data Platform deployments. Aimed mostly at SQL Server related services, including SQL Server and Azure Synapse SQL Pools. Along the way well also cover other topics like PowerShell and Containers. You will see a reasonable amount of YAML in this session, which is why we class this session as a borderline expert/brain-hurting one. You might want to bring along pen and paper to take down some notes and help with muscle memory, or at least bring something electronic to enter notes in. We will show you demos for some real-life scenarios, including Unit Testing for both SQL Server and Azure Synapse SQL Pools. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Vision in Microsoft Azure Cognitive Services | Andreas Erben | Data Science (AI/ML) | Microsoft Azure Cognitive Services offers various commoditized yet powerful and sophisticated services to work with visual content through Computer Vision. Currently those services can - detect and recognize Faces, - classify images or find objects in an image - run spatial analytics on video, - understand rich information in an image, - process whole videos and get insights from the video - recognize handwriting and ink in applications - provide OCR (Optical Character Recognition) on documents - automatically parse a scan of a paper form. This fast paced session will introduce the currently available set of services and explain through sample code and demonstrations how to use them. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure Data Factory for Beginners: Let's Make some Data | Leslie Andrews | Development | Does Azure Data Factory really make data? Of course not, but what it does is allow you to make your data into something new and different! In this presentation you will learn the basics of Azure Data Factory, what it DOES do, the sections of the “factory”, and how to build a basic factory output. You will learn the basic skills of a Data Factory “machinist” and how to rebuild your data. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Automated provisioning of SQL Server VMs on Azure | Kay Sauter | Development | If you need to have an (almost) fully automated deployment of a SQL Server VM including restoring databases and installations of needed software on Microsoft Azure, this PowerShell demo shows how. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Benefits of Installing IaaS Agent Extension on Azure SQL VM | Ameena Lalani | Data Administration | SQL Server IaaS Agent Extension, formerly known as Resource Provider, enables additional management capabilities for self-installed SQL Server on Azure VMs. It provides PaaS-like capabilities to IaaS-based SQL for customers who adopt it. During this session, I will demonstrate some of the unique benefits of the SQL IaaS extension that will help you discover, manage and administer your SQL Servers in Azure VM. This is what you are going to learn in this session. 1. What is IaaS? 2. What is IaaS Agent Extension? 3. What are the Benefits of enabling this extension? 4. How to enable and disable this extension? |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure Arc enabled data services | Dinakar Nethi | Data Administration | This session will cover Microsoft's latest offering in the Hybrid space - Azure Arc. Come find out what is Azure Arc enabled data services, what is the value proposition, what is the benefit for customers, what does the architecture look like, etc. There will be demos! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Data Replication in Azure SQL and Beyond | Alain Dormehl; Mara Steiu | Data Administration | This session will cover data replication technologies such as CDC (with a focus on CDC in SQL DB), SQL Data Sync, transactional replication, and more. The topics covered will include common use cases, benefits/limitations, demos for each of the products covered. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Let's talk Monitoring ! | Alain Dormehl; Anna Hoffman | Architecture | Come and learn from Anna and Alain, and maybe some special guests, about the latest Microsoft monitoring features for SQL. We will walk through the current product landscape, explain the current options, talk about the best options for customers, current industry trends and even look at some of the roadmap items for monitoring. This will be a session jam packed with demos and some really great features ! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Latest Access Control enhancements in Azure SQL | Andreas Wolter | Data Administration | Learn about the latest enhancements in the authentication and authorization space for Azure SQL that help you adhere to the Principle of Least Privilege when granting access to Database resources, and how to do it in a scalable way. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure SQL Database High availability & Disaster recovery | Roberto Bustos Emily Lisa | Data Administration | This session will dive into Azure SQL Database High Availability and Disaster Recovery features including zone redundancy and geo replication. Come and share your expertise and feedback directly with the engineering team while also learning about the latest in HA/DR for Azure SQL Database. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | What's new in Azure's path to an Intelligent Database | Pedro Lopes | Development | Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale, while remaining adaptive to the constantly changing world of data! Now join us to find about what's coming in this new intelligent database world! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Protecting your data from tampering with Azure SQL Database ledger | Jason Anderson | Data Administration | How can you rely on your business critical data if you can't ensure that it has not been tampered with? Blockchain has been a destination for many customers who want data immutability, but blockchain is targeted at decentralized multi-party business processes. How do you get the immutability benefits blockchain offers if your system is centralized? Azure SQL Database ledger is a new capability that uses the same cryptographic patterns employed in blockchains to protect your data from tampering. Join this session to understand how the ledger feature works, and how you can use it to build the digital trust you need in your data. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | SQL Server on Azure Virtual Machines Reimagined: Overview | Pam Lahoud David Pless Aditya Badramraju | Data Administration | Running SQL Server in an Azure virtual machine gives you the same capabilities and experience you are used to with on-premises SQL Server, plus the additional ease of use and management benefits available only on Azure. In this session, we will discuss the SQL Server in Azure VM experience, including some new features of the SQL Server IaaS Extension that help you optimize cost, enhance security, improve manageability and increase uptime for your SQL Servers in Azure. Expect a focused session on best practices and proven methods to get the most out of your Azure SQL VM experience. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | SQL Server on Azure Virtual Machines Reimagined: Sizing Deep Dive | Pam Lahoud David Pless Aditya Badramraju | Data Administration | Typically, you choose a VM when your application requires more control over the computing environment than the other platform-as-a-service options offer. This can be due to vendor requirements, familiarity with virtualization, ease of migration and other scenarios. When selecting a virtual machine to host your SQL Server workload in Azure, you need to choose a virtual machine size that provides optimal performance and fits your organization’s budget. In this session, we will cover topics such as the different virtual machine types that are most appropriate for SQL Server workloads, optimal memory-to-core ratios for various workload types, and features unique to Azure such as write acceleration that can help boost your performance without breaking the bank. We will also cover the Azure Virtual Machine naming conventions and how you can quickly identify a given machines capabilities from the virtual machine series name. We will close out the discussion with a review of virtual machine disks and storage limits that will be a precursor to the next deep dive session on Azure SQL VM storage. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | SQL Server on Azure Virtual Machines Reimagined: Storage Deep Dive | Pam Lahoud David Pless Aditya Badramraju | Data Administration | Optimizing Virtual Machine storage is one of the most critical areas to master when considering a migration to Azure SQL Virtual Machine. Azure virtual machines have input/output operations per second (IOPS) and throughput performance limits based on the virtual machine type and size. Additionally, OS disks and data disks will have their own IOPS and throughput limits. Workloads can be limited at either the virtual machine or the disk level. In this session we demystify storage and how VM sizing will impact performance limits. We will cover what you should consider when choosing Azure disks and storage pool configurations. We will discuss Storage Spaces and Storage Pools. We will also simplify the correct block level, interleave, and the NumberofColumns settings necessary for an optimized storage configuration. Finally, we will review how to monitor IOPs and throughput limits of your virtual machine, the underlying disks, and the caching capabilities of the ephemeral disks and the storage cache. Get ready, this is one of the most important sessions to get the best performance out of your Azure virtual machine deployment! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Notebooks deep dive session | Julie Koesmarno Alan Yu | Data Administration | In this session, we will cover lessons learned during our journey in using Azure Data Studio Notebooks internally in SQL org and what it means for external customers. We’ll cover executable and automatable Troubleshooting Guides (TSGs aka. Playbook/Run Book) for external customers and internal customers. Finally, we’ll show you recent Notebook features/improvements in Azure Data Studio based on these lessons learned. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Protect your SQL assets anywhere with Azure Defender for SQL | David Trigano Michael Makhlevich | Data Administration | SQL assets are critical resources and contain the most precious information a company owns, which makes them one of the preferred target for attackers. Protecting them across the environments can be challenging and requires multiple skills to deploy, manage, and remediate those precious resources. In this session, you will learn how Azure Defender for SQL protects your SQL anywhere, and offers capabilities to discover misconfigurations and raise alerts in case of usual activities across every flavor or SQL you are using today, in any environment. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Inside Azure SQL Managed Instance | Bob Ward Niko Neugebauer | Data Administration | SQL Server professionals are looking to modernize all aspects of their data platform. Azure SQL Managed Instance is a fully managed database service for those looking to modernize SQL Server in the cloud. Azure SQL Managed Instance includes almost the complete surface area of a SQL Server instance but saves you time and effort with a versionless server and powerful built-in HADR capabilities. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | What’s new in Azure SQL | Anna Hoffman | Data Administration | If you want to get started quickly with Azure SQL Managed Instance, this session is for you including demonstrations and resources to accelerate your journey for SQL in the cloud. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Develop serverless, full stack apps with Azure SQL | Anna Hoffman | Development | Learn how to create, build, and deploy modern full stack applications in Azure by using the language of your choice (Python, Node.js, or .NET) and with a Vue.js frontend. Topics covered include modern database capabilities, CI/CD and DevOps, backend API development, REST, and more. Using a real-world scenario of trying to catch the bus, you will learn how to build and architect solutions that use Azure SQL Database, Azure Functions, Azure Static Web Apps, Logic Apps, Visual Studio Code, and GitHub Actions. |
| Demo-Only - 60 mins (45 mins + 15 mins Q&A) - Demos Only (max one slide) | Azure SQL Edge : Real-time analysis of IoT Data | Sourabh Agarwal, Vasiya Krishnan | Data Administration | In this session, we will be designing an end to end IoT solution for real time data analysis. This is a demo-only session where we will take you from 1. Setting up the sensors 2. Streaming the data from sensors to the Azure SQL Edge module 3. Conducting real-time analysis using the Time-series/AI/ML features in Azure SQL Edge 4.Data visualization and managing Azure SQL Edge across multiple devices |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | What's new with Azure Data Factory | Wee Hyong Tok Linda Wang | Business Intelligence & Advanced Analytics | Azure Data Factory is Azure's cloud ETL service for scale-out serverless data integration and data transformation. It offers a code-free UI for intuitive authoring and single-pane-of-glass monitoring and management. You can also lift and shift existing SSIS packages to Azure and run them with full compatibility in ADF. In this session, you'll learn what's news with Azure Data Factory, and resources to help you get started, and be productive with ADF. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Inside Serverless SQL pools in Azure Synapse Analytics | Bob Ward; Anshul Rampal | Architecture | Azure Synapse Analytics is the first unified, cloud native platform for converged analytics. As a cloud data warehouse, Synapse provides traditional warehouse capabilities but evolves this feature set to include big data processing and data integration in a single cloud service. Synapse SQL is the ability to do T-SQL based analytics in Synapse workspace. As part of this capability, Synapse supports serverless SQL pools. In this session, we will dive into how Serverless SQL pools let you use SQL without having to reserve capacity. You will learn how Serverless SQL pools work, how you can use the familiar T-SQL language to query data lake assets, and Serverless SQL pools use a distributed data processing system, built for large-scale data and computational functions. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Near Real Time Data Analytics with ADF | Sunil Sabat | Business Intelligence & Advanced Analytics | This session will cover how ADF can be used to orchestrate twitter data ingestion with EventHubs and perform PoweBI lead analytics in realtime. We will also cover how Tweeter data can be shaped with Synapse Warehouse to deliver enterprise analytics at scale, all on the foundation of Azure Data Factory. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | New Enterprise-Friendly Features for SSIS in Azure Data Factory | Sandy Winarko | Business Intelligence & Advanced Analytics | This session will cover new enterprise-friendly features for SQL Server Integration Services (SSIS) in Azure Data Factory (ADF), such as express virtual network (VNet) injection, dual standby SSIS integration runtime (IR) pair for business continuity & disaster recovery (BCDR), Azure Monitor/Purview integrations, SSIS DevOps tools for continuous integration & continuous delivery (CI/CD), Azure-enabled SQL Server Data Tools (SSDT) to assess/test/migrate SSIS packages, ADF templates to run SQL/any process anywhere in 3 easy steps, etc. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Unified Data Governance with Azure Purview | Gaurav Malhotra | Business Intelligence & Advanced Analytics | Azure Purview is a unified data governance service that helps you manage and govern your on-premises, multicloud, and software-as-a-service (SaaS) data. Easily create a holistic, up-to-date map of your data landscape with automated data discovery, sensitive data classification, and end-to-end data lineage. Empower data consumers to find valuable, trustworthy data. During this we will showcase the power of Azure Purview as a unified data governance service. Both existing capabilities and roadmap items will be discussed. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure Synapse Analytics: Overview, Updates, & Roadmap | Saveen Reddy | Business Intelligence & Advanced Analytics | Azure Synapse Analytics become generally available in December 2020. Since then we've seen tremendous growth in usage and interest in using it to deliver enterprise analytics. At the same time, Azure Synapse is delivering more and more capabilities that help make it a one-stop solution for analytics. The volume of the service, dive deep into the latest key capabilities, and explore the roadmap of what's coming and what is top-of-mind for the Synapse engineering team. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure SQL readiness assessment and migration from Azure Data Studio | Mohamed Kabiruddin; Rajesh Setlem | Data Administration | In this session we will walk you through database assessment and migration using Azure Data Studio that will assist in seamlessly migrating your SQL Server databases to Azure SQL. The session will guide you through migration process on how to determine readiness of your SQL Server instances, identify a recommended target, and complete the migration to Azure SQL using Azure Data Studio. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Discover, assess Azure SQL readiness of SQL Server data estate at scale using Azure Migrate service | Raj Pochiraju Ajay Jagannadhan | Data Administration | Come and join our latest Azure Migrate innovations, a seamless discovery and assessment of your SQL Server data estate at scale. Learn how Microsoft makes your migration and modernization decision making easy by providing the target Azure SQL deployment option and sizing recommendations using Azure Migrate. You can also get the monthly pricing estimates migrating to Azure SQL. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Database Modernization Best Practices & Lessons Harvested from Customer Engagements | Raj Pochiraju Mukesh Kumar | Data Administration | In this session you’ll learn the real-world ins-and-outs of how we successfully migrate customers to Azure data platform. You learn, customer migration patterns, FUDs, IP & migration tools that worked in our customer migrations and modernization engagements. We also share few recent customer evidence, what worked and not. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Modernize your Oracle workloads to Azure SQL | Alexandra Ciortea | Data Administration | Are you looking to leave Oracle behind? Join us to find out how to accelerate the migration journey by automating Oracle migrations to SQL Server using 1st party tools as SQL Server Migration Assistant and Data Access Migration Tool |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Inside the Memory of SQL | Bob Ward | Data Administration | This will be the brain melting session for the event. In this session I'll describe how SQL Server memory management works including architecture, limits, and how you can configure and monitor memory usage. I'll also describe differences in memory management for SQL Server on Linux and Azure SQL. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | What's New in SQL Tools for Developers | Drew Skwiers-Koballa Alan Yu | Development | With the growth of cross platform environments and DevOps for databases, now is a great time to learn about database development in Azure Data Studio and VS Code. Learn the latest updates to the tooling features for developers working with SQL Server in this demo-heavy session presented by the team that is creating these features, covering SQL Projects, Azure Data Studio, SqlPackage, VSCode and more. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | SQL Server on Linux- Deployments made easy! | Amit Khandelwal | Data Administration | This is going to be a fast paced demo filled session, where we spend time on how you can automate the SQL Server deployments across Azure Linux VMs. We also will talk about how we can configure the SQL Server HA on Azure Linux VMs, key aspect of how you can rotate keytabs for AD authentication and if time permits we will bind all this together with a monitoring solution all this in 60 min, so fasten your seatbelts and enjoy! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | SQL Stateful Containers on Kubernetes with Helm! | Amit Khandelwal | Data Administration | SQL Server is a stateful application and hence should be deployed as a stateful set. In this session, we look at the helm method of installing multiple instances of SQL Server as stateful deployments, look at the recommendations and best practices when running SQL Server on containers for production environment. After this session, you can go ahead and look to take the next step towards modernization of your data estate via SQL containers! |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Modern SQL Server Storage & Hardware Solutions | Brian Carrig | Data Administration | The wealth of hardware and storage solutions available for SQL Server has evolved considerably in recent years. In this session we will provide an overview of the latest hardware available to the DBA, Developer or Systems Administrator with respect to compute, storage and memory, as well as how to design high-performance systems for SQL Server for a number of different budgets and workloads. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Designing and benchmarking SQL Server for high-performance Key-Value (KV) "NoSQL" workloads | Brian Carrig | Data Administration | Contrary to popular misconception, SQL Server can make an excellent platform for a highly scalable, high performance NoSQL alternative, catering for Key-Value Store (KVS) workloads, prevalent in microservices architectures or cloud native applications. In this session we describe how to go about designing, testing and benchmarking SQL Server as a database platform for a simple JSON-based Key Value Store (KVS). We then see how SQL Server stacks up against commonly chosen NoSQL alternatives like Redis, MongoDB, Yugabyte, as well as PostgreSQL and MariaDB. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Understanding and designing HA/DR solutions in SQL Server | Kevin Farlee | Data Administration | Learn the fundamentals of HA/DR in SQL Server. Understand what solutions work best where, and what the tradeoffs are. Understanding how the HA/DR solutions work will enable you to make better choices for your systems, both in terms of protecting your data and in terms of protecting your bottom line by not paying for solutions that don't help your situation. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Learn why you should run your open-source database workloads on Azure | Sunil Kamath | Data Administration | Over three years ago, we listened to our customers and launched several managed open-source database services in Azure. Over time, we have introduced many innovations and capabilities, helping tens of thousands of customers with fully managed MariaDB, MySQL, and PostgreSQL. During this session, we will talk about these innovations and demonstrate what makes Azure the best place to run your open-source database workloads. We will also show you what you can get from our unique capabilities such as Advanced Enterprise Security, Intelligent DB and from running Azure open-source database engines on any infrastructures (including your data centers and other public clouds) with Azure Arc. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Migrate Your MySQL and PostgreSQL Databases to Azure | Arun Thiagarajan | Data Administration | Ever wondered what it takes to migrate your existing Open-Source Database workloads to Azure? Azure offers a fully managed PostgreSQL, MySQL which provides maximum flexibility including, zone redundant high availability, AI powered performance optimization and enterprise-grade security and compliance. In this session, we will cover – 1. The benefits of migrating your MySQL and PostgreSQL databases to Azure; and 2. The benefits of migrating your Oracle workloads to Azure Database for PostgreSQL. We will show you various migration tools to make this journey easy, discuss tip/tricks we have learnt from helping customers migrate 1000s of workloads into Azure and showcase some technical demos to visualize the migration journey. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Modernize your open-source database workloads with Flexible Server for the Azure Database for Postgres and MySQL | Sridhar Ranganathan, Bashar Hussein | Data Administration | Your feedback shaped the new Flexible Server for Azure Database for PostgreSQL and MySQL managed service. Flexible Server allows you to gain operational efficiency, and yet more importantly, not give up control of your database. In this session you will learn how the new Flexible Server gives you full control of choosing your configuration, reduces cost, automates maintenance – all with flexible high availability options for your databases. You will also learn about the migration tools that can transition your data to cloud with minimal downtime. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Learn how to bring the best of open-source Postgres from Azure to your datacenter and other public clouds | Jean-Yves Devant | Data Administration | You need to meet regulatory requirements like data residency and customer control, and yet, you would like to use Azure open source database engines? You are using a public cloud other than Azure and yet, you would like to use Azure open source database engines? You can't go to the Azure cloud so you'd want that the Azure cloud to come to you? You would like to manage Postgres simply on any infrastructure? You would like build Postgres applications at an unprecedented level of scale and performance? Then attend this session and learn about Azure Arc enabled Postgres Hyperscale and try it. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | PowerBI Vision, strategy and roadmap | Patrick LeBlanc | Business Intelligence & Advanced Analytics | Power BI is helping organizations large and small, drive a data culture. We will cover our vision and roadmap. You will learn how AI automatically finds patterns in your data, you will learn about how Power BI is built into Teams and Excel to enable incredible collaboration experiences, and how Power BI with Synapse and other Microsoft technologies meets your most demanding needs. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Designing for high performance in Power BI | Siva Harinath; Philip Seamark | Business Intelligence & Advanced Analytics | It's so easy to get started with Microsoft Power BI Desktop and get immediate value. Power BI is a feature-rich platform with many advanced capabilities. However, as solution complexity grows, with this great power comes great responsibility. It's important to carefully consider how your datasets and reports are going to be deployed and consumed so that they perform at scale and save you from future pains. In this session we address common pitfalls and cover top tips to get great performance across the entire platform - from sourcing data to designing reports and dashboards. Bonus material - special considerations for Power BI Premium. Key Learning: Understand what features of Power BI based on business needs and performance implications. Demos: Most of the content will be presentation and guidance. |
| Deep-Dives - 120 mins (105 mins + 15 mins Q&A) - Slides + Demos | 10 superb tips about Azure Data Factory | Abhishek Narain | Business Intelligence & Advanced Analytics | Learn how to build enterprise-grade data pipelines using Azure Data Factory. We will run through 10 data engineering best practices which will help you build scalable and secure data pipelines. Some of the areas that we will cover are – pipeline architecture patterns, pipeline deployments, performance, governance, security, collaboration, logging and monitoring. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Scaling database workloads with Azure SQL Hyperscale | Denzil Ribeiro | Data Administration | Azure SQL Hyperscale, the innovative architecture of Azure SQL Database, provides applications with scale and availability needed from a cloud database. In this session, we will discuss Hyperscale architecture, including new scalability improvements in the platform. We will also discuss recently released and upcoming features, and cover Hyperscale-specific diagnostics that help gain insights into system performance. |
| Lightning Talk – 20 mins (15 mins + 5 mins Q&A) – Slides and/or Demos – whatever, something lightning 🙂 | Run Microsoft Azure Arc enabled data services anywhere | Bapi Chakraborty | Architecture | This lightening talk (with a short demo) will focus on Architecture and solutions made possible by Azure Arc enabled data services anywhere. With latest innovation, we are now able to run always updated, scalable, Azure data services on any infrastructure. With Azure Arc, any enterprise can deploy Azure SQL Managed Instance or PostgreSQL (with hyperscale) to supported Kubernetes infrastructure whether on-premises, on any cloud or at the edge. This also includes unified & at scale management and always updated services. |
| Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos | Implementing a green recovery: How Data Science is central to your Sustainability goals | Rishabh Gaur | Industry Solution | Modern buildings contain complex mechanical devices, sophisticated control systems, and a suite of features to improve the energy blueprint. As businesses and consumers adjust to life in this ‘new normal, it’s clear that implementing a ‘green recovery’ is vital to ensuring that Sustainability is central to every business. With the right guidance and solutions, businesses can put initiatives in place to improve their sites’ energy efficiency and reduce their carbon footprint. We will look at how organizations can look at data as a new frontier on their Sustainability journey to proactively limit their carbon footprint. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Azure Function for Everyone. | Alpa Buddhabhatti | Development | In this session, we will provide you with an overview of Azure Function. Azure Function is a fully managed serverless integration service. A use case with Azure Function and Azure Blob Storage and Azure Key Vault will be used for a demo. You’ll also learn about Continuous Integration and Continuous Delivery of Azure Function objects using Azure DevOps Pipelines. At the end of this session, you’ll have a basic understanding of both Azure Function and Azure DevOps. You can apply these ideas to event driven scenarios and the automation of Azure Function pipelines. I tried to make it more personal by using “you” instead of attendee. I also explained what ADF is in one sentence, so that readers who’ve never heard of ADF have some idea what it does. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure Synapse Analytics: AI, Synapse Link, and Microsoft Business Applications | Josh Caplan | Business Intelligence & Advanced Analytics | Azure Synapse Analytics is meant to help data engineers and data scientists work with data to transform their businesses. In this session you'll see the latest in how Synapse gives superpowers to these users to work with the data in their enterprise and use Synapse to operationalize machine learning at scale. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Azure Databricks for AI and Analytics | Bhanu Prakash | Business Intelligence & Advanced Analytics | Azure Databricks brings a premium Spark Engine to unlock insights go enterprises. In this session, we'll provide an overview of Azure Databricks and some of the latest developments in Spark that will accelerate your analytics workloads and time to insight. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Fast GDPR compliance | Yuli Stremovsky | Industry Solution | Privacy by design compliance is a challenging task for most startups. It is better to build it from the first steps of the product. Otherwise, you will have to add privacy to an already developed product. It is much more complicated and much more expensive. In this session, I am going to deep dive into a Databunker. Databunker is a Swiss army knife tool for storing personal records or PII. Databunker is an open-source, network-based, self-hosted, GDPR compliant, secure storage for personal data. This product can streamline GDPR compliance. |
| Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos | Azure Database for MYSQL – Flexible Server | Sravani Saluru | Data Administration | Azure Database for MySQL – Flexible Server is a fully managed MySQL database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability. In this session we will cover Overview of Single and Flexible Server for MYSQL Azure DB Performance Monitoring & Security High Availability & Disaster Recovery Migration strategies Q&A |
| Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos | Enterprise data governance with Azure Purview | Richard Conway | Architecture | In this session Richard Conway will talk about how to build an enterprise data governance strategy with Azure Purview. He will describing patterns and practices of data governance and how to use features of Azure Purview within complex Hub and Spoke cloud network topologies. Richard will consider the gap in the current Purview offering and how to fill the gap. There will be fast paced demos showing Azure Purview setup, Purview automation and usages of the Apache Atlas API to get catalogue information. Richard will show how to integrate Purview into pre-existing Azure Data Platform and Cloud Data Warehouse deployments that have built using Azure Data Factory, Azure Databricks and Azure Synapse. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Remote Work and Certifications | Oluwaseyi Oluwawumiju | Professional Development | The session will take a dive into the new Role base certification and its effect and how we can align it with remote jobs. |
| Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos | Azure MLOps – Production Deployment of Azure ML models | Neil Hambly | Data Science (AI/ML) | Azure MLOps (Azure ML + DevOps) provides features that are needed to 'Productionize' Azure ML models. Enable the ability to track, version, audit and reuse assets for your ML lifecycle Providing orchestration of services to streamline the ML lifecycle and cohesively manage datasets, experiments and models. Creating a release & testing strategy for Azure ML models into ACI or AKS |
| Breakouts – 75 mins (60 mins + 15 mins Q&A) – Slides + Demos | Delta Lake with Azure Databricks - Let's build a reliable Data Lake! | Mohit Batra | Business Intelligence & Advanced Analytics | While Data Lakes allow us to store massive amounts of data, there are many challenges that come along – maintaining data and multiple files, providing consistency to downstream applications, handling updates, data recovery in case of failures, slower transactional query performance, consolidation of streaming data and much more. On the other hand, Data Warehouses based on relational databases, handle many of these challenges, but they do not scale well and are expensive to maintain. Are you interested to build a large-scale, reliable Data Lake? This session will take you through Delta Lake - an open-source storage layer that brings ACID transactions and reliability to your data lakes. It can scale to handle TBs and PBs of data, handle updates, combine and store batch and streaming data, as well as data and metadata management. And this is what we will look into, via demos: 1. What is Delta Lake, and its features 2. How to get started with Delta Lake using Azure Databricks 3. How to handle Inserts, Updates, Deletes and Merge for the records 4. How it provides ACID guarantees, using transactional logs 5. How Time Travel works 6. How schema enforcement and schema evolution works 7. How data clustering, and clean up works 8. And compare it with Parquet format in terms of features and performance These features of Delta Lake can truly help you build large-scale data warehouses in your Data Lake. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Power BI Tips to increase your productivity | Mohammed Adnan | Development | All about short cuts and tips to increase the Power BI development and some of the Industry best practices which we need to follow |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Microsoft latest Web UI technology, Blazor, working with Azure SQL Azure database in cloud | Ming Man Chan | Development | The topic is targeted at startup organizations that have limited resources to develop coding and maintain the infrastructure. ASP.NET has been using many JavaScript and proven hard to maintain. Thus, Microsoft has emerged a new platform to do all the necessary code in C#, Blazor. Blazor uses open web standards without plug-ins or code transpilation. Blazor is able to work in all modern web browsers, including mobile browsers. In order to setup servers and maintain databases is not cost efficient for the startup company. By using SQL Azure Database organization can mitigate the infrastructure cost and focus on the business core competency. In this short session you will learn how to get started with Blazor UI as a frontend and SQL Azure as a backend for your solution. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Test Driven Database Development | Magnus Ahlkvist | Development | est Driven Development, or TDD, means we start with unit tests, even before writing our code. When done properly, TDD leads to higher quality systems. It gives us good test coverage, it's automated and it gives us good regression testing. To isolate the unit tests, so that they only verify the behaviour of an invidiual method or function, everything outside of the function is mocked. This is a really good idea. If we write a function ConvertCurrency and that function calls service GetCurrencyRate(date,currency), create a mock service which always returns the same value. How about unit tests for the service GetCurrencyRate? The service probably gets the currency rate for a certain date/currency combination from a database, perhaps through the stored procedure call Finance.GetCurrencyRate. And just like the unit tests for ConvertCurrency uses a mock service for GetCurrencyRate, the unit test for GetCurrencyRate will use a mock for the stored procedure Finance.GetCurrencyRate. But who will test the stored procedure Finance.GetCurrencyRate? In this session we will talk about test driven database development. How we can apply the TDD methodology to database development. We will look at the most common unit testing frameworks and how they integrate with database development environments. We will look at unit test design and how we can isolate unit tests to only test the logic of an individual statement, view, stored procedure or user defined function. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Tips and Tricks to Modernize Power BI Paginated Reports | Hariharan Rajendran | Business Intelligence & Advanced Analytics | The demand for Power BI Paginated reports is keep increasing from the announcement of Premium Per User License and most of you interested to learn. This session is for all report developers who started working with Power BI Paginated Reports. In this session I will be explaining how to make modern paginated reports with different built-in features. If i say modernize, it does not mean that I am covering only the look and feel of the reports. I will be explaining what kind of features are available and how you can effectively use them and how the tool can compete with other BI tools. Basically, I will be showing the hidden gems of Paginated Reports. In simple, this session will cover development, automation, performance and etc with Paginated Reports. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Backup Options for SQL Server in Azure | Frank Gill | Data Administration | Database backups are the foundation of data protection in SQL Server. In Azure, backups for Azure SQL Database are managed, but there are options for both short- and long-term retention. Backups for SQL Server databases running on Azure VMs can be backed up using SQL Server Agent jobs. Alternately, these databases can be backed up using Azure Recovery Vault. Join me for this session to learn about these options, including demonstrations of set up and administration. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Knowing and Controlling Your Azure Spend | Dustin Dorsey | Industry Solution | Cloud technologies provide us so many benefits to get us what we need very quickly with its extensive library of services, easy to deploy infrastructure, and flexibility to scale. However, without proper planning, control and monitoring you can end up with some unexpected surprises when your bill arrives that can jeopardize your project. As technical professionals it is easy to get focused on the technology and not consider items such as cost management, but you are essential to successfully creating a cost efficient system. In this session, we will review the primary components of budgeting and cost management, review the tools and programs in place to assist you, and provide several tips based on years of experience to help get you started. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Power BI: Using streaming for real-time data | Dennes Oliveira | Business Intelligence & Advanced Analytics | There are many scenarios of data ingestion when we would like to see our real time data. Come to this session to learn how to build reports over real time data using power bi |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Feeding the Modern Data Warehouse | Christian Cote | Business Intelligence & Advanced Analytics | When it comes to feed the modern data warehouse in Azure, we're facing new challenges. This session will explain what id the modern data warehouse and how it can be fed using ETL 2.0 methodologies. Topics like Common Data Model and services will also be talked and demonstrated. |
| Short Drive - 30 mins (25 mins + 5 mins Q&A) - Slides + Demos | Working with Azure SQL DB Serverless | Carlos Lopez | Data Administration | Abstract: Summary: In this session we will be working with Azure SQL DB, we will be exploring the use of the compute model serverless. Using the Azure CLI, and the declarative mode we will be creating, deleting and altering the server and databases. All of this with the help of Visual Studio Code integrating with different technologies to make SQL Server better. Goal 1: Provisioning the server with the serverless compute model Goal 2: Creating and altering db using declarative model through Azure CLI |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | DBAs getting more done in less time with PowerShell | Ben Miller | Data Administration | Have you thought about how you would use PowerShell to do your Administrative work with SQL Server? This session is all about practical use of the PowerShell to actually do DBA work on a daily basis. In this session I will cover using DbaTools module, SqlServer module and combine that with PowerShell Notebooks in Azure Data Studio. You will learn different ways to backup databases and to restore databases as well as quickly find out when each database was backed up. I will also cover how you can use TSQL in PowerShell to get information to store for trending. From AdHoc backups and restores, to automated tasks to gather data for trending and combining these concepts in a PowerShell Notebook to create habits and transportable insights into your environment, this session is a great way to take the PowerShell you know and use it to do actual work. This session is not meant to teach you PowerShell, but to show you how you can use it more effectively. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Intro to Azure Data Service and Azure Synapse Analytics | Balram Prasad | Development | In this talk i will present a slide where i will talk about different data services offered by azure and then how we can use azure synapse for different purpose and in the end i will have demo about how we can create notebook and run sql script in azure synapse |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Power BI good, bad and the ugly | Augustin Dokoza Bukvic | Business Intelligence & Advanced Analytics | Common mistakes and how to avoid them when creating Power BI enterprise reports. Guiding you through all the common pitfalls all the way from data ingestion, modeling to visualizing. With common pitfalls there are also best practices to follow. This session guides you through the main roadblocks and gives you some useful tips and tricks to help you create a stunning enterprise reports. |
| Breakouts - 75 mins (60 mins + 15 mins Q&A) - Slides + Demos | Power BI scenarios for automated monitoring | Andrea Martorana Tusa | Business Intelligence & Advanced Analytics | Power BI grows at an exponential rate and so probably does your environment. Many new users every day, workspaces, data sources etc. How to deal with it? For a Power BI tenant’s administrator it's a challenging task keeping everything under control, documenting the model, tracking changes, cleaning it up, knowing which dataset is used and which one isn't. What is needed is automation. Monitor workloads, track changes, read and download logs, set alerts, handle contents and artifacts. How to achieve this goal? Through the use of the three automation pillars: Powershell, Microsoft Flow, Power BI APIs. Many examples will be illustrated during the session, based on a customer implementation where the Power BI admin plays a central role for governance and management of the solution. |
