Category: Information Technology

Case Study – Read and respond (2 page minimum) to the following article by answering their initial question – “Why should academics and practitioners be interested in understanding the impacts of big data?”. Identify what your organization can learn about the potential value as well as pitfalls of improperly leveraging big data. What types of data does your organization struggle with analyzing and how could big data technologies assist? In reviewing table A1 in the article, which value dimension might most apply to your organization and why? Which issue dimension?
Fosso Wamba, Akter, S., Edwards, A., Chopin, G., & Gnanzou, D. (2015). How “big data” can make big impact: Findings from a systematic review and a longitudinal case study. International Journal of Production Economics, 165, 234–246. https://doi.org/10.1016/j.ijpe.2014.12.031
Submission details
Two pages of written content, plus cover page, plus reference page = 4 pages minimum
APA format, double spaced.

1-For multipoint configuration, only one device at a time can transmit. Why and what is that terminology called. Explain in maximum 2 paragraphs and cite your work? (10 Point)
2- Cost-2-Cost is a famous radio show broadcast from Los Angeles, California. The broadcast use AM stereo at 1320 kHz by the time it reaches Maryland, Rockville WWDC-F2 (@101.1 kHz) Monday – to Saturday from 1AM to 6AM and Sunday off day. What is the antenna height required to capture the station wavelength. Explain your Answer and calculations in details Do Not give only the final answer or short explanation you will not get a grade. (10 points)
3- Hulu and YouTube offer regular TV broadcast, and Time Shift service for their customers. As promotion to encourage subscribers to the service providers. FXX movie channel broadcast a new 4K movie with Dolby Atmos for subscribers. Answer the following Questions and Explain your Answer and calculations in details Do Not give only the final answer or short explanation you will not get a grade. (20 points)
What is the required bandwidth to watch a 4K HDR10 12-Bit color movie stream? (10 points)
How much data is needed for the Time Shift of 1.5 hour and what is the compressed Value in? (10 points)

