Category: Data Analytics

I need someone to edit the slides and manuscript. The presentation supposed to be 3-4 minutes long for each person and my part is deliverable 3. I already have slides and manuscript, but It’s too long, so I need it to be shorten,and also on manuscript I need slides page number so that I know when to switch slides. For the slides I need graph or table, so that it visually better for audience. (doesn’t have to be all slides are graph or table)
Please go over the instructions first and again my part is deliverable 3.

Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.
Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.
Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.
Requirements: Follow each and everything mentioned in the description.

Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.
Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.
Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.
Requirements: Follow each and everything mentioned in the description.

Assignment-4 Program Logic Design
Instructions:
Design a Program Logic for the Picnics ‘R Us case [Refer to ‘Assignment#1’; ‘Assignment#2’;
and ‘Assignment#3’ on Canvas, under “Assignments”]
Guidelines:
A program logic model sets out the resources and activities that comprise the program,
and the changes that are expected to result from them. It visually represents the
relationships between the program inputs, goals and activities, its operational and
organizational resources, the techniques and practices, and the expected outputs and
effects. The purpose of a logic model is to show how a program works and to draw out
the relationships between resources, activities and outcomes. A program logic is a
critical element in program planning and evaluation because it sets out a graphic and
easily understandable relationship between program activities and the intended
outcomes of the program.
Example program logic template with guidance:
Example of a completed program logic:
Hints:
It makes sense when planning and thinking through a program to begin with the problem
statement and then work backwards from your long-term outcomes. Once you have the
major elements in place, consider the assumptions and external factors as a way to
identify potential risks that may prevent you from achieving your outcomes.
Rubric:
Developing your problem statement is the first step in program logic design – as it will establish
the issue that your program is trying to address. Your problem statement should be both
targeted and specific. It brings out the problem that is ‘solved’ by your ‘system’ goal(s).
Things to consider are:
1) What is the problem? [30%]
2) What are the causes of the problem? What are the causes of these causes? [20%]
3) Who is impacted by this problem? [15%]
4) Who is involved in this problem? Who else is working on it and who cares if it is solved?
[15%]
5) What do we know about the problem from research, evidence and experience? [10%]
6)What do we know about the way the target group experiences this issue?[10%]

Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.

Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.

Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
• Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.

Smart E-Commerce Logistic Construction Model Based on Big-Data Analytics
This project proposes an innovative and reasonable supply chain construction model for e-commerce that enhances the power of big data analytics to optimize and amplify the efficiency of the logistics continuum. The primary objective involves thoroughly exploring how big data analytics can effectively amass, scrutinize, and extract vital insights from the wide variety of logistics-associated data within the e- commerce landscape. This encompasses diverse sources such as order records, inventory data, transportation logs, and traffic patterns. Ultimately, the project aims to create an intelligent logistics construction model, harnessing big data analytics capabilities. This includes the integration of data mining, machine learning, predictive analytics, and optimization algorithm
Use examples from real word
Use graphs,figures and tables
no methodology needed just explain in very simple words

I only need to do question 1. Only need to fill all the yellow cell and columns and grey cells and columns. Also, provide explain how you do it and what formula you used.

For my research there are some teachers comments for the methodology and analysis. those comments are at the last page of the report in red color letters. I want you to rectify those errors and rewrite methodology and analysis chapter. I have attached sample report given by teacher as well.
Analysis should do by STATA… you are free to change hypothesis used by me and do necessary changes.

Purpose
The purpose of this assignment is to help you relate current information about accounting information systems with the information presented in the text. A second purpose is to give you experience identifying good sources for this type of information and identifying information considered important by the accounting profession. Finally, this will also give you practice in using Generative AI and seeing both its benefits and its limitations. As a suggestion, you may want to start with the Journal of Accountancy: https://www.journalofaccountancy.com/topics/techno…. Try at least two more sources until you find one that you really like and could see yourself reading after graduation.
Task
List 2 other sources you looked at besides the Journal of Accountancy (provide links to the 2 sources if available)
Post a summary of the article, your assessment of why this topic is important, and a link to an article, and how it relates to a specific textbook chapter. Be sure to include the chapter title and your source in your post.
Select a Generative AI such as ChatGPT or Microsoft Copilot and use different prompts to achieve an article similar to the one you produced. Include the prompts that you tried and the one you settled on. You should try to achieve a similar structure (2 paragraphs) and length as your analysis.
Copy and paste the article (how to cite AI generated content): https://dal.ca.libguides.com/CitationStyleGuide/ci…. (Take the challenge and get the AI to provide its own content citation).
Discuss the differences between your work and the AI’s.
Finally, based on this experience, give some ways that you might incorporate AI in your future class/professional work.
What to turn in
Here is a sample framework for the assignment. This is not a required structure, merely a suggestion for incorporating all of the elements.
“I looked at several articles in the Journal of Accountancy using keywords such as information systems, computer technology, and automated control. I also looked at articles in [source 2] and [source 3]. Source 2 was targeted more so to academic researchers. Source 3 was similar to the Journal of Accountancy but its coverage of information systems was not accounting specific. In the end, I chose [article X] from the [Journal of Accountancy, source 2, or source 3; whichever you used]. This article covers [topic x] and is most closely related to [textbook chapter number and title].
One paragraph summary.
One paragraph analysis including why it topic is important to accounting and/or information systems professionals. (Including a citation that confirms your opinion would strengthen your case.)
“I used several prompts with [generative AI x] and eventually settled on the following prompt”
My prompt
“Overall, the AI did a good job of summarizing the topic” The key differences I noticed between my summary and the AI’s are…]” I think in the future, I might use AI to…”
Table of Contents (course textbook)
PART ONE: AIS and the Business
Chap 1. Accounting Information Systems and Firm Value
Chap 2. Accountants as Business Analysts
Chap 3. Data Modeling
Chap 4. Relational Databases and Enterprise Systems
PART TWO: Business Processes
Chap 5. Sales and Collections Business Process
Chap 6. Purchase and Payments Business Process
Chap 7. Conversion Business Process
Chap 8. Integrated Project
Chap 9. Reporting Processes and eXtensible Business Reporting Language (XBRL)
PART THREE: Data Analytics and Emerging Technologies in AIS
Chap 10. Data Analytics in Accounting: Concepts and the AMPS Model
Chap 11. Data Analytics in Accounting Information: Tools and Practice
Chap 12. Emerging Technologies: Blockchain and AI Automation
PART FOUR: AIS Development and Management
Chap 13 Accounting Information Systems and Internal Controls
Chap 14. Information Security and Computer Fraud
Chap 15. Monitoring and Auditing AIS
PART FIVE: Optional AIS Topics
Chap 16. The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology
Chap 17. Evaluating AIS Investments
Chap 18. The Systems Development Life Cycle and Project Management: Addressing the Challenges of Building AIS Systems
This assignment should not take more than 30 minutes to be completed.
PLEASE NOTE THAT IF THE ANSWER IS NOT SATISFACTORY, I WILL ISSUE A REFUND! THEREFORE I HIGHLY ADVISE YOU TO PUT ACTUAL EFFORT IN THE ASSIGNMENT.

For my research there are some teachers comments for the methodology and analysis. those comments are at the last page of the report in red color letters. I want you to rectify those errors and rewrite methodology and analysis chapter. I have attached sample report given by teacher as well.
Analysis should do by STATA… you are free to change hypothesis used by me and do necessary changes.