Individual Assignment 10

During Marta Dalton's guest speaker event, I learned about the differences between business to business digital marketing and business to consumer digital marketing, social media, and job opportunities and the outlook for jobs in digital marketing. For a business to business (B2B) digital marketing the targets are the companies, whereas for a business to consumer(B2C) digital marketing the targets are consumers. The campaign complexity and campaign volume for a B2B is medium because the company usually has buyers who are long term clients who buy a lot more products than an individual consumer. Therefore, in a B2B digital market, the company grows a personal relationship with their buyers and does not put much money into marketing campaigns. Whereas in a B2C the campaign complexity and campaign volume is high because they need consumers to stay interested in their products so they will go buy them in stores. I also learned about how Marta Dalton's company uses social media, and how there is a purpose to each social media platform. She also discussed how they use google analytics to analyze the amount of people that are looking at their sites. Additionally, Dalton emphasized that social media includes posting, liking other individuals or companies, commenting on others posts, and maintain the site. My favorite part about Marta Dalton's presentation was when she talked about the digital market jobs and outlooks. She stated that digital marketing jobs are in demand from companies and that the growth predicted is about 9%. I also liked  how she related digital marketing to students who are not planning to graduate with a digital marketing degree, and that even if I do not have a degree in that particular field the ways that I can use digital marketing in my own job.

When I went on the MSA tour and listened to the guest speaker Karl Herleman I learned what MSA does and how they use information systems to help them help their customers grow. MSA is a small company that analyzes data to inform their customers the best way to grow their business. The customers can then use the data to make decisions. MSA has eight different areas that they are involved in including business analysis, gaming, information technology systems and solutions, media and MSA focus international, corporate enterprise application, information management solutions, life sciences, and metals and advanced manufacturing. MSA uses information systems to help them analyze the data. However, to use information systems the have to develop them. MSA develops information systems if their client wants analysis on a specific type of data or if someone has a good idea for a program that they can develop. When someone has an idea it goes through multiple stages of designing the information system and then developing the system. I thought that this tour was very interesting because I did not know MSA was involved in all of the things that they have been involved in such as determining when the best time and day it would be to air a TV show. 

During Ginger Ellis-Polozoff guest lecture I learned the basics of project management. A project is temporary and it produces something new. Therefore, project management is a framework for completing projects and managing workflow. The project is usually monitored by a project manager, which is the person responsible for leading the project from the beginning to the very end. A project manager is also in charge of finding the most efficient way to complete the project. The requirements of a project should be clear, measurable, feasible, verifiable, correct, and traceable. The deliverables of a project are what comes out of the project management process, and they can be traced back to the requirements. Stakeholders are individuals who can influence or are at least affected by the project. A project charter is during the initiating phase of the project management process, and it defines and outlines what is expected to come out of the project. The next phase is the planning step. During this step network diagrams are created, which is a graphic that shows relationships between groups, steps, and tasks that will impact the project. The other three steps are executing the project, monitoring and controlling the project, and closing the project. I really enjoyed learning about project management because I think that it is a great tool that I can use in my future career.

Personally, I have learned a lot from this course. I have learned things such as security; how to build a business process model; how to use access, excel, and tableau; and the basics of management information systems. This course has affected me both professionally and personally. Professionally, this course has taught me things I know I will use again in the future. It has also helped me finding contacts in the field that I eventually want to work in through interviewing professionals for the team assignment. Personally, I have become more interested in MIS and I found out that I am really good at it. I wanted to continue learning about MIS that I even added the MIS minor to my transcript. In the future, I plan to use the knowledge that I learned in excel and access because I know that I will be using those programs in my field. In the beginning of this course I took a survey and did not know a lot of the things on the survey, but on the post survey, I knew what everything was. To conclude, this course was challenging, but I think it is mandatory for people to take especially if they are going into the business field because this course teaches you essential skills that students can build on in the future.   

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.

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.