POWER BI et Divalto : L’excellence du reporting industriel
POWER BI et Divalto : L’excellence du reporting industriel
Walid Bergaoui
POWER BI and Divalto: Excellence in Industrial Reporting
Your plant generates a wealth of data every day — production orders, material consumption, machine time, deliveries, purchases. Yet when it comes time to decide, you find yourself facing endless PDF listings and Excel exports that are impossible to consolidate. This training gives you the power to turn Divalto, your industrial ERP, into a true visual control tower. You learn to connect Power BI directly to Divalto's SQL Server database and to make your data speak as never before.
The approach is decidedly hands-on and true to the realities of Tunisian industry. You begin by understanding the actual structure of Divalto data — its generic tables, its concatenated fields, its business rules — then you build optimized SQL views that clean and restructure the raw data before Power BI, ensuring fast and reliable reports. Next, you build a solid data model (star schema, relationships, calendar), you write your DAX measures, and you design clear, interactive dashboards. Every session is based on real Divalto cases: an indicator designed in class is an indicator you will be able to reproduce on your own data.
By the end of the program, you no longer endure your production: you steer it with precision. Planned vs. Actual comparison on your production orders, immediate detection of cost overruns, OTIF service rate by customer or by root cause, trends in purchase prices and supplier ratings — everything becomes readable in just a few seconds. You leave able to publish your reports, secure them, and refresh them automatically, finally giving your executives the concise, modern overview they expect.
What you walk away with
A training measured in concrete deliverables, directly reusable on your ERP:
Your ready-to-use Divalto SQL views — clean, high-performance extractions that decode Divalto tables and respect your business rules (discounts, taxes, cost price).
A complete industrial dashboard — production order monitoring, OTIF service rate, and purchasing analysis, assembled and operational by the end of the program.
A library of DAX measures — the key calculations (variances, margins, rates, running totals) documented so you can adapt them to your own indicators.
The support of BSF expertise — the know-how of a team that knows Divalto inside out, to clear technical pitfalls without wasting time.
Program — 12 sessions of 1 hour
A progressive, 100% Divalto-applied program: we start from the ERP's raw data, clean it in SQL, model it in Power BI, then build the industrial dashboards that drive the plant — all the way to secure publishing and automatic refresh.
Module 1 — Understanding Divalto and preparing the data (sessions 1-3)
1. Divalto, Power BI, and the challenge of industrial reporting — why the Divalto + Power BI pairing is so natural (native Microsoft SQL Server database), the limits of standard reporting, and the goal: a concise overview for decision-makers.
2. Decoding the structure of Divalto data — generic tables, concatenated fields, coding schemes: pinpointing where your production orders, stock, sales, and purchases actually live.
3. Building clean, high-performance SQL views — cleaning and restructuring raw data, embedding business rules (discounts, taxes, cost price) for fast and reliable reports.
Module 2 — Connecting and modeling in Power BI (sessions 4-6)
4. Connecting to SQL Server from Power BI — Import vs. DirectQuery, queries on your views, connection settings, and security best practices.
5. Transforming data with Power Query — typing, merges, calculated columns, splitting concatenated fields: finalizing the preparation on the Power BI side.
6. Star schema data model — separating facts and dimensions, creating relationships, adding a calendar table: the foundation of robust reporting.
Module 3 — DAX calculations and visualization (sessions 7-8)
7. DAX fundamentals — measures vs. columns, CALCULATE and filter context, running totals and time comparisons, Planned vs. Actual variances.
8. Designing clear, interactive visuals — choosing the right chart, KPI cards, slicers and filters, a readable and consistent layout for executives.
Module 4 — Industrial dashboards (sessions 9-11)
9. Production Order (PO) monitoring — comparing Planned and Actual (machine time, material consumption), detecting production cost overruns in real time.
10. OTIF service rate — finely analyzing delivery delays by customer, by carrier, and by root cause (stockout, machine breakdown).
11. Purchasing and supplier analysis — tracking trends in raw material purchase prices and setting up automatic supplier ratings.
Module 5 — Publishing and sustaining (session 12)
12. Publishing, security, and automatic refresh — publishing to the Power BI service, managing access and row-level security, scheduling refresh via the gateway for always up-to-date data.
Reactions & comments
No comments yet.
Log in to comment.