4 ms·

I worked for a management consulting company and produced such a system based on aggregating data from across a global corporate network and producing dashboard

by iamdave 14y ago

I worked for a management consulting company and produced such a system based on aggregating data from across a global corporate network and producing dashboards in SharePoint. Telerik?

buro9 14y ago
No. But a few of our clients did use their web parts for dashboard. What I build was an assortment of plugins to products (Project Server, Excel for SharePoint, SharePoint) as well as some simple scrapers (HTML, XML and CSV from web sites and windows shares). These were either event triggered or attached to timers. Data was extracted from all of the backend systems and then deposited in a local database, and the local databases (usually office or department specific) were then rolled up nightly to produce the HQ view of all of this data. Finally, that data was dumped into OLAP cubes and surfaced through reporting web parts into SharePoint so that people could slice and dice however they wanted. And now think of what IFTTT and Yahoo Pipes can do. Right, so they're just missing a reporting layer to act on the output of all of that, potentially a database if they want to add trending.
- buro9 14y ago
  Found an old product page for the thing I built: http://www.pcubed.com/services/tools.deliveryhub.aspx http://www.pcubed.com/services/tools.deliveryhub.aspx When I say "I built" I mean that I designed it, coded it, delivered it. We were only a small 2 person team, though we had support assistance from a couple of developers in other timezones to support multi-national clients. DeliveryHub wasn't solely a technical solution; sure it could trend any data on your intranet and inside your project management software. The real selling point was that we shipped a suite of charts and reports designed by project and programme managers. Every business wanted to produce those reports, but none had systems that gave them a record of their data that allowed them to generate such reports. Sales were easy, and the only factor that limited sales potential was that Pcubed as a services company never sold software without headcount. I understand why they did that, but never agreed with it.

by iamdave 14y ago

I worked for a management consulting company and produced such a system based on aggregating data from across a global corporate network and producing dashboards in SharePoint. Telerik?

buro9 14y ago

No. But a few of our clients did use their web parts for dashboard. What I build was an assortment of plugins to products (Project Server, Excel for SharePoint, SharePoint) as well as some simple scrapers (HTML, XML and CSV from web sites and windows shares). These were either event triggered or attached to timers. Data was extracted from all of the backend systems and then deposited in a local database, and the local databases (usually office or department specific) were then rolled up nightly to produce the HQ view of all of this data. Finally, that data was dumped into OLAP cubes and surfaced through reporting web parts into SharePoint so that people could slice and dice however they wanted. And now think of what IFTTT and Yahoo Pipes can do. Right, so they're just missing a reporting layer to act on the output of all of that, potentially a database if they want to add trending.

buro9 14y ago
Found an old product page for the thing I built: http://www.pcubed.com/services/tools.deliveryhub.aspx http://www.pcubed.com/services/tools.deliveryhub.aspx When I say "I built" I mean that I designed it, coded it, delivered it. We were only a small 2 person team, though we had support assistance from a couple of developers in other timezones to support multi-national clients. DeliveryHub wasn't solely a technical solution; sure it could trend any data on your intranet and inside your project management software. The real selling point was that we shipped a suite of charts and reports designed by project and programme managers. Every business wanted to produce those reports, but none had systems that gave them a record of their data that allowed them to generate such reports. Sales were easy, and the only factor that limited sales potential was that Pcubed as a services company never sold software without headcount. I understand why they did that, but never agreed with it.