Progress you can
put your finger on.

Perfection Fresh AU

Microsoft Fabric · dbt · Power BI

Complex freight data. A clearer route forward.

The challenge

Freight analysis depended on complex relationships across databases. The team needed reliable data and a practical way to understand routes and carriers.

What we built

We consolidated data in a Microsoft Fabric lakehouse, modeled it with dbt and built a star schema to support Power BI analysis.

What changed

The model refreshed hourly, giving the team current information to support route planning and carrier management.

Lnet Digital

Research · Power BI

Less report preparation. More valuable insight.

The challenge

Biometric user-experience research generated eye-tracking and facial-expression data that had to be cleaned and reported through a complex set of spreadsheets.

What we built

We automated data cleaning and report generation in Power BI, with a reusable template that could work across clients and datasets.

What changed

Reporting became less labor-intensive, leaving more time for analysis. Interactive visualizations made the findings easier to explore and explain to clients.

Building surveyor

Property · Data management

One place for audits, budgets and client reporting.

The challenge

Audit findings, data capture and client reports lacked a central system, making estate-wide information harder to manage.

What we built

We built a tailored solution that centralized data collection and reporting with a clear interface for the surveyor’s clients.

What changed

The team could see budgets, identify roof-condition issues and consider cost savings by grouping remedial work. Pictorial summaries made estate-wide information more useful.

Australian real estate business

Microsoft Fabric · Xero · Power BI

From monthly spreadsheets to a daily financial view.

The challenge

The business prepared Xero reports manually and wanted more frequent cost, sales and profit analysis, with room to create its own reports.

What we built

We connected Xero to a Fabric data lake, cleansed and modeled the data in a warehouse, and built Power BI reports with transaction-level profit-and-loss detail.

What changed

Leaders gained a daily view of performance, while super users could query the warehouse and extend the reporting themselves.

Southeast Asian commerce agency

Microsoft Fabric · Embedded Power BI

Connecting sales performance to the financial picture.

The challenge

A growing TikTok Shop agency needed to bring influencer sales, canceled orders and Xero costs together for management and investor reporting.

What we built

We combined Xero data and TikTok Shop exports in a Fabric warehouse using dbt, PySpark and SQL, then created an embedded Power BI reporting portal.

What changed

Management and investors could review performance through a shared reporting interface backed by connected sales and financial data.

UK city council department

Finance · Power BI

Financial planning without the monthly data chase.

The challenge

Monthly financial analysis required staff to manually bring together numerous spreadsheets, limiting the depth and frequency of reporting.

What we built

We created a Power BI solution that consolidated files uploaded to a folder into a central model, with period comparisons and trend analysis.

What changed

The department could explore historical data and financial performance without repeating the manual collation process.

US fast-food franchisee

Multi-site operations · Power BI

A clearer view across the stores.

The challenge

Weekly analysis depended on manually combining separate spreadsheets, making it difficult to explore performance more frequently.

What we built

We connected the data in one reporting model and built a Power BI dashboard with historical comparisons, store benchmarks and flexible period analysis.

What changed

The franchisee could compare performance across stores and time periods without first collating the underlying spreadsheets.

FMCG retail business

Retail · Power BI

A shared performance view, from leadership to local teams.

The challenge

Data was available across regions and departments, but the business lacked a unified way to analyze and report it.

What we built

We developed a Power BI model with tailored performance visuals, ranking views and dynamic currency conversion.

What changed

Centralized reporting gave leadership a cross-business view while supporting more detailed analysis by regional and country teams.

Multinational retailer

Sales operations · Power BI

Turning extensive sales data into practical decisions.

The challenge

Sales leaders needed to understand revenue, profit, products and regional trends within a large, complex dataset.

What we built

We built a Power BI dashboard with product contribution analysis, rolling-quarter views, regional seasonality and dynamic revenue and profit comparisons.

What changed

The sales team could explore performance through a single interface and investigate the factors behind the results.

Lnet Digital

Statistical brand analysis

Understanding brand response through research.

The legacy collection also includes statistical brand analysis for Lnet Digital’s biometric user-experience research. It sits alongside our work automating their reporting.

This project is listed in the original collection; the detailed article is currently unavailable.