- Analytics project implementation
BI solution architecture for New Balance
At the core of the solution, we built an automated integration between the ERP system and Power BI. New data now flows into the analytical model every day, is processed automatically, and refreshes the visualizations without any manual transfer to Excel.
The owner gets up-to-date metrics in one environment and can quickly move from the big picture to the level of detail they need. The analytics were built around three key areas of the business, each with its own dashboard.
Sales
The dashboard shows sales trends across different periods and allows results to be analyzed by store and SKU. The executive can see overall trends, compare performance, and drill down to individual products when needed.
Inventory
The analytics combine inventory levels, cost, and margin data. This makes it easier to monitor inventory structure, assess stock in the context of sales, and identify items that may require closer attention.
Cash
A separate dashboard consolidates cash balances across different accounts and locations. For foreign-currency balances, the team added a manually entered exchange rate: once the rate is updated, Power BI automatically recalculates the figures in the local currency.
What analytics can look like on a smartphone
The mobile format makes it possible to view key metrics without being tied to a computer and quickly access the information you need. Below are demo versions of 6 mobile dashboards that illustrate how analytics can be organized on a smaller screen. The data shown in the visualizations is for demonstration purposes only.

