Individual Assignment 9

In this assignment, I learned how to analyze data given to me by using formulas and a pivot chart and table. The formulas I used for the data were the DAYS function, the Nested IF function, the VLOOKUP function, and the Concatenate function. I have never used any of these functions before, and I think that they are very important because they will help me in my future job to analyze data. Learning how to create a pivot chart and table is was also one of the most important things I learned in this assignment because it helped me to find answers quickly and organize the data that I wanted into a chart and a table. I also learned that using pivot tables and charts is an essential skill that I need and what my future employers will want me to do with excel because it is a way to analyze certain data quickly. 

This assignment is related to 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 an excel file that I downloaded from Tableau Public. Next, I had to analyze the data by using formulas to find answers to questions such as using the DAYS function to see what the age of an NFL player would be today if all the data gave me was the player's birthdate. I also had to analyze the data by creating a Pivot Chart and Table in excel to show which state had the highest average of Fan points. For the third step, I published my results. I used Tableau Public to complete this step by using the player's birth place zip code and their position rank scores to create a map. Once I created the map I saved it and published it on the web. 

https://public.tableau.com/shared/FBDH2CDGF?:display_count=yes

An Excel skill that I did not learn about in this assignment is the COUNTIF function. I think that this function would be useful in the future because it analyzes data in a certain range and tells me how many cells meet my specified criteria. Since I eventually want to become a hospital administrator, this function can be useful in many ways such as finding out how many hospital rooms are on a certain floor or how many times a certain patient has been seen in the hospital that year. 

Works Cited

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