A Robust Analytical Solution
Smartbridge coordinated meetings with operations teams to identify the KPIs and reports needed by regional and district managers to make decisions related to key operational areas:
The finance team then provided a list of reports that needed to be automated, which Smartbridge’s Business Intelligence team assisted to define the requirements. These reports were converted into documents or dossiers depending on the needs.
Taking advantage of the scalability and data governance available through MicroStrategy, Smartbridge handled the development of documents and dossiers by reusing many of the developments previously done.
A guest sentiment analysis dossier based on customer satisfaction survey data was created. These insights allowed the client to pinpoint major opportunity areas from a region down to a store level. This dossier also provided visibility of what elements contributed to a good customer experience based on business units with higher satisfaction scores.
Using MicroStrategy’s Association Rules Analysis, Smartbridge then developed a Market Basket Analysis and affinity report to identify a variety of relationships between the menu items offered at the restaurants.