top of page
data analyst course online, data analytics certification, python for data science, sql data analyst

Data Analyst Course

Dive into an immersive learning experience, unlock new skills, and pave the way for a dynamic career

Streamlined career pivot

Our course simplifies the process of advancing or shifting careers, paving a new path in just 6-10 months.

Comprehensive career boost

Our course equips you with everything needed to advance or launch your Data Analyst career, instilling confidence in your career journey.

Excellence within reach

Our Data Analyst training offers a realistic and attainable path where confidence intersects with capability, catering to individuals of various backgrounds.

Learn from the best

Gain hands-on training from NYC professionals in our Data Analysis course, aligning your skills with global tech standards.

Job Outlook

Data Analysts

Average Salary

New York, NY. 2024

$88,490

Ziprecruiter.com, 2024

Projected Growth

Number of jobs 2023-2032

23%

 U.S. BUREAU OF LABOR STATISTICS, 2024

Market Size

Forecast by 2028

$199 bn

GLOBE NEWSWIRE, 2024

Tube Lights

Why pursue a career in Data Analytics?

Unlock career opportunities through Data Analytics skills

Whether your background is STEM, business, or social sciences, mastering data analysis boosts your market value, unlocking higher-paying job opportunities and advancement potential.

No education in Statistics or Computer Science is required

While having relevant education is always a plus, for hiring companies, it is more important to demonstrate practical Data Analysis knowledge and skills.

Data Analytics offers many career avenues

Whether you're seeking to excel in finance, healthcare, or marketing, mastering data analytics opens doors to diverse career paths.

Why Us?

  • We conduct IT training in New York City since 1993

  • Our training is approved by the New York State Education Department

  • We offer hands-on training to acquire practical, in-demand skills

 

  • We design up-to-date curriculum to meet job market requirements

Computer Keyboard

Course Objectives

This comprehensive course equips students with the essential skills and tools necessary to excel as a Data Analyst in today's data-driven world. Covering a diverse range of topics including:

  • Understand the fundamentals of statistics and their application in data analysis

  • Master advanced features and functions of Excel

  • Acquire proficiency in SQL querying

  • Create visually compelling data visualizations using Tableau

  • Learn Python programming language for data analysis and manipulation

  • Utilize Python libraries such as NumPy, Pandas, Seaborn, Matplotlib, SciPy, and StatsModels for data analysis tasks

  • Gain insights into business intelligence concepts and develop reports and dashboards using Power BI

Course Topics

Data Analysis Core:

Statistics Basics

Some students may find their understanding of statistics to be somewhat rusty. By incorporating this module into our curriculum, we ensure that all students achieve the same level of familiarity with the subject.

Students will review basic concepts and terminology in Statistics. In this module, you'll delve into fundamental statistical concepts essential for data interpretation and analysis. Explore topics such as population and sample, descriptive and inferential statistics, and the organization of data variables and scales. Learn how to describe data using tables and graphs, distinguishing between qualitative and quantitative variables, as well as sample and population distributions.

Discover various measures of central tendency, including mode, median, and mean, along with measures of variation such as range, interquartile range, and standard deviation. Gain an understanding of probability distributions, including the normal distribution, and explore sampling distributions and point estimation.

Dive into hypothesis testing, including p-values and null and alternative hypotheses, and learn about popular analysis methods, such as descriptive statistics, regression, correlation, t-tests, ANOVA, and sampling methods.

Advanced Excel

In this module, we cover the most popular techniques, such as formulas, math and logical functions, statistical functions, lookup, pivot tables, and using macros.

In this Advanced Excel module, students will delve into advanced Excel techniques essential for efficient data manipulation and analysis. Learn various math functions such as Auto Sum, Absolute Values, and Rounding Values, as well as text and date functions to handle text and date-related data effectively.

Explore logical functions like IF, AND, OR, and NOT for making decisions and performing conditional calculations. Gain proficiency in statistical functions such as SUMIF, COUNTIF, and SUMPRODUCT for analyzing data based on specific criteria.

Discover additional functionalities including lookup, sorting/filtering data, pivot tables and pivot charts, and power pivot tables for dynamic data analysis. Additionally, get a quick review of VBA scripting and using macros to automate repetitive tasks and enhance productivity.

SQL Databases

This module teaches how to work with relational databases, specifically focusing on extracting and manipulating data using SQL queries.

 

In our SQL Databases module, students will gain comprehensive knowledge of SQL fundamentals essential for effective data querying and manipulation. Learn to craft powerful SELECT queries to retrieve data from databases, and master techniques for filtering, grouping, and sorting data to extract valuable insights efficiently. Explore advanced SQL concepts including joins and unions to combine data from multiple tables seamlessly. Gain proficiency in utilizing built-in functions to manipulate dates and strings effectively.

Understand the importance of primary and foreign key table relationships, and discover strategies for optimizing database performance using indexes. Dive into additional topics such as creating views for simplified data access, leveraging conditional testing with IF and CASE statements, and performing data manipulation operations including inserting, updating, and deleting records.

