Business Intelligence User Adoption: Baby Steps
In the past, I’ve written a few posts that discuss dealing with the challenge of user adoption when introducing a new business intelligence solution.
Recently I have encountered some scenarios that have challenged my ego and my desires to produce solutions that I feel are extensible and efficient.
I continue to learn more about the psychology that is involved when users are asked to abandon their old processes and adopt a new (and in my opinion better) way to accomplish their tasks. So here is my dilemma: I can either continue with my stubborn ideas of implementing best practice solutions or I can bend (can you do the limbo?) and design a process that caters to the users’ comfort levels.
Which one to choose? In this scenario, you would need a significant amount of power and influence within your organization to override the user preferences for their work tasks (covering many departments throughout your organization) and replace those processes with your own design and plan. In addition, even if you happen to have this type of clout at your organization, this iron fist approach will likely just cause resentment and rebellion – resulting in little to no user adoption.
Baby steps…You’ve done your research, you see multiple ways that tedious manual processes can be streamlined, but your users aren’t quite ready to make this leap. If you are like me this may be challenging. You may be thinking “really, you want me to implement a design that I don’t think is the best solution?” and my humble reply is yes, sometimes. I swallow hard as I write this because admittedly I am still having trouble accepting this concept.
Selling your solution to the users in your organization is a psychological process as much as it is a technical process. Consider this scenario: Users currently present KPI trends and results to executives based on manual entry into spreadsheets. They may incorporate some charts and include some complex macros that beef up the technicality of the spreadsheet, but ultimately they are still relying on manual entry. To me this method screams risks of human error, potentially lost data, lack of historical storage, and difficult data retrieval… Ahhhhh!
From my perspective, I see the best solution for generating these KPIs in a consistent and reliable manner is to pull the data from the sources into the data warehouse and then generate automated reports or create dashboards for users and executives. (Seems obvious right?) However the reality is that for most end users this would be a dramatic transition, even if it ultimately means less work. They may also be worried about their jobs no longer being necessary. So, it may be going against everything you feel is “right” about a business intelligence design but I recommend taking baby steps here.
First you may want to try a simple solution that utilizes your data warehouse while still allowing the user to remain in complete control of the data that is inserted and reported on. If they are used to using a spreadsheet as their data entry point then a possible solution is to provide a SharePoint list that resembles their current data entry format. Allow the users to continue their manual entry while also becoming familiar with the SharePoint structure (or other collaboration BI tools you may be using). You will be able to extract this data into your data warehouse and generate reports/dashboards while also maintaining history.
The lesson: Don’t take away all of the users’ control at once. Trust is a slow process and ultimately you need your users to trust the data that lives in your data warehouse. When they are able to create useful reports by pulling the data from the data warehouse (that they essentially manually entered) then they will slowly grow an affection for the structure and will hopefully over time begin to ask you how other processes can be streamlined. You may be the BI guru, but ultimately your users will end up being the ones who set the pace.Phocas Software has been a consistent outstanding performer in BARC BI Survey, the world's largest business intelligence software survey since 2013. Find out more about how Phocas performed in the most recent edition here.
Top 7 KPIs and metrics for mid-market executives
Fill out the form below to download the eBook.
We'll do the data wrangling, you do the analyzing
In today’s business world, we are faced with the constant struggle to bring our data into line. The sheer volume of data that businesses generate can be overwhelming to simply manage, never mind analyze. A survey by Phocas revealed that 60% of businesses identified ‘no expertise in-house,' and 33% said, ‘too much data to unravel' as the main obstacles that prevent them from breaking down data silos.Read more
Behler-Young connects Amazon Alexa and Phocas BI with great results
Can you have a conversation with your business intelligence solution while driving? Behler-Young sales people do. Robert Wright, a Senior Application Developer and Analyst at Behler-Young, integrated Amazon Alexa with Phocas, a business intelligence solution for manufacturers, distributors and retailers. With critical data only a question away, they always know what's going on even when they're on the road.Read more
Phocas secures 37 top rankings in BARC's 2023 BI + Analytics Survey
The voice of the BI and analytics community has officially spoken following the release of The BI & Analytics Survey 23 by software selection and strategy experts, BARC last week.Read more
Phocas Products Now on Sage Intacct Marketplace
Phocas Software helps Sage customers gain more insights from their business Phocas Software, a business planning and analytics platform for sales, operations, and finance teams, announced a new technology partnership with Sage, the leader in accounting, financial, HR, and payroll technology. Phocas products are now integrated with Sage Intacct, making it easier for companies to access, analyze, report, and share information in their systems.Read more
Find out how our platform gives you the visibility you need to get more done.Get your demo today