The company was already using Power BI, but the creation of reports had not been automated yet. Vaillancourt, therefore, called upon Nmédia to help it achieve its Power BI objectives within the allotted time.
This is how Nmédia undertook to:
- Centralize its business data in one place;
- Make the creation of analysis reports automatic.
Creation of an ERP-independent data warehouse
Power BI makes it possible to retrieve data from several different sources, including ERP software, and to group them at will. For added security, we suggested to Vaillancourt that they create a warehouse that could store all their data for the long term.
We started by creating this customized data warehouse into which we migrated the data from the past. We also programmed the warehouse to allow for automatic migration and backup of information from new systems.
This brand-new warehouse housed, among others, the following information:
- Representatives and their respective clients;
- Current projects;
- Submitted bids;
- The company's business intelligence.
With this data now centralized, anyone in the organization with web access can get what they need to work.
