Google Data Analytics Professional Certificate-Click Here
What you’ll learn
Gain an immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job
Learn key analytical skills (data cleaning, analysis, & visualization) and tools (spreadsheets, SQL, R programming, Tableau)
Understand how to clean and organize data for analysis, and complete analysis and calculations using spreadsheets, SQL and R programming
Learn how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms
Skills you’ll gain
- case study
Foundations: Data, Data, Everywhere-Click here
WHAT YOU WILL LEARN
Define and explain key concepts involved in data analytics including data, data analysis, and data ecosystem
Conduct an analytical thinking self assessment giving specific examples of the application of analytical thinking
Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics
Describe the role of a data analyst with specific reference to jobs/positions
Ask Questions to Make Data-Driven Decisions-click Here
WHAT YOU WILL LEARN
Explain how each step of the problem-solving road map contributes to common analysis scenarios.
Discuss the use of data in the decision-making process.
Demonstrate the use of spreadsheets to complete basic tasks of the data analyst including entering and organizing data.
Describe the key ideas associated with structured thinking.
Prepare Data for Exploration-click Here
WHAT YOU WILL LEARN
Explain factors to consider when making decisions about data collection
Discuss the difference between biased and unbiased data
Describe databases with references to their functions and components
Describe best practices for organizing data
Process Data from Dirty to Clean-click here
WHAT YOU WILL LEARN
Define data integrity with reference to types of integrity and risk to data integrity
Apply basic SQL functions for use in cleaning string variables in a database
Develop basic SQL queries for use on databases
Describe the process involved in verifying the results of cleaning data
Analyze Data to Answer Questions-click here
WHAT YOU WILL LEARN
Discuss the importance of organizing your data before analysis with references to sorts and filters
Demonstrate an understanding of what is involved in the conversion and formatting of data
Apply the use of functions and syntax to create SQL queries for combining data from multiple database tables
Describe the use of functions to conduct basic calculations on data in spreadsheets
Share Data Through the Art of Visualization-click here
WHAT YOU WILL LEARN
Describe the use of data visualizations to talk about data and the results of data analysis
Identify Tableau as a data visualization tool and understand its uses
Explain what data driven stories are including reference to their importance and their attributes
Explain principles and practices associated with effective presentations
Data Analysis with R Programming-click here
WHAT YOU WILL LEARN
Describe the R programming language and its programming environment
Explain the fundamental concepts associated with programming in R including functions, variables, data types, pipes, and vectors
Describe the options for generating visualizations in R
Demonstrate an understanding of the basic formatting R Markdown to create structure and emphasize content
Google Data Analytics Capstone: Complete a Case Study
WHAT YOU WILL LEARN
Differentiate between a capstone, case study, and a portfolio
Identify the key features and attributes of a completed case study
Apply the practices and procedures associated with the data analysis process to a given set of data
Discuss the use of case studies/portfolios when communicating with recruiters and potential employers