5.4.Performing data calculations - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

Calculations are one of the more common tasks that data analysts complete during analysis. 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.

Learning Objectives

• Describe the use of functions to conduct basic calculations on data in spreadsheets
• Discuss the use of pivot tables to conduct calculations on data in spreadsheets
• Demonstrate an understanding of the use of SQL queries to complete calculations
• Explain the importance of the data-validation process for ensuring accuracy and consistency in analysis
• Discuss the use of SQL queries to manage temporary tables
• Reflect on how conditional statements can be used to create complex queries and functions
• Generate multiple points of summary based on a wide variety of conditions using COUNTIF, SUMIF, MAXIF, and AVERAGEIF

---

• Get started with data calculations
• Learn more SQL calculations
• The data-validation process
• Weekly challenge 4