By the end of the module, students will have a solid understanding of SQL databases and the ability to leverage SQL skills to extract, manipulate, and analyze data effectively.

Data Visualization with Tableau

Tableau is one of the most popular data visualization tools in the market, offering flexibility in building dashboards and employing advanced data visualization techniques

In our Data Visualization with Tableau module as part of the Data Analysis course, students will explore the Tableau interface and paradigm to create impactful data visualizations. Learn how to create calculations, build dashboards, and utilize advanced chart types to present data effectively.

 

Gain proficiency in creating complex calculations to manipulate and analyze data, and utilize statistical techniques to derive meaningful insights. Discover advanced geographic mapping techniques for spatial analysis and visualization of both geographic and non-geographic data.

 

Learn how to prepare data for analysis, combine data from multiple sources using data blending techniques, and complete exercises to apply the skills learned throughout the module.

Data Analysis with Python:

Python Programming

First things first, to utilize Python for Data Analysis, let’s learn the fundamentals of Python programming, such as data types, loops and iterators, working with files and functions, and other concepts

In this Python Programming module, students will cover essential topics to build a strong foundation in Python programming for data analysis tasks. Explore basic data types, variables, operators, functions, and modules to understand the core concepts of Python programming.

Delve into compound data types including lists, strings, sets, and dictionaries, and learn how to manipulate and manage data effectively. Gain proficiency in flow control mechanisms such as conditional expressions, loops, and iterators to control the execution flow of your programs.

Learn how to work with files and functions to handle input/output operations and create reusable code snippets. Get an overview of object-oriented programming (OOP) concepts and understand the benefits of utilizing the standard library for efficient programming practices.

Data Analysis with Python Libraries

Now that we've learned the fundamentals of Python programming, we can practice analyzing data and creating visualizations using Python Libraries - modules of code that we can use in a program for specific operations, such as Pandas, Numpy, Seaborn, Matplotlib, SciPy, StatsModels, etc.

In this Data Analysis with Python Libraries module, students will delve into essential Python libraries for comprehensive data manipulation, visualization, and statistical analysis.

Explore the functionality of the Pandas library, mastering series and dataframes to perform diverse tasks such as aggregation, importing/exporting data from various formats, merging datasets, and handling missing data. Additionally, understand the powerful capabilities of the NumPy library for creating arrays, performing mathematical operations, and indexing/slicing data. Learn how to visualize data effectively using Seaborn and Matplotlib libraries, creating a wide array of plots including histograms, scatter plots, bar plots, box plots, heatmaps, and more.

 

Understand statistical analysis concepts with SciPy and StatsModels libraries, covering descriptive statistics, probability distributions, hypothesis testing, and ANOVA.

Gain proficiency in the data analysis process from setting analysis objectives, data collection, cleaning, exploratory data analysis (EDA), feature engineering, modeling, to interpreting insights and delivering results. Complete a project to apply the skills learned throughout the module.

Bonus:

Business Intelligence with Power BI

Power BI offers numerous features for creating reports and dashboards, enabling effective extraction and transformation of insights from data, along with advanced data analytics capabilities.

In this module, students will delve into the intricacies of utilizing Power BI to harness the full potential of data for insightful analysis and decision-making.

Learn the fundamentals of connecting to various datasources, deploying data gateways, and managing connections with import and DirectQuery methods. Dive into data modeling essentials including layout, data types, filtering, merging, and basic transformations to prepare data for analysis effectively. Master advanced Power BI features such as creating relationships between data tables, formatting data, and implementing various calculations including iterators, logical functions, and date/time functions. Explore techniques for handling errors, cleaning text fields, and applying business rules to derive valuable insights. Understand the power of quick measures and learn to leverage them efficiently to streamline the analysis process. Gain hands-on experience in building robust reports and dashboards that communicate insights effectively to stakeholders. 

By the end of the module, students will be equipped with the skills to leverage Power BI as a powerful tool for business intelligence, enabling them to drive data-driven decisions and deliver impactful solutions.

Questions?

Give us a call at 718-648-3997 or send us a messageWe are happy to walk you through the course and answer your questions.

Duration: 16 weeks

The actual number of weeks depends on holidays and the schedule

Course Schedule:

Tuesday (7PM-9:30PM)

Wednesday (7PM-9:30PM)

Thursday (7PM-9:30PM)

Sunday (10AM-3:30PM)

Eastern Standard Time (New York Time)

Training Type: Remote

This is a remote synchronous instructor-led training

Next Start:

March 2024

Contact us for start dates and enrollment process. Limited number of seats. Please register in advance.

Tuition

$2,750

Payment plan

We offer three installments payment plan. First payment of $1,000 (registration), second payment of $1,000 (30 days after the start), and $750 (60 days after the start).

Flexible refund policy

The course didn't work out for you? No problem. Ask for eligible refund: 1st week 100%, 2nd week 75%, 3rd week 50%, 4th week 25%. Except non-refundable $50 registration fee.

No full tuition commitment

Unlike other schools, we have no "full tuition commitment" policy when a student withdraw from the course. Stop when you drop. Contact for details.

