This is what we do
FAQ
MIC Nordic needed to replace a cumbersome Excel solution with a more structured and sustainable system. By developing a central platform in Microsoft Dataverse and Power Apps, information from multiple sources is consolidated in one place. The solution provides a better overview, higher data quality, and full traceability. At the same time, it has reduced manual work, streamlined processes, and created a stable foundation for future development.
Automate your reportsLearn more about our Office templates
MIC Nordic is a technology company specializing in robust and secure indoor mobile communications. The business demands a high level of technical expertise, with a clear ambition to remain at the forefront of technological developments in wireless communications. The company possesses specialized knowledge in all relevant technologies and is actively engaged in research and development. Through close collaboration with organizations such as Wireless@KTH, MIC Nordic contributes to innovation in the industry, including by offering students opportunities for thesis projects and development projects. The company is also involved in industry issues, educational initiatives, and research projects.
Technology and IT
25
Mic Nordic reached out to us again following a previous successful collaboration in which we automated their reporting of measurement data in Excel. This time, their needs were more extensive. A complex and unwieldy Excel file had become a bottleneck in their operations, while important project information was scattered across the Visma Spiris business system and among various stakeholders. The work required a significant amount of manual handling, with a high risk of errors.
The request was clear: to create a more unified and user-friendly system that could consolidate all data, reduce errors, and provide a better overview.
We built the solution in Microsoft Dataverse to create a stable and secure database, and developed an intuitive interface in Power Apps. Data was integrated from Visma and other sources and structured into clear fact tables and dimensions. The project was carried out in several phases—from the feasibility study to deployment—to ensure quality at every step. During the project, we addressed challenges related to API integrations and varying data quality in existing files. We also developed a separate application for managing SIM cards, which enabled clear links between projects, items, and customers.
The result was a new system where all information is centralized and updated automatically. The customer can manage projects, products, installations, and contracts within the same solution, with excellent traceability and up-to-date information. Manual work has been reduced, while data quality has improved. The solution provides a clear overview of operations and creates a stable foundation for future development, saving time and reducing the risk of errors.
