Data Analytics courses in NY

COURSE DESCRIPTION:

This unique comprehensive course provides solid knowledge in Data Analysis and Statistical Software. Through a combination of lectures and exercises, students will learn the key techniques and approaches necessary to be an effective Data Analyst.
Students will learn fundamentals of Data Analysis with Python programming, advanced Excel techniques and VBA macros, basics of SQL Server Databases In the end of the course students will polish their knowledge practicing Data Analysis projects.

COURSE CONTENT:

1. Statistics for Business. Overview – students will review basic concepts and terminology in Statistics, including: Mean, Mode, Range, Standard Deviation, Normal Distribution, T-Distribution, Hypothesis Testing, Chi Square Test, A-B Testing etc.
 
2. Python Programming Fundamentals – the module includes following topics: Basic Data Types (Basic Data Types, Variables, Operators, Functions and Modules), Compound Data Types (Lists, Strings,  Sets, Dictionaries), Flow control (Conditional expressions, Loops, Iterators), Working with files, Working with functions, OOP Concepts, Benefits of Standard Library.

3. Data Analysis and Visualization with Python – module provides solid fundamentals of Data Analysis and Data Visualization using Python Libraries: Numpy, Pandas and Seaborn. Students will learn Machine Learning (Linear Regression, Logic Regression etc) and Data Visualization with Histograms, Kernel Density Plots, Box and Violin Plots, Clustered Matrices, Regression Plots etc.

4. Advanced Excel Techniques – in this module students will learn Excel advanced techniques, including Math Functions, Logical Functions, Statistical Functions, Lookup, Sort/Filter Data, Pivot Tables and Pivot Charts, Data Analysis Tools etc.

5. VBA Programming Fundamentals – this module provides VBA Programming fundamentals, including VBA Sub Procedures, VBA Function Procedures, Excel Objects, and using Macros. VBA is simple but powerful scripting language that will help to analyze data, work with objects and develop automated procedures.

6. Microsoft Access. Overview – this module student reviews fundamental functions of Microsoft Access, such as Tables and Datasheets, Lookups, Forms, Reporting etc.

7. Introduction to SQL Server Databases – this module provides students with the understanding of database concepts and the essentials of relational database with the SQL language. Through a series of hands-on activities students will learn data selection and manipulation using multi-vendor compliant SQL syntax and writing simple queries. The module includses: data types, table structure, essential SQL commands, retrieving data, queries, group functions, data manipulation, control transactions etc.

8. Data Visualization with R – in this module students learn fundamental, intermediate and some advanced techniques for Data Visualization and Business Intelligence. The module starts with the following topics: using the R interface/paradigm to create data visualizations, creating basic calculations (arithmetic, custom aggregations/ratios, date math, and quick table calculations), building Dashboards to share visualizations. After this module students will know how to build some advanced chart types and visualization, complex calculations to manipulate data, use statistical techniques to analyze data, implement advanced geographic mapping techniques and visualizations of non-geographic data, prep data for analysis, combine data sources using data blending.

9. Data Analysis Projects Workshop – at the end of the course students will polish their knowledge practicing Data Analysis and Data Visualization with Excel, Access, Python and R.

180 instructor-led class hours, plus labs

Prerequisites:
Basics of Statistics and Excel. Related education or work experience is a plus.


CREATING RECORD MACROS
Recording a Macro
Running a Macro
Running a Macro from the Macros Dialog Box
Creating a Short-cut key to run a macro
Running a Macro with a Shortcut key
Assigning a Macro to a Menu or Toolbar
Editing a Macro with Visual Basic
VISUAL BASIC EDITOR
Objects
Methods
Properties
Programming Tools
The Menu Bar
THE PROJECT EXPLORER
Using the Project Explorer
USING CONSTANTS
Excel Constants
Variable Constants
EXCEL OBJECTS
Objects, Properties and Methods
Getting & Setting Properties
Calling Methods
Passing Arguments
Singular Objects & Collections of Objects
USING VISUAL BASIC FUNCTIONS
InputBox Function
MsgBox Function
Using a Set Statement
BUILDING FORMULAR CONTROL STRUCTURES
If Then Janision Structures
Logical Operators
Select Case Janision Structures
Case Else
Comparison Operators with Select Case Structure
For Loops
Do Loops
While...Wend Statement
RUNNING CODE
Run mode and Design mode
Running Code from the development environment
Running Code from the host application
THE PROPERTIES WINDOW
Changing a Property
VARIABLES
Dimensioning a variable
Using variables in routines
Object Variables
USERFORMS
Designing & Creating Forms
Working with Controls
Creating Custom Dialog Boxes
Userform Properties Methods & Events
ADVANCED VBA PROGRAMMING TECHNIQUES
Developing Excel Utilities with VBA
Error Handling
Using In-Built Excel Features in VBA
Working with Pivot Tables
Working with Charts
Understanding Excel's Events
Interacting with Other Applications
Creating and Using Add-Ins
DEVELOPING APPLICATIONS
Working with the Ribbon
Working with Shortcut Menus
Providing Help for Your Applications
Developing User Oriented Applications
EVENT HANDLING
VBA Editing & Debugging
Auto Macros
Error Handling