Online Courses

Data + Analytics in Insurance

Learn how to harness data and harvest business value in the insurance industry using analytics.
Vertical Divider

Cross-Selling and Up-Selling

Improve and optimize your promotions, product placements, and bundling of products.
Vertical Divider

IoT and Analytics

Understand the Internet of Things and learn how to capitalize on/implement IoT solutions.

On-Site Training

HARNESSING - Enterprise Data Management

Data Architecture & Modeling

Topics include Data Modeling Overview, Database Development Cycle, Three Schema Model, Entity-Relationship (ER) Modeling,  Extended ER, IDEF1X, 4 Types of Relationships, Domains, Enterprise Data Modeling, Standardization, Roles, Tools, Challenges, Normalization, Dimensional Modeling​.
Vertical Divider

Data Quality
​

Data Quality (DQ) Topics include Overview, Definitions, Challenges, Solutions, Tools, Types of Issues, Metrics, Implementation strategies, Thresholds.
Vertical Divider

Data Warehouse & Data Lake

Topics include Data Warehouse, Data Lake, Architecture, Components, ETL/ELT, Slowly Changing Dimensions, Dimensional vs 3NF Modeling, Automating scripts, Pipelines, SQL, Native DBMS Tools, Commercial Enterprise Tools.
Vertical Divider

​SQL
​

Topics include RDBMS, SQL, DDL, DML, DCL, Syntax, Usage, SEE Strategy, Practice Problems, Aggregate Functions, NULL Values, Joins, Nested Queries, Combo Statements, ANSI Standard, SQL Front-ends.
* See FREE training resources at the bottom of this page.

HARVESTING - Descriptive Analytics (BI)

Exploratory Data Analysis & Wrangling

We study what is involved in EDA and Why, Data Quality, Pivot, Correlations, Heteroskadicity, NULL Imputations, Factor Analysis, Unique values, Homonyms & Synonyms, Grain of Data.
Vertical Divider

Data Visualization (BI)
​

Topics include Normalization, Dimensional Modeling, Star & Snowflake Schema, BI Visualization Tools, Metrics, Facts, Dimensions, Attributes, Measures, Drill up & down, detailed vs summary metrics, visualization widgets.
Vertical Divider

Tableau
​

Topics include system requirements, dimensional modeling, facts, dimensions, attributes, filters, sorting, aggregation, stories, visualization widgets, data cleansing and splitting, data types.
Vertical Divider

​Microstrategy
​

Topics include system requirements, dimensional modeling, facts, dimensions, attributes, filters, sorting, aggregation, SQL, visualization widgets, data cleansing and data types, visual thresholds, alerts.

HARVESTING - Advanced Analytics

Predictive Modeling

Topics include definitions, sampling, MDLC, CRISP-DM, Data Wrangling, Modeling, Production, Testing, Machine learning & Statistical Techniques, RoC Curves.
Vertical Divider

Statistical Techniques

Topics include Basic Statistics such as probability, permutations and combinations, Distributions, z-score, p-value, Sampling, Bias, Random values, Bayesian Models etc.
Vertical Divider

Machine Learning​

Topics include Supervised Learning Techniques (Prediction and Classification including regression, gradient boost, random forest, decision trees etc.) and Unsupervised Learning Techniques (Association Rule Mining, Clustering, PCA).
Vertical Divider

Text Analytics

Topics include various NLP and text mining techniques including N-gram, Word2Vec, Topic Extraction, Sentiment Analysis, Similarity Measures, Clustering

TCS Courses Created & Taught

While working at TCS from 2008-2014, Ajay built internal curriculum, competency, and proficiency plans in areas relating to enterprise data management, statistics, machine learning, predictive modeling, and text analytics. More than 3500 TCSers have benefited from these trainings. ​

UT, UTA, CoEP Courses Taught

As a graduate student at UTA and later as an Adjunct Faculty at UT Austin and College of Engineering (CoEP) Pune, Ajay has actively taught various Data & Analytics Related courses. Ajay enjoys teaching and considers it as a great way to learn and give back to the community.
Courses Include:
Ajay has also guest-lectured in Graduate level Executive MBA & Data Mining courses.

15 Free SQL Training Resources

Leetcode SQL Link:
 
1. Second highest salary problem: https://lnkd.in/erz9tM2
 
2. Duplicate emails: https://lnkd.in/eF9NJ4w
 
3. Classes with more than 5 students: https://lnkd.in/enYntdq
 
4. Rising temperature: https://lnkd.in/eEe3k-k
 
5. Department top 3 salaries (this one is hard): https://lnkd.in/e-SmKD4

6. Zachary Thomas' SQL Questions https://lnkd.in/g-JJzuD

7. Select * SQL: https://selectstarsql.com/

8. Leetcode: https://lnkd.in/g3c5JGC

9. LinkedIn Learning: https://lnkd.in/gQXFc4n

10. Window Functions: https://lnkd.in/g3RtPCJ

11. HackerRank: https://lnkd.in/grv_9sB

12. W3 Schools: https://lnkd.in/gJPfrrv

13. CodeAcademy: https://lnkd.in/gT5xmpN

14. SQLZoo: https://sqlzoo.net/

​15. SQL Bolt: https://sqlbolt.com/

© 2015-22 Analytics Advisory Group, LLC. All Rights Reserved.