Individual Assignment 8

In this assignment, I used Excel and Tableau to create a visualization of the data we had in Excel. In Excel, I had to reorganize the 10 brands so that each brand would have a column for familiarity, regard, and relevance. In addition to the data that was provided to me, I had to create 10 additional columns for each brand. In the new columns that I created I had to use the Excel Sum function to find the total brand equity score. Once I did that for each brand, I had to import that file into Tableau Public. In Tableau, I created four visualizations of the data from Excel for the average familiarity, the average regard, the average relevance, and the aggregate brand equity for the 10 brands. For this assignment, I learned how to use Tableau to create a visualization for the data that I created in Excel. This assignment is an example of business intelligence because I needed to complete the three primary activities in the BI process (Kroenke, 2014). First, I had to acquire the data which was the Excel file. Next, I had to analyze the data by organizing the excel columns into the 10 brands and I had to create a new column to perform the Excel Sum function. For the third step, I had to publish my results. I used Tableau Public to complete this step by publishing it on the web.

Works Cited

Kroenke, D. M. (2014). MIS Essentials (pp.230-236). Upper Saddle River, NJ: Pearson Education, Inc.