How do you come up with clear and objective answers to any data question you encounter? Explore the Analyze phase, focusing on how to organize and format the data you have so that you can do all sorts of calculations. Knowing how to analyze the data you’ve collected and cleaned is essential to your work as an analyst.

0:00 Welcome to the Course
0:27 The Analysis Process
5:08 Always a Need to Organize
7:53 Utilizing Sorts and Filters
13:02 Sorting Data Sets
17:42 The SORT Function
22:59 Sorting Queries in SQL

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--G5sjJ1lwQYs__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

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-infocard

Subscribe HERE: https://bit.ly/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.

You need to make sure your data is formatted and adjusted correctly. Learn to start converting and formatting your data, use data validation and conditional formatting in spreadsheets. Also, learn how to combine multiple pieces of data, get support during your analysis, and find resources whenever you’re stuck.

0:00 Getting Started with Data Formatting
0:27 From One Type to Another
5:53 Data Validation
9:46 Conditional Formatting
14:24 Merging Multiple Pieces of Data
18:42 Strings in Spreadsheets
21:42 Search for Support
25:08 Know the Tools

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--ofcG687FGsU__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

Explore Tableau, a data visualization platform that will help you create effective visualizations for your presentations.

0:00 Getting Started with Tableau
0:27 Data Visualizations with Tableau
2:24 Meet Tableau
4:31 Tableay Basics
13:05 The Good, the Bad, the Ugly
16:13 Get Creative
20:16 Wrap up

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--o0xG3SjBV0Q__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

The data is only one piece of the puzzle. Being able to communicate that data, and tell a story with it is what brings ideas to life. This lesson goes through Tableau and how it can help you create compelling presentations.

0:00 Storytelling Through Data
3:19 Bring Ideas to Life
8:35 Accommodate Different Audiences
13:15 Tableau Dashboard Basics
17:54 From Filters to Charts
24:34 Compelling Presentations
27:17 Sharing a Narrative
32:57 Wrap up

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--r8KZGpVns3o__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

It's time to put all your data, and data visualizations into your presentation and learn the skill to present your findings like a pro.

0:00 Putting It All Together
1:28 Presenting with a Framework
7:02 Incorporating Data in Presentations
14:34 The Importance of Presentation Skills
19:58 Present Like a Pro

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--aEnWzdMU65A__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

You have finished your presentation and opened up the floor for questions. Let's go over how to prepare by anticipating what questions might be asked and the best practices for the Q&A section of your presentation.

0:00 Effectively Answer Presentation Questions
1:22 Consider the Possible Questions
7:08 Handling Objections
10:47 Listen and Respond

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--Qbcw2nwypCI__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

Learning R will help you take your data analysis to the next level. It’ll also look great on your resume. R is widely recognized as a key credential in entry level job positions. Knowing how to use R will give you a big boost in your job hunt, and help you stand out as a new analyst.

0:00 0:00 Welcome to the Course
6:48 Fun with R
12:36 Programming Languages
17:57 Understand R Programming Languages
20:57 Introduction to RStudio

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--fFkg8iOQ1ck__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

Start by learning more about data frames and how to use them, and then explore how to work with data in different ways using tidyverse packages. Plus, how to check for bias in R.

0:00 Data in R
0:28 R Data Frames
5:01 All About Data Frames
9:36 Cleaning Up
17:14 Getting Organized
23:55 Transforming Data
28:54 Same Data Different Outcome
34:10 The Bias Function

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--aC009Px4tEg__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

R Markdown is a file format for making dynamic documents with R. Learn to use a R Markdown file as a code notebook to save, organize, and report your analysis to stakeholders.

0:00 Intro
0:28 Overview of R MarkDown
3:24 Using R MarkDown in RStudio
7:05 Markdown Document Structure
11:03 Even More R Markdown Document Elements
16:51 Code Chunks in R Markdown
23:38 Exporting your R Markdown Documentation

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--c7EhBASskXw__topic--DA&utm_term=youtube-description


Subscribe HERE: https://bit.ly/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.

Learn how to use code to visualize your data. Data visualization is one of the most important parts of data analysis. Powerful visuals show stakeholders what your data means in a clear and compelling way, and highlight key insights.

0:00 Visualizations in R
2:22 Visualization Basics
8:35 Getting Started with ggplot()
18:30 Enhancing Visualizations
26:31 Doing More with ggplot
34:57 Aesthetics and Facets
40:14 Annotation Layer
46:46 Saving your Visualizations

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--ZPw0dmGuyyE__topic--DA&utm_term=youtube-description

Subscribe HERE: https://bit.ly/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.

Explore the data ecosystem, find out where data analytics fits into that system, and go over some common misconceptions you might run into in the field of data analytics. Mastering these data basics will help you empower organizations to make data-driven decisions. 0:00 Data All Around Us5:32 How Data Becomes Insights9:24 Working Within the Data Ecosystem13:52 How Data Informs Better DecisionsThis 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--GbL-42kv5LI__topic--DA&utm_term=youtube-descriptionSubscribe HERE: https://bit.ly/SubscribeGCC#GrowWithGoogle #googlecareercertificate #dataanalyticswhy 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.