Skills
Excel
- Data Cleaning using formulas
- Pivot Tables & Charts
- Conditional Formatting
- VLOOKUP & XLOOKUP
- Power Query for data transformation
SQL
- Complex queries for data extraction & analysis
- JOINs & aggregations across multiple tables
- Window functions for advanced analytics
- Date & time functions for time-based insights
- DML & DDL for managing analytical datasets
Python
- NumPy & Pandas for data manipulation
- Matplotlib & Seaborn for visualization
- Scikit-learn for machine learning
- Jupyter Notebooks for interactive coding
- BeautifulSoup & Scrapy for web scraping
Jupyter Notebook
- Interactive code execution
- Markdown documentation
- Data visualization inside notebooks
- Integration with Python libraries
- Exporting notebooks as HTML/PDF
Statistics
- Descriptive Statistics
- Probability Distributions
- Inferential Statistics
- Correlation & Regression Analysis
- ANOVA and Chi-Square Tests
Power BI
- Building interactive dashboards
- Power Query for data transformation
- DAX language for calculated columns
- Real-time data visualization
- Integration with Excel & databases
Tableau
- Drag-and-drop dashboard creation
- Calculated fields & LOD expressions
- Interactive filters and parameters
- Data blending and joins
- Integration with SQL & cloud data
GitHub
- Uploading and maintaining analysis projects
- Using Git for version control
- Sharing notebooks and dashboards
- Documenting projects with README files
- Collaborating with teams
