Online Courses
Data + Analytics in InsuranceLearn how to harness data and harvest business value in the insurance industry using analytics.
Vertical Divider
|
Cross-Selling and Up-SellingImprove and optimize your promotions, product placements, and bundling of products.
Vertical Divider
|
IoT and AnalyticsUnderstand the Internet of Things and learn how to capitalize on/implement IoT solutions.
|
On-Site Training
HARNESSING - Enterprise Data Management
Data Architecture & ModelingTopics 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 Warehouse & Data LakeTopics 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
|
HARVESTING - Descriptive Analytics (BI)
Exploratory Data Analysis & WranglingWe 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)
|
Tableau
|
Microstrategy
|
HARVESTING - Advanced Analytics
Predictive ModelingTopics include definitions, sampling, MDLC, CRISP-DM, Data Wrangling, Modeling, Production, Testing, Machine learning & Statistical Techniques, RoC Curves.
Vertical Divider
|
Statistical TechniquesTopics include Basic Statistics such as probability, permutations and combinations, Distributions, z-score, p-value, Sampling, Bias, Random values, Bayesian Models etc.
Vertical Divider
|
Machine LearningTopics 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/
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/