Four years ago working for a small data analytics company I was trying to import data into their data analysis product. I fumbled and floundered. Eventually I got everything setup correctly and started the import process with a spreadsheet of 20,000 rows.
During the hour it took to import data into the system I was disgusted at how difficult it was to do this simple first step. I was talking to the system architect and his response frustrated me greatly:
This is a necessary step, the customers just need to persevere.
I wasn’t so sure.
So I set about building a system that allowed users to import data quickly with minimal pain. After a few experiments I had the workings of the system. The company is no more but the system I created is launching today as GravaMetrics an online dashboarding / business intelligence tool.
So how easy is it to import data into the system?
Create an Account, grab your fav spreadsheet and let’s try. On the home page under Datasources click the big plus icon.
Over the years I added lots of different types of data that you can import. You can see a list of them all here.
For the moment let’s click the Excel Icon. Then choose your excel file or drag it onto the drop area. You’ll then be presented with a page showing you the data you’re importing:
Then Click the upload button and enter the name you want to call your new datasource and you’re done. This is a datasource you can think of like a container that holds the data you’ve just uploaded.
You can view these on the home page:
You can click on this to view the data within or you can use the menu on the top left. By clicking on the edit button you will access GravaMetrics powerful data editor.
Data changes so GravaMetrics includes and Excel like data editor for a familiar data editing experience:
Dashboard / Chart Editor
But of course the whole point of adding data to this system is to be able to create dashboards and share them. On the GravaMetrics home page click the big plus button next to Dashboards to start creating your dashboard:
This takes you to a page where you can create your dashboard:
The tool bar at the top allows you to add a Chart / Text / Image, edit the appearance of the dashboard or share this dashboard with other users or publicly. You then enter a name and save and it will appear on the homepage or dashboard list.
Add a chart by clicking the Plus icon will show the chart editor:
Here you can create a query by selecting the datasource from the data panel and dragging the data up to either the Aggregate, Group or Filters panels.
Each field can be changed by clicking the drop down, label or sort icon to see all the different options you have for creating a query. If you have a very complex query then choose custom under aggregate and write your own custom query.
The chart type is clicking the button below the chart preview:
After clicking save you can then size and position your chart on the dashboard as you see fit:
Adding Text works the same way:
Images are also added similarly by clicking the image icon and selecting you image.
The appearance of the chart is changed by clicking the customize icon:
Lastly you can share this dashboard by clicking the share button:
Sharing data is simple you can share data by editing a datasource and clicking the share button:
This will bring up the share screen (which can also be accessed in the main menu to share dashboards):
Here you can share the entire datasource to a user or group of users or you can add a data filter which will filter out this data from the other user’s perspective. You can use this to filter the data down to a specific branch and all share just the data for that branch with those branch users.
I hope you can see that GravaMetrics is both easy to use and feature rich at the same time.
Any questions then please send them through to firstname.lastname@example.org we’d be happy to hear from you.