Extracting Insights from Data with Databricks SQL
Offered By: Pluralsight
Course Description
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.
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
Related Courses
Design Computing: 3D Modeling in Rhinoceros with Python/RhinoscriptUniversity of Michigan via Coursera 3D SARS-CoV-19 Protein Visualization With Biopython
Coursera Project Network via Coursera Access Bioinformatics Databases with Biopython
Coursera Project Network via Coursera Accounting Data Analytics
University of Illinois at Urbana-Champaign via Coursera Lean Data Approaches to Measure Social Impact
Acumen Academy