InfoPlanIT Business Analyzer:
Standard cubes are provided for various Accounting and ERP systems for quick installation and startup. However every organization sees their data differently and needs customizations to be an effective tool. Business Analyzer takes data from a source system (Accounting, ERP or Data Warehouse) and re-organizes it from OLTP (On Line Transaction Processing) formats to a relational view that is much more effective for reporting and analytics. Through these views, Stored Procedures, or various types of scripts, data can be consolidated, merged and re-aligned to meet almost any type of reporting and analytic requirement. The key point is that you can start with pre-built analytics and then customize it to meet your needs! The following is a general representation of what the typical packaged analytics we provide for our customers. This is not a complete list but provides an overview of the most common building blocks for each Cube that can be analyzed with Business Analyzer.
Easily installed and customized
Connect to any and all data sources
Simple to complex tables, graphs, and analysis panels
» Bar and Line Charts: full featured charts that can be customized
» Benchmarks: target vs actual,pass/fail, performance based KPI’s
» Bullet Charts: easy to read, compare and contrast data visually
» Spark Lines: visually communicate trends or compliance
» Tables: tabular representation of data dashboards
Dashboards for monitoring KPIs
Windows and web-based
Visual Analyzer is a state-of-the-art Business Intelligence Application Suite.
InfoPlanIT Visual Analyzer allows everyday business users to extract valuable details from their business. By using simple drag and drop operations, users are able to create charts and tables that enlighten. Creating robust multi-dimensional charts has never been easier than it is by using InfoPlanIT Visual Analyzer. Any user that is familiar with viewing simple Excel spreadsheets can now analyze data in free form using nothing more than their mouse.
Easy to implement and use
Setting the InfoPlanIT Visual Analyzer windows application is as simple as installing the executable on your machine. Once you’ve completed the setup, you are immediately able to analyze any database on your machine or network. Configuring a new connections is a breeze using our connection wizard which walks you through the steps of connecting to virtually any database. Once connected you are able to explore the contents of the database by selecting any table or view. Upon completing the data source wizard, you immediately able to analyze the data in free-form analysis using simple drag and drop operations.
Connect to any data source
InfoPlanIT Visual analyzer is able to connect to any relational database. This includes: SQL Server, Oracle, DB2, MySQL, MS Access, SQLite, Excel, XML, ODBC, and even MS Analysis Services cubes. When connected to a relational datasource, InfoPlanIT Visual Analyzer will provide you with a default schema, which allows you to model your data however you see fit. If you need to disconnect your data from the network and take it with you, this can easily be done by saving your relational data to an external cube file. Cube files are created from relational databases on-demand, or through an automated scheduled job. (i.e. daily, hourly, etc.). InfoPlanIT cube files provide a snapshots of the relational data and can be compacted to leave a very small footprint.
InfoPlanIT Visual Analyzer also connects directly to SQL Server Analysis Services. This technology allows multi-dimensional data to be extracted and manipulated with sub-second response times. There is no need to configure a complex schema for analyzing your data, because InfoPlanIT Visual Analyzing infers the schema automatically to allow you to begin analyzing the data immediately. This is a nice compliment to the Business Intelligence Suite of products from Microsoft SQL Server product line.
OLAP technology stands for On Line Analytical Processing. This is exactly what InfoPlanIT Visual Analyzer allows you to do. Once you’ve configured your connections using the windows application, you can then go online and analyze your data using your favorite web browser. With InfoPlanIT Visual Analyzer, you are able to connect to your data over a standard HTTP protocol and filter live data using nothing more than your mouse. Our interactive web experience enables you to analyze your data in much the same way you would inside the windows application.
Windows (local and server based) and Web (server based)
We offer multiple solutions for your company. Depending on your needs, we have a solution that would fit to your system requirements. Using our windows product, you are able to connect to any database on the local network or directly from your machine. When you take your analysis to the web, the same concepts are applicable. As long as your web server has access to the database, your users are able to analyze the data and share layouts. If security is a concern, InfoPlanIT Visual Analyzer allows group level security for your connections and dashboards.
Tabular and Graphical representation of data
Many times, users need a simple tabular display of data to understand their data. With simple tabular data, users are typically take the data and put their results into Excel to do further analysis to calculate their data, sort it, filter it, and style it to fit their needs. The beauty of using InfoPlanIT Visual Analyzer is that there is no need to take your data to Excel. InfoPlanIT Visual Analyzer has a lot of built-in functionality that enables real time visual analysis. If you do find that you need to take your data into Excel, there is a built-in export for that. However, by viewing your data visually with bars and lines, you allow the data to tell it’s own story and enable the numbers to jump out at you. Seeing your data in easy-to-understand charts, rather than tabular text format gives you a deeper insight to the data. InfoPlanIT Visual Analyzer will prove the age old “a picture is worth 1,000 words”. Using extensive research, we’ve taken many of the visual techniques that make analyzing multi-dimensional data easy to analyze and baked it right into our solution. Using InfoPlanIT Visual Analyzer enables your key outliers to become more visible, thus allowing you to focus on the “exceptions”. By using colors or shapes you can isolate data and spot trends easier than ever before.
Powerful data analysis tools
Analyzing data is so much more than looking at a report or seeing the results of a consolidated chart. InfoPlanIT realizes that the process of analyzing data is typically complex and sometimes mundane. The problem in most cases is that users are not equipped with the right tools to do free form analysis against their data. InfoPlanIT Visual Analyzer takes the complexity and monotony out of analyzing data, and makes exploring your database fun and very enlightening. Users are able to filter their data with a simple click of a mouse or drag and drop operation. Sorting data can be done with a single menu click, and slicing your data between multiple dimensions is as simple a dragging a field to the right or left of another field. Analysis displays can go from a huge table of numbers to a series of visually appealing chart displays.
Layout manager saves time and enables sharing
Using InfoPlanIT Visual Analyzer, users are able to build a report or chart and save that configuration (sort definitions, filters, and all..) to their profile. If the user wishes to share that display with another user, they can easily do so by using the online layout manager. From here users are able to organize, share, and manage their layouts. Consider a scenario where a user finds that a certain product line is loosing money in a particular region due to some unforeseen factor. The user could simply give that layout a name, and share it with another user. That user could then open that same exact display and begin doing their own analysis on it, which might result in one or more other layouts. The possibilities are limitless.
Online analysis widgets
InfoPlanIT Visual Analyzer allows users to take their analysis experience a step farther by enabling their saved layouts to become data sources for other data bound displays. Once a user has configured a layout and given it a name, they can then use this layout (taking it’s filters and other settings) as the underlying data source for one or more analysis widgets. Imagine the possibilities with this capability for a second… Consider a layout named “Profit vs. Sales Analysis”, you could setup a small ‘Chart’ widget that lists the ‘Product Name’ and the ‘Sales’ for each Month. If you would like to update the display of the ‘Chart’ widget, simply go back to the layout and modify the filter from Year ’2009′ to year ’2010′ and your chart display is immediately updated with the new values. This is a very powerful feature of the InfoPlanIT Visual Analysis product.
Dashboards (Web) group various Analysis Widgets together
The beauty of analyzing data is not only the insight that you gain during your analysis experience, but it also needs to be consolidated and shared with others in order to be of value. This is where InfoPlanIT’s Online Dashboard Module comes into play. Using an intuitive online designer, users can publish multiple charts and tables into a single organized display that tells a single story.
Published analytics (Web) can be embedded inside any 3rd party web application or Microsoft Office (Excel or PowerPoint)
InfoPlanIT Visual Analyzer ships with a Microsoft Office Add-In that allows your analysis results to be easily embedded into PowerPoint Presentations, Excel Spreadsheets, and Word Documents. No long do business analysts have to spend hours and hours building chart displays only to take screenshots and tell stories about the chart being displayed… only to have to do the same thing next month. Using this add-in, users can simply choose a layout from their drop down and add it to their report. Next month, they simply have to ‘Update’ the chart with the latest numbers. It makes building your monthly reports a breeze!
Center of all the magic – makes valuable business insights visual! Data from virtually anywhere* can viewed and analyzed using our Windows or Web Analyzer or our Web Dashboards. Easily identify outliers and focus on the “exceptions” – positive or negative. Colors and shapes help you isolate data and spot trends.
Visual Analyzer can connect to data in SQL Databases (any relational source, SQL Server, Oracle, Access, MySQL, Excel, XML, ODBC), MS Analysis Services (Highly Optimized SQL Server Cubes, utilizing MDX Queries for super fast data retrieval, and managing very large data sources on scalable servers), and InfoPlanIT Cubes (created from relational databases on-demand or on an automated schedule such as daily, hourly, etc). InfoPlanIT Cubes provide snapshots of relational data and can be saved to local systems and allow for offline analysis in the Windows version of InfoPlanIT’s Visual Analyzer.
Powerful Filtering options
Half the battle of doing insightful data analysis is having powerful filtering options that are easy to use and make sense. We’ve made it simple to isolate and strip out data so you’re in control. Filters allow you to narrow down the breath of data available into a subset of actionable information.
Page Filters provide the ability to key in on a single position in an Attribute Field. By using a drop down box or arrows you can quickly scroll through the positions and see how your data changes so that you can play some what-if scenarios while you play with the filters you want.
Attribute Filters allow you to select multiple values or ranges of values. Options like Equals, Begins with, Contains create powerful filter expressions.
Quick Filters allow you to easily click on different levels of an attribute and select / deselect items. And finally values can be filtered to narrow the results even further.
Setup behind the scenes is a snap with our Scheme Manager. Information about your schemas is inherited from Microsoft Analysis Services and can be customized for SQL Queries. This saves your database technical staff loads of time and eliminates duplicate effort. The Hierarchical Dimension Attributes organizes your data in a meaningful manner and enables the summary to detail drill down capability. It offers an incredibly flexible range of measures taking values directly from the data source and allows you to calculate values by combining data from any other information. This extends your analysis beyond just what the data source provides and gives you insights not possible elsewhere!
Once the schema is established in Visual Analyzer, the reporting possibilities are endless and all this power is always delivered in simple ways so that even the uninitiated can create beautiful and consistent models and build meaningful reports and dashboards!
After you’ve analyzed and found insights through your data, there’s a good chance you’ll also want your data in Excel (or other apps) for additional manipulating, sharing, reporting and commentary. The key is to get it there without a lot of effort and Visual Analyzer has you covered. We keep things flexible – no locking you it into a single environment.
Once you identified an opportunity, drill down into the details with our simple to use Pivot Table view and then easily export to Excel!
You can use Layouts to save time and to automate repetitive reporting tasks! Once you create a ‘view’ of the data you can save it with our Layout Manager. Layouts can be private for a user, or published to our Web Portal and shared. This allows for any level of granular security your organisation needs while getting views out to as many people as possible quickly. This means that the effort of creating the best and most insightful views of your data only needs to be done once and by the person who has the greatest expertise of that data. This results in huge time savings and agreement on the correctness of reported data, something many companies waste many hours not quite getting there.
Visual Analyzer Web Portal
Our Web Portal makes visualizing your data everywhere possible! It ties everything together in one easy to use and manage web enabled interface. This allows you to create and publish Dashboards throughout your organization or on the web. The Web Portal can run stand-alone with its own user security and has a web based user interface. Or you can publish content using our Analysis Widgets within your own web applications (similar to RSS type news feeds). This means your internal applications and intranets gain all the benefits that we bring to everyone in your organization through our powerful tools!
Analysis Widgets are customized data visualizations that you can combine to make dashboards or embed directly in other applications like Excel and PowerPoint. Monitoring metrics and highlighting trends made to fit in your existing workflows and reporting.