Course Overview
The Data Analytics Certified Associate course will give you insights into applying data and analytics principles in your business. You will gain an understanding of the complete data analytics lifecycle, from problem definition to solution deployment. And through various industry-specific examples and case studies, you will learn how analytics, data visualization and data science methodologies can be used to drive better business decisions.
Course Curriculum
Unit 1: Fundamentals of Data and Excel I
- The Value of Data
- Navigating in Excel
- Preparing Data in Excel
- Visualizing Data in Excel
- Statistics for Data Analysis
Unit 2: Fundamentals of Data and Excel II
- Data Referencing in Excel
- Data Aggregation in Excel
- AirBnB Investment Presentations
Unit 3: Managing Data with SQL
- Foundations of Databases and SQL
- Aggregating Data in SQL
- Using Logic and Functions in SQL
- Writing Efficient, Dynamic Queries and Subqueries
Unit 4: Communicating Data Analysis with Tableau
- Exploring the Fundamentals of Tableau
- Visualizing Data and Text Manipulation in Tableau
- Calculation and Analysis in Tableau
- Dashboard Actions and Analysis in Tableau
- Final Project Presentations
Frequently Asked Questions
Data is now an integral part of every business. To be successful in today’s business landscape, all companies need to learn how to leverage data to make critical business decisions. It is a requirement for every employee to know how to analyze data. In this course, you will learn how to use large amounts of data to help your company make those critical decisions about strategy.
At the end of the program you will be issued with the Professional Certificate in Data Analytics(PCDA™).
This course will teach you how to use large amounts of data to make business decisions. Using Excel and Sql, you will learn how to collect, clean and analyze data from multiple sources including the web, a local file and a relational database. Additionally, you will be able to use this analysis to make business decisions. In this course, you will practice with real world data sets and problems to contextualize how analytics fit into the business world.
Prerequisites
- No, there are no prior knowledge required
- A basic understanding of statistics
- A basic understanding of variables, functions, and lists in Python
- A good laptop to use