{"id":28971,"date":"2020-03-23T11:23:06","date_gmt":"2020-03-23T15:23:06","guid":{"rendered":"https:\/\/centricconsulting.com\/?p=28971"},"modified":"2024-03-06T15:46:04","modified_gmt":"2024-03-06T20:46:04","slug":"7-ways-to-get-critical-business-reporting-during-covid-19","status":"publish","type":"post","link":"https:\/\/centricconsulting.com\/blog\/7-ways-to-get-critical-business-reporting-during-covid-19\/","title":{"rendered":"7 Ways to Get Critical Business Reporting During COVID-19"},"content":{"rendered":"
When organizations respond to crises, many business leaders realize how little they know about their company operations. Priorities and processes must rapidly change to survive. If we are to weather any crisis, we need critical business reporting.<\/span>\u00a0<\/span><\/p>\n We do not have the luxury of time during periods of disruption. Traditionally, we would rely on IT-driven reporting for business insights. However, trusted reporting requires investment in data governance, data warehousing and report development.<\/strong> All of these have a long implementation cycle and require considerable input from the business. Technical teams that are laser-focused on business continuity (for example, remote work, VPN and related issues) are less focused on reporting.<\/span>\u00a0<\/span><\/p>\n But don\u2019t let critical business reporting take a back seat. Here are seven changes that will allow business leaders to make informed decisions while working around the realities of crisis management.<\/span><\/p>\n During a crisis, give developers permission to take shortcuts and work with more efficient tools. Focus on making the minimum effort to get the essential information. Manual steps may be just what you need.<\/strong><\/em><\/p>\n Tactical is not a dirty word. Don\u2019t underestimate the value of quick wins.<\/p>\n Hands-on development work often requires a small amount of time compared to the overall business-as-usual development process (requirements docs, prioritization, UAT, code reviews, and more). Your development team might surprise you with what they can accomplish when given latitude. If it keeps your business running for the next 30 days, the benefits can easily outweigh the costs.<\/strong><\/p>\n What does tactical mean when it comes to reporting? Here are a few ideas:<\/p>\n Set your development team free to explore new tools that get the job done. This step has multiple benefits: one, your technical people will be excited to get their hands on new technologies, and two, business leaders will have rapid insight into business performance.<\/p>\n Data lakes put all your raw operational data in one place, making analysis faster. Employ lightweight techniques for moving data rather than traditional ETL.<\/em><\/strong><\/p>\n Don\u2019t think \u201cHadoop\u201d when you hear \u201cdata lake.\u201d Nowadays, \u201cdata lake\u201d refers to an environment where you co-locate all your raw data. There\u2019s something almost magical about co-located data. Data lakes permit analysts to blend data from every system at once, creating a cross-department view. Creating a data lake can be as simple as restoring a backup copy of an operational database.<\/p>\n In times of crisis, real-time reporting is essential. Emergencies disrupt established business processes, and never-before-seen problems unexpectedly emerge.<\/strong><\/p>\n You can achieve real-time reporting through transactional database replication into a data lake. Replication generally has zero impact on operational systems because it works from database logs rather than the database itself.<\/p>\n Cloud offers innovative ways to store and work with data. Ultimately, cloud allows you to move faster and be more flexible with data and reporting. Moving your data up to the cloud has no ingestion cost.<\/strong><\/em><\/p>\n Cloud is amazing, no matter if you prefer Microsoft Azure<\/a>, AWS<\/a> or Google Cloud Platform. Platform-as-a-service tools will dramatically accelerate work with data and reporting. We\u2019re not talking about virtual machines here, but rather specialized products you can turn on and off as needed.<\/p>\n Cloud is the perfect environment for data lakes. Data ingestion incurs no cost and you can delete the data when you\u2019re finished with it. Cloud tools allow you to drop data into file storage.<\/strong> You can even avoid the hassle of working through a relational database.<\/p>\n Cloud also offers modern technologies that can help you deliver faster. Azure Synapse Analytics<\/a> (formerly Azure SQL Data Warehouse), Snowflake<\/a> and other MPP platforms<\/a> provide a single environment in which you can blend all sorts of data: relational data, semi-structured data (JSON, XML, and so on), non-structured data. All are blazingly fast, and you can provision these in minutes.<\/p>\n Another exciting technology is Databricks<\/a>. Databricks lets analysts work with data using a blend of SQL, Python, and other languages. Now, developers can get in on the data action, not just your reporting team.<\/p>\n If your reporting tool runs in the cloud (such as, Power BI Professional), there are no egress data costs. All your data stays in the same cloud environment throughout its lifecycle.<\/p>\n Your businesspeople know what they want and can often move faster than IT. They may impress you by their ability to work with data in Excel and modern visualization tools. Take advantage of this resource.<\/em><\/strong><\/p>\n IT has historically been a guardian of data and reporting. But \u201cshadow IT\u201d thrives in every organization, living on clandestine access to databases and operational report downloads. This data finds its way into Excel and has given rise to the term \u201cspreadmarts.\u201d<\/p>\n The very existence of shadow IT means some businesspeople not only can work with data but desire it enough that they are prepared to circumvent IT. The reason, of course, is that having good insight is extremely important. Furthermore, these business analysts understand the application of data analysis far better than anyone in IT.<\/p>\n Why not give those savvy business analysts access to the data they crave? Demand for insight goes up during a crisis and IT availability goes down. We recommend recruiting business analysts to participate in reporting.<\/p>\n They will certainly want to use Excel. At the same time, we are seeing many businesspeople migrate toward visualization tools like Power BI and Tableau. These tools make it simple to ingest data, produce beautiful visualizations and create rapid insight.<\/p>\n Historically, the greatest objection to wide exposure of data has been that business analysts will arrive at wrong conclusion– and then blame IT. Shadow IT and spreadmarts are direct evidence that people are misplacing their concerns. Yes, they may sometimes need guidance, but isn\u2019t it exciting for the business to desire advice from IT?<\/p>\n Once the crisis passes, you will have instilled throughout the organization a stronger desire for data and reporting. There also will be a heightened appreciation for data governance, data quality, and the IT development process.<\/strong><\/p>\n It\u2019s a win-win for the CIO.<\/p>\n Strict business-as-usual procedures can stymy an organization\u2019s ability to respond quickly. Develop a process to quickly assess the risk of providing access and expedite when benefits outweigh risks.<\/em><\/strong><\/p>\n As we interact with clients during the crisis, the greatest inhibitor of rapid response is red tape in IT. Classically, red tape involves filling out forms and waiting for approval queues, especially as it relates to data access. Red tape serves an important purpose during normal business operations: ensuring proper procedures, security and documentation.<\/p>\n How does your organization evaluate the risk and benefit of red tape?<\/p>\n When you require a rapid response for business survival, it warrants extreme measures.<\/p>\n We can see how CIOs have done an excellent job with their teams, creating a culture of maximum security and strict protocols. This blanket vigilance eliminates many legitimate risks. At the same time, it can be counterproductive to rapid response.<\/strong><\/p>\n The key is to assess the genuine level of risk due to granting access and then expedite access when it conveys a benefit to the business.<\/p>\n IT has traditionally been the guardian of access to networks, data, and applications. They may need to hasten or shortcut procedures to ensure long-term business continuity.<\/p>\n Collaboration platforms feature integration with visualization tools. This is a powerful way to keep important information front-and-center, for example: operational scorecards.<\/em><\/strong><\/p>\n Collaboration platforms such as Microsoft Teams<\/a> often provide hooks to integrate dashboards easily<\/a>. How many times have you resisted going into a reporting portal just because it\u2019s outside your stream of consciousness?<\/p>\n <\/p>\n <\/p>\n By hooking dashboards to a widely used communication channel, the information is always in front of your stakeholders, keeping them aware of hot spots.<\/p>\n It\u2019s worth a moment to consider the design of effective scorecards.<\/strong><\/p>\n Lastly, provide links to other dashboards that allow for deeper analysis. You probably should not push every dashboard through the collaboration tool, just the most critical information.<\/p>\n Professional services companies (such as consulting firms) are motivated to help. They can deliver the extra capacity you need and may accommodate better pricing.<\/p>\n Just as you are going through tribulations, so is the rest of the world. We\u2019re all in this together.<\/strong><\/p>\n Professional services firms are often the first expense businesses cut. They have employees just like you, and those employees have families. For those reasons, these firms may accommodate special arrangements, including more generous terms, reduced pricing, and access to more experienced talent.<\/p>\n Consider how professional services firms can create a win-win experience with you. They can help you knock down your queue of tickets, quickly implement cloud, build and deploy rapid reporting solutions, and more. In our experience, data visualization skillsets are plentiful among consulting firms and can help to deliver critical business reporting.<\/p>\n You may also take advantage of the crisis to get ahead of the market. If you have available capital, you may be able to accelerate the development of products and other market differentiators.<\/strong> This may not seem like a priority now, but it could make a big difference once the economy rebounds. As the saying goes, \u201cluck happens when opportunity and preparedness meet.\u201d<\/p>\n At the same time, introducing outsiders can present challenges to an organization. Be sure to broadcast a clear expectation of cooperation when you use professional services in new, possibly sensitive areas of your business. A rapid response will thrive when people trust each other and can work together happily.<\/p>\n\n 1. Tactical Is Not a Dirty Word<\/h2>\n
\n
2. Take a Dip in a Data Lake<\/h2>\n
3. Get Your Head in the Cloud<\/h2>\n
4. Unleash the Business Hounds<\/h2>\n
5. Judiciously Cut Red Tape<\/h2>\n
6. Dial into Your Collaboration Channel<\/h2>\n
\n
7. Lean on Your Friends<\/h2>\n