I will do sql queries and excel google sheets automation and insightful dashboards
Data Analyst
About this Gig
I am a professional Data Analyst specializing in transforming raw, complex data into interactive, easy-to-read, and insightful dashboards. Whether its writing complex SQL queries or automating your daily spreadsheet tasks, I deliver solutions that drive data-backed decisions.
Services I Offer:
- Custom Dashboards: Build powerful BI dashboards with dynamic filters and real-time KPI tracking.
- Advanced SQL Analysis: Writing complex queries, database integration (PostgreSQL) and performance optimization.
- Excel & Google Sheets Automation: Advanced formulas, Pivot Tables, Apps Script, and VBA to streamline your workflow.
- Data Cleaning: Organizing messy files, and ensuring data consistency.
- Python Data Analysis: Using Python (Pandas/NumPy) for advanced statistical analysis and pattern recognition.
What I Need From You:
To provide the best results, please provide the following:
- Your Data Source: Data files (Excel / CSV) or secure access to your database/tool.
- Requirements/References: A brief description of your goal or a sample dashboard/reference (optional).
NOTE: Please contact me first through a message to discuss your data needs and clarify the scope before placing an order!
Analysis type:
Quantitative analysis
•
Descriptive analysis
Expertise:
Business Insights
•
AB test
•
Business intelligence
•
Other
Programming language:
Python
•
DAX
FAQ
Can you automate my manual Excel/Google Sheets reports?
Yes! I use advanced formulas, VBA Macros (for Excel), and Apps Script (for Google Sheets) to automate repetitive tasks, saving you hours of manual work every day.
Which BI tools do you specialize in?
I specialize specifically in Metabase and Power BI for business intelligence and data visualization. By focusing on these two powerful tools, I ensure the highest level of expertise, dynamic filtering, and professional design for your business insights.
What do you need from me to get started?
I will need access to your data sources (Excel/CSV) or secure access to your database (PostgreSQL). I also require access to your Metabase or Power BI account.
Will you provide any guidance on how to use the dashboard?
Absolutely! If you need help, I can provide a video recording explaining all the project features, along with written step-by-step instructions.

