In partnership with the Digital Skills Certification Institute USA, 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.

Unit 1: Fundamentals of Data and Excel I

• The Value of Data
• Navigating in Excel
• Preparing Data in Excel
• Cleaning 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

• Why is this course relevant today?

• 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.

• What practical skill sets can I expect to have upon completion of the course?

• 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.

• Are there any prerequisites for this course?

• No, there are no prior knowledge required
• Your willingness to learn, grow and explore new opportunities are most critical
• Following this, basic computer appreciation is vital
• A good laptop to use
• Understanding Microsoft products will be an advantage but not required.

Choose one of two convenient ways to skill up on Data Analytics. Our 7-Weeks (3 hours/twice a week) Classroom bootcamps which is only available in some cities. If your city is not available or if your work won’t permit a classroom session, you can attend the fully online school. We give several learning aids, assignments and tasks which our team will work you through.