Power BI & Business Intelligence
Self-refreshing dashboards you can open every morning and trust.
A good dashboard does not display numbers, it directs attention. We start by discussing which decisions get made, then define the KPIs that feed those decisions. I model the data as a star schema, keep DAX measures lean and set up automatic refresh. What remains is a system that lets you intervene without waiting for month-end.
What's included
- KPI definitions and a metric dictionary
- Star-schema data modelling
- ETL and scheduled refresh with Power Query
- DAX measures and time-intelligence calculations
- Row-level security and mobile layout
Process
- 01Decision and KPI workshop
- 02Connecting the data sources
- 03Building the model and measures
- 04Dashboard design and review
- 05Publishing, permissions and training
Selected Work
Work in this area
Competitor Store Analysis Platform
A competitor analysis platform for e-commerce businesses, bringing price comparison, assortment breadth and trend tracking into one decision support screen.
Asylove E-commerce Platform
Asylove's own storefront alongside its Amazon, Etsy and eBay sales: a multi-language structure with secure payments and international shipping.
Özarslan Design
The corporate site of an interior architecture and design firm, with a project gallery, service pages and a client enquiry flow.
Services
Other services
Web Development
Fast, scalable and SEO-friendly websites with Next.js and React.
- Component-based architecture with Next.js / React
- Mobile-first layout that holds up on every screen
- Technical SEO, sitemap and structured data
Data Analysis
I clean scattered data and turn it into something you can actually decide on.
- Collecting and merging data from multiple sources
- Cleaning, validation and normalization
- Exploratory data analysis and statistical testing
AI Applications
Small, dependable tools built with LLMs, RAG and computer vision.
- Document-grounded question answering (RAG)
- Speech recognition and automatic transcription
- Image classification and object detection