Budget: 18000 UAH Deadline: 7 days
I can take the Power BI dashboard as the first stage - 2 screens, financial indicators, waterfall of deviations, SKU heat map, batch and factor diagnostics.
Estimate - !!18,000 UAH!!, timeline - 7 working days provided that the ETL and data model are already ready. If ANOVA needs to be not only displayed but also calculated within Power BI, it is better to separate it into a mini-stage - otherwise, the report may become slow.
What I need from you - PBIX or access to the Power BI workspace, field descriptions, planned values, rules for the red zone, and examples of 2-3 SKUs where the result can be verified. After that, the indicators can be gathered without unnecessary magic, as magic in analytics is often just poorly named DAX =)
> Clarification - Is ANOVA already calculated in ETL or does it need to be calculated in the report?
> Clarification - Are the data on batches and factors in one model or do we need to consolidate several tables?
Relevant examples
> https://business.ingello.com/platforma - corporate system with management logic and indicators for decision-making
> https://business.ingello.com/forma-bpm - automation of business processes, where important roles, operation control, and transparent analytics are crucial
> https://systems-fl.ingello.com/ua - main page of Ingello Systems for FLH