A pivot table visualization of Labor productivity data by industry Looking at the above pivot table, it kind of gives a general clue that the productivity has moved from yellow to green over the number of years. Now let us change the visual to a simple line chart This visual although very simple seems to … Read more
Photo by Dan Chmill, via Flickr creative commons. Energy Dashboard metrics for Pittsburgh Municipal buildings Today we get our hands busy analysing data from Pittsburgh Open data. Few months ago we did Chicago wifi usage visualization and this is our first attempt analysing our own city data. The very first thing we notice is that … Read more
From SQL Query to Analysis InfoCaptor is extremely versatile dashboard application. It started initially just as “SQL Dashboard“. What do you mean by “SQL Dashboard”? This was the MVP (minimal viable product) for a Dashboard tool. The basic premise of the idea was that a developer can type any SQL query and produce the information. … Read more
What’s the first thing you look at when you flip on your computer screen in the morning? What’s the item you peek at on your phone even when your dinner partner wishes you’d leave work behind for the evening? For most people that addictive checking-tendency applies to their emails, but the truly business-savvy marketers are … Read more
Check the previous video on How to build dashboard pivot table In this video we illustrate a simple bar chart
Check the different flavors of pivot tables you can build using dashboard software Here is a quick video, click on it Click on the above image to see full screen
Journey Begins Once you start your own business or startup, the very first thing that comes to mind is “How many visitors did my website receive?” Google Analytics provides tons of metrics and it becomes quite a chore to keep up with all the dashboard pages and filter options. As a small biz owner myself, … Read more
InfoCaptor has powerful visualization engine that does pivot tables just like Microsoft Excel. The complete visualizer is built on the concept of pivot tables. When you are displaying a simple table grid, then sorting is very easy to specify. There are only two ways you can sort a column based tabular grid. In a … Read more
Here is a quick overview of to clone a dashboard within Infocaptor. InfoCaptor’s dashboard meta data is stored in a hybrid of database and file system. So when you want to create an exact copy of existing dashboard, you would have to create a “New Dashboard Page”. This action creates the database meta-data. Next you … Read more
How to streamline dashboard reporting with Google Analytics? There are lot of ways you can optimize your reporting with Google Analytics and I would like to bring your attention to a very powerful solution as described below. Our solution is not an Excel plugin but it is a packaged Datawarehouse. Let me assure and explain … Read more