Transforming fragmented SQL Server and Navision data into a unified Power BI reporting foundation for clear, scalable insight across sales, returns and inventory.
Struggling With SQL Server or Navision Reporting?
Explore our consulting services or book a call directly with Simon to find out more
Contact UsBook A CallProject Snapshot
Client
Aspinal of London
Industry
Fashion
Tech Stack
Power BI, SQL Server & Navision
The Challenge
Aspinal of London faced several obstacles in turning SQL Server and Navision data into clear, reliable reporting:
- Fragmented Data: Sales, returns and inventory information lived across multiple systems, making it difficult to create a unified view.
- Limited Visibility: Teams lacked clear dashboards to understand performance trends or identify operational issues.
- Manual Processes: Reporting relied heavily on spreadsheets and manual exports that were slow to update and prone to inconsistency.
- Complex Data Sources: Combining SQL Server and Navision required structured modelling to ensure accuracy and reliability.
- Internal Capability Gaps: The team needed support to confidently maintain and expand their Power BI reporting environment.
The Solution
Aspinal of London’s focus on brand image meant the reporting experience needed to feel as refined as their website. As a fashion client where aesthetic is everything, we spent time matching the dashboards to their corporate colours, typography and visual style. Using pixel‑perfect layout features in Power BI, we ensured every page looked polished, intentional and on‑brand.
To maintain visual consistency, we used their own image URLs to dynamically pull product and category imagery directly into Power BI, mirroring the look and feel of their ecommerce site. We also combined bookmarks with carefully crafted page design to create a smooth, elegant navigation experience—showcasing the visual potential of Power BI as a BI tool.
Alongside the design work, we delivered a complete reporting foundation:
- Design: Created custom dashboards tailored to sales, returns and inventory workflows.
- Modelling: Built structured, scalable data models using SQL Server and Navision sources.
- Integration: Centralised key datasets in Power BI to reduce manual handling and improve accuracy.
- Mentoring: Provided hands‑on support in modelling, DAX and dashboard design.
- Enablement: Ensured the internal team could confidently maintain and expand their reporting environment.
The Results
- Insight: Clear visibility across sales, returns and inventory for faster decision‑making.
- Efficiency: Reduced manual reporting effort through automated refreshes and structured data models.
- Accuracy: A unified reporting approach that improved consistency across teams.
- Capability: A more confident internal team able to maintain and enhance their dashboards.
- Scalability: A reporting foundation ready for future growth and additional data sources.
Ready to unlock clearer insight from your SQL Server and Navision data?
We help fashion brands like Aspinal of London turn complex operational data into actionable Power BI reporting.
Book a free consultation to get startedThis is just one example of what we do – explore more in Our Work