COMPETENCIES
4034.3.1 : Dimension, Quality, Relations, and Limitations
The graduate examines the data available for analysis to determine their dimension, quality, relations, and limitations.
4034.3.2 : Physical Data Models
The graduate implements physical data models.
4034.3.3 : Table Operations
The graduate performs table operations and queries within the context of data acquisition for analysis.
INTRODUCTION
A common undertaking for a data analyst is to connect an external data collection to an existing data set. This process involves the exploration of the source and target data sets to merge the new data in a meaningful and logical way.
You will replicate this common process in this task. You will take external data from a comma-separated values (CSV) file and design conceptual, logical, and physical models that describe the data. You will load the new data into an existing database alongside the existing data and run queries across it.
You will work on this performance assessment on the Labs on Demand website, which can be found in the Web Links section. The data sets, associated data dictionary, and CSV file are located at the Labs on Demand site.
REQUIREMENTS
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
Perform the following tasks to combine an existing data set with some external data:
A. Provide a question that can be answered using structured query language (SQL) to acquire data from both the original database and the add-on CSV file data. The question should require data from both data sources.
1. Identify which data from the original data set and the add-on CSV file are needed to answer the question including all tables, columns, and data types.
B. Create an entity relationship diagram (ERD) for the add-on CSV file and any other tables and columns used to answer the question from part A by evaluating the data contained in the file and identifying the m:n relationships and relational constraints.
1. Write SQL code, in text format, that creates a table based on the ERD and specifies the columns and relevant keys.
2. Write SQL code, in text format, that loads the data from one of the add-on CSV files into the table created in part B1.
Note: Do not include SQL code as a screenshot.
C. Write a SQL statement or statements in text format for a query or queries that answer the question from part A.
Note: Do not include SQL statements as a screenshot.
1. Provide a data file or files that capture the results from the query or queries.
D. Identify the specific time period for how often the add-on file should be acquired and refreshed in the database for the data to remain relevant to the business and the question from part A.
1. Explain why the time period identified in part D is relevant to the business needs.
E. Provide a Panopto video recording that includes the presenter and a vocalized demonstration showing all code used, the code being executed, and the results of all code used in the task.
1. Include a vocalized demonstration within the Panopto video recording provided in part E that describes the programs used to complete the task.
Note: For instructions on how to access and use Panopto, use the “Panopto How-To Videos” web link provided below. To access Panopto’s website, navigate to the web link titled “Panopto Access” and then choose to log in using the “WGU” option. If prompted, log in using your WGU student portal credentials, and then it will forward you to Panopto’s website.
To submit your recording, upload it to the Panopto drop box titled “Master of Science, Data Analytics TGM2 | D205 (Student Creators) [assignments].” Once the recording has been uploaded and processed in Panopto’s system, retrieve the URL of the recording from Panopto and copy and paste it into the Links option. Upload the remaining task requirements using the Attachments option.
F. Acknowledge web sources used to acquire data or segments of third-party code to support the application. Be sure the web sources are reliable.
Note: Submit web sources for part F separate from the sources in part G, or state none were used.
G. Acknowledge sources, using in-text citations and references, for content that is quoted, paraphrased, or summarized.
H. Demonstrate professional communication in the content and presentation of your submission.
File Restrictions
File name may contain only letters, numbers, spaces, and these symbols: ! – _ . * ‘ ( )
File size limit: 200 MB
File types allowed: doc, docx, rtf, xls, xlsx, ppt, pptx, odt, pdf, csv, txt, qt, mov, mpg, avi, mp3, wav, mp4, wma, flv, asf, mpeg, wmv, m4v, svg, tif, tiff, jpeg, jpg, gif, png, zip, rar, tar, 7z
RUBRIC
A:QUESTION
NOT EVIDENT
A question is not provided.
APPROACHING COMPETENCE
The question cannot be answered using SQL to acquire data from both the original database and the add-on CSV file data or does not require data from both the original database and the add-on CSV data, or the question is illogical.
COMPETENT
The question is logical and requires using SQL to acquire data from the original database and the add-on CSV file data.
A1:IDENTIFYING DATA
NOT EVIDENT
The submission does not identify which data from both the original data set and the created table from the CSV file are needed to answer the question.
APPROACHING COMPETENCE
The submission identifies which data from both the original data set and the created table from the CSV file are needed, but the identified data do not provide all the tables, columns, and data types needed to answer the question.
COMPETENT
The submission identifies which data from both the original data set and the created table from the CSV file are needed including all the tables, columns, and data types needed to answer the question.
B:ENTITY RELATIONSHIP DIAGRAM
NOT EVIDENT
An ERD for the database is not provided.
APPROACHING COMPETENCE
The ERD for the database does not identify m:n relationships and relational constraints.
COMPETENT
The ERD for the database that was created identifies m:n relationships and relational constraints.
B1:CODE FOR THE ERD
NOT EVIDENT
A SQL code is not provided.
APPROACHING COMPETENCE
The SQL code does not create a table based on the ERD, or it does not correctly specify columns and relevant keys, or it does not include the actual code in text format.
COMPETENT
The SQL code creates a table based on the ERD that specifies the columns and relevant keys and includes the actual code in text format.
B2:LOADING CSV DATA
NOT EVIDENT
SQL code that loads the data from one of the add-on CSV files into the table created in part B1 is not provided.
APPROACHING COMPETENCE
The SQL code does not correctly load the data from one of the add-on CSV files into the table created in part B1 or it does not include the actual code in text format.
COMPETENT
The SQL code correctly loads the data from one of the add-on CSV files into the table created in part B1 and includes the actual code in text format.
C:SQL QUERY
NOT EVIDENT
A SQL statement or statements for a query or queries that answer the question from part A is not provided.
APPROACHING COMPETENCE
The SQL statement or statements for a query or queries do not accurately answer the question from part A, or the SQL statement is not in text format.
COMPETENT
The SQL statement or statements for a query or queries accurately answer the question from part A, and the SQL statement is in text format.
C1:CSV FILES
NOT EVIDENT
The data file or files are not provided.
APPROACHING COMPETENCE
The data file or files do not contain accurate results from the query or queries.
COMPETENT
The data file or files contain accurate results from the query or queries.
D:ADD-ON FILE
NOT EVIDENT
The submission does not identify the specific time period for how often the add-on file should be acquired and refreshed in the database.
APPROACHING COMPETENCE
The submission does not accurately and logically identify the specific time period for how often the add-on file should be acquired and refreshed in the database for the data to remain relevant to the business and the question from part A.
COMPETENT
The submission accurately and logically identifies the specific time period for how often the add-on file should be acquired and refreshed in the database for the data to remain relevant to the business and the question from part A.
D1:EXPLANATION OF TIME PERIOD
NOT EVIDENT
The submission does not include an explanation of why the time period identified in part D is relevant to the business needs.
APPROACHING COMPETENCE
The submission does not accurately and logically explain why the time period identified in part D is relevant to the business needs.
COMPETENT
The submission accurately and logically explains why the time period identified in part D is relevant to the business needs.
E:PANOPTO VIDEO OF CODE
NOT EVIDENT
A Panopto video recording of the code used is not provided, or the link provided for the video is not functional.
APPROACHING COMPETENCE
The Panopto video recording is provided, but a full demonstration of the code used, the code being executed, or the results of the code used in the task is not provided, or the video does not capture both the presenter and the vocalized demonstration.
COMPETENT
The Panopto video recording includes a full demonstration of the code used, the code being executed, and the results of the code used in the task. For the duration of the presentation, the video captures both the presenter and the vocalized demonstration.
E1:PANOPTO VIDEO OF PROGRAMS
NOT EVIDENT
A Panopto video recording of the programs used is not provided.
APPROACHING COMPETENCE
The Panopto video recording is provided, but a complete description of the programs used to complete the task is not provided, or the video does not capture both the presenter and the vocalized presentation describing the programs used to complete the task.
COMPETENT
The Panopto video recording includes a complete description of the programs used to complete the task. For the duration of the presentation, the video captures both the presenter and the vocalized presentation describing the programs used to complete the task.
F:WEB SOURCES
NOT EVIDENT
A record of the web sources used to acquire data or segments of third-party code to support the application is not provided.
APPROACHING COMPETENCE
The record of the web sources used to acquire data or segments of third-party code to support the application is incomplete or inaccurate. Or the web sources cited are not reliable.
COMPETENT
The record of the web sources used to acquire data or segments of third-party code to support the application is both complete and accurate, and the web sources cited are reliable. Or the candidate stated that they did not use any web sources to acquire data or segments of third-party code.
G:SOURCES
NOT EVIDENT
The submission does not include both in-text citations and a reference list for sources that are quoted, paraphrased, or summarized.
APPROACHING COMPETENCE
The submission includes in-text citations for sources that are quoted, paraphrased, or summarized and a reference list; however, the citations or reference list is incomplete or inaccurate.
COMPETENT
The submission includes in-text citations for sources that are properly quoted, paraphrased, or summarized and a reference list that accurately identifies the author, date, title, and source location as available. Or the candidate stated that they did not use any sources to acquire data or segments of third-party code.
H:PROFESSIONAL COMMUNICATION
NOT EVIDENT
Content is unstructured, is disjointed, or contains pervasive errors in mechanics, usage, or grammar. Vocabulary or tone is unprofessional or distracts from the topic.
APPROACHING COMPETENCE
Content is poorly organized, is difficult to follow, or contains errors in mechanics, usage, or grammar that cause confusion. Terminology is misused or ineffective.
COMPETENT
Content reflects attention to detail, is organized, and focuses on the main ideas as prescribed in the task or chosen by the candidate. Terminology is pertinent, is used correctly, and effectively conveys the intended meaning. Mechanics, usage, and grammar promote accurate interpretation and understanding.
WEB LINKS
Churn Data & Medical Data/Dictionary Data Sets
Labs On Demand
Panopto Access
Sign in using the “WGU” option. If prompted, log in with your WGU student portal credentials, which should forward you to Panopto’s website. If you have any problems accessing Panopto, please contact Assessment Services at assessmentservices@wgu.edu. It may take up to two business days to receive your WGU Panopto recording permissions once you have begun the course.
Panopto How-To Videos
Panopto FAQs
Skillable Labs Knowledge Base Article
Please consult this WGU Knowledge Base article for general FAQs regarding your Skillable lab environment.

