> Home / Continuing and Professional Studies / Data Analytics

Data Analytics

Turn Data Into Insights and Career Opportunities

Every day, organizations collect massive amounts of data—from customer interactions and marketing campaigns to financial transactions and operational performance. The challenge isn't gathering data; it's knowing how to turn it into meaningful insights that drive smarter decisions.

Data analytics is the process of collecting, cleaning, analyzing, and visualizing data to uncover trends, answer questions, and solve real-world problems. From understanding customer behavior to improving business operations, data analytics helps organizations make informed decisions with confidence.

The Data Analytics Certificate Program at CCNY Continuing and Professional Studies is beginner-friendly and designed to prepare you for the growing demand for data professionals. In this hands-on course, you'll gain practical experience with Excel, SQL, Tableau, and Python—industry-standard tools for analyzing, visualizing, and interpreting data. Working with real-world datasets from industries such as business, healthcare, marketing, public service, and operations, you'll complete guided projects, a midterm project, and a portfolio-ready capstone case study that demonstrate your ability to transform data into actionable insights while building a strong resume and professional portfolio.

Whether you're exploring a new career path, upskilling for your current role, or preparing for more advanced analytics training, this program provides a strong foundation in the tools and techniques used by today's data professionals. By the end of the course, you'll have practical experience, real-world projects, and a portfolio that showcases your ability to make data-driven decisions.

Course Description

The Data Analytics Certificate Program prepares students to explore and analyze data to solve real-world business problems. This hands-on course covers the essential tools and techniques used in the industry today, including SQL for data querying, Tableau for data visualization, and Python for statistical analysis.

Students will learn how to collect, clean, and interpret data, design dashboards, and communicate findings through impactful reports. Guided projects and a capstone assignment provide practical experience working with datasets across industries such as business, healthcare, marketing, and operations.

By the end of the course, students will gain a strong foundation in analytical thinking, data storytelling, and technical skills that prepare them for entry-level roles in data analytics and business intelligence.

Learning Outcomes

Through hands-on projects and guided instruction, you'll learn how to:

Analyze and organize data using Excel
Query and manage data with SQL
Create interactive dashboards and visualizations in Tableau
Perform data analysis and automation using Python
Communicate findings through compelling reports and presentations
Apply analytical thinking to solve real business challenges

Key Skills Covered

Excel Data Analysis
Data Visualization with Tableau
SQL Querying and Database Fundamentals
Python for Data Analytics
Dashboard Development
Data Storytelling and Communication
Analytical Thinking and Problem Solving
Portfolio Development

Schedule

Fall 2026:

Dates: September 14 - December 9 | Mondays & Wednesdays | 6:00 - 9:00 pm

Total Instructional Hours: 72; Total Sessions: 24; ONLINE

Tuition

$625 + $25 registration fee

Total: $650*

*CCNY students, staff, and Alumni Association members receive a 10% discount.
Payment plan options are available to assist with tuition affordability.

Instructor

Kamal Abdelrahman

Kamal Abdelrahman is an Analytics Specialist with a background in building dashboards and backend data engineering. His experience spans across non profits, tech, public service, marketing, and consulting. He has built Power BI and Tableau reporting for stakeholders across sales performance, operational ROI, and program outcomes, and has led analytics training in Tableau, SQL, and Python. His work includes automating large scale data cleaning with Python. Before analytics, Kamal was also a visual artist, painting murals across New York City, an experience that still shapes how he approaches storytelling, clarity, and design in data visualization. He’s also a lifelong fan of the Knicks and, like every New Yorker, holds a strong belief they’ll (maybe) one day win a NBA championship.

Benefits of Data Analytics?

As we explore data analytics, it becomes clear that its importance goes beyond numbers and stats. The true value of data analytics lies in its ability to uncover valuable insights organizations can use to drive their business goals.

Let's discuss some of the benefits data analytics brings to the table.

Better decision-making: Picture making decisions based on real data and facts—this is the essence of data-driven decision-making (DDDM). It's about making smart decisions that align with your goals, giving every team member the power to make better decisions daily. Achieving this requires nurturing skills in data proficiency, analytics agility, and fostering a data-centric community. Although it can be challenging to transform an organization into a data-driven one, blending data and analytics into decision-making processes can have a big impact.

Improve operational efficiency: Data analysis reveals bottlenecks and inefficiencies in your operations. This boosts efficiency and simplifies workflows while lowering operational costs and minimizing wasted resources. It's the recipe for enhancing your overall operations without sacrificing quality.

Enhance forecasting and planning: Data analysis provides predictive insights by enabling you to delve into historical trends and patterns. With this information, you can anticipate market shifts and emerging opportunities. It can also help you project sales and forecast customer demands. This foresight guides your decisions and helps you prevent potential disruptions.

Drive innovation: Data analytics plays a key role in driving innovation. Data, in particular, provides the foundation for game-changing innovations such as AI and impacts AI outputs. Overall, data analytics helps identify gaps in the market, determine customer needs, and reveal undiscovered opportunities. A data-driven approach encourages the exploration of new ideas and the creation of new products, services, and business models—ultimately driving growth and progress.

Boost security and minimize risks: When it comes to managing risks, data analysis is a reliable and valuable tool to have on your side. You can spot potential threats and craft strategies to mitigate them by examining past data and patterns. Insights gained through data analysis empower you to tackle uncertainties strategically, minimizing disruptions to your business.

Gain a competitive advantage: Combining the power of data analytics with market trend awareness, superior customer experiences, efficient operations, and informed decision-making creates an unbeatable competitive advantage. It extends to recognizing areas for improvement, tracking sales trends, and identifying market gaps fueled by insights from within your organization and the broader industry.

Career Outlook

Data Analytics is one of the most in-demand skills in today's workforce. According to the U.S. Bureau of Labor Statistics, jobs for data analysts, business analysts, and related roles are projected to grow much faster than average over the next decade. Professionals skilled in data analysis earn competitive salaries, with median U.S. salaries starting around $75K–$95K/year, depending on industry and location.

Typical job roles include: