I will do sql data analysis and build power bi and excel dashboards
Ecommerce and sales data analyst, Power BI, SQL and Excel
About this Gig
Your data is spread across spreadsheets, exports and databases, and nobody trusts the numbers. I'll take it from raw files to clear answers: cleaned, modelled, analysed in SQL and shown in a Power BI or Excel dashboard.
I'm a Business Analytics graduate (Macquarie University) who ran campaign analytics for a fintech with 24M customers. At bKash I used SQL to re-engage 400,000+ inactive users and built automated reporting pipelines.
THE PIPELINE
1. Collect: Excel, CSV, Google Sheets, MySQL, Shopify or WooCommerce exports
2. Clean: duplicates, errors, dates and formats fixed in Power Query, SQL or Python
3. Model: a structured database or star-schema data model
4. Analyse: SQL queries answering your business questions
5. Visualise: an interactive Power BI, Excel or QlikView dashboard
6. Explain: plain-English findings and next steps
EVERY ORDER INCLUDES
- Totals checked against your source data
- Editable files (.pbix, .xlsx or .sql)
- A mock-up for approval before I build
Not sure what you need? Message me with your data and goal, and I'll recommend a package.
My Portfolio
FAQ
Q: Which package do I need?
A: Basic if your data is already clean and you want a dashboard. Standard if you need questions answered with SQL. Premium if your data is in several places and you want it set up properly end to end.
Q: Can you connect to my database?
A: Yes: MySQL, SQL Server or PostgreSQL. If direct access isn’t possible, a CSV export works just as well.
Q: Will the dashboard update automatically?
A: In Premium I set it up to refresh from your source files or database. Scheduled online refresh needs a Power BI Pro licence.
Q: Is my data safe?
A: I use your data only for your order and delete it after delivery. Anonymised data is fine.

