Kartik Jhajharia
Summary
A data analyst with a strong command of Python, SQL, advanced Excel, Power BI, and Tableau. Skilled at transforming complex datasets into clear, actionable insights through effective data visualization and analysis. Demonstrates a keen curiosity and problem-solving mindset to tackle challenging data problems and deliver simplified solutions that drive informed decision-making.
Skills
Advanced Excel:Advanced formulas XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS
Array & dynamic formulas: FILTER, SORT, UNIQUE
Data validation & conditional formatting
Data Analysis
Pivot Tables & Pivot Charts (advanced)
Power Query (data cleaning & transformation)
Power Pivot & Data Model
What-If Analysis (Goal Seek, Solver)
Automation
Macros & basic VBA
Excel dashboards & reporting
SQL:SELECT, WHERE, ORDER BY, GROUP BY, HAVING
JOIN (INNER, LEFT, RIGHT, FULL)
Subqueries
Advanced
Window functions (ROW_NUMBER, RANK, LAG), CTEs (WITH)Views & indexes, Case statements, Data Handling, Data cleaning with SQL, Performance optimization, Writing analytical queries
Python:Variables, loops, functions, Lists, dictionaries, tuples, File handling
Data Libraries:NumPy, Pandas (data cleaning, merging, grouping), Matplotlib & Seaborn (visualization)
Data preprocessing, Working with APIs, Jupyter Notebook
Intro to machine learning (optional)