Data Architect/Data Analytics Module           

Overview

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 Content   
  • 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

PSI
clep
pearson1
Scantron-Logo+Tagline
Kryterion Authorized Testing Center
EEP-Logo
PSI
clep
pearson1
Scantron-Logo+Tagline
Kryterion Authorized Testing Center
EEP-Logo

 IT Expert System, Inc. is approved to operate by the Private Business and Vocational Schools Division of the Illinois Board of Higher Education.

 IT Expert System, Inc. is not accredited by a US Department of Education recognized accrediting body. IBHE Mandatory Disclosure Reporting

 IT Expert System, Inc Training programs are approved by the Illinois State Approving Agency for the enrollment of qualified veterans and/or other eligible persons to receive Montgomery GI Bill® education benefits.

‘PMP’ and 'CAPM' are registered marks of the Project Management Institute, Inc.

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

Office:

951 N. Plum Grove Rd.

Suite A, C
Schaumburg, IL, 60173

Ph: 847 350 9034

Email: info@itexps.com

Branch Office:

1560 Wall Street,

Suite #111,

Naperville, IL 60563 

Ph: 847 350 9034

Email: info@itexps.com

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