Search for question
Question

Memo 2 Assignment: Writing A Data Collection MEMO

Overview

In this assignment you are going to write a 2 page memo by filling out the various pieces. This

memo format is based on a common format I used when working in industry.

• The template for Memo 2: see attachment

• A general FAQ is available: see attachment

• Format: docx submission.

o This is an option in google docs download.

You will be writing a 2-page Memo. If you go over 2-pages it needs to be in the appendix and

referenced in the other text. This should never go over 5 pages!

The Scenario:

You are a Data Scientist working for a Tech Company. In this exercise you will design a data

collection plan for an A/B test (wikiLinks to an external site.) -- an A/B test is where you design

an experiment to compare two cases. You need to define the PROBLEM and whether you will

use log data (data collected by the APP, e.g. Facebook, Google Maps) or from the user (e.g. a

survey). (Remember - think carefully about the data needed for your proposed A/B test and how

you will acquire that data). See How to think about experiment (file is attached)

Fig: 1


Most Viewed Questions Of Business Intelligence

Assignment 1 - Ethics and Global Strategies in Bl Summer 2023 It must be submitted through the "Assignment 1 - Ethics and Global Strategies in BI" in Assignment Submission Folder provided in the D2L. It is important that you specify your name in the DOCX file. The attachment name should follow the following convention: BUSA532 ASSIGNMENT1 FIRSTNAME LASTNAME.DOCX BI Ethical Case: You are CIO of Facebook, and you want to buy data from Google as soon as possible. However, you don't know the origins of the data and how the data was collected from Google. What should you do? 1. Identity and discuss about the ethical dilemma that you faced (1 point). 2. Stakeholders are directly or indirectly affected by your decisions. Provide at least 3 specific stakeholders affected by the situation. (1 point) 3. Discuss the challenges in addressing the ethical dilemma by identifying at least 2 key issues and their subsequent implications/ramifications (1 point). 4. How would you have responded to the ethical dilemma? Apply at least two ethical models to brainstorm the questions you want to ask (1.5 points). 5. How would you implement solutions to respond to the ethical dilemma? Apply at least two ethical models to brainstorm the solutions (1.5 points). Global Strategy Case: You are CIO of Facebook, and you want to build online video rental service like Amazon Prime or Netflix in China. However, pirated movies are very common in China, and the government lacks regulations to protect intellectual property. What should you do? 1. Develop PEST analysis for Facebook to build the service in China (1.5 points). 2. Recommend at least three strategies for Facebook to build the service (1.5 points). SQL Server Installation: Please follow the instructions in D2L to install all three components of SQL Server (SSMS, SSIS and SSAS) and provide screenshots that you successfully install them (1 point). The following criteria will be used to grade the assignment: Answers are correct, and writing are polished. ********NOTE


Your Task In response to the following scenario, students will produce a one-page infographic and a 500-750 word supporting paper detailing what would be included in a staff professional development workshop entitled 'Developing Intercultural Competence'.


Discussion Question # 2: Noting the failure of Charlie's social networking platform to achieve its intended goals of sharing information and building a community of support, what should the researchers have done? Arguably, social networking is not central to the purpose of a diabetes health care system. Should they have simply dropped this functionality, or should they have adopted a stronger role in moderating these forums? What are the tradeoffs of each decision?


Discussion Question #1: From the outset, the research team was explicitly concerned about inequality in type 2 diabetes care and outcomes. Their aim was not just to improve to improve diabetes treatment in general, but to do so for all. How can they best achieve this? Might Technology different users sometimes require different treatment protocols? Does the research team have a responsibility to single out users who are not receiving the full benefit of Charlie's interventions for special attention and/or treatment?


Discuss some major issues in implementing business intelligence (BI) as well as the support that artificial intelligence (AI) can provide to business decision makers, including the benefits of automatic and autonomous decision making.


Question 11 Customer churn, also known as customer turnover, occurs when customers cease using the services provided by a company. The data set "Churn_ECA.xlsx" contains information about the telephone company's customers, including demographics, account details, subscribed services, and a binary indicator denoted as "Churn", which indicates whether a customer has left the service within the last month. The accompanying "Glossary" sheet provides descriptions of the variables used in the dataset. Question la Identify one (1) business question that can be addressed by analysing the data. Elaborate on the pertinent data fields and how they can provide insights to address the question. Construct an influence chart relevant to the issue. (Max word count: 150 words)/nQuestion 1b Prepare a tabular summary of the dataset, indicating the data type, key attributes, summary measures, and any relevant data issues, if present. (Max word count: 150 words) Question 1c Use visualization techniques to design a comprehensive dashboard comprising a minimum of three (3) professional graphical charts that convey valuable insights from the dataset. Attach a screenshot of each chart and the complete dashboard. Describe the process of chart and dashboard creation and how the dashboard effectively generates and communicates insights extracted from the data. (Maximum 250 words)


QUESTION 1 [25 marks] 1. Using the file BOC_Store_Database.xlsx, Desktop which can be published in Power BI Service. construct a Dashboard in Power BI Follow the tasks given below in compiling the Dashboard. a) Using the power query editor in Power BI desktop, clean the data and load it onto Power BI (1 mark). b) Construct a data model in Power BI using star schema architecture (2 marks). c) Using appropriate visualizations, create the Dashboard. The Dashboard should have the data filtering capability including slicing functions. To effectively design a Power BI Dashboard, it's important to focus on a specific area to ensure that the Dashboard serves its intended purpose. (15 marks). (Submit the Dashboard as a Power BI report file) 2. Interpret the visuals presented in the Dashboard (7 marks) (this can be done in a Word document).


Memo 2 Assignment: Writing A Data Collection MEMO Overview In this assignment you are going to write a 2 page memo by filling out the various pieces. This memo format is based on a common format I used when working in industry. • The template for Memo 2: see attachment • A general FAQ is available: see attachment • Format: docx submission. o This is an option in google docs download. You will be writing a 2-page Memo. If you go over 2-pages it needs to be in the appendix and referenced in the other text. This should never go over 5 pages! The Scenario: You are a Data Scientist working for a Tech Company. In this exercise you will design a data collection plan for an A/B test (wikiLinks to an external site.) -- an A/B test is where you design an experiment to compare two cases. You need to define the PROBLEM and whether you will use log data (data collected by the APP, e.g. Facebook, Google Maps) or from the user (e.g. a survey). (Remember - think carefully about the data needed for your proposed A/B test and how you will acquire that data). See How to think about experiment (file is attached)


Assignment Procedure Step 1: First Phenomena Observe one phenomen on for each of the following three categories using the examples above as a reference. Your phenomena should be different from these examples. Judd D. Bradbury Ⓒ 1. Science 2. Business 3. General Observation (neither science nor business) Data Visualization Page 7 Based on your observations answer the following questions for each of the 3 types of phenomena. (refer to the model examples above for answering the following questions) a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen./nc) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color encoded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created. Step 2: Second Phenomena a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen. c) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color encoded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created./nStep 3: Third Phenomena a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. Judd D. Bradbury Ⓒ Data Visualization Page 8 b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen. c) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color en coded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created. Step 4: Submission Submit your assignment documented in Microsoft Word in eLearning.


Develop a proposal for a business analytics solution to tackle the issue identified in Q1. It should include the discussion of at least two (2) appropriate business analytics techniques, such as spreadsheet analysis, clustering, association analysis, or predictive/prescriptive analytics. Explain how all stages of the business analytics process, except for business understanding, information search, and problem definition, are applied in this initiative.