VC Investment Data visualization and analytics

Using the data from pwcmoneytree.com and easy to use dashboard software we perform analytics on a huge dataset that spans 20 years of Venture capital investment data from 1995 onward. Having data that goes far into the history should give us enough to extract the necessary analytical juice out of it.   The year 2000 … Read more

InfoCaptor releases self hosted web dashboard

InfoCaptor released the free online dashboard for every small business user in the entire universe. The free dashboard is available at https://my.infocaptor.com and it is one of the most innovative dashboard in the Business Intelligence world. With the online dashboard a small biz owner can automate its entire business reporting and set it on auto-pilot. … Read more

Disruptive Dashboard with Bells and Whistles – Google Analytics – Facebook – Database

Ever imagined your dashboard could sing? Ever wondered if the widgets on your dashboard could shake and dance? Ever imagined you could design your dashboard like a flowchart and move your magic wand and “Boom!” the flowchart starts displaying real time metrics. Ever wondered a cloud based Dashboard SAAS service that is dead easy to … Read more

Create Dials and Speedometer Scorecard

In this article we will take an Excel source containing scorecard information and convert into dials and speedometer charts. We will also create few bar trending charts. Consider the below sample data Source File: You can download the excel file here         The above excel file tracks few metrics such as safety, … Read more

How to build Excel Dashboards – 12

Previous – Excel Dashboard Tutorial – 11 How do you share your Excel Dashboard with users? Now that you have built the dashboard, you can share the dashboard in multiple ways. ” Create a PDF output of the dashboard and send as email attachment. Click on the PDF icon on the toolbar as shown below … Read more

How to build Excel Dashboards – 11

Previous – Excel Dashboard Tutorial Summary We built the above dashboard completely from scratch. We defined Calculations We defined date hierarchies We built Date Filters We built Date Parameters We built Bar Charts We built Pie Charts We cleaned the dashboard layout Next – Share Excel Dashboard with other Users

How to build Excel Dashboards – 10

Previous – Excel Dashboard Tutorial – 9 Cleanup – Resize and Organize Give appropriate names to each portlet. During the chart creation if we did not provide names, now is the time to provide them. Right click on each title and click on “Edit”   Scale down the Size   Note, you can drag the … Read more