I'm a Technical Lead with 2.4 years of Analytical Experience(overall 3.8 years in IT) with hands on experience in SQL, Excel, Power Bi and Python specializing in:
Data cleaning and Transformation
Exploratory Data Analysis(EDA)
Dashboard creation and reporting
Turning raw data into meaningful and actionable insights
SQL
SQL Commands
Filtering and Sorting
Functions (Aggregates, Strings, Numerics, Date/Time)
JOINS (Inner, Left, Right, Full, Self, Natural, Cross)
Grouping and Aggregations
Window Functions (Row_Number, Rank(), Dense_Rank(), Lag(), Lead(), Running Totals/ Averages..)
CTEs and Subqueries
Views & Indexes
Excel
Data Cleaning
Advanced Formulas
Pivot Tables and Slicers
Power Query
Power Pivot
Charts
Dashboards and reporting and many more....