Training

Information Technology

Data Analysis with Business Intelligence (BI, SQL, Excel, Tableau)

Start: Sep 2019       Type: Evening / Weekend Classes       Duration (hr): 145

COURSE DESCRIPTION:

This unique course provides solid knowledge in Data Analysis and Business Intelligence. Students will learn the fundamentals of Data Analysis with Microsoft Excel, SQL Databases and Business Intelligence, Data Visualization with Tableau. After completing this course, students will be able to work as a Data Analyst or perform related work that requires knowledge of data analysis, data manipulation and data visualization.
  
COURSE CONTENT: 
  
1. Statistics Basics – students will review basic concepts and terminology in Statistics.
 
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. Foundations of Business Intelligence with SQL – in this module students will learn key components of the Microsoft Business Intelligence stack, including SSIS for ETL, SSRS for reporting and SSAS for multidimensional data analysis. SSIS provides knowledge in creating connection managers to various data sources, use and configure data flow and control flow tasks, work with container objects, create variables and parameters, deploy packages, work with the Integration Services Catalog. SSRS concentrates in configuring the tablix controls (table, matrix and list), creating data sources and data set, using subqueries, grouping rows and columns, dynamic and cascading parameters, conditional formatting, creating expressions, publish reports. SSAS teaches creating multidimensional cubes, building dimension and fact tables, datawarehouse concepts, star and snowflake schema.
 
4. 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.
 
5. 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. 
 
6. Project – students will polish their knowledge practicing Data Analysis and Data Visualization.
 
*145 instructor-led in-class academic hours
 
Prerequisites:
Basics of Statistics and Excel
  
Bonus for our students enrolled in DA w course:  
Special discount price for SAS ProgrammingR Programming (valid 24 months)
 
Note: Statistics Basics module can be waived for students with recent similar college credits (Statistics) or people with extensive experience in Statistics.
 
 
   
  

 

Related Courses