BUS171: Individual Assignment 9

The most important things that I learned was how to created a code for the "IF" function and creating a Pivot Table and Pivot Chart. The "IF" function can be very useful when an organization needs classify combined pieces of data. The Pivot Table and Pivot Chart was helpful to know because it can graphically represent data represented in the Excel tables. The tables can do all the calculations of the data by a click of a button.

By looking at the data from Tableau, I learned the three primary activities in the business intelligence process. The first step is to acquire data, but the data we used was an Excel file of NFL Offensive Player Stats from 1999-2013 provided by Tableau. The second step is to analyze the data. We analyzed the data by using different Excel functions, the "IF" function was one of the many we completed. The final step is to publish results. For this assignment, we published our results by inputting the data into a Pivot Chart and Pivot Table.

An advanced Excel skill that we did not use in this assignment was "HLookup". HLookup is similar to VLookup, but the difference is that "VLookup" finds data placed vertically, while HLookup finds data placed horizontally. A user can lookup data in a specific column and duplicate it somewhere else in the Excel table. The example on Atomic Learning showed a case where a student's test score, homework, and project score needed to be copied onto another chart. Teachers can use this function to pull up a student's score on assignments if the student's parent called and wanted to know what their grades were in the class.

Map