Fundamentals of Data Analytics and Data Modeling using Excel and SQL

Through this program, you will develop a comprehensive understanding of data analysis and modeling. Starting with Excel, you’ll learn basic data analysis techniques, measure central tendencies using statistical methods, and create visualizations to depict data characteristics effectively. You will also explore measuring data spread and correlation.

The curriculum then shifts to SQL, covering database design and populating tables, along with querying data from multiple tables. You will gain proficiency in writing SQL queries and retrieving specific information from relational databases.

The course concludes with a capstone project that allows you to apply your skills in a real-world data analysis scenario. By the end of the course, you will have a solid foundation in using Excel and SQL for real-world, in-demand data analysis. You will be capable of performing various data analysis tasks, visualizing data, designing databases, and retrieving information efficiently.

Program Objectives

• Perform Basic Data Analysis Using Excel
• Measure Central Tendencies using Statistical Techniques
• Data Visualization Using Excel
• Measuring the Spread and Correlation of Data
• Creating Database Objects & Populate data
• Query Data Using SQL
• Retrieve Data from Multiple Tables
• Complete a Capstone Based on Real-World Application

Target Candidate

The target candidate for this program is either an early-career individual or someone seeking a career change to enter the high-paying field of data analytics. They are eager to gain a strong foundation in data analysis and modeling using Excel and SQL and have a genuine interest in learning how to perform data analysis tasks such as visualizing data effectively and leveraging databases.

This program appeals to individuals who aspire to secure jobs in data analytics, data modeling, business intelligence, or related fields who understand the growing demand for data professionals and seek to leverage their skills and knowledge to pursue lucrative career opportunities.