Organize the information in 4 pages and upload your paper, including thorough ba

Organize the information in 4 pages and upload your paper, including thorough background information about the organization’s mission, vision, goals, history, strengths, weaknesses, opportunities, and threats. Include a conclusion with your proposed strategies to maximize strengths and opportunities, overcome weaknesses, and neutralize threats. Cite all your sources. This means historical sources for the organization, websites, and other reference sources used to compile the information, stakeholders, magazines, newspapers, and other materials. You may use a table to organize the strengths, weaknesses, opportunities, and threats of the organization and accompany it with a narrative explaining the table content and its context.

In Tableau, please complete all 5 sheets (charts) using the music store data, ex

In Tableau, please complete all 5 sheets (charts) using the music store data, export the images generated, and answer the questions. When you are done, please submit:
a) a Word file on Canvas with all the exported images from chart1 to chart5;
b) answer the questions with texts and numbers using Google Form link provided below. (I suggest you also paste your answers into this file as a copy of your record) Please pledge your honor code in your Word file by pasting this statement at the beginning of the file: “I confirm that I have generated all these charts in Tableau with my own work.”
////////////////////////////////////////////
Learning objectives: Getting familiar with how to use Tableau, and being able to read the Tableau charts correctly.
1. How would you describe this dataset to a manager? (a general question that one can ask to any dataset)
Answer the following questions with your Tableau charts. You should read the numbers or information from your tableau charts (submitted separately with a Tableau file). Note below are based on filtering all other regions out and keeping only “Europe” and “Asia”.
How many genres were captured? What is the most popular genre and its total sales? What is the second most popular one? (chart1)
Who is the most popular artist? What kind (genre) of music is the most popular among his/her songs? (chart2)
Which country has the highest music sales? What percentage of sales does this country take? (chart3)
How much revenue does India have? (chart4)
Which genre shows a clear declining trend over time? (chart5)
Please answer these questions using the following link, and submit your Word file with all the exported images on Canvas before the due day, 5pm:

Select a country of your choosing and write a 1,750 to 2,000-word paper describi

Select a country of your choosing and write a 1,750 to 2,000-word paper describing healthcare systems and healthcare delivery systems. Identify the healthcare challenges faced by the country you selected, recommend solutions and suggest a means of funding. Compare and contrast the healthcare system and population health of the country you selected with the United States.

MUST COMPLETE ALL 8 ASSIGNMENTS EACH ASSIGNMENT SHOULD HAVE ITS OWN FILE, YOU MU

