DataInsiders/SQLDay2023

SQLDay2023

Day 0 (pre-conf)

Explore the ocean of data with Azure Data Explorer aka Data Explorer in a day Azure Data Explorer aka ADX aka Kusto is a fully managed, high-performance big data analytics platform that makes it easy to analyze large amounts of data in near real time. So much marketing, and what in practice? Come to the workshop, learn ADX from scratch and see how it works in different scenarios. Let's promise a lot of hands-on and just a little talk of two dinosaurs

• ADX Product Page https://aka.ms/adx.pp
• Docs https://aka.ms/adx.docs
• Cost estimator https://aka.ms/adx.cost
• Customer stories https://aka.ms/ADX.Customers
• Preloaded open ‘help’ ADX cluster http://aka.ms/adx.try
• Queries that can run on this cluster ('Samples' DB): https://aka.ms/adx/query.tutorial and throughout the docs.
• Start for free https://aka.ms/ADX.Free
• YouTube Channel https://aka.ms/adx/youtube
• Including the ADX intro video: https://aka.ms/ADX.Intro
• Reference architecture (integration with other components) https://aka.ms/adx.architectures.video
• Written version: https://aka.ms/adx.architectures
• ADX product team blog (this blog) https://aka.ms/adx.blog
• Twitter @AzDataExplorer
• LinkedIn group https://www.linkedin.com/groups/12147235/
• Stack overflow https://aka.ms/adx.sof
• KQL cheat sheets
  • https://aka.ms/SQL2KQL
  • https://aka.ms/ADX.KQL.Quick
  • https://github.com/marcusbakker/KQL
• KQL tutorial (you can run the KQL on the “help” cluster) https://aka.ms/adx/query.tutorial
• Learn and practice KQL (community content) https://aka.ms/MustLearnKQL
• KQL Overview video https://aka.ms/ADX.KQL.Video
• MS learn modules and free Pluralsight courses
  • https://aka.ms/adx/start
  • https://aka.ms/ADX.Learn.Dashbboards
  • https://aka.ms/ADX.Learn.Queries
• MS Learn modules
  • https://aka.ms/learn.adx
  • https://aka.ms/learn.kql
• **Pluralsight**
  • https://aka.ms/adx.pluralsight - To activate the free benefit
  • https://aka.ms/adx.pluralsight.how-to-start-with-adx
  • https://aka.ms/adx.pluralsight.azure-data-exploring
  • https://aka.ms/adx.pluralsight.kql-from-scratch
  • https://aka.ms/adx.pluralsight.advanced-kql
• **Technical posts:**
• Technical whitepaper: https://aka.ms/adx.techwhitepaper
• Performance benchmark https://aka.ms/ADX.Benchmark.post

**Day 1 (conference)**
Session: Back to the future, or analytics on the Microsoft platform today and tomorrow

The last few years have seen a dynamic development of various analytical and reporting concepts and platforms. The cloud has become an accelerator of many ideas, both more and less hit. Whether you're going down the road of a data warehouse or a lakehouse, the Microsoft ecosystem supports your decisions. During this session we will take you on a journey to the future of analytics according to Microsoft, join and see how your knowledge and experience of today's world of analytics may be useful soon...
Link: https://github.com/DataInsiders/SQLDay2023/blob/main/Back%20to%20the%20future%20-%20analytics%20on%20the%20Microsoft%20platform%20today%20and%20tomorrow.pdf

**Day 2 (conference)**
Session: Optimize KPI reporting using Power BI metrics
In every organization it is important to be able to follow up on KPIs in order to understand how the business are doing. KPIs used in the business can often be found in existing Power BI reports, however, following up on KPIs across multiple reports are not effective. Instead you should use Power BI metrics where you easily can get an overview over KPIs that are relevant. In this session we will take a deep dive into Power BI metrics, this include everything from creating KPIs, following up on KPIs, automating status on KPIs and consuming KPIs
Link: https://github.com/DataInsiders/SQLDay2023/blob/main/Optimize%20KPI%20reporting%20using%20Power%20BI%20Metrics.pdf