From the course: Introduction to SQL Using Google BigQuery

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Challenge: Financial analysis

Challenge: Financial analysis - SQL Tutorial

From the course: Introduction to SQL Using Google BigQuery

Start my 1-month free trial Buy for my team

Challenge: Financial analysis

“

(upbeat music) - [Instructor] In our next data analytics challenge, we've been asked by the Wisdom Pets Finance Team to help them dive into a new sales data set, something different to the products table that we've been dealing with so far. The team would like us to provide some high level sales summary metrics to publish on their latest finance report. Our tasks today include the following questions. Which top three product IDs are the best selling based off the total_amount field? What is the total sales and percentage breakdown by transaction_type? These two questions will focus on our previous learnings, but we will now need to apply these same techniques to a brand new sales dataset. Make sure to check out the BigQuery resource viewer for the sales table to explore this dataset further as you try to solve these questions. Good luck with these realistic analysis tasks. I'll be here to take you through my solutions…

Contents