Select the right data Following are some data-collection considerations to keep in mind for your analysis: How the data will be collected Decide if you will collect the data using your own resources or receive (and possibly purchase it) from another party. Data that you collect yourself is called first-party data. Data sources If you don’t collect the data using…
Course 3: Prepare Data For Exploration: Learning objectives and overviews
A massive amount of data is generated every single day. In this part of the course, you will discover how this data is generated and how analysts decide which data to use for analysis. You’ll also learn about structured and unstructured data, data types, and data formats as you start thinking about how to prepare your data for analysis. Learning…
SQL best practices
Content collected from Google Data Analytics course Feel free to download a .pdf version of this reading below: These best practices include guidelines for entering SQL queries, developing documentation, and examples that demonstrate these practices. This is a great resource to have handy when you are using SQL yourself; you can just go straight to the relevant section to review…
Course 2: Ask questions to make data driven decisions, Module 4: Always remember the stakeholder
Working with stakeholders Your data analysis project should answer the business task and create opportunities for data-driven decision-making. That’s why it is so important to focus on project stakeholders. As a data analyst, it is your responsibility to understand and manage your stakeholders’ expectations while keeping the project goals front and centre. You might remember that stakeholders are people who…
Course 2: Ask questions to make data driven decisions, Module 3: Spreadsheet magic
Spreadsheets are a key data analytics tool. Here, we will learn both why and how data analysts use spreadsheets in their work. We will also investigate how structured thinking helps analysts understand problems and come up with solutions. Learning Objectives Spreadsheets and the data life cycle To better understand the benefits of using spreadsheets in data analytics, let’s explore how…
Course 2: Ask questions to make data driven decisions, Module 2: Make data-driven decisions
In analytics, data drives decision-making, and this is your opportunity to explore data of all kinds and its impact on all sorts of business decisions. We will also learn how to effectively share your data through reports and dashboards. Learning Objectives Data trials and triumphs Introduction A data analytics professional’s job is to provide the data necessary to inform key…
Course 2: Ask questions to make data driven decisions, Module 1: Ask effective questions
Why You Should Take This Course This course is the second in the Google Data Analytics Certificate program. It builds on the foundation you learned in the first course and dives deeper into the world of data analysis. Here are some reasons why you should take this course: In addition to the above, this course will also help you to:…
Foundation Course Module 4: Becoming a fair and impactful data professional
In this module, we will examine different types of businesses and the jobs and tasks that analysts do for them. You’ll also learn how a Google Data Analytics Certificate will help you meet many of the requirements for an analyst position with these organizations. Learning Objectives Ethical and fair decision-making process of a Data analyst Fairness means ensuring your analysis…
Foundation Course Module 3 : Setup of data analytics toolbox
Data Analytics Tools Spreadsheets, query languages, and data visualization tools are all a big part of a data analyst’s job. In this part of the course, we will learn the basic concepts to use them for data analysis. Learning Objectives Let’s learn Spreadsheet .. In the spirit of lifelong learning, it is good to have resources to turn to when…