Summary
Keywords
Full Transcript
Revisit spreadsheets where you will look at formulas for basic calculations, then take a look at pivot tables, and how queries and calculations go hand-in-hand in SQL. 0:00 Data Calculations 2:43 Common Calculation Formulas 12:58 Functions and Conditions 21:36 Composite Functions 27:18 Working with Pivot Tables 40:20 Queries and Calculations 44:32 Embedding Simple Calculations 52:14 Working with Other Statements 56:34 Validate Everything 1:02:15 Time for Temporary Tables 1:08:56 Variations of Multiple Tables This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data. The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics. Take the Certificate HERE: https://www.coursera.org/google-certificates/data-analytics-certificate?utm_source=google&utm_medium=institutions&utm_campaign=youtube-organic__geo--Global&utm_content=vid--WutHuhEWG1g__topic--DA&utm_term=youtube-description Subscribe HERE: https://goo.gle/subscribegcc #GrowWithGoogle #GoogleCareerCertificate #DataAnalytics Why earn a Google Career Certificate? ► No experience necessary: Learn job-ready skills, with no college degree required. ► Learn at your own pace: Complete the 100% online courses on your own terms. ► Stand out to employers: Make your resume competitive with a credential from Google. ► A path to in-demand jobs: Connect with top employers who are currently hiring.
