Training

Information Technology

Data Analysis Comprehensive Course

Start: Sep 2017       Type: Evening / Weekend Classes       Duration (hr): 156

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, Data Visualization with Tableau.
  
COURSE CONTENT: 
  
1. Statistics for Business. Overview – students will review basic concepts and terminology in Statistics.
   
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. Data Visualization with Tableau – the module includes: using the Tableau interface/paradigm to create data visualizations, creating calculations, building Dashboards, 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. 
 
5. 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.
  
6. 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.
 
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.The module includses: data types, table structure, essential SQL commands, retrieving data, queries, group functions, data manipulation, control transactions etc.
 
8. Project – students will polish their knowledge practicing Data Analysis and Data Visualization.
 
*156 instructor-led class hours, plus labs
 
Prerequisites:
Basics of Statistics and Excel. Related education or work experience is a plus.
 
 
   
  

 

Related Courses