Humans process images, machines process numbers. Thus, data is visualized—be it in an infographic or a business intelligence (BI) application dashboard or some other art form. This way, humans can ingest information faster and easier. In the case of BI apps and analytics, data visualization is the crystallization of numeric algorithmic outputs into images. The purpose of such imagery is to quickly transfer information from the machine to the human brain, not only efficiently but also in the most meaningful manner possible. Therefore, it is not the aesthetic value of a visualization that counts but the clarity of the message it conveys. However, the conciseness necessary for clarity does not preclude complexity in the message. Since much of the information humans must consume is complex and nuanced, data visualizations are configured alone and in groups to tell a larger story through images. An example of a single configuration is any visualization that reveals more granular or related information when the viewer clicks on or performs a mouseover on a section of the illustration. Examples of group visualizations include just about every BI app dashboard ever made. Indeed, data visualization is such an integral part of self-service BI tools that the tools to make and publish them largely share common feature sets. As expected, in our recent review roundup of the best self-service BI products, we found the vast majority to be capable of data visualization operations. However, customers looking to really exploit data visualization should look at these tools carefully and exclusively through that lens before making a buying decision. After all, sometimes the right tool to parse your data may not offer a sufficient visualization palette for your needs. For example, you may want the ability to build a custom infographic or create interactive visualizations, but not all BI apps provide those options. You may need to invest in a combination of tools in order to get both the analytics and the visualization tools you need. What Is Data Visualization? In short, data visualization is a visual depiction of information. It is imagery dedicated exclusively to messaging or presenting information. Data visualization tools can automatically create visualizations, enable you to create your own, or offer both capabilities. At the lower end are simpler and even free data visualization tools dedicated to building infographics rather than performing sophisticated data analytics. Some of these tools include Tableau Gallery and even Microsoft Power BI. At the higher end are tools that can change visualizations on the fly, in the same way that outputs from sophisticated algorithms change after repeated direct querying of real-time data (i.e., streaming data) and across multiple data sources. The tools occupying the middle of the spectrum do not represent real-time data but still produce visualizations from advanced analytics outputs. Source: Christopher Ratcliff, econsultancy.com The self-service BI apps we reviewed contain average to higher-end visualization tools. All are well above the simpler infographic tools mentioned earlier, even though some can be used to build infographics, too. In short, you cannot judge the quality of the underlying analytics engine by the cover of its art package. Some very powerful analytics come with pitiful to passing visualization capabilities. Conversely, some pitiful to passing analytics come with some pretty impressive visualization features. There is a wide range of art depictions that data visualization tools can create. Some are simple, some are complicated. Some beautiful, others are crude, and some are truly individual creations. But most spring from templates in the traditional forms associated with statistics. The simplest examples of data visualization are the pie and bar charts you've been able to access via Microsoft Excel for more than a decade now. But, as BI has matured as a platform so, too, have the options available to you for seeing your data and presenting it to others. The tools we review here reflect the medium to higher end of the spectrum in BI; they're capable of performing sophisticated queries without the need to understand SQL coding. Plus, they can render analytics in a wide variety of visual formats—going far beyond the basic bar chart to include geographical mapping, heat maps, sparklines, and even more specialized visualizations such as the spider chart below). Source: Lachlan James, yellowfinbi.com Data visualization is not a new concept. Pie charts and bar and line graphs have existed throughout the ages. What's changed is the kinds and size of data that can be represented this way, and the many more sophisticated ways in which you can show it and share it. The Importance of the Dashboard Ultimately, data visualization capabilities are used to build dashboards. Sometimes the dashboard represents a single, data-based story that is significant to many viewers. Or the dashboard may contain many stories for the benefit of a single user. Dashboards sometimes come with visualizations that are pre-set and fixed in place. Other times the dashboard's visualizations come with various display options or images that are customizable. Sharing can often be customized too, such as according to permissions, per business line, per job role pertinence, or even by personal preferences. In any case, the dashboard typically contains two or more data visualizations meant to inform and sometimes even prompt a business action or decision. Source: Mailchimp blog Prior to the advent of self-service BI tools, executives had to present their questions to a database professional who would then try to understand it as best he or she could, write a SQL query, and representing that question against a database or data warehouse. The result would be fed to an IT person who would then write the necessary code to represent it as a dashboard on the executive's team website, on a shared app, or even just as a standalone document the executive received via email. If more than one data source was needed, then very often more than one database professional had to write separate queries (which then had to be melded together offline). At the end of this inefficient and multi-step process were analyses, you got historical analyses (i.e., information after the fact rather than in real time). These reports usually arrived too late for the business to change or influence the outcome of the activity it depicted. Thus, business analysts, department heads, and C-suite leaders typically received reports with delayed, overly simplistic, and vague information. Sometimes the information was irrelevant when it finally made its way to business analysts or the C-suite because the company had changed direction or other factors emerged in the meantime. Even so, dashboards and reports made in this way rarely changed. Things proceeded as they always had: the same questions asked, the same data queried, the same reports and dashboards generated—day after day and week after week. By contrast, today's self-service BI apps let business analysts bypass the middlemen and unstop many of the IT bottlenecks. This self-service software also enables the use of data outside the company as well as from within, such as social media, the cloud, public data sets, and Internet of Things (IoT) data. Some self-service BI apps can use real-time data, but many are limited to near-time data (frequent refreshes). However, near-time data usually isn't a business limitation. There are actually only a few use cases where real-time data analysis warrants the extra effort and expense. After all, near-time refreshes can be as frequent as every minute or less. With regards to self-service BI dashboards, the key value is typically three-fold: First, they don't require database expertise to use. You'll probably (though not always) need your database professional's help to set them up and connect them to all of the data sources you need. After all, compliance and security issues still remain. IT usually gets involved at least to the point of resolving those issues, determining who gets credentialed access, and how much data they can see. Once that's done, these tools provide varying degrees of simplicity when it comes to writing your own queries. Some still work best if you know some SQL, but others work entirely using natural language syntax, rendering SQL knowledge unnecessary. However, most do require a good understanding of statistics. This necessity is not strictly from an operational standpoint, but because errors can be made in the interpretation of the outputs if the user lacks a basic understanding of statistics. Just because the software made you an excellent visualization of the machine's answer does not mean that you asked the right question. Second, almost all of them can act as a unified front end to multiple databases and data types. This is primarily due to the rising popularity of Big Data, which is typically a combination of relational data (generally SQL-based) and unstructured data found in disparate sources both inside and outside the company's walls. By providing support for various kinds of data, these tools allow folks without database expertise—but with direct, front-line job experience—to ask questions directly against the organization's data. This can provide immediate payback against fast-growing Big Data stores. It also enables new insights and ways to leverage data, which might otherwise be lost when those questions percolate through data scientist and IT professional filters. A single query can span multiple databases and data types in record speeds, and the tool will take care of building the visual representation, too. In short, a team of data scientists is not required. That's not only faster but it's orders of magnitude easier. Third, these tools can also build live data visualizations and dashboards themselves rather than forcing a separate operation from your company's programmers or IT staffers. Those visualizations can be exported as flat graphic files or as code snippets that you can just copy and paste onto webpages or team websites. Dashboards can also be directly shared, oftentimes even with users who are not using the BI app. Integrating them with other apps is usually easily done through connectors, depending on whether or not the self-service BI app you are using has a connector to the app on which you want to share the dashboard. Some will still require some IT assistance, but even there the time required to perform the integration is often reduced versus starting from scratch with just a series of SQL queries. Those code snippets will also do more than simply render a visualization; they can also maintain their connections to the live data sources referenced in the query. This lets them change on the fly as source data changes—the primary function of any dashboard. That certainly goes far beyond what you can get through a traditional spreadsheet. The good news is that even some spreadsheet software such as Microsoft Excel now includes data visualization capabilities. These tools can bring businesses of any size fresh perspectives on their data quickly and easily. Given that most businesses are being inundated with new data from all directions, a fast path to return on investment (ROI) is often reason enough to justify a self-serve BI or data visualization software purchase. What to Look For Once you've made the decision to invest, you'll quickly realize that not all data visualization tools are created equal. You'll realize they also tend to focus on different aspects of data interaction. So, to find a solution that will fully meet your needs, you need to evaluate your selection carefully in terms of features and capabilities. First, check carefully into the kinds of visualizations a tool supports. Compare that not just with the kinds of data your organization collects, but with how your company likes to consume that data. Grab a free trial and experiment with new visualizations. Many companies have standardized on a certain method of looking at their key data. Make sure any new tool can render data that way, and take the opportunity to try some new visualization methods. You may find that a new view unlocks new insights. Second, find out exactly which data formats the query tools supports. There should be a long list that includes not just basic data formats such as SQL and NoSQL databases, but also specific apps such as Oracle or SAP Financials, sales tools such as email marketing platforms and customer relationship management (CRM) apps, and similar business platforms (especially the ones your company is currently using). And, if you're contemplating a move into Big Data processing, then support for Hadoop is critical. Third, examine the degree to which a tool can drill down on all of that source data. What's required to drill down on data beyond first-tier querying? Can the tool drill down on a live data visualization? For some organizations, that can be an invaluable capability because it lets teams effectively change the story a given visualization is telling immediately, without starting from scratch. Does a "re-querying" of this kind require SQL or does it use the same natural language syntax as a first-tier query? Remember that the graphics you're building with these tools aren't simply pictures, they're intended to be live, visual windows into your business. So, being able to quickly and easily adjust that view can be critical to realizing a tool's full value. For many industries, it's important to have an audit trail of sorts for compliance reasons on who is responsible for the data and/or analysis the visualizations depict. It's equally important information for organizations that do not face such a regulatory requirement, as it gives you more transparency and accountability within the organization. Not to mention a contact you can reach out to should you have more questions. Look for these capabilities in the publishing or collaboration features of the visualization tool. Next, check into its exporting capabilities. Once you've built your query and visualization in the BI tool, what are your options for exporting it to where other folks can consume it? Key options here should include not just a variety of flat graphic formats (i.e., CVS, JPEG, PDF) but also code snippets that can be dropped directly onto webpages, incorporated into other apps via open application programming interfaces (APIs), and rendered in the best way possible on both desktop and mobile devices. Finally, if your business is collecting Big Data or is about to enter into such a venture (for example, embarking on an IoT offering), then look at a product's advanced processing capabilities. Some tools act mainly as querying front ends for back-end data warehouses intended to do most of the processing your queries require. That can be difficult if the data warehouse is under a constant query load already, and it can be downright impossible if your queries will span data sources outside of the data warehouse. In such situations, the BI tool will need to provide the performance muscle to crunch your query's numbers, which means support for advanced data processing capabilities (such as in-memory processing) can be crucial. Again, when evaluating your tool using its free trial, make sure to test its performance capabilities by running as many complex queries through it as you can. Data visualization can definitely be considered the pretty face of data analytics. It doesn't change the numbers or the questions, it simply gives you more ways of looking at them. That can be invaluable for some organizations but completely unnecessary to others. If advanced analytics is what your organization needs, then evaluate self-service BI tools based more on their number-crunching capabilities than on their visualization features. But if you're trying to bring an easier yet deeper view of all the data your organization is collecting to a wider swath of your employees, then data visualization is of prime importance. Just remember that not all people understand all images easily. People learn and ingest information in different ways. Know your audience and choose visualizations that work best in communicating with that audience. Zoho Reports Review MSRP: $50.00 at Bottom Line: Zoho Reports is great for introducing general business users who are new to advanced analytics the ins and outs of this new technology as well as its benefits. And it even does so at a very ... Read Review Sisense Review MSRP: at Bottom Line: Sisense checks all the boxes that more experienced business intelligence users are looking for. Where it falls a little short is in being an easy platform to learn for BI newcomers.  Read Review Domo Review MSRP: $2000.00 at Bottom Line: Domo isn't aimed at newcomers to business intelligence. But for companies with some BI experience on staff, it's a powerful tool with loads of data connectors and decent data visualization c... Read Review Microsoft Power BI Review MSRP: $0.00 at Bottom Line: Microsoft Power BI garners our Editor's Choice designation for its standout data visualization features, intuitive design, and excellent integration with the rest of the Microsoft Office sui... Read Review Tableau Desktop Review MSRP: $42.00 at Bottom Line: Tableau Desktop represents one of the most mature players in the self-service business intelligence space and it shows in this products depth of features. Unfortunately, it also shows in its... Read Review Google Analytics Review MSRP: $0.00 at Bottom Line: Because it's free to use, Google Analytics has become a de facto standard for website and mobile app intelligence. While it's got a significant learning curve, Google has turned this free to... Read Review Chartio Review MSRP: $2000.00 at Bottom Line: Chartio has done an excellent job building a powerful analytics platform for experienced business intelligence users. For those new to BI, however, it represents a very steep learning curve.... Read Review SAP Analytics Cloud Review MSRP: $21.00 at Bottom Line: If your business already uses SAP's HANA database platform or some of its other back-end business platforms, then SAP Analytics Cloud is an easy, well-priced choice. But be warned there's a ... Read Review IBM Watson Analytics Review MSRP: $360.00 at Bottom Line: IBM has put its Watson Analytics engine on the map with loads of marketing combined with a powerful analytics engine riding on top of an excellent natural language querying tool. This is a g... Read Review

weiterlesen: RSS Quelle öffnen