A great feature of ASUG Annual Conference is the customer stories. One of the more popular customer sessions was with Alex Papagiannidis of Molson Coors. He gave business scenarios of how they use BI for the business.
Figure 1: Source: Alex of Molson Coors
You can see in Figure 1 that Molson Coors has had to do more with less. Their user base has increased over the last 5 years, but team members remain flat.
Figure 2: Source: Alex of Molson Coors
Alex serves as a partner – “the face of BI” to the business. Figure 2 shows that they try not to be just “doers” but also solution providers.
Figure 3:Source: Alex of Molson Coors
Figure 3 shows that the BEx Query is the semantic layer for several tools. Molson Coors reuses same BEx query structure in Web Intelligence and Analysis Office to add value to different audiences.
Figure 4: Source: Alex of Molson Coors
Figure 4 shows the BI demand profile with 90% guided structure and PowerPoint.
The scenario is that a sales representative needs to track performance, calendar, brands to meet their targets. When on-site they need to answer questions ad-hoc with a professional tool. Across Canada, they needed an off-line dashboard, with guided analysis on how perform, along with a user friendly experience.
He reviewed how business needs have evolved. In 2009, they had 1 market, 2 languages, one source of information – BW. Today they now have 14 languages, more users, tablets, different operating system and now add executives and analysts
Figure 5: Source: Alex of Molson Coors
Figure 5 shows the current and future vision for which tool is used when.
Alex said selecting the right tool is the key and they are moving from static view to more interactive view.
Future vision is an executive can access to sales data in board room quickly.
Change management is key using the RACI model- responsibility, accountability, consult, inform.
He explained that the challenge with SAP tools is that some tools used were lacking in maturity. He suggests to compensate, you should attend events to build relationships with SAP.
Figure 6: Source: Alex of Molson Coors
Figure 6 reviews some of the best practices Alex follows, with a recommendation of Ingo Hilgefort iTunes book https://itunes.apple.com/us/book/mastering-sap-businessobjects/id586039477
I thank Alex for sharing his story at ASUG Annual Conference.