I will build power bi dashboards with dax and sql
About this Gig
Are you struggling to make sense of fragmented spreadsheets and complex raw databases? I transform unstructured data into dynamic, automated, and visually compelling executive dashboards that drive data-backed decision-making.
As a dedicated Data Analyst, I specialize in building end-to-end analytics pipelines from writing optimized SQL queries to designing clean Star Schema data models and custom Power BI visuals.
What I Offer in This Gig:
- ETL & Data Cleaning Power Query automation, M-code tweaks, and SQL data extraction.
- Data Modeling Robust Star Schema architecture for maximum query performance.
- Advanced Calculations Complex DAX measures, time intelligence, YoY growth, and custom KPI cards.
- Interactive Design Multi-page dashboard layouts, dynamic slicers, custom tooltips, and drill-through actions.
- Enterprise Features Row-Level Security (RLS) setup for role-based data access.
Tools & Technologies:
- Microsoft Power BI (Desktop & Service)
- Microsoft Excel (Advanced Formulas, Power Pivot)
- SQL Databases (PostgreSQL, MySQL, SQL Server)
- Message me with your data and goals before placing an order I'll recommend the best package for your needs.
Expertise:
Web analytics
•
Business Insights
•
Prediction
Technology:
Excel
•
Power BI
•
Power Query
Programming language:
SQL
•
DAX
My Portfolio
FAQ
: What do I need to provide to get started?
Please provide your dataset (Excel, CSV, SQL DB credentials) along with a brief description of your key business metrics and goals.
Can you connect directly to my SQL database?
Yes, I can connect Power BI directly to your relational database via DirectQuery or Import mode.
Do you offer custom offers for larger projects?
Absolutely! If your project scope falls outside these packages, send me a message and I will create a tailored proposal.

