Data Analyst | Data Engineer Designed and deployed a Power BI dashboard to track weekly sales trends, integrating multiple data sources and applying data modeling, reducing analysis time from 3 hours to 20 minutes.Cleaned, transformed, and automated a 10,000-row dataset in Excel and Power Query, preparing it for downstream analytics and ETL pipelines.Developed SQL queries and data pipelines to join 5 different tables, generate insights, and support management reporting and decision-making.
π Spreadsheets
- Excel: Pivot Tables, lookup functions (VLOOKUP/XLOOKUP), aggregate functions, IF logic, Conditional Formatting
- Google Sheets : Data cleaning, aggregate functions, lookup functions, pivot tables, collaboration features ποΈ Databases & SQL
- SQL
- MySQL
- PostgreSQL
- Oracle π Python & Libraries
- Python
- Pandas
- NumPy
- Matplotlib
π BI & Analytics
- Power BI: Data modeling, DAX (measures & calculated columns), interactive dashboards, report automation, data visualization
- Power BI Advanced Features: Data Gateway, Row-Level Security (RLS), Object-Level Security (OLS), deployment pipelines
ποΈ Data Engineering - Microsoft Fabric
- Data Pipelines
- Lakehouse
- ETL workflows
- Data Warehouse
- automation
- Clean, transform, and model messy data using Excel, Google Sheets, Python, and SQL
- Build automated ETL pipelines and deploy them with Microsoft Fabric
- Design and maintain dashboards in Power BI with secure access (RLS, OLS, Data Gateway)
- Analyze data and create reports that turn raw numbers into actionable insights
- Automate repetitive tasks to save time and improve accuracy
- Support business decision-making through storytelling with data
π« Open to opportunities, collaborations, and data projects