Data calculations

Calculations are a common task for data analysts. In this part of the course, you’ll explore formulas, functions, and pivot tables in spreadsheets and queries in SQL, all of which will help with your calculations. You’ll also learn about the benefits of using SQL to manage temporary tables.

• Common calculation formulas - 9 minutes
• Functions and conditions-  8 minutes
• Composite functions - 5 minutes
• Start working with pivot tables - 7 minutes
• Pivot tables continued - 5 minutes
• Queries and calculations - 4 minutes
• Embed simple calculations with SQL- 6 minutes