Data Architect/Data Analysis

Time: 32 hours (for each module) 

 

Course Description:

 

Data analysis/ architects develop, analyze, and administer data for businesses, schools, and other organizations. They need sophisticated design and development skills to collect data and translate it for use in computer applications and systems. Data architects are like data ninjas who figure out how to create and manage data for companies in complex, creative, and innovative ways. Data analysts review the data, visualize the data and find out the data patterns and based on perform data predictions.  

Course Topics:

Module 1: Data Architect 

  • Relational Databases concepts 

  • Recap of Database/SQL concepts

  • Dimensional Data Model

  • Star Schema /Snowflake Schema

  • Conceptual, Logical, and Physical Data Model

  • TOAD / ER Tools for creating Data Model

  • Reverse/Forward engineering

  • Data Reporting + Specification 

  • What is OLAP, OLTP

  • MOLAP, ROLAP

  • Data Integrity through Normalization

  • Business Intelligence / Visualization

  • Interview Preparation for Data Architect/ Data Modeler

   + Project work

Module 2: Data Analytics

  • Data vs Data Base vs Data Warehouse vs Big Data

  • Supervised/Non supervised learning/Machine Learning/Predictive Analysis

  • Data Statistics: Z Test  

  • Linear Regression [ANOVA], Correlation, Classification, Recommendation 

  • Linear Problem solving using Excel Solver

  • @Risk - Data Simulation and Data Distribution: Normal, Triangular, Uniform and more

  • Forecasting/Prediction Techniques/Algorithms
  • R - Programming for data visualization 

  • Healthcare + Retail Data Analysis using R

  • Visualization tools: Tableau

  • Case studies: data volume, velocity, varieties 
  • APM [Asset Performance Monitoring]

  • Hadoop Technology Overview

  • Python - Numpy , Pandas Data Analytics Library 

  • Software tools: GIT, R Studio, Anaconda, Excel, @Risk

  • AWS IOT Service Overview 

  • Project work

  • Interview Preparation for Data Architect/ Data Modeler

 

Who should take this course?

 

  • Project Manager

  • Database programmer

  • Web Developer

  • Architect

Note: Students can combine modules to get a combo discount.

 

 

1/7
Staffing Support
  • Resume Preparation

  • Mock Interview Preparation

  • Phone Interview Preparation

  • Face to Face Interview Preparation

  • Project/Technology Preparation

  • Internship with internal project work

  • Externship with client project work

Our Salient Features:
  • Hands-on Labs and Homework

  • Group discussion and Case Study

  • Course Project work

  • Regular Quiz / Exam

  • Regular support beyond the classroom

  • Students can re-take the class at no cost

  • Dedicated conf. rooms for group project work

  • Live streaming for the remote students

  • Video recording capability to catch up the missed class

Tel: 847 350 9034

1560 Wall Street, Suite #111,

Naperville, IL 60563

  • LinkedIn Social Icon
  • Facebook Social Icon

Disclaimer: At this time, we are not offering any training programs for Nebraska residents.
 

 'PMP' and 'PMI' are registered marks of the Project Management Institute, Inc.

'GI Bill' is a registered trademark of the U.S. Department of Veterans Affairs (VA).

InfoTekGuide - A Leading IT Training Provider in Schaumburg and Naperville