Name: Student Name Template Version 1.1 Module: 6 Max Pts: 10 Exercise 2 Parts: 1 Rubric: Standard VBA Objective: Import several lines of data from a text file. Create a summary array of unique words and count the frequency of each word Instructions and tips: Modify the sub you wrote for M6_Ex1 so that it can process multiple lines within a single text file. The end result will be a list of unique words in the Output sheet and the number of times each word was found in the file. See sample ---> Use the text file Ch13_Ex10B_SampleText.txt as your input. (Find on Blackboard.) See "Output" for an example but be sure your sub deletes any previous output. Ignore case so that "Director" = "director" Variables, significant starter code, and two functions are all ready included. You'll need to "fill in the blanks" in the code. Your code MUST go between comment lines that look like this: v======== some instruction ... your code goes below this line ^======== .....and above this line Because of punctuation and the possibility of special characters and extra spaces, the list of words created may not be "clean". Don't worry about that. For instance, you might see "director" and "director." show up as two different words. Feel free to try to handle it with your code but that is not required for this problem. in a single text file. mment lines that es, the list of job description the senior director of business intelligence and analytics will be leader in organization for reporting ad hoc performance within travelocity global organization. ensure that basic analytical needs (daily, weekly, monthly) are met while ensuring team is able to support deep dives into key metrics business. this role 1 1 26 1 3 9 4 1 28 9 3 3 3 8 7 4 5 1 1 7 5 1 2 1 58 5 5 1 6 3 1 1 1 5 1 1 1 3 4 1 7 3 2 1 1 2 2 1 2 3 Import Text a travelocity's businesses globally as well all functional units (product, marketing, business, finance, media, partner etc). responsibilities: responsible / dashboard framework execution understand different provided accurate encompass data sources available take measurement beyond click-stream including financial system record call centre consolidations develop world class supports both automated dive analysis work with 9 2 1 2 5 2 1 3 3 1 2 1 1 1 3 1 1 1 6 1 2 1 2 5 1 1 1 4 1 1 1 5 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 4 their models supported overall thought on measurement, they measuring function optimally site optimization product management roadmap positioned success future it long term big strategy, act champion high-impact high-visibility unique has strong blend following skill sets leadership managerial (marketing attribution analysis) processchange-management creative problem solving presentation communication desired skills & experience 2 1 1 1 1 3 1 2 1 1 1 1 1 2 1 1 1 1 1 1 1 1 2 1 2 1 1 1 1 1 2 1 1 1 1 2 2 1 1 1 2 1 1 2 1 2 2 1 3 1 3 bachelors degree or equivalent required 10+ yrs understanding tools how leveraged an track building successful ability establish influential relationships internally externally ability/interest working fast paced, dynamic environment multiple priorities simultaneously passion win; results oriented abilities think independently collaboratively excellent written verbal strategic proficient at change-management, solver 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 Job Description The Senior Director of Business Intelligence and Analytics will be the leader in the organization for reporting and ad hoc business performance within the Travelocity Global organization. The Director will ensure that the basic reporting and performance "analytical needs (daily, weekly, monthly) are met while ensuring" that the team is able to support deep dives into the key metrics of the business. This role is a global role and will be support Travelocity's businesses globally as well as all of the functional "units (product, marketing, business, finance, media, partner" "marketing, etc). " Key responsibilities: Responsible for reporting / dashboard framework and execution within the organization Understand and support the different reporting needs of the different business and functional units globally Ensure the metrics provided are accurate and encompass the different data sources available within the organization Take performance measurement / analytics beyond click-stream analytics including financial system of record and call centre consolidations Develop a world class analytical team that supports both the automated reporting and deep dive analysis Work with the different functional units to ensure that their data needs and models are supported in the overall analytical framework Be a thought leader in the organization on performance "measurement, work with team to ensure they are measuring their" business / function optimally Partner with the Director of Site Optimization and Analytics Product Management to ensure the analytics product roadmap is positioned for Travelocity's success in the future Understand and partner with IT on a long term Big Data "strategy, act as the champion of Big Data within the" organization This is a high-impact and high-visibility role for a unique leader that has a strong blend of the following skill sets leadership and managerial analytics and measurement performance measurement (marketing analytics / attribution analysis) process- and change-management analytical and creative problem solving presentation and communication Desired Skills & Experience Bachelors degree or equivalent required 10+ yrs experience in performance measurement / analytics Understanding of different analytical tools and how they are leveraged within an organization A track record in building successful performance measurement / analytics organization Ability to establish influential relationships internally and externally "Ability/interest in working in a fast paced, dynamic" environment on multiple priorities simultaneously Passion to win; results oriented Strong leadership and managerial experience and abilities Ability to think and act independently as well as collaboratively Excellent written and verbal presentation and communication skills Excellent analytical and strategic skills "Proficient at process- and change-management, problem" solver