Training

Information Technology

Data Analysis (Excel, SQL, Tableau)

Start: Nov 2019       Type: Evening / Weekend Classes       Duration (hr): 96

COURSE DESCRIPTION:

This course is perfect for business professionals, analysts, non-programmers, students and graduates who would like to improve their Data Analysis and Data Visualization skills. Students will learn how to work with data using advanced Microsoft Excel techniques, such as Functions, Lookups, Pivot Tables and Pivot Charts, Data Analysis Tools. Also, students will discover how to use VBA and Macros for more advanced analysis and automated procedures. Students will study fundamentals of SQL syntax and writing queries in SQL Server Databases. Finally, students will become skilled at Data Visualization in Tableau, including building Dashboards and using statistical techniques to analyze data. After completing this course, students will be able to perform work that requires intermediate knowledge of data analysis and data manipulation (in the Microsoft Excel environment) and data visualization.
  
COURSE CONTENT: 
  
1. Data Analysis with Excel – 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, Power Pivot Tables, Data Analysis Tools etc. Also, this module provides introduction to VBA scripting and using Macros.
 
2. SQL Databases Fundamentals – this module provides solid fundamentals of SQL databases, with emphasis on querying data. Students will learn how to filter, group and sort data, retrieve data from multiple tables using joins and unions, built-in functions to manipulate dates and strings, primary and foreign key table relationships, understand indexes for performance gains. The following topics will be covered: select queries, filtering, grouping, sorting data, combining tables with joins and union, understanding primary and foreign key relationship, views, built in system functions for querying data, conditional testing with If and Case statements, looping, inserting, updating and deleting data basics.
 
3. 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.
 
*96 instructor-led in-class academic hours
 
Prerequisites:
Basics of Excel
    
 
 
 

Related Courses