From the course: Hands-On Data Science using SQL, Tableau, Python, and Spark
Join today to access over 24,800 courses taught by industry experts.
Visualizing data in Spark
From the course: Hands-On Data Science using SQL, Tableau, Python, and Spark
Visualizing data in Spark
- Now let's look at how to create some data visualizations inside of Spark. Here in a new workbook inside of our Databricks platform, I'm going to start writing some SQL queries and then use the built-in visualization tools of Databricks to actually create some charts. So the first thing I want to do is just get a trend of sales. So I'm going to pull back OrderMonthYear from our table, and then we're going to do a sum of sales amount, and then group by OrderMonthYear, I'll hit shift enter to run this. And you can see essentially I have the sales by month here, so easy to start out with. And then instead of just having it be a table of data, I want to actually create a data visualization. So, I'll click on the plus sign next to this and say, visualization. Here, it already chose line chart, which is good because that's what I want. And I can also play with all the other types of things like let's say, instead of a sum, I want an average sale amount. I can do all of that right here…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.