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.
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
Why this training
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.
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
​​
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.
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
Tuition
$2,550
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 $550 (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.​
​
Customize Your Training
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,550
Tuition Assistance
You may be eligible for a training grant. Please visit our Tuition Assistance page for more information or contact us.
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
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.