Explore how to use the Bollinger band chart type when looking at metrics for a business.
- [Man] And another question that you…might want to answer sometimes is…about what is normal related to a metric.…And a great way to do this is using Bollinger Bands.…So, this is essentially calculating the upper…and lower limits using standard deviation.…Which we just looked at a minute ago.…And a rolling average.…So you need several rolling calculations but…in the result, what you have is a really…good sense and a way to graph what is…normal for your business users.…Now this is something often used in manufacturing.…
But businesses all around the world are adopting…this as a good way to understand their data better.…So, I'm going to paste this in here…and explain it as I go.…First, I want to create a table alias.…So I'll say with Sales Weekly.…Then I'm going to give it a select statement here.…That's going to aggragate my data up to the week level.…So I have my date trunc function and I have my week…of the order date.…Then I have my total price…and I'm going to pull this from the tpch tiny orders.…
I need to group by my date trunc function and then…
Data science expert Ben Sullins helps you get up to speed with Presto, and leverage it to accomplish a wide-range of data science and analytics tasks. He uses different interfaces with Presto—such as R and Tableau—and digs into the expressive SQL language that Presto offers for your analysis. At the end of this course, you'll know the key concepts of Presto and how to use them to take full advantage of your modern big data system.
- What does Presto do?
- Running Presto
- Connecting from Tableau and R
- Connecting to Hive, MySQL, and the local system
- Retrieving data
- Combining data sources
- Basic SQL functions
- Advanced SQL functions
- Migrating from Hive
Skill Level Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
Advanced SQL for Data Scientistswith Dan Sullivan1h 24m Advanced
1. Introducing Presto
2. Running Presto
4. SQL Syntax
5. Basic SQL functions
6. Advanced SQL Functions
7. Migrating from Hive
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.