MUST COMPLETE ALL 8 ASSIGNMENTS EACH ASSIGNMENT SHOULD HAVE ITS OWN FILE, YOU MUST TURN 8 FILES TOTAL. Buhi’s different marketing teams are competing for funding based on past performance. You must determine what efforts are the most effective, so the marketing budget can be allocated to the best performers. Your first job is to download and clean the web, sales, and search ad campaign data.
To clean the data properly, you must find and remove:
Outliers Impossible values Incorrect Values Be careful though. Each data file will require different data-cleaning transformations.
Once you’ve completed your transformations, you’ll need to answer questions for the Analytics Report.
You’ll also have to recommend marketing budget allocations for search ad campaigns.
Objectives
You’ve been given access to three Buhi files, containing multiple sets of data:
Web data
Sales data
Search ad campaign data
You can access these datasets and explore their contents by downloading the attached zip file containing the corresponding CSV files. Open the CSV files in Microsoft Excel or Google Sheets.
Your first task is to clean the data by finding and removing outliers, impossible values, and incorrect values.
*You can clean the data manually or use formulas and functions to speed up the process. Make sure to check the Guides tab inside the Help menu in the top right corner. If you need help using formulas, watch the Excel tutorial videos.
Let’s Review the Process
Download and Clean the Data
To clean the data properly, you must find and remove: Outliers
Impossible values
Incorrect values
Each dataset will require different data-cleaning transformations. You’ll come across different types of data in the web file than the sales file. Be sure to adjust your data-cleaning methods accordingly.
Upload Your Cleaned Files
Upload your cleaned file paying close attention to the existing data structures.
Answer Analytics Questions
You will answer a series of questions after you’ve cleaned each dataset. Then, you’ll come up with a new budget for search ad campaigns. This should be based on the calculated return on ad spend (ROAS).
Assignments Assignment 1: Landing Page – Conversions
Recent inconsistencies and errors in Buhi’s web data have made it hard to collect insightful information. You must clean the web data to move forward with your website analysis.
1 – Download Q1 Web Data
The web data contains the following data:
Conversions
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203 or state = Canada)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
3 – Upload Cleaned CSV Files
Accepted File Type(s): csv
File must contain 6 columns with the names: “ID”, “Landing Page”, “Date Range”, “Country”, “Ad Campaign Clicks”, “Converted Sales”
File must contain 390 rows (+- 10) .
Assignment 2 : Landing Page – Traffic
Recent inconsistencies and errors in Buhi’s web data have made it hard to collect insightful information. You must clean the web data to move forward with your website analysis.
1 – Download Q1 Web Data
The web data contains the following data:
Traffic
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203 or state = Canada)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
3 – Upload Cleaned CSV Files: Accepted File Type(s): csv
File must contain 7 columns with the names: “ID”, “Landing Page”, “Date”, “Country”, “Organic Visits”, “Referral Visits”, “Direct Visits”
File must contain 390 rows (+- 10) .
ASSIGNMENTS 3:
Sales – January
Recent inconsistencies and errors in Buhi’s Sales report have made it hard to collect insightful information. You must clean the January sales data to move forward with your Q1 sales analysis.
1 – Download January Sales Data
The Q1 sales data contains the following data:
January product sales
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203 or state = Canada)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
3 – Upload Cleaned CSV Files
Upload January Sales Data
Accepted File Type(s): csv
File must contain 8 columns with the names: “ID”, “Name”, “Shipping Address State”, “Product Purchased”, “Order Number”, “Date of Purchase”, “Quantity of Item purchased”, “Price paid per item”
File must contain 1000 rows (+- 20) .
ASSIGNMENT 4 Sales – February
Recent inconsistencies and errors in Buhi’s Sales report have made it hard to collect insightful information. You must clean the February sales data to move forward with your Q1 sales analysis.
1 – Download February Sales Data
The Q1 sales data contains the following data:
February product sales
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203 or state = Canada)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
3 – Upload Cleaned CSV Files
Upload February Sales Data
Accepted File Type(s): csv
File must contain 8 columns with the names: “ID”, “Name”, “Shipping Address State”, “Product Purchased”, “Order Number”, “Date of Purchase”, “Quantity of Item purchased”, “Price paid per item”
File must contain 1000 rows (+- 20) .
ASSIGNMENT 5 Sales – March
Recent inconsistencies and errors in Buhi’s Sales report have made it hard to collect insightful information. You must clean the March sales data to move forward with your Q1 sales analysis.
1 – Download March Sales Data
The Q1 sales data contains the following data:
March product sales
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203 or state = Canada)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
3 – Upload Cleaned CSV Files
Upload March Sales Data
Accepted File Type(s): csv
File must contain 8 columns with the names: “ID”, “Name”, “Shipping Address State”, “Product Purchased”, “Order Number”, “Date of Purchase”, “Quantity of Item purchased”, “Price paid per item”
File must contain 1000 rows (+- 20) .
ASSIGNMENT 6 Search Ad Campaign
Recent inconsistencies and errors in Buhi’s search ad campaign data have made it hard to collect insightful information. You must clean the search ad campaign data to move forward with your analysis.
1 – Download Q1 Search Ad Campaign Data
The Q1 search ad campaign data contains the following data:
Weekly budget amount
Impressions
Clicks
Conversions
Revenue
2 – Perform Basic Data Transformations
Remove extreme outliers
Remove incorrect value formats (e.g., age = “twelve” instead of 12)
Remove impossible values (e.g., age = 203)
Remove any date outside of Q1 2019 (e.g., date = 07/21/2019)
3 – Upload Cleaned CSV File
Note: To remove outliers, impossible values, and incorrect values, clear the individual cells, NOT entire rows. After clearing a cell, simply leave it empty.
Upload Search Ad Campaign Data
Accepted File Type(s): csv
File must contain 10 columns with the names: “ID”, “Ad Campaign Name”, “Date”, “Budget allocated to campaign”, “Total impressions from the campaign”, “Total clicks”, “Total Cost”, “Total Conversions”, “Total Revenue”, “Cost Per Click”
File must contain 90 rows (+- 5) .
ASSIGNMENT 7 Analytics Report
Now that you’ve finished transforming the data, answer the questions below. Make sure to use the cleaned and transformed data for your calculations, rather than the original data files.
Analytics Questions – Basic Data Transformation
Answer the 10 questions below worth a total of 100 points.
In total, how many referral visits were there to all landing pages in Q1 2019?
Enter a whole number (ex. 1, 10, 100, 1000)
How many customers made their first purchase of the quarter in March?
Enter a whole number (ex. 1, 10, 100, 1000)
In total, how many organic visits were there to all landing pages in Q1 2019?
Enter a whole number (ex. 1, 10, 100, 1000)
Using total clicks and total sales by landing page for all of Q1 2019, which landing page had the highest conversion rate?
/backpack/medium/orange
/duffle/leather/blue
/bag/gym/black
/tote/canvas/white
How many items, in total, were purchased in the most recent month?
Enter a whole number (ex. 1, 10, 100, 1000)
Using total clicks and total conversions by campaign for all of Q1 2019, which search ad campaign had the highest conversion rate?
Duffle bags 20% off
Free shipping weekend
Womens bag clearance
New line of travel bags
Which search ad campaign had the highest total revenue in Q1 2019?
New line of travel bags
Backpack sale
Free shipping weekend
Womens bag clearance
Which search ad campaign had the highest total profits in Q1 2019? Your manager defines a search ad campaign’s profits as total revenue minus campaign cost.
Duffle bags 20% off
Free shipping weekend
Backpack sale
Womens bag clearance
Which search ad campaign had the highest total clicks in Q1 2019?
New line of travel bags
Free shipping weekend
Womens bag clearance
Backpack sale
Which search ad campaign had the highest return on ad spend (ROAS)? Your manager defines ROAS as a campaign’s revenue divided by its cost.
New line of travel bags
Free shipping weekend
Backpack sale
Womens bag clearance
ASSIGNMENT 8 Recommend Budget Allocation
Recommend marketing budget allocations for Buhi’s search ad campaigns based on your transformed data and the questions you answered.
Recommend Budget Allocations
Based on your decision, you will see a ROAS for next month’s search ad campaigns. If the data are perfectly cleaned and the budget is allocated wisely, you should see an optimal performance.
Use the boxes below to recommend budget allocations for the search ad campaigns. You must allocate the budget to at least two search ad campaigns. You can allocate a maximum of $5,000 to a single campaign.

