Using Flexmonster Pivot Table and Charts as Self-Service Analytics Tool

Volodymyr Yatsevsky posted on August 10th, 2012

Implementing full-scale BI solution in a small company can be quite cumbersome and expensive. While in the pursuit of the simple to bring Excel sheets into web, companies engage into huge contracts and large-scale projects of implementing the complete BI stack, offered by BI consulting and ISV companies. However, that is not completely necessary as a number of lightweight tools emerge on the market.

While a common use of Flexmonster Pivot Table & Charts component is adding it into analysis dashboard, it can be also used as a fully standalone tool for online report analytics, working right in your browser. Take 3 simple steps to start analysing your data in less than 10 minutes:

1. Prepare and Load CSV data file into Flexmonster All-in-One Demo. The CSV is the most common format which you can obtain by using the Save as CSV function in your favorite Excel.
2. Once the CSV is loaded, Flexmonster Pivot will prompt you to Choose Dimensions, Rows and Value Aggregations to include into your report. Click Update to see your first report. You can modify the layout later anytime by clicking the Fields icon in the toolbar.
3. Apply Filters, Sorting and Formatting to locate trends and opportunities and start gathering value from online analytics, now easily powered with Flexmonster Pivot.

You can always Save Report for later usage or Export it into same Excel and share with a colleague. Enjoy effortless analytics with Flexmonster and don’t forget to share your feedback with us!