01An offer built around your decisions
We begin with a focused scoping exercise: decisions to support, priority indicators, reporting frequency, available sources, owners and constraints. Depending on the agreed assignment, we may address sales, procurement, inventory, production, costs, management cash monitoring, projects, human resources, programme activities, commercial performance or beneficiary tracking. Excel is suited to controlled analysis and collaborative models; Power Query automates recurring imports and transformations; Power BI supports interactive dashboards and sharing under defined access rights. Models are documented to support continuity rather than dependence on one individual.
02From heterogeneous files to usable data
Cabinet Nova Conseil reviews workbook structures, duplicates, missing values, units, periods, currencies and indicator definitions. Power Query can consolidate recurring files, standardize labels, validate data types and make transformation steps visible. We clearly distinguish observed data, assumptions, estimates and projections. When data is insufficient, we say so and propose a collection or control plan; we do not invent figures or present an estimate as a fact.
03Forecasting and scenarios without false precision
Forecasts can support procurement, inventory, volumes, capacity, staffing or management-budget preparation when historical data and explicit assumptions are available. Where relevant, we compare several scenarios—conservative, central and dynamic—and show sensitive variables. In the DRC context, analysis may separately incorporate observed effects of exchange-rate movements, inflation, supply lead times, seasonality, infrastructure constraints or data interruptions. A projection is a planning tool, not a promise or personalized legal, tax or financial advice.
04BI adapted to Congolese sectors
For extractive industries, dashboards may track production, volumes, costs, shipments, suppliers, incidents or ESG indicators, subject to the project’s data and requirements. For non-extractive sectors—trade, industry, agriculture, energy, transport, telecommunications, health, education, services and NGOs—we adapt indicators to actual operations. Solutions must reflect infrastructure, connectivity, data-entry quality and team availability constraints. We prioritize manageable source files, realistic refresh routines and simple governance, with user validation.
05Support, knowledge transfer and prudence
The engagement may combine diagnosis, design, implementation, training and start-up support. Workshops use your cases and files when authorized. We explain formulas, queries, measures, filters, control rules and interpretation limits. For institutions, NGOs and researchers, we can structure indicators, time series, monitoring tables and presentation materials. Confidentiality, access and file retention are agreed with the client; regulatory, tax, legal or investment matters remain with the relevant qualified professionals.