Please answer 1 Discussion Question and a paper, then write 2 peer reviews for the discussion question
DQ 1 :
Data is critical in making effective business decisions in today’s workplace. Provide an example of how data is used in your current workplace to make business decisions. If you are unaware of how data is used for this purpose, speak with your manager and ask how they use data to determine how their department or business is performing. Share the general concepts you learn in the discussion. Job: Team Lead
Work: Fashion Industry
Company: Zara
Write a paper (4 pages of content)
Information researched and evaluated during weeks 5 and 6 of this course introduced students to Management Information Systems (MIS) referred to as ERP and CRM. These systems rely on data to be collected and evaluated in order to inform business decisions and manage business operations. The purpose of MIS is to use technology as an enabler for businesses. One of the primary challenges businesses face, however, is that there are so many different systems, each of which provides different services and uses different data. For your paper, research and compare three different business analytics tools. Present a business case in which you determine the tools that are the best fit for the business. Justify your reasoning and selection criteria. You will present your case individually during the live class in Week 8. Your final paper needs to be at least 4-5 pages in length, adhering to APA formatting requirements, not including the cover and reference pages. —————————————————
Do these in order:
Please write a paper (4 pages of content), answer the Discussion Questions & write two peer reviews separately (½ page each)
– In correct APA format, write the citation.
– please submit the paper on time and make sure NO PLAGIARISM!!!

