Extracting Insights from Data with Databricks SQL

Focused View

Kishan Iyer

1:17:38

63 View

1. Course Overview

1. Course Overview.mp4

02:09

2. Querying Data To Extract Insights

1. Course Prerequisites and Outline.mp4

01:37

2. An Overview of Databricks SQL.mp4

02:43

3. Querying Data in Databricks.mp4

03:02

4. Demo - Creating a Table from a CSV File.mp4

06:32

5. Demo - Running SQL Queries for Analysis.mp4

04:29

6. Demo - Filtering Results with Multiple Conditions.mp4

02:14

7. Demo - The IN and BETWEEN Clauses.mp4

03:20

8. Demo - Using Nested Queries.mp4

07:32

3. Grouping and Aggregating Data

1. Aggregations and Query Filters.mp4

03:29

2. Demo - Using Aggregation Functions.mp4

04:48

3. Demo - Applying Query Filters.mp4

06:30

4. Creating a Dashboard to Visualize Business Data

1. Visualizing Query Results.mp4

04:30

2. Compiling Visuals in Dashboards.mp4

03:57

3. Demo - Defining Multiple Query Parameters.mp4

06:04

4. Demo - Building a Line Chart.mp4

03:55

5. Demo - Configuring a Pie Chart.mp4

01:48

6. Demo - Building a Dashboard.mp4

05:04

7. Demo - Using Dashboard-level Filters.mp4

02:51

8. Course Summary and Related Content.mp4

01:04

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Database Programming

Microsoft SQL

Kishan Iyer

Instructor's Courses

I have a Masters in Computer Science from Columbia University and have worked previously as a developer and DevOps engineer. I now work at Loonycorn which is a studio for high-quality video content. My interests lie in the broad categories of Big Data, ML and Cloud.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.