Skip to content

Blackbook.ai

Reporting and Automating Oracle Journal Uploads

A food and beverage retail company engaged Blackbook.ai to migrate existing data from another cloud system into a new data warehouse, create reports and have their underlying data sets used in Power BI.

Client Industry

Food and beverage

Technology stack

Industry

Food and beverage 

Technology stack

Industry

Food and beverage

Technology stack

The challenge

The client had previously extracted data from their data warehouse to create reports in Excel, manually bringing in the new data as necessary and updating them. There were various reports across different sectors: Area Coach, Finance, HR, Sales, etc.

The solution

Blackbook’s solution involved making the data now available in Power BI, and automatically updates and refreshes the dataset to include new data as it comes in. This assisted in creating intuitive reports and visualisations (charts, graphs, etc.) that remain up to date and relevant for business users to use and analyse.

The outcomes

The client was able to reduce the time spent on creating and manually updating reports, with them now being live and ready to use. Reports are visually appealing and easy to analyse across multiple teams.

Related case studies

Beef Sales Assistant Chat Bot

The customer is a premium beef producer with an experienced sales team servicing foodservice, retail, and export customers. Sales representatives manage a wide range of cuts, specifications, pricing rules, and inventory positions while responding quickly to customer requests.

Read more >

Marble and Weight Prediction

The customer is a large beef producer managing complex supply chains from livestock intake through to sales and financial planning. Accurate forecasts of marbling scores and carcass weights are essential for pricing, customer commitments, and financial performance.

Read more >

Carcass Data Analytics Platform

The customer is Australia’s largest integrated cattle and beef producer, supplying premium grass-fed, grain-fed, and Wagyu beef to global export markets. Their operations span backgrounding, feedlots, processing, and commercial functions, operating at significant scale with a strong focus on high-quality, data-driven production.

Read more >
Services
About