top of page

Data Architect/Data Analytics

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

  • Arch