Using Business Intelligence Systems


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

•Traditional databases
•Data Warehouses
•Columnar databases for reporting
•Business Intelligence Systems
•Data Mining
Data Warehouse
Columnar Database
Business Intelligence Systems
Data Mining
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.
Business Intelligence App (dashboards)

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s