In an article in the Graziadio Business Review, Using Dashboard Based Business Intelligence Systems, it discusses challenges for current business intelligence systems (BIS), benefits of using BIS, and strategies for implementing future BIS. As we have become a more global world, BIS has been applied across many industries . A dashboard is used to make real time management decisions. The dashboard could be used to analyze a building or city project through different data sources to identify issues that are otherwise difficult to sift through in the sea of data provided.
Tools for organizing & analyzing urban data
•Columnar databases for reporting
•Business Intelligence Systems
Business Intelligence Systems
Using data in Excel for BIS:
I created this Excel Spreadsheet from xml data exported from the Chicago Data Portal about city owned land inventory. This is a simplified example of what one can do with the data to discover relationships between data sources. I used a pivot table to calculate the number of properties within an area that had a particular zoning class. When filtering to business, one can recognize that there are a high amount of properties in Englewood zoned business. Why is this the case? These are the types of questions one can ask by layering different data sources and become better informed of what the issues within these complex data sources mean. Although I only analyzed the zoning classifications, one data dimension or measurement does not tell the whole story, its only when you compare different dimensions and classifications within the various hierarchies that you can really judge what the information means. For example, comparing property tax funds received by the government in a certain area to the population of that area, this would result in a per capita tax contribution to the fund.