Monday, March 10, 2014

Web Analytics

Similar to the Business Intelligence life cycle, in web analytics we set goals, collect data, report, analyze, and optimize. Using a web analytics program such as Google Analytics, we can track every action on a website in real time. By setting goals we can begin determining the KPI that are relevant to our websites and then create dashboards and widgets to help us better analyze and understand performance trends.



Recently I've been using Google Analytics to explore http://www.westcoastfix.com/. West Coast Fix is a music blog that focuses on thoughtful in-depth coverage of new music regardless of popularity or buzz factor. All WCF staff members are heavily involved in their own creative outputs and offer a greater context for the topics covered. By providing discourse on deserving music and music related media, WCF sheds light on undiscovered artists and continuously produces meaningful content for its viewers through its interviews and music reviews.

With the goals of the site in mind, I decided to look into where their audience was coming from in terms of audience demographic and in terms of traffic sources. I also looked into which key words were bringing users to the site from search engines such as Google and which types of devices, browsers, and operating systems were being used to access the site. After performing an analysis on the site's content, I was able to determine average page view duration and bounce rate per page.

I came to the conclusion that West Coast Fix is a well designed music blog. Its minimalist interface allows users to effortlessly navigate through content on different browsers and operating systems. WCF provides meaningful content according to its average page duration and average bounce rates. The only advice/critique I have is to bring back the search bar and the about/contacts page. The majority of site traffic flowed through the contacts page and the search bar was convenient. It will be interesting to see how their new site affects user interaction.



Friday, March 7, 2014

Business Intelligence


Business intelligence is centered around performance measurement and management. To measure how well a business is doing we need to first establish key performance indicators (KPI). One way of doing this is by using a performance management framework such as a balanced scorecard which lays out the actions required to achieve specific organizational goals. A balanced scorecard focuses on four aspects: customer, financial, internal business processes, and learning and growth. Traditionally, businesses have often exclusively used financial performance as indicators for organizational growth, but this is misleading because non-financial factors such as customer satisfaction, employee morale, and product performance, all contribute to organizational growth and performance.



After establishing KPIs we quantify these measures and ensure that the data is correctly cleaned and profiled. Data profiling is used to determine if business rules and integrity constraints are being violated. It is vastly easier to perform new application integration and repurpose data sets when data is maintained at a high level of integrity. Poor quality data is worthless and analyzing poor data is a worthless effort. This cleaning process is necessary for proper extraction, transformation, and loading (ETL) into data marts and data warehouses.



Data warehouses are designed and implemented to store all of our records. Analysts will access this data to create dashboards for quick and easy information consumption. Dashboards are visual representations of current and historical KPIs. A good dashboard is designed with a minimalist mindset and is presented in a way which information can be monitored at a glance. I want to stress how important it is to create well designed dashboards because immediate decisions that depend on real time dashboards can have dire consequences. Consider a hospital that uses poorly designed dashboards to monitor its patients or a businessman that uses poorly designed dashboards to monitor stocks.


Ram, Sudha. (February 2014). MIS 587 – Business Intelligence: Dashboard Design and its use for analysis. Lecture Conducted from University of Arizona, Tucson, AZ. Accessed on February 16, 2014 from http://courses.eller.arizona.edu/mis/587/ram/Lecture8/

Ram, Sudha. (February 2014). MIS 587 – Business Intelligence: Data Quality Analysis. Lecture Conducted from University of Arizona, Tucson, AZ. Accessed on February 14, 2014 from http://courses.eller.arizona.edu/mis/587/ram/Lecture7/

Ram, Sudha. (January 2014). MIS 587 – Business Intelligence: Balanced Scorecard. Lecture Conducted from University of Arizona, Tucson, AZ. Accessed from http://courses.eller.arizona.edu/mis/587/ram/Lecture4/