Microsoft Business Intelligence Case Studies

Yet the underlying challenge was a more subtle one, explains Berendsen’s IT director Duncan Macmillan—and one that tended to rule out conventional approaches such as barcoding.

Tags: Thesis Statement On IraqDissertation DoctorSsrc International Dissertation Research SWriting An AssignmentThe Color Purple Essays On CelieItt Capstone ProjectScarlet Letter Essay Dimmesdale GuiltFood Safety Essay

There is only one chance to make a great first impression so, after a brief Power Point presentation, we put words into action and took the liberty to connect a few of SPAR’s databases and extract some data previously deemed unreachable.

SPAR wanted to build a Reporting and Analytics (RAP) platform that could enable its end-users to be decision makers.

Everyone at the company had their own perception of the business, but there simply wasn’t enough information to make educated guesses.

SPAR scheduled a meeting with Dev Scope to find out how we could help.

SPAR processes thousands of daily transactions on thousands of items multiplied by 365 days throughout the year, all accumulated and spread across several PCs and servers.

Microsoft Business Intelligence Case Studies

This kind of chaos made decision-making in a timely way very difficult.

Identifying which products’ sales were down during a given period could only be done if the server was updated daily and could take SPAR between 2 to 3 hours.

After that, they would have to figure out where that scenario had the biggest impact, which could take an additional 3 hours.

The company’s ultimate goal was to increase its teams’ efficiency but, in order to do so, they had to equip them with proper tools to not only analyze data but also act on it.

Dev Scope’s proposed solution used Microsoft® Power BI™ to display data and was built on Azure Cloud Services, namely Azure Gateways and Service BUS to read and sync all business data stored in SPAR’s on-premise data sources.