For Flexmonster team 2014 has become a year of bringing our web pivot table component to the new level. Announced in spring release of version 2.1 has become not only one of the most expected by our partners and leads but also one of the most advanced in terms of functionality extension. We continue focusing on making Flexmonster pivot table component more Excel-like and thus we add a number of cool features as well as bring HTML5 version to the same level as Flash/Flex one (by features and performance).
The full list of new features and improvements includes over 20 items but we would like you to pay your attention to the most spectacular of them:
Classic (not-grouped) view or Classic mode - widespread way of pivoted data presentation. Classic view helps end users see hierarchies one beside another - just like they are accustomed to in Excel;
Drill-through - clicking on a cell gives user an outstanding opportunity to dig deeper into data and see its constituents;
Editing cells for CSV data sources - lets end user change values in the grid on-the-fly;
Drag and drop fields on the grid - changing filters/columns/rows location on the grid without opening field list (configurator);
Speed up CSV parsing - updated loading algorithm allowing.
Imagine you walk into the room full of sales people doing unstopping “cold calls”. Every one of them features their own call list designed in Excel with marks, notices and statuses for each calling lead. Their manager has his own calling list of leads as well and sometimes reviews performance of his sales team.
As you go, you see people unaware of their own performance against others as well as their manager not knowing performance of his team as well. He tries to pull up some call list sheets from his mates, but the raw figures talk nothing to him as he needs to open numerous attachments for each of his sales reps. He prints out number of pages, then a moment later throws them out in a desperate attempt to answer sole question - what’s going on.
No doubts pivot reports provide better insight on multidimensional data with their ability to provide basic operations like slicing, dicing and pivoting OLAP data interactively. Rather than having such data separated into flat reports for dashboard tables, gauges and charts, pivot table report is still a tool where analysts can interactively gain more visibility.
While traditional pivot table report tools like Excel or PowerPivot provide a number of instruments to accomplish the above, the web report should be more robust to meet expectations and usability of common users. From manager to CIO, web pivot table reports should be a straight and easy self-service reporting tool to answer questions with little (or better without) any lengthy trainings or education.
The Big Data continues to roam through the world of business intelligence. Recently, I’ve came across a totally striking infographics, displaying an impact of Big Data market on enterprises. Regardless of industry and size, company executives begin to understand how big data inside their company can be converted into big profitability.
Analysis tools are essential part of enterprise software as they become more and more effective in day-to-day decision making. As most companies operate big data amounts today, it is obvious that it becomes difficult to do all the data retrieval, management and analysis, or the ETL cycle. If implemented properly, the data-driven decision making can increase overall company performance from 5% and up!
Big Data is sprouting today across every company life. Web traffic, social marketing activities, as well as KPI like shipments, sales and customer care - all of these are data that are coming into the company, but require quick and efficient tools for decision making. The data becomes the main driver of the company as it becomes as important asset as personnel or money.
Today, rapid analysis of big data is crucial for efficient business decisions. By year 2015, according to Gartner research, the companies who have implemented fast big data management and analysis will begin to win over their unprepared competitors by 20% in every available financial metric that is critical to run their businesses.
