Databricks SQL Analytics Deep Dive for the Data Analyst

In this session, we will cover best practices for analysts, data scientists, and SQL developers exploring Databricks SQL Analytics as a solution for their companies. This guided technical tour of the product walks through:
• Creating and working with queries, dashboards, query refresh and alerts
• Constructing queries for semi-structured data, such as json, structs, and arrays
• Navigating the improved Spark SQL Documentation to find and leverage powerful built-in functions to solve common problems
• Creating connections to 3rd party BI and database tools (PowerBI, Tableau, dbVisualizer etc.)
Connect with us:
Website: databricks.com
Facebook: / databricksinc
Twitter: / databricks
LinkedIn: / databricks
Instagram: / databricksinc Databricks is proud to announce that Gartner has named us a Leader in both the 2021 Magic Quadrant for Cloud Database Management Systems and the 2021 Magic Quadrant for Data Science and Machine Learning Platforms. Download the reports here. databricks.com...

[@radekou]

Timestamps: 4:00 - demo begins - UI interview 6:35 - data selection, schema etc. 7:09 - select statement 9:10 - visualisation - map 15:39 - bar chart 17:46 - query parameter 20:29 - query-based dropdown 25:12 - creating a dashboard 29:00 - schedule data refresh 29:43 - set up alerts 34:35 - working with "silver" level/array type data 41:50 - handling arrays - transform 46:00 - handling arrays - reduce 51:45 - connecting to 3rd party tools 51:30 - tableau

[@dipanjansaha6824]

Couple of questions 1. Assume I have shared the dashboard link with business users, everytime an user opens the dashboard will spin up the cluster? 2. How about ci/cd pipelines? I.e. how to play/cook my code in dev then move to production?

[@rajeshkumardash611]

Yes it will spin up cluster every time user open the dashboard

[@angallaamardeep5472]

this is an excellent lecture I have ever come across, Thank you very much

[@basyasalid4988]

Thank you for sharing the session. This was great and informative!

[@dianacarolinaduquemontoya2199]

I can see that the lady made a mistake writing the average temperatures query and the video was edited with no clarification, this can be confusing.

[@sconnell194]

👍

[@user-ub6]

SO GOOD