Professional Skills
Attention to Detail, Problem Solving, Analytical Thinking, Stakeholder Communication, Teamwork, Time Management, Accuracy, Process Improvement.
Excel & Spreadsheet Analytics
Microsoft Excel, PivotTables, PivotCharts, XLOOKUP, VLOOKUP, INDEX/MATCH, SUMIFS/COUNTIFS, IF/IFS, IFERROR, Conditional Formatting, Data Validation, Sorting/Filtering, Dashboard Design, KPI Reporting.
Data Analysis & Reporting
Data Cleaning, Data Transformation, Data Validation, Data Reconciliation, Exploratory Analysis, Trend Analysis, Variance Analysis, KPI Tracking, Business Reporting, Requirements Gathering, Data Storytelling.
Data Visualization
Power BI, Tableau, Excel Charts, Interactive Dashboards, Slicers, KPI Cards, Visual Reporting.
SQL & Databases
SQL Server, MySQL, SELECT, JOINS, GROUP BY, HAVING, CASE, Subqueries, CTEs, Window Functions, ROW_NUMBER, Data Cleaning, Data Transformation.
Python
Python, Jupyter Notebook, Pandas Fundamentals, Data Cleaning, Exploratory Analysis, Basic Visualization.
Data & Collaboration Tools
GitHub, GitLab, CRM Systems.
Data Methods & Development
Data Cleaning, Data Validation, ETL Concepts, KPI Analysis, Descriptive Statistics, Business Reporting, Dashboard Development.