Data Analytics Certificate Online (Self-Paced)

Master Excel’s most powerful features to streamline data analysis, improve reporting accuracy, and extract meaningful insights from large datasets in this hands-on training.

• Learn Excel functions and formulas for organizing, calculating, and summarizing data efficiently
• Create and customize visual charts, including line, column, and pie charts to present data clearly
• Use logical statements, database functions, and data validation to manage and filter large datasets
• Build and manipulate Pivot Tables to quickly summarize, sort, and group information
• Explore advanced tools like named ranges, date calculations, and macro recording for custom reporting
• Apply auditing techniques, cell locking, and Excel hot keys to optimize your spreadsheet workflow 

Build a strong analytical foundation through hands-on training in statistical concepts, forecasting techniques, and data modeling methods used across industries for smarter decision-making.

• Understand core statistical concepts including measures of central tendency, data dispersion, and the normal curve
• Explore descriptive and inferential statistics, including probability distributions like binomial and Poisson
• Learn to analyze and forecast data using correlation, linear regression, and multiple regression techniques
• Apply predictive analytics with tools like trendlines, moving averages, and scenario modeling
• Create clear data visualizations using charts, histograms, icon sets, color scales, sparklines, and pivot tables
• Discover prescriptive analytics techniques such as Solver and linear programming to optimize decision-making

Unlock the power of Python for data-driven decision-making as you master Python programming fundamentals and dive into data analysis. Acquire essential skills to clean and manipulate data, create insightful visualizations, and perform statistical analysis, all through hands-on projects with real-world datasets.

• Handle different types of data such as integers, floats, and strings
• Control the flow of your programs with conditional statements, loops, and functions
• Reuse and simplify code with object-oriented programming
• Analyze tabular data with NumPy and Pandas
• Create graphs and visualizations with Matplotlib
• Make predictions with linear regression, using scikit-learn

Learn how to extract, filter, and manipulate data using SQL. This course covers PostgreSQL fundamentals, database querying, table joins, and advanced techniques for handling large datasets.

• Write SQL queries to retrieve, filter, and sort data efficiently
• Use joins to combine information from multiple tables and establish relationships
• Apply aggregate functions like SUM, COUNT, AVG, and GROUP BY to summarize data
• Work with subqueries, conditional logic (CASE statements), and advanced string functions
• Optimize queries using indexes, data type conversions, and best practices
• Explore views and user-defined functions to streamline database management

Learn how to use Python to extract data from websites and write loops for processing large numbers of pages. This course covers HTML and CSS, Python fundamentals, web scraping techniques, data storage, and scheduling.

• Learn Python syntax and how to construct programs and scripts
• Write scripts that automate manual tasks and update Excel files automatically
• Identify and correct common errors in your code
• Schedule your programs to run automatically on a regular basis
• Apply web scraping techniques through real-life exercises and examples

Learn to gather, manipulate, and analyze real-life data in this course, where you'll gain hands-on experience with Python's NumPy and Pandas libraries. Develop your data visualization skills using Matplotlib, Seaborn, Plotly, and Dash Enterprise, and complete real-life projects that can be deployed online.

• Plan, gather, and manipulate data from different sources to present a data story
• Find data stories through exploratory data analysis 
• Manipulate data with NumPy and Pandas.
• Use advanced Python visualization libraries Plotly and Dash
• Build a dashboard and apply the rules of effective dashboard design to create professional data science solutions
• Go live with your project and deploy the dashboard on a live server

Learn the fundamentals of machine learning, including regression analysis and classification algorithms, in this practical, hands-on course. Gain the skills needed to solve real-world problems using machine learning, with a focus on Python programming and data science libraries.

• How to clean and balance your data using the Pandas library
• Applying machine learning algorithms such as logistic regression and random forest using the scikit-learn library
• Choosing good features to use as input for your algorithms
• Properly splitting data into training, test and cross-validation sets
• Important theoretical concepts like overfitting, variance and bias
• Evaluating the performance of your machine learning models

Develop the skills to turn raw data into compelling visual stories with Tableau, the industry-leading data visualization platform. This hands-on bootcamp teaches you to explore, analyze, and publish dashboards that communicate insights clearly and effectively.

• Connect to datasets in various formats, then clean, filter, and structure data for effective visual storytelling
• Create a range of visualizations including bar charts, line charts, treemaps, heat maps, dual-axis charts, and advanced types like spider maps and alluvial diagrams
• Use Tableau's calculation tools to create custom fields, apply aggregates, and deepen your data analysis
• Format charts with labels, tooltips, color, and axis adjustments, and build interactive map visualizations such as choropleths and proportional symbol maps
• Customize dashboards and stories for various audiences and screen sizes using Tableau's interactivity tools
• Publish work to Tableau Online and export dashboards for professional sharing and collaboration

Throughout this program, you will complete three capstone projects to showcase in your portfolio: 

Machine Learning & AI Capstone

• Choose, clean, and engineer features from a structured dataset to train machine learning models (e.g., logistic regression, random forest), evaluate performance, and visualize results clearly.
• Deliver a professional presentation detailing your data processing workflow, modeling techniques, and insights discovered using Python libraries like pandas, scikit-learn, and Matplotlib.

Python for AI Capstone (Choose One of Two)

• AI Chat Assistant: Build an interactive chat assistant embedded on a webpage, using Flask and JavaScript to integrate with OpenAI’s API for context-aware user interactions.
• Collectibles Identification App: Develop a Flask-based web app allowing image uploads of collectible items, leveraging OpenAI to identify items, generate descriptive metadata, and dynamically display logged session history.

Python Data Visualization Capstone

• Clean, analyze, and visualize global CO₂ emissions alongside GDP and population data, highlighting trends and correlations through insightful visualizations with Matplotlib, seaborn, and plotly.
• Build a responsive Dash dashboard enabling interactive exploration of emissions data, clearly communicating insights such as regional trends, GDP-emission correlations, and emission anomalies.

You will work on your capstone projects both in and outside of class, using scheduled mentoring sessions to review your progress, ask questions, and get personalized feedback from your instructor.