Tejas Kanse

Background

About Tejas Kanse

Looking For Data Analyst Opportunities in Mumbai, Pune, and Bangalore locations. I've done my Computer Engineering from Mumbai University and I've also done course of PG in Data Analytics. Skills Acquired- 1)Machine Learning:@Jupyter Notebook @VSCode @googlecolab. Supervise Machine Learning(Linear Regression, Logistic Regression, Decision tree, Random Forest, KNN, Naive Bayes) Un-Supervise Machine Learning (KMeans clustering, Hierarchical clustering) Non-Linear interaction data(Bagging, Boosting) and learning new things daily. 2) Analysis Modules: Numpy, Pandas, Matplotlib, Seaborn Importing data from CSV, TSV, PSV, and Excel files, understanding data, data manipulation, data cleaning, handling null values, and performing Exploratory Data Analysis(EDA). 3) Python Programming:@IDLE,@Jupyter Notebook @VSCode @googlecolab.(Data types, conditional statements, loops, functions, modules, file operations, oops, exception handling, regular expression (Regex) and web scrapping, flask webpage development, and database connectivity) 4) SQL: on MySQL server @XAMPP Framework. DDL, DML, DQL, DCL, TCL Commands, Constraints, JOINS, Stored procedure, String Functions, Date Functions, Having Where and Group by clause, Indexing, Subquery, and Views. DBMS, RDBMS. 5)Power BI Desktop: DAX functions, Power Query (ETL operations), Power Pivot (Data Modelling & Data Relationship), Power View, Power Map, Power Q&A, Measures, Calculated Columns, visuals, filters, Datasets, Data Transformation, tiles, Reports, Dashboards, Schedule Refresh, Power BI Services, Power BI Pro/ Premium versions. 6) Math and Statistics: Types of data, descriptive statistics(mean, median, mode, std deviation, variance, normal distribution, z score, correlation, Karl parson's correlation coefficient), removal of outlier data points, inferential statistics(chi-square method, ANOVA), Probability and Probability distribution, hypothesis testing, correlation test, t-test, chi-square test, ANOVA test. 7) Tableau Desk: Data Analysis and Visualization, Tableau shelf, and card, connecting to and preparing data, joining and blending data, making insightful relations by plotting graphs and deriving noteworthy observations, filtering data, sorting data, building hierarchies, and making dashboards. 8)Advance Excel @MSexcel Macros, VBA, Edit, Date and Text Functions, Sort, Filter and Subtotals, Conditional Formatting, VLOOKUP & HLOOKUP, LOOKUP, INDEX, MATCH, INDIRECT, Data Validation, Pivot Table, Data Visualization, Protecting and Sharing Workbook.