This week, you will submit the final part of your Marketing Plan. Add this porti

This week, you will submit the final part of your Marketing Plan.
Add this portion of your marketing plan to the portion submitted last week, to complete your marketing plan (be sure to continue the formatting provided in the template). This section of your plan should be approximately 1-2 pages long with properly cited in-text citations.
Use these headings in bold font in your plan and cover the points beneath it.
Evaluating PerformanceThink back through the components of your marketing plan. How will you determine if your goals and objectives are being met? There are several metrics to choose from that can help shed light on whether or not your strategy is working. Discuss how you might use TWO metrics from each of the four following categories to evaluate if your plan is successful.
Measuring Digital and Social Media Effectiveness Reach metrics
Acquisition metrics
Engagement metrics
Conversion metrics
Retention Metrics
Financial Performance Metrics
Return on Marketing Investment
Revenue Analysis
Market Share Analysis
Profitability Analysis
Metrics for Evaluating Customer Relationship Management Share of Customer
Customer Equity
Customer Focus
Lifetime Value
Analytics for Auditing Social Responsibility
Qualitative analytics
Quantitative analytics

Organize the information in 4 pages and upload your paper, including thorough ba

Organize the information in 4 pages and upload your paper, including thorough background information about the organization’s mission, vision, goals, history, strengths, weaknesses, opportunities, and threats. Include a conclusion with your proposed strategies to maximize strengths and opportunities, overcome weaknesses, and neutralize threats. Cite all your sources. This means historical sources for the organization, websites, and other reference sources used to compile the information, stakeholders, magazines, newspapers, and other materials. You may use a table to organize the strengths, weaknesses, opportunities, and threats of the organization and accompany it with a narrative explaining the table content and its context.