We offer free retake

Completed the course, but need to retake some of the modules or a whole course again? We can do it. Let us know in advance. Limited seats. 12 months eligibility.​

White Waves

Customize Your Training

DATA ANALYSIS

CORE

Data Analysis Core:

Statistics Basics 

Advanced Excel

SQL Databases

Data Visualization with Tableau

Ideal for entry-level analysts and skill enhancement

7.5 - 10 hours/week

10 weeks

 

$1,950

FULL

COURSE

Best for effectively starting a data analyst career

Data Analysis Core:

Statistics Basics 

Advanced Excel

SQL Databases

Data Visualization with Tableau

Bonus Module: Power BI

Data Analysis with Python:

Python Programming

Data Analysis with Python Libraries

12.5 hours/week

16 weeks

Best Value

$2,750

DATA ANALYSIS WITH PYTHON

Ideal for data analysts advancing with Python analytics

Data Analysis with Python:

Python Programming

Data Analysis with Python Libraries

5 - 7.5 hours/week

14 weeks

 

$1,750

Tuition Assistance

You may be eligible for a training grant. Please visit our Tuition Assistance page for more information or contact us.

data analyst course online, data analytics certification, python for data science, sql data analyst

Course Advantages

  • Only 16 weeks to learn a new profession: No additional years in college

  • Weekday evening and weekend classes: Attend your other life commitments

  • Remote course: Study from anywhere

  • Real-time instructor-led classes: No more uncompleted self-paced online courses

  • Affordable training costs: No unnecessary financial burdens

  • Free retake opportunity: Refresh the skills that you have learned for free

  • Payment plan: Finance your education with confidence

 

  • Flexible refund policy: Less financial risks and peace in mind

Let's get you hired

Where Our Students Work

merck, logo
Bofa, bank of america, logo
pseg, logo
dtcc, logo
Deloitte, logo

Success Stories

"The Data Analysis programs in this school are very beneficial and relevant to the market. Moreover, they add new fresh modules and classes on a constant basis to meet the highest requirements of the IT industry. I highly recommend SAM Consulting Services to anyone."

​Alex, Project Manager

"SAM Career Center is an excellent place to learn the latest, cutting-edge technologies. The place is professionally run, teachers are knowledgeable, and you will meet the community of job seekers that will help you to build yourself up."

 

Oleg, Senior Analyst

Frequently Asked Questions

What is the application and enrollment process?

There are two steps. First, an informal admission interview over the phone, where we have the opportunity to answer questions about the course and discuss the applicant’s background (education, experience) to ensure their training needs align with the course objectives. The goal is to help the applicant make an informed decision. Second, once approved by our admissions team, we send our standard enrollment paperwork to sign and an invoice for the first payment, concluding the enrollment process. 

What are the course prerequisites?

Excel and Statistics basics. Completed college degree (associate or bachelor's) or nearing graduation is highly preferred, most majors are acceptable. Alternatively, a high school diploma with a combination of corporate/industry work experience. Any related work experience and education is welcome, but not required. 

What placement assistance services do you offer to your students?

We provide free assistance with resume editing and optimization for the target job, behavioral interview questions, technical interview questions, and job search resources and strategies. These services are available to students upon request. Additionally, we offer career coaching services as an optional add-on for an additional fee.

Do you guarantee jobs after completing the course?

As a school, we strive to create a productive learning environment that enables students to unlock their potential for a successful new career; however, we cannot promise employment to all our students.

Is your training hands-on?

Yes, while we do have a theoretical component, the majority of hours are dedicated to hands-on practical training to develop skills essential for the job.

How can I maximize the training for better job prospects?

Actively engaging in classes is crucial, offering valuable feedback for instructors to tailor their focus. Attend all sessions, as new topics build on previous lectures. Ensure completion of homework and utilize recommended supplemental materials. Additionally, concentrate on optimizing your resume and LinkedIn profile while honing your skills in answering interview questions.

What are the advantages of your training compared to any self-paced online course?

Since 1993, our training has offered a system that has helped hundreds of students start new careers. It helps maintain self-discipline, provides feedback and guidance from industry professionals with years of experience, and offers carefully designed comprehensive hands-on training optimized for employment. While we do recommend some self-paced online courses as supplemental materials, online courses may not be the best option for everyone as a main training source, especially for individuals making a transition into a new career.

What are the advantages of your training compared to boot camps?

The price of our courses is significantly lower than the average boot camp price, which may vary from $8,000 to $18,000. We offer a comparable number of actual instructor-led hours. We have a flexible refund policy and no "full tuition" commitment for students who decide to withdraw from the training. Our evening and weekend schedule allows students to attend to other life commitments. We have over 30 years of experience in conducting IT training in New York City.

Am I eligible for a training grant?

To determine your eligibility for a training grant, please visit our Tuition Assistance page or give us a call at 718-648-3997.

Need career advice?

Give us a call at 718-648-3997 or send us a message. We are happy to discuss your career experience and explore this career path.

bottom of page