Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Extracting Insights from Data with Databricks SQL

via Pluralsight

Overview

Databricks SQL provides a unified interface to create and run SQL queries, and then visualize the results using a variety of built-in charts. This course explores how these can be combined with dashboards to extract useful insights from data.

Most data analysts, and other big data professionals will often need to draw useful information from data which can then be used to make data-driven decisions that help their organization achieve their goals. In this course, Extracting Insights from Data with Databricks SQL, you'll learn how Databricks SQL can play a crucial role in this task, with a combination of SQL queries, visualizations and dashboards. First, you'll discover different kinds of SQL queries, from the use of simple WHERE clauses to nested queries. Next, you'll explore aggregations on data, and the different types of aggregate functions which can be used to combine records in a large dataset to generate a meaningful summary, such as aggregate sales in a certain region. Finally, you'll learn how finding patterns and identifying trends in data can be greatly simplified by visualizing data. At the end of this course, you'll have the skills necessary to make the best use of all the tools available in Databricks SQL to learn from your data, extract actionable insights, and help your organizations make the best decisions based on data.

Syllabus

  • Course Overview 2mins
  • Querying Data To Extract Insights 31mins
  • Grouping and Aggregating Data 14mins
  • Creating a Dashboard to Visualize Business Data 29mins

Taught by

Kishan Iyer

Reviews

Start your review of Extracting Insights from Data with Databricks SQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.