Complete all 4 sheets (charts) using the fundraising data in Tableau (note this

Complete all 4 sheets (charts) using the fundraising data in Tableau (note this time I supply the twbx file so you don’t need to do the Excel connections to read in excel data – data are already in). When you are done with the charts, please: a) submit a Word file with all the exported images on Canvas (for chart3 please just take a screenshot) ; b) answer the questions with texts and numbers using Google Form link provided below.
Learning objectives: Be able to use some simple Tableau calculations, and be able to use the information in the charts in a flexible way to deliver marketing insights.
Please pledge your honor code in your Word file by pasting this statement at the beginning of the file: “I confirm that I have generated all these charts in Tableau myself, and have done my own work for the calculations.”
How would you describe this dataset to a manager? (a general question – explore data in Tableau)
Answer the following questions with your Tableau charts. For some of the questions you will need to do some extra work and calculation beyond the charts that you created with the step by step guide in the file.
Which Degree has the highest average pledge amount? Of how much? And the least average pledge amount? Of how much? Do you think ‘number of records’ is very informative here? Why or why not? (chart1)
What trends can you describe for fundraising effort of this university? Which fund type has the highest drop over the last 2 years? If you were to propose something to investigate further, what would that be? (chart2)
What percentage of funds were pledged by the “Major Gift Donors”? What percentage of funds were pledged by the top 20% of donors? [hint: you may use the information at the lower left corner of Tableau, and do some simple filtering and calculation to get the answers] (chart3)
What is the most popular fund type in the top 10 funds? How many of them are there in the top 10? What percentage of total pledge amount were captured in the top 10 funds? (chart4)
Please answer these questions using the following link, and submit the Word file with all the exported images on Canvas before the due day, 5pm:
https://docs.google.com/forms/d/e/1FAIpQLSd4DOy-P1ZuVvHKoZzuNDZgffwss4dlCrfTO0ZVcjyGIAM_kQ/viewform?usp=sf_linkLinks to an external site.
Grading Criteria:
Q1 is for practice, no points given.
a. Q2 and Q3 each are worth 20pts. Half for the chart and half for answers. 2×20 = 40pts.
b. Q4 and Q5 each are worth 30pts. (In each question, the chart is 10pts and the calculation part (and answers) are 20points.) 2×30 = 60pts.

Readings: Study this chapter in order to answer the questions below: Chapter Thr

Readings: Study this chapter in order to answer the questions below:
Chapter Three: Analyzing the Marketing Environment
Questions
1. Identify the five major generational groups and briefly describe their impact on today’s marketing strategies
2. How should marketers respond to unpredictable disruptions from the natural environment?
3. Briefly describe the consumer movement toward environmental sustainability. Provide two specific examples of brands that have responded to this trend.
For each question, use one external source to support your answer. Use APA formatting

So you have your eCommerce idea, you’ve built a Sitemap, you’ve reviewed what yo

So you have your eCommerce idea, you’ve built a Sitemap, you’ve reviewed what your main competitors are doing, you’ve looked at a ton of websites’ marketing programs and functionality, and you have your mood board in hand. I think you’re now ready to take a stab at designing your Homepage. Not to fret, this is your first draft and you’ll have opportunity to submit a Homepage version 2 in your Final Project. The Homepage is the most critical page of the entire website and contains many elements. Your Homepage design should also follow the aesthetic of your mood board and your sitemap should guide what your links are. Feel free to use the design platform of your choosing. Many like to use Adobe Photoshop, Illustrator and XD, and others have used PowerPoint and other simpler tools. There are also sites out there like Wix that allow you to mock-up for free. I just want to make sure to note that not all the elements I am looking for in this assignment will be available of these free sites.
Get inspiration from noteworthy sites and review your competitors if you’re having a tough time getting started. Look at how your favorite website homepage are structured. Don’t forget all the minor details.
You are allowed to “swipe” ideas from a few websites, but do not simply copy a template and imagery from another brand. You may use imagery from other websites, but I recommend you try using imagery from a variety of resources (free stock imagery, Adobe Spark, etc). Get as creative as you want (the world is your oyster in regards to functionality, widgets, marketing, content, etc), but always stay consistent to your brand image and make sure we know what you are selling and are trying to promote.
Your HP design should have at minimum the following –
Brand Name / LogoI recommend that your brand name/logo is aligned left or centered
NavigationThese are your shoppable categories across the top after your brand name
Search Bar, Login, Favorites, Shopping Cart Iconsalign right corner
Hero Banner(s)*This is the main image underneath your navigation
Additional Content*: Smaller Banners and Tiles w/ Images, Texts, and/or Video linking to category pages, special promotions, blogs, press mentions, etc
Social Media Icons
Email Sign-Up
Footer Menu (About Us, Customer Service, Blogs, Sustainability, Privacy Policy, etc)
Global HeaderThis is the bar across the top of your website that will have the latest news or a promotion
Minimum 1 Promotion Could be in Global Header, in email sign-up, or in one of your banners Example: Free Shipping on Orders over $XX, Buy One Get One offer, Additional 50% off Sale, Loyalty Program incentives, Shop Now, Pay Later, etc
*Note: all banners and images should have a call-to-action (SHOP NOW, LEARN MORE, etc) that potentially goes to another page of your website when you click on it.
Review these reference links to help guide your HP design:
https://sumofy.me/blog/2015/06/30/5-parts-of-a-website-and-their-design-trends-this-2015/
https://11web.com/parts-of-a-website/
https://blog.hubspot.com/marketing/elements-of-modern-web-design-list
https://www.orbitmedia.com/blog/what-to-put-on-your-homepage/