The Google Digital Marketing and E-commerce Professional Certificate Program offered by Coursera is meant to teach students to work together with stakeholders. Through this course, you will learn to anticipate the needs of stakeholders, explain the progress and results of campaigns to them, and analyze and prepare metrics and insights for their viewing.
The program also includes capturing and presenting visualizations that will provide succinct summaries of insights to stakeholders. You will have that opportunity by presenting a set of practice insights during the course. When completed, be ready to share metrics and insights in professional environments with confidence.
Learning Objectives:
- Identify stakeholder information needs and the appropriate measures to meet those needs.
- Prepare datasets for sharing using sorting, filtering, and pivot tables following spreadsheet features.
- Create charts in spreadsheets to visualize metrics.
- Develop presentations and reports to update stakeholders on campaign progress, successes, and key insights.
TEST YOUR KNOWLEDGE: STAKEHOLDER NEEDS AND COMMUNICATION STRATEGIES
1. What is a stakeholder?
- Someone who creates content for different social media platforms to drive engagement and promote a business or product
- Someone with an interest in or a concern for a project and its results (Correct)
- Someone who coordinates marketing activities and initiatives, identifies target audiences through research, runs campaigns, and evaluates trends
- Someone who collects data, queries databases, applies statistical methods to data, and creates data visualizations.
Correct: A stakeholder can be defined as any person or group of persons with an interest or concern in a project and the outcomes from that project. Such a person is often seen as a marketer or specialist for social media where the person writes across several social media platforms to engage clients and promote an organization or a product.
2. Which of the following are important to understand when working with stakeholders on a project? Select all that apply.
- How to communicate with stakeholders (Correct)
- Stakeholder needs (Correct)
- Stakeholder hobbies
- When to inform stakeholders (Correct)
Correct: Understanding the needs of the stakeholder and determining when to inform them and how to do so are essential considerations in stakeholder outreach.
3. What is the relationship between internal stakeholders and external stakeholders?
- Internal stakeholders are people from the same company but outside of your team who support a marketing project or campaign, or benefit from its results. External stakeholders normally result from partnerships, such as when a company partners with an external ad agency for a campaign. (Correct)
- Internal stakeholders are people who have contractual agreements and limitations to working on aproject. External stakeholders work on the marketing team and are the closest stakeholders on a day-to-day basis.
- Internal stakeholders are people who fund a project and are in charge of the financial aspects of amarketing campaign. External stakeholders are members of a marketing team who are interested inbeing involved in the project.
- Internal stakeholders normally result from partnerships, such as when a company partners with anexternal ad agency for a campaign. External stakeholders are people outside your team who support a marketing project or campaign, or benefit from its results.
Correct: Internal stakeholders are individuals who lie within the same company as you but are not on your team and who support a marketing-related project or campaign or derive benefits from that project or campaign. Usually, external stakeholders would be someone like your partner, an external advertising agency that is joining you for a campaign or driving one jointly.
4. What is a stakeholder map used for?
- A stakeholder map is used to keep track of the interests and hobbies of the various stakeholders involved in a project.
- A stakeholder map is used to keep track of the possible stakeholders a company wants to bring on to a project in the coming year.
- A stakeholder map is used to keep track of all the addresses of stakeholders involved in a project.
- A stakeholder map is used to keep track of the influence and needs of stakeholders and the level of communication required to work with them. (Correct)
Correct: A stakeholder map is the tool that helps track the influence and needs of stakeholders and the amount of communication needed with them for effective collaboration.
5. Which of the following can help establish a high level of trust with stakeholders? Select all that apply.
- Self-orientation
- Credibility (Correct)
- Reliability (Correct)
- Detachment
Correct: To establish a considerable level of acceptance by stakeholders, demonstrating that one is reliable-which means always doing and following through all commitments and actions-is essential.
6. In business, what is a stakeholder?
- Someone who hires employees to work on a campaign
- Someone in charge of social media platforms for the company
- Someone with an interest in or a concern for a project and its results (Correct)
- Someone who analyzes data from a project
Correct: Stakeholder in business, according to most jurisdictions, refers to a person or group who has an interest in or worry about a project and its outcomes.
TEST YOUR KNOWLEDGE: SPREADSHEET FEATURES
1. Which of the following are reasons to sort data in a spreadsheet? Select all that apply.
- To organize and prepare data to share with others (Correct)
- To uncover new patterns and relationships within datasets (Correct)
- To compare current data with data from previous campaigns (Correct)
- To calculate average session duration
Correct: Organizing information and sharing it, discovering patterns and relationships within datasets, and comparing current data with that from previous campaigns may involve sorting data in a spreadsheet.
2. Fill in the blank: _____ calculates how long users spent interacting with a site before leaving.
- A pivot table
- Number of units sold
- Average session duration (Correct)
- A spreadsheet
Correct: Average session duration accounts the process and time a user spends extensively before abandoning a site and can be measured using techniques in spreadsheet environments like Google Sheets or Microsoft Excel.
3. Which of the following happens to data when it is filtered in a column? Select all that apply.
- Some matching data is hidden
- Only the data that meets a certain condition is displayed (Correct)
- All data is displayed
- All non-matching data becomes hidden (Correct)
Correct: A filtered column shows only the data above a certain condition and hides everything else.
4. What spreadsheet tool changes the view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?
- A commerce table
- A marketing table
- A pivot table (Correct)
- A digital table
Correct: A pivot table helps you reorganize your data in a spreadsheet into different views that allow you to classify them or find meaningful insights and trends. It does not change the original data in the spreadsheet at all.
5. Imagine that you need to work with a large dataset. Instead of manually counting instances, what function can you use to return the number of non-blank cells in a range?
- Average
- COUNTA (Correct)
- SumIF
- SUM
Correct: Instead of manually counting every occurrence for large datasets, one can use COUNTA, which returns the count of cells in a range that are not blank.
6. L’Acier wants to run their one-time discount ads during the time period with the most conversions. You can find this information by sorting the data in the Conversions column. Which day and time had the most conversions?
- Wednesday at 10:00 (Correct)
- Thursday at 10:00
- Wednesday at 13:00
- Tuesday at 2:00
7. L’Acier wants to understand how many days and times had over 1,000 conversions. You can find this information by filtering the data for greater than 1,000 conversions and counting the rows. How many rows had over 1,000 conversions?
- 18
- 6
- 20
- 8 (Correct)
Correct: Filtering out those that had more than 1,000 leads shows that only less than 20 days and times are more than 1,000 conversions.
8. L’Acier wants to know the three days and times during the weekend that had the highest conversion rate. You can find this information by filtering by Saturday and Sunday and then sorting by conversion rate. Which days and times on Saturday and Sunday had the highest conversion rate? Select three.
- Sunday at 23:00 (Correct)
- Saturday at 00:00 (Correct)
- Sunday at 22:00 (Correct)
- Sunday at 19:00
Correct: It was already known that there was a conversion of 13.43% on Sunday at 22:00 making it one of the highly converted three days and times.
9. L’Acier wants to know which day and time had the most users during midday—from 10:00 to 14:00. You can find this information by filtering the hour of day by 10:00 to 13:00 (do not include 14:00) and then sorting by users. Which day and time had the highest number of users between 10:00 and 14:00?
- Friday at 11:00
- Wednesday at 11:00 (Correct)
- Thursday at 10:00
- Wednesday at 10:00
Correct: Wednesday, 11:00, saw a user count of 9,436, thus becoming the peak day-time hour with users at the hitherto capped time of 10:00-14:00.
TEST YOUR KNOWLEDGE: CHARTS IN SPREADSHEETS
1. Which of the following are basic visualizations found in spreadsheets? Select all that apply.
- Pivot charts
- Area charts (Correct)
- Histograms (Correct)
- Vertical column charts (Correct)
Correct: The most basic examples of visualizations in spreadsheets are vertical column charts, area charts, and histograms.
2. Which of the following tasks would a data analyst be responsible for? Select all that apply.
- Running marketing campaigns
- Applying statistical methods to data (Correct)
- Creating data visualizations (Correct)
- Collecting data (Correct)
Correct: A data analyst’s duty involves collecting data, using statistical techniques to carry out analysis through processes of deducing insights, and preparing data visualizations for communicating these insights.
3. On a marketing team, who arranges activities and initiatives, identifies target audiences through research, runs campaigns, and evaluates trends?
- Stakeholders
- Marketing coordinators (Correct)
- Sales managers
- Customers
Correct: A marketing coordinator within a marketing team organizes events and activities, does target audience research, runs campaigns, and analyzes trends with the aim of improving marketing efforts.
4. Fill in the blank: _____ is used to communicate with databases developed by different vendors and hosted on multiple platforms.
- Sorting
- Structured query language (Correct)
- Tableau
- Filtering
Correct: Structured Query Language (SQL) is what is used to communicate with the databases from various vendors over different platforms for retrieval, manipulation, and management of data.
5. Which tool tracks, analyzes, and displays KPIs, metrics, and insights dynamically based on interactive user criteria?
- Dashboard (Correct)
- Pie chart
- Vertical column chart
- Histogram
Correct: Dashboard is a tool for tracking, analyzing, and dynamically displaying key performance indicators, various metrics, and insightful data including user-defined criteria for customizing the displayed information.
6. What are the three basic parts of a pivot table?
- Documents, spreadsheets, and files
- Slides, decks, and presentations
- Rows, columns, and values (Correct)
- Charts, tables, and graphs
Correct: There are three major parts in a pivot table, which are rows, columns, and values. The selected values from the data appear as horizontal in rows and vertical in columns. Values are used for computation or counting of the repeating data.
7. What visualization is useful for showing how a metric changes over an extended period of time?
- Vertical column chart
- Line chart (Correct)
- Horizontal bar chart
- Stacked column chart
Correct: A line graph is beneficial to portray variation in attitude over a longer time and to recognize areas of trends and patterns.
TEST YOUR KNOWLEDGE: BEST PRACTICES TO PRESENT DATA
1. When creating a presentation, what data should you include?
- The most minimal amount of data collected from the campaign
- The full range of metrics that may or may not lead to insights
- The raw data that you collected before conducting analysis
- The most relevant metrics that led to your insights (Correct)
Correct: This is one presentation which should only contain relevant and essential metrics which, by turning into insights, will contribute to shaping the clearest and most succinct understanding thereof.
2. Which of the following are best practices when creating slides for a presentation? Select all that apply.
- End with a call to action (Correct)
- Allow minimal time for questions
- Progress from general to specific topics (Correct)
- Introduce visualizations with insightful titles (Correct)
Correct: A slide presentation should move from broad to narrow topics, introduce impressive visualizations with thought-provoking titles, and end with a clear call to action, directing the audience to the next steps.
3. Which of the following are benefits to communicating insights at the beginning of a presentation? Select all that apply.
- Gain audience attention right away (Correct)
- Provide necessary information to people who leave before the end of the presentation (Correct)
- Keep audience attention when presenting data and metrics that support insights (Correct)
- Learn additional insights from audience members
Correct: If there is in the early stages of a presentation communicating what insight is to be gained, it secures attention by laying the groundwork for later data and metrics presentations. Another benefit is that if some audience members must leave early, they will have already been exposed to the main points.
4. Which of the following describes the proportion of ink (or pixels in digital content) that is used to present actual data compared to the total amount of ink (or pixels) used in the entire visualization?
- Data-ink ratio (Correct)
- Visual comparison ratio
- Presentation ratio
- Proportion-amount ratio
Correct: The data-ink ratio is defined as the amount of ink (or pixels in a digital picture) used to portray the actual data as a proportion of all ink (or pixels) in that entire visualization. To maximize this ratio, then, distractions in the visualization should be minimized; for example, removing unnecessary lines, boxes around charts and legends, or effects like the shadows of text. Focusing on the data itself.
ASSESS FOR SUCCESS: MARKETING ANALYTICS AND MEASUREMENT WEEKLY CHALLENGE 4
1. Which of the following best describes a stakeholder?
- Someone who purchases products or services from a company
- Someone who analyzes marketing data
- Someone who strongly influences the success of a project or campaign through funding (Correct)
- Someone who sells products or services for a company
2. Which of the following might be reasons to create a stakeholder map? Select all that apply.
- To help people work effectively without having the process consume too much of their time or energy
- To allow for people to better manage stakeholders’ expectations and avoid information overload (Correct)
- To help coordinate marketing activities and initiatives and identify target audiences through research
- To make it easier to identify the type and amount of interaction needed to maintain each stakeholder (Correct)
3. Which of the following are spreadsheet features that support preparing data to be shared? Select all that apply.
- Sorting (Correct)
- Pivot tables (Correct)
- Acquiring
- Filtering (Correct)
4. What is the purpose of a pivot table?
- Pivot tables display individual measurements in a vertical column.
- Pivot tables display individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column.
- Pivot tables change the view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend. (Correct)
- Pivot tables display how a metric changes over an extended time connected with a continuous line.
5. Fill in the blank: Line charts, area charts, and pie charts are all examples of _____.
- Tableaus
- Visualizations (Correct)
- histograms
- inputs
6. Which of the following charts represents data in the same way as a line chart, but with the space under the line filled in to form a visual area?
- Pie chart
- Area chart (Correct)
- Horizontal bar chart
- Histogram
7. Fill in the blank: A _____ could blend a marketing coordinator and a data analyst role into a single marketing specialist role.
- stakeholder role
- new role
- traditional role
- hybrid role (Correct)
8. Which of the following would enable a data analyst to communicate with databases developed by different vendors and hosted on multiple platforms?
- Sorting
- Filtering
- Structured query language (Correct)
- Spreadsheets
9. Which of the following resources help marketers visualize data with custom reports and dashboards? Select all that apply.
- Google Sheets
- Microsoft Excel
- Tableau (Correct)
- Google Data Studio (Correct)
10. Which of the following are considered best practices when creating slides for a presentation? Select all that apply.
- Repeat the insights when presenting the relevant, supporting data (Correct)
- Introduce data visualizations using titles that relate back to the insights (Correct)
- Progress from specific to general topics
- Allow time for questions so the audience can reach the same conclusion (Correct)
11. Which of the following are reasons why stakeholders might be important to a project or campaign? Select all that apply.
- Stakeholders often fund projects or operate budgets for campaigns. (Correct)
- Stakeholders strongly influence the success of a project or campaign. (Correct)
- Stakeholders coordinate marketing activities and initiatives.
- Stakeholders often analyze the data from a campaign.
12. Which method keeps track of the influence and needs of stakeholders and the level of communication required to keep them informed?
- Pivot table
- Histogram
- Stakeholder map (Correct)
- Newsletter
13. Which of the following visualizations shows individual data points that have been categorized into ranges, with the frequency of each range represented by the height of a unique column?
- spreadsheet
- pivot table
- pie chart
- histogram (Correct)
14. On a marketing team, who is responsible for running campaigns, identifying target audiences through research, and evaluating trends?
- Marketing coordinator (Correct)
- Customer service agent
- Stakeholder
- Sales manager
15. A marketer is creating a presentation using marketing analytics data. How can they use data to lead their audience to agree with their final conclusion? Select all that apply.
- Include the most relevant metrics that led to their insights (Correct)
- Develop a clear outline or flow for their presentation (Correct)
- Include all the data collected about the topic of their presentation
- Omit most of the data collected and put together a short presentation
16. Which of the following are important to understand when interacting with a stakeholder about a project? Select all that apply.
- Which communication methods a stakeholder prefers (Correct)
- What the stakeholder thinks about project team members on the project
- The stakeholder’s interest in the project and what their needs are (Correct)
- When to communicate with a stakeholder (Correct)
17. Which of the following describes the relationship between stakeholders and marketing coordinators?
- Marketing coordinators fund projects and ensure a project’s success. Stakeholders keep the marketing coordinator informed about a project’s progress, ongoing metrics, and insights.
- Stakeholders collect data, apply statistical methods, and create data visualization. Marketing coordinators identify target audiences through research, run campaigns, and evaluate trends.
- Marketing coordinators collect data, apply statistical methods, and create data visualization. Stakeholders identify target audiences through research, run campaigns, and evaluate trends.
- Stakeholders fund projects and ensure a project’s success. Marketing coordinators keep stakeholders informed about a project’s progress, ongoing metrics, and insights. (Correct)
18. A marketer is working with a spreadsheet. What can they do to uncover new patterns and relationships within datasets that they might miss otherwise?
- Copy data
- Input data
- Sort data (Correct)
- Acquire data
19. Which of the following changes your view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?
- Spreadsheet
- Area table
- Pivot table (Correct)
- Histogram
20. Which of the following is an example of a way a pie chart can be used to represent data?
- Represent individual data points for a changing variable connected with a continuous line
- Represent percentages of data in sections, all adding up to one hundred percent (Correct)
- Represent a large spike in new users with a horizontal bar
- Represent individual data points categorized into ranges, with the frequency of each range represented by the height of a unique column
21. A marketing team member queries databases, applies statistical methods to data, and creates data visualizations. What role does this describe?
- Stakeholder
- Office manager
- Data analyst (Correct)
- Copywriter
22. Imagine a marketer is working on a campaign and wants to request a change to the budget. Which of the following presentation best practices should they use to get this change approved by stakeholders? Select all that apply.
- Do not allow any time for questions
- Start with a general status of the campaign and then move on to the specifics of making a change to the budget (CORRECT)
- Create visualizations of the data using titles that relate back to the insights (CORRECT)
- End the presentation with changing the budget as a call to action for stakeholders (CORRECT)
Correct: Correct
Correct: Correct
Correct: Correct
23. Imagine that a marketer is working with a dataset in a spreadsheet. They want to view the data from a new perspective to help them categorize it and identify insights or trends. What spreadsheet tool should they use?
- Data visualization
- Values
- Pivot table (CORRECT)
- Columns
Correct: Correct
24. Which of the following tasks would a marketing coordinator be responsible for? Select all that apply.
- Applying statistical methods to data
- Identifying target audiences through research (CORRECT)
- Running campaigns (CORRECT)
- Evaluating trends (CORRECT)
Correct: Correct
Correct: Correct
Correct: Correct
25. Which of the following is a visual analytics platform that makes it easier to explore and manage data, and to create custom dashboards that incorporate different data visualizations in one place?
- Google Sheets
- Tableau (CORRECT)
- Microsoft Office
- PowerPoint
Correct: Correct
26. Which of the following visualizations includes individual data points for a changing variable connected by a continuous line?
- line chart (CORRECT)
- single column chart
- vertical bar chart
- pie chart
Correct: Correct
27. On a marketing team, who is responsible for running database queries, applying statistical methods to data, and creating data visualizations?
- Human resources representative
- Data analyst (CORRECT)
- Accountant
- Customer service agent
Correct: Correct
28. Which of the following best describes a stakeholder?
- Someone who sells products or services for a company
- Someone who strongly influences the success of a project or campaign through funding (CORRECT)
- Someone who analyzes marketing data
- Someone who purchases products or services from a company
29. How do marketers and stakeholders work together?
- 24. How do marketers and stakeholders work together?
- Marketers access data to create campaigns. Stakeholders advise on creative assets.
- Stakeholders have access to data that marketers do not. Marketers receive data from stakeholders to create campaigns.
- Marketers summarize campaign data and inform stakeholders of a campaign’s progress. Stakeholders fund campaigns and have an interest in their success. (CORRECT)
- Stakeholders set goals and KPIs for a campaign. Marketers fund campaigns to reach the goals.
30. Why would a marketer sort data in a spreadsheet?
- It helps them automatically remove irrelevant data.
- It helps them find new patterns and relationships within data sets. (CORRECT)
- It helps them display data that match specific criteria.
- It helps them present campaign data with visualizations.
31. What are the three main fields used to categorize data in a pivot table?
- Function, Name, Menu
- Rows, Columns, Values (CORRECT)
- Display, Columns, Filter
- Filter, Units, Rows
32. Fill in the blank: A benefit of _____ is that you can easily copy and paste them into slides when you need to share data insights with others.
- spreadsheet charts (CORRECT)
- vertical columns
- campaign assets
- marketing plans
33. Which of the following guidelines should a marketer follow when working with stakeholders in a marketing campaign?
- Understand why the stakeholder is interested in the campaign (CORRECT)
- Identify which team members the stakeholder has worked with before
- Provide limited information to the stakeholder to manage their expectations
- Create a map to understand previous campaign stakeholders
34. A marketer determines what type of interaction each stakeholder requires from them during a campaign. What visual assistance helps them gather this information?
- Provide clear and concise explanations of concepts and processes. (CORRECT)
- Provide documentation in a paper-based format.
- Write documentation in a way that reduces confusion. (CORRECT)
- Write documentation using technical language.
35. A marketer uses a chart to compare two variables side-by-side. The chart displays each variable as a bar. What type of chart did the marketer create?
- Pivot chart
- Histogram
- Vertical column chart (CORRECT)
- Line chart
36. Which of the following is an example of a way a pie chart can be used to represent data?
- Represent individual data points for a changing variable connected with a continuous line
- Represent individual data points categorized into ranges, with the frequency of each range represented by the height of a unique column
- Represent a large spike in new users with a horizontal bar
- Represent percentages of data in sections, all adding up to one hundred percent (CORRECT)
37. A business hires someone to analyze data and create and monitor marketing campaigns. What is this role known as?
- Data specialist role
- Marketing coordinator role
- Hybrid role (CORRECT)
- Data analyst
38. An e-commerce business hires someone to organize its marketing activities and initiatives. Who is typically responsible for these tasks?
- To analyze data and create visualizations for statistical calculations
- To communicate with databases developed by different vendors on multiple platforms
- To track, analyze, and display KPIs, metrics, and real-time data in a centralized view (CORRECT)
- To create and manage large data sets and analyze custom data visualizations
39. Why would a marketer create a data dashboard?
- Managerial (CORRECT)
- Operational (CORRECT)
- Privacy
- Technical (CORRECT)
Security measures could be listed into three approaches, namely; technical, operational, and managerial. Under technical controls would be those that rely on technology as a means of securing assets. In operational controls, one would find procedures that are designed to make sure an environment is secure by daily practices. Managerial controls cover how technical and operational measures will work together to mitigate risk.
40. A marketer uses a graph to show how a metric changes over an extended period. The chart displays a connected series of data points. What type of chart did the marketer create?
- Vertical column chart
- Horizontal bar chart
- Histogram
- Line chart (CORRECT)
41. When would you use a horizontal bar chart instead of a vertical column chart?
- To compare how one metric changes over time in a single column
- To compare two metrics side-by-side in a column
- To compare measurements with a significant difference (CORRECT)
- To compare how a metric or variable changes
42. What programming language allows you to access large databases for analysis?
- SQL (CORRECT)
- Data Studio
- Tableau
- Search console
43. Which three steps should you follow when creating an effective presentation using marketing analytics?
- Learn about stakeholders, include all campaign data in the presentation, and use an interactive template
- Introduce data visualizations, include all campaign data, and share insights at the end of the presentation
- Develop a clear outline of the presentation, choose the correct data, and include the most relevant metrics (CORRECT)
- Find an interactive template, gather insights from previous campaigns, and include all metrics
44. What role do stakeholders typically play in a campaign?
- Stakeholders approve the creative used in a campaign.
- Stakeholders track and analyze data about a campaign’s success.
- Stakeholders fund a project or manage a campaign budget. (CORRECT)
- Stakeholders create campaigns and related social media efforts.
45. Why would a marketer create a stakeholder map?
- General Data Protection Regulation (GDPR)
- Digital certificates (CORRECT)
- Platform as a service (PaaS)
- Encryption algorithms (CORRECT)
PKI enlists the usage of encryption algorithms and digital certificates to ensure a safe and secure exchange of information over the web. To begin with, the use of asymmetric and symmetric algorithms gets a specification for the efficient and secured encryption of the data. Finally, the digital certificates are used to establish a trust relationship between the parties while exchanging secured data.
46. What feature can a marketer use to hide data in a pivot table?
- Columns
- Filter (CORRECT)
- Sort
- Values
47. When would a marketing team use Tableau?
- To track, analyze, and display KPIs, metrics, and insights in a centralized view
- To access and manage large databases, gather insights, and create visualizations (CORRECT)
- To create KPIs and metrics for a real-time interactive dashboard
- To learn coding or programming skills to create interactive visualizations
48. A marketer is working with a spreadsheet. What can they do to display only data that meets a certain condition and hide all non-matching data?
- Delete the data that does not match
- Sort the data in ascending order
- Copy and paste the data
- Filter the data in a column (CORRECT)
49. How is an area chart different from a line chart?
- The space under the line is shaded in with colors or textures. (CORRECT)
- Area charts can only be single or stacked.
- Area charts can show data with partial and whole results.
- The changing variable connects on a continuous line.
50. Why would an e-commerce business hire a marketing coordinator?
- To design visual assets for campaigns, print ads, and create websites
- To manage the company’s social media accounts
- To collect data, query databases, and create data visualizations
- To identify target audiences, create campaigns, and evaluate trends (CORRECT)
51. An e-commerce business hires someone to collect and analyze data as well as create visualizations. What role does this describe?
- Marketing coordinator
- Data analyst (CORRECT)
- Graphic designer
- Project manager
52. A data analyst uses visual analytics software to analyze data and create unique dashboards and visualizations. What software does this refer to?
- Python
- SQL
- R
- Tableau (CORRECT)
53. Which of the following is a best practice when creating slides for a presentation?
- Use generic titles for data visualizations (CORRECT)
- Include all data you collected
- End the presentation with the most surprising insight
- Progress from general to specific topics
54. A marketer shares campaign insights with a director because the director funds the campaign and plans to make decisions based on its results. What is likely the director’s role in the campaign?
- Marketer
- Data analyst
- Stakeholder (CORRECT)
- Campaign advisor
55. In which of the following scenarios would a horizontal bar chart be most useful?
- To save space because there is a large difference between the measurements being compared (CORRECT)
- To show data points categorized into ranges, with the frequency represented by the height of a unique column
- To show how a metric changes over an extended period of time
- To show data that has partial and whole results
56. A marketing team member queries databases, applies statistical methods to data, and creates data visualizations. What role does this describe?
- Copywriter
- Stakeholder
- Data analyst (CORRECT)
- Office manager
57. A marketer is working with a spreadsheet. What can they do to uncover new patterns and relationships within datasets that they might miss otherwise?
- Copy data
- Sort data (CORRECT)
- Acquire data
- Input data
58. Which of the following changes your view of data in a spreadsheet to a different perspective to categorize it, or to identify an insight or trend?
- Pivot table (CORRECT)
- Histogram
- Area table
- Spreadsheet
And by this course, it makes you able to work effectively with stakeholders on anticipatory needs and articulate campaign progress or results. You have also learned about analyzing, filtering, and preparing metrics and insights for sharing with them.
Also learn how to create visualizations, presentations, and dashboards that summarize insights in a straightforward manner to stakeholders. Towards the end of this course, you would use this understanding by presenting a set of practice insights to stakeholders. Enroll in Coursera today to enhance your skills and take the next step in your professional journey!