Add subtract data from two different database sources : Howto

How to perform calculations across different data sources/databases Imagine, you have a CRM database that contains all your customer and sales information and you have a different database that stores your GL and ERP data. Now add some complexity to it, your CRM database is say SQL Server or Microsoft Access or just Plain old … Read more

Visualize your data from database tables into Bubble pack layout using d3js

Previously we saw how to build D3js Analog clock on the dashboard In the same note, we dig deeper and now take our data from database tables and visualize into pretty bubbles. Here is how the tabular data looks like Brazil 5,197.89 Argentina 702.69 France 1,025,156.84 Germany 2,604,893.08 Saudi Arabia 628.89 Denmark 598,323.01 Singapore 909,996.22 … Read more

School District and School metrics – Colorado School performance framework

Previously we built this School District Metrics Dashboard and using more data files from the same Colorado School Framework website we build few more metrics. This one is more interactive than the previous one and it is suppose to be a browsable by School district and school name. The top portion highlights School District metrics … Read more