Internship Hardship Activities 23
Your application to meet graduation requirements by engaging in an alternative professional experience in lieu of an internship has been reviewed and approved. To be considered as a graduate having fulfilled the requirements, please complete the following workshops via slide decks and videos and then submit the corresponding assignments.
The Resume
The Resume Workshop
For this activity, once you have participated in the workshop by reviewing and working on your resume, please submit the following:
1.) Roughdraftofresume.
2.) Revised resume (be sure to include the program you have completed by
indicating your new degree.)
Navigating the Job Search
Get That Job!
This workshop has several slides with a series of questions and worksheets. Please submit:
3.) Answers to all the questions and submit a single document. Label each set of answers to correspond with the slide’s title or activity.
Elevator Pitch
Crafting Your Story
As you complete this workshop, please:
4.) Take all assessments
5.) Complete any questions and activities
6.) Write, revise, and submit your elevator pitch.
Personal Branding
Crafting & Designing Your Brand
For this workshop:
7.) Watch all videos and answer all questions and quizzes. Label each set of
answers to correspond with the slide’s title or activity.
8.) Write and submit your personal brand tagline
9.) Write and submit your mission statement
10.) Draft your Call to Action and revise your elevator pitch if needed. Join the
links below as we welcome you to your status as a Westcliff University Alumnus.
Westcliff University Alumni Association LinkedIn
https://nterstride.com/westcliff

ScenarioThe Corporation Techs’ current network consists of 1 web server (accessible by the public), 2 application servers, 2 database servers, 2 file and print servers, and 50 workstations. The web server runs Linux/Apache, the other servers run Microsoft Windows Server, and the workstations run Microsoft Windows. The network is connected through a series of switches, is not physically connected to other networks, and runs Internet Protocol version 4 (IPv4). The network is protected by a single border firewall. The senior network architect, whom you work for directly, has verified the company’s business goals and has determined the features and functions required to meet those goals.
The senior network architect has asked you to create a network design that includes the following components:
-Current infrastructure elements
-A logical topology that separates the Accounting and Sales departments
-Redundant communications
-Justification for continuing with IPv4 or upgrading to IPv6
TasksFor this part of the project, perform the following tasks:
1.Conduct research to determine the best network design to ensure security of internal access while retaining public website availability.
2.Design a network configuration with physical and logical topologies. Identify major network elements (e.g., servers, switches, gateways) and their locations within the private and protected network segments.
3.Include a high-level plan that ensures communications are available 24/7.
4.Recommend whether to continue using IPv4 or upgrade to IPv6, and explain why.
5.Create a basic network diagram that illustrates the current network and enhancements. Include a few workstations to represent all workstations on the internal network. The diagram will be very high level at this stage and include only necessary details. You may use a software tool or simply pencil and paper. You will update this design later in the project.
6.Create a draft report detailing all information as supportive documentation.
7.Cite sources, where appropriate.
Required ResourcesInternet access
Submission RequirementsFormat: Microsoft Word (or compatible)
Font: Arial, size 12, double-space
Citation style: Your school’s preferred style guide
Length of report: 3–4 pages
Self-Assessment ChecklistI determined the best network design to ensure the security of internal access while retaining public website availability.
I designed a network configuration with physical and logical topologies, and identified major network elements and their locations within the private and protected network segments.
I created a plan that ensures communications are available 24/7.
I recommended whether to continue using IPv4 or upgrade to IPv6, and explained why.
I created a basic network diagram that illustrates the current network and enhancements.
I created a professional, well-developed report with proper documentation, grammar, spelling, and punctuation.
I followed the submission guidelines.
***NO plagiarism***

I want to resolve this discussion and respond to it with two responses here for these two girls, each of which has an appropriate response to their solution.

I want to resolve this discussion and respond to it with two responses here for these two girls, each of which has an appropriate response to their solution.

please find the attached pdf for lecture material. and attached word document (assignment 1) for assignment instructions to complete the assignment.
and please find the youtube links to complete the assignment

just solve question 9 only.
the answer is yes but justify your answer and please don’t use advanced English words and make it simp