Topic: It’s just a SQL – Crash course on Synapse Serverless for T-SQL Ninjas!
Are you a seasoned T-SQL developer, used to solve each and every challenge by writing plain old SQL? But, now you need to leverage data coming from semi-structured or unstructured sources? What if I tell you that you can get your mission accomplished by writing your favorite T-SQL syntax?
In this session, you will learn what is a Serverless SQL pool within Azure Synapse Analytics, how it works behind the scenes, and how can you preserve your “T-SQL Ninja” status even when dealing with the data coming from CSV and Parquet files, or from NoSQL database.
About the presenter: Nikola Ilic
Passionate about Data Analysis, Data Modeling, and extracting knowledge from raw data. Extensive experience in Banking Business and Online Gaming industry, combined with broad IT knowledge. Curious by nature, always motivated to learn the latest technologies and tools and work with talented people. Blogger @ https://data-mozart.com, speaker, Data Engineering, and Business Intelligence enthusiast, interested in mining useful information from structured and less structured data. True football/soccer (and Barca) fan!
Topic : A first look at Azure Purview with Azure Synapse Analytic
The data industry has come a long way in the past few years, we’re seeing the massive growth of data lakes, data mesh architectures, distributed data stores and an explosion in self-service analytics. But how do you govern this sprawling array of desperate data stores? How can you be certain you’re adhering to data sensitivity guidelines? How do your users know where to find the right dataset for their analytics?
True Data Governance has long been a missing piece of the Azure landscape, but with the preview release of Azure Purview, we now have an answer. This tool allows you to scrape metadata from a whole range of sources, automatically classify and catalogue the data within and present it to your users as a one-stop data catalogue & security management service.
This session will take you through a first look at the tool, how we go about basic operations and begin to implement purview in our environment. We’ll look at several different governance scenarios, use several different data sources and give you a good initial impression of where the tool fits in your organisation. As this is a preview tool, we won’t have all the answers – but bring along your questions & scenarios and we’ll see what we can do!
About Simon Whiteley
Data Platform MVP. Cloud Architect, Nerd
Director of Engineering for Advancing Analytics Ltd and Microsoft Data Platform MVP. Simon is a seasoned solution architect & technical lead with well over a decade of Microsoft Analytics experience. A deep techie with a focus on emerging cloud technologies and applying “big data” thinking to traditional analytics problems, Simon also has a passion for bringing it back to the high level and making sense of the bigger picture. When not tinkering with tech, Simon is a death-dodging London cyclist, a sampler of craft beers, an avid chef and a generally nerdy person.
“New composite models” is the friendly name for “DirectQuery for Power BI datasets and Analysis Services”, a feature that will have a huge impact in corporate and self-service BI in the coming years. In this session you see how this feature work, you learn several examples of adoption, and you have an overview of the challenging ahead for governance and development.
About the presenter: Alberto Ferrari
Alberto started working with SQL Server in 2000 and immediately his interest focused on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence.
Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, Sqlbits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses.
Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.