jramanan.com/professional/Details-of-Technical-Skills
| Technology/Skill | Topics of Experience |
|---|---|
| SQL | |
| (Postgres, MS SQL Server, Google BigQuery) | Basic statements in DDL, DML, filtering using WHERE, AND/OR, LIKE, IN, LIMIT, Aggregates: AVG(), MIN(), MAX(), COUNT(), GROUP BY, HAVING(), Joins (LEFT, RIGHT, FULL, SELF), Subqueries, Nested queries, Common Table Expressions (CTE), window functions: OVER(PARTITION BY), Aggregate Window Functions, Ranking Window Functions RANK(), DENSE_RANK(), ROW_NUMBER() , Time-Series Window Functions: LAG(), LEAD() |
| Tableau | Creating intuitive dashboards (advanced level), dashboard performance optimization for large datasets in production, LODs FIXED, INCLUDE, EXCLUDE , Table Calculations, Window Calculations, Parameters, Sets, Sheet Swapping. |
| R | Tidyr, Dplyr, Lubridate, stringr, SNA, iGraph, file handling, R Markdowns, Automating data cleaning process on css/xlsx data formats |
| Python | Numpy, Pandas, Matplotlib, Seaborn, mlxtend, SciPy |
| Statistical Analysis | Frequency Distributions, Central Tendency (Mean, Median, Mode), Variability (variance, SD, range), Z-Scores, Probability, Sample mean and Standard Errors, Hypothesis testing (z-test, t-test, ANOVA), Linear Regression, Pearson Correlation |
| Machine Learning/ Data Mining | Association Rule Mining, Regression, Classification, K-Means Clustering, Recommendation System. |
| **Git | |
| (Gitlab, BitBucket, GitHub)** | setup git repo via git init, git clone, file management via git status, git add, branching using git checkout, git branch, update remote/local changes via git commit, git push, git pull, resolve merge requests using git rebase |