Category: Data Analytics

This assignment continues the case study analysis of Foxcore Retail that you wor

This assignment continues the case study analysis of Foxcore Retail that you worked on in Part 1. We have now covered some more data modeling concepts and are now ready to design a much more comprehensive data model. In this submission, you need to do the following.
Write a new report, once again with a cover page that must have your name, email id, course name, semester, and date of submission. The report should have the following sections.
DB Design Overview: (50 points)Write a summary of the key changes and improvements made from Part1. If you received some feedback in Part 1 and were asked to fix some issues, please point them out clearly in this section.
Write a description of the ER model, highlighting the key decisions taken and their reason when coming up with this design.
Point out the strong / weak entities, strong / weak relationships, and optional / mandatory participation
DB data model: Draw a fully developed ER model using Crow-foot notation. The following elements must be clearly shown: (75 points)Entities, their attributes, primary keys, foreign keys.
Relationships with cardinalities.
Entity super-type and sub-type where applicable with sub-type discrimination, disjoint/overlapping constraint, complete/partial constraint.
Conclusion and key take aways: Summarize your key learnings from this case study, and how could your design be further improved in future. (25 points)
Feedback of my submission Case Study 1, Part:1
‘Good job on identifying most of the improtant entities.
Data model should have ER diagram as covered in this week. ‘ I didn’t submit ER Diagram in part-1.

Page 4 of 4
INSTRUCTIONS
The textbook contains a series of case problems that h

Page 4 of 4
INSTRUCTIONS
The textbook contains a series of case problems that highlight situations that real organizations could encounter and are related to the weekly learning activities.At the end of Chapter 6, read Case Problem Forecasting Food and Beverage Sales or download Case Problem 3 – Forecasting Food and Beverage Sales.pdf
Data for the case – Vintage.xlsx

Instructions:Write a two-page APA report answering the questions below. Do not just answer the questions, but use the questions to formulate your report. Your paper should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to University’s Academic Integrity Policy.Questions to be answered in your report:Perform an analysis of the sales data for the Vintage Restaurant. Prepare a report for Karen that summarizes your finds, forecasts, and recommendations. Include the following in your report.A time series plot. Comment on the underlying pattern in the time series.
Using the dummy variable approach, forecast sales for January through December of the fourth year.
Requirements of the assignment:All papers must follow all APA requirements including an abstract. (10% deduction if not)
All papers must have a reference page. The textbook is an acceptable source.
Body of the paper 2 -3 pages, no more or less.
Title page, abstract, and reference pages are required. However, they do not count towards any page count.
Writing should reflect an understanding of the chapter’s basic concepts, thorough research, and logic and critical thinking skills.
The introduction is attention getting with sufficient background information to establish the topic and a clear thesis statement.
The conclusion summarizes the main points and leaves the reader with a strong comprehension of the paper’s significance and the author’s understanding.
Grammatically correct – No spelling, grammar, or mechanics errors.
Do not use the first person. (10% deduction if used)

Good day,
I am writing a report titled “Enhancing Bidders Participation in Biddi

Good day,
I am writing a report titled “Enhancing Bidders Participation in Bidding in Oil and Gas Projects”. I have gathered information via interviews and historical bid rejections reasons I have, and also made a survey to other contractors to collect more data.
I want someone to analyze this data and come up with results and suggestions/recommendation on ways to enhance the contractors participation to conclude this report.
I would appreciate a well-written conclusion. Attached are:
1. Interviews summary, historical bid rejections reasons. I made some analysis that may help you (powerpoint)
2. Survey’s results (excel), for survey attached is how the analysis shall be done according to my teacher (pdf.)
3. The report (pdf.)
Thanks,

Would you be able to write a 3-4 page reflective journal on what regression anal

Would you be able to write a 3-4 page reflective journal on what regression analysis means and how that impacts business decision-making. Must include a cover page and reference page. Read Chapters 7 and 8 in the textbook, Business Analytics: Communicating with Numbers, 2e.
The journal’s intent is for you to apply what you have learned to how data analytics is applied in the industry.
Review the infographic “Linear Regression Analysis – An Example”.This image comprises three graphs that explain three types of linear regressions using a constant variable “Earnings” and three variables (“Savings,” “Expenses,” “Spending Habits”), one for each example. The three examples are shown as three tips from a wise economist on how you can save more money.The first example shows a positive linear relationship between savings and earning indicating that savings should increase in proportion to earnings.The second example shows a negative linear relationship between expenses and earnings indicating that one should not increase expenses if their earnings increase, else there are fewer savings.The third example shows no linear relationship between variables such as spending habits and earnings. Your higher earnings do not necessarily make you a big spender. Similarly, you may not have substantial earnings, but you may still be a big spender. Alternatively, you may even be prudent and not be a big spender regardless of how much you may earn.

INSTRUCTIONS
The textbook contains a series of case problems that highlight situ

INSTRUCTIONS
The textbook contains a series of case problems that highlight situations that real organizations could encounter and are related to the weekly learning activities.At the end of Chapter 4, read Case Problem Lawsuit Defense Strategy or download Case Problem 2 – Lawsuit Defense Strategy.pdf.
Instructions:Write a 2-page APA report answering the questions below. Do not just answer the questions, but use the questions to formulate your report. Your paper should demonstrate thoughtful consideration of the ideas and concepts presented in the course and provide new thoughts and insights relating directly to this topic. Your response should reflect scholarly writing and current APA standards. Be sure to adhere to University’s Academic Integrity Policy.Questions to be answered in your report:Perform an analysis of the problem facing Allied Insurance and prepare a report that summarizes your findings and recommendations. Be sure to include the following items:A decision tree
A recommendation regarding whether Allied should accept John’s initial offer to settle the claim for $750,000
A decision strategy that Allied should follow if they decide to make John a counteroffer of $400,000
A risk profile for your recommended strategy
Requirements of the assignment:All papers must follow all APA requirements including an abstract. (10% deduction if not)
All papers must have a reference page. The textbook is an acceptable source.
Body of the paper 2-3 pages, no more or less.
Title page, abstract, and reference pages are required. However, they do not count towards any page count.
Writing should reflect an understanding of the chapter’s basic concepts, thorough research, and logic and critical thinking skills.
The introduction is attention getting with sufficient background information to establish the topic and a clear thesis statement.
The conclusion summarizes the main points and leaves the reader with a strong comprehension of the paper’s significance and the author’s understanding.
Grammatically correct – No spelling, grammar, or mechanics errors.
Do not use the first person. (10% deduction if used)
Case Problem 2 – Lawsuit Defense Strategy.pdf

Review Discussion: Storytelling and Success Stories then focus on Moritz’s work

Review Discussion: Storytelling and Success Stories then focus on Moritz’s work on the OECD Better life index download the executive summary and the index data.
In a one-page summary, note a few particular places around the world and compare and contrast the statistics. Also, note briefly how this graphic tells the story.

Prior to beginning work on this assignment:
Read Chapters 4 and 5 in your textbo

Prior to beginning work on this assignment:
Read Chapters 4 and 5 in your textbook.
Review the interactive, The Probability Game, to synthesize your understanding of different data visualization tools.
Use the Firefox or Chrome browser to view the learning activity.
In this assignment, you will analyze the Cost-of-Living Index and Groceries Index for seven United States cities. You will then create a scatterplot to represent the relationships between the variables. In the end, you will describe the implications of your analysis in your Paper. You may choose any seven United States cities you wish.
Go to the Northern America: Current Cost of Living Index by CityLinks to an external site. webpage and follow the directions below to get started:
Identify seven cities and note the “Cost of Living Index” and “Groceries Index” values.
In your Excel spreadsheet or tool of your choice, develop a table with three columns with the following titles:City
Groceries Index (independent variable)
Cost of Living Index (dependent variable)
Enter details for all seven cities under these column headers. You will then have a table with seven rows representing each city in one row.
Now, insert or draw a scatterplot of the above data set.
Display the regression line (also called the trend line, linear model, or line of best fit). To do so in Excel, select anywhere in the scatterplot. Select the plus sign, and at the bottom of Chart Elements, select “Trend line.”
Display the equation for the trend line and R2 value on the graph. To do so in Excel, right-select the trend line. Review the options on the right of the chart under “Format Trendline…” and scroll to the bottom to select the boxes for “Display Equation on chart” and “Display R-squared value on chart” options.
In your paper,
Provide the URL and complete an APA reference for the URL. For assistance formatting your reference list, refer to APA: Formatting Your References ListLinks to an external site. resource.
Provide the table with your data and your spreadsheet of the graph with the equation and R2 value. For assistance on when and how to use tables, refer to Tables, Images, & AppendicesLinks to an external site. resources.
Assess the relationship between the Groceries Index and the Cost of Living Index in the cities you studied. How do these indices help you identify the best and worst cities in the list regarding cost?
Summarize how this week’s visualization and probability tools helped you in your analysis.
The Identifying Relationships Between Variable paper
must be two to three double-spaced pages in length (not including title and references pages, charts or tables), and formatted according to APA StyleLinks to an external site. as outlined in the Writing Center’s APA Formatting for Microsoft WordLinks to an external site. resource.
must include a separate title page with the following:title of paper in bold fontSpace should appear between the title and the rest of the information on the title page.
student’s name
name of institution (The University of Arizona Global Campus)
course name and number
instructor’s name
due date
must utilize academic voice. Review the Academic VoiceLinks to an external site. resource for additional guidance.
must include an introduction and conclusion paragraph.Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & ConclusionsLinks to an external site. as well as Writing a Thesis StatementLinks to an external site., refer to the Writing Center resources.
must use at least one credible source in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible SourcesLinks to an external site. table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
To assist you in completing the research required for this assignment, review Quick and Easy Library ResearchLinks to an external site. tutorial, which introduces the University of Arizona Global Campus.
must document any information used from sources in APA Style as outlined in the Writing Center’s APA: Citing Within Your PaperLinks to an external site. guide.
must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.Review the APA: Formatting Your References ListLinks to an external site. resource in the Writing Center for specifications.

Prior to beginning work on this assignment:
Read Chapters 4 and 5 in your textbo

Prior to beginning work on this assignment:
Read Chapters 4 and 5 in your textbook.
Review the interactive, The Probability Game, to synthesize your understanding of different data visualization tools.
Use the Firefox or Chrome browser to view the learning activity.
In this assignment, you will analyze the Cost-of-Living Index and Groceries Index for seven United States cities. You will then create a scatterplot to represent the relationships between the variables. In the end, you will describe the implications of your analysis in your Paper. You may choose any seven United States cities you wish.
Go to the Northern America: Current Cost of Living Index by CityLinks to an external site. webpage and follow the directions below to get started:
Identify seven cities and note the “Cost of Living Index” and “Groceries Index” values.
In your Excel spreadsheet or tool of your choice, develop a table with three columns with the following titles:City
Groceries Index (independent variable)
Cost of Living Index (dependent variable)
Enter details for all seven cities under these column headers. You will then have a table with seven rows representing each city in one row.
Now, insert or draw a scatterplot of the above data set.
Display the regression line (also called the trend line, linear model, or line of best fit). To do so in Excel, select anywhere in the scatterplot. Select the plus sign, and at the bottom of Chart Elements, select “Trend line.”
Display the equation for the trend line and R2 value on the graph. To do so in Excel, right-select the trend line. Review the options on the right of the chart under “Format Trendline…” and scroll to the bottom to select the boxes for “Display Equation on chart” and “Display R-squared value on chart” options.
In your paper,
Provide the URL and complete an APA reference for the URL. For assistance formatting your reference list, refer to APA: Formatting Your References ListLinks to an external site. resource.
Provide the table with your data and your spreadsheet of the graph with the equation and R2 value. For assistance on when and how to use tables, refer to Tables, Images, & AppendicesLinks to an external site. resources.
Assess the relationship between the Groceries Index and the Cost of Living Index in the cities you studied. How do these indices help you identify the best and worst cities in the list regarding cost?
Summarize how this week’s visualization and probability tools helped you in your analysis.
The Identifying Relationships Between Variable paper
must be two to three double-spaced pages in length (not including title and references pages, charts or tables), and formatted according to APA StyleLinks to an external site. as outlined in the Writing Center’s APA Formatting for Microsoft WordLinks to an external site. resource.
must include a separate title page with the following:title of paper in bold fontSpace should appear between the title and the rest of the information on the title page.
student’s name
name of institution (The University of Arizona Global Campus)
course name and number
instructor’s name
due date
must utilize academic voice. Review the Academic VoiceLinks to an external site. resource for additional guidance.
must include an introduction and conclusion paragraph.Your introduction paragraph needs to end with a clear thesis statement that indicates the purpose of your paper.
For assistance on writing Introductions & ConclusionsLinks to an external site. as well as Writing a Thesis StatementLinks to an external site., refer to the Writing Center resources.
must use at least one credible source in addition to the course text.The Scholarly, Peer-Reviewed, and Other Credible SourcesLinks to an external site. table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.
To assist you in completing the research required for this assignment, review Quick and Easy Library ResearchLinks to an external site. tutorial, which introduces the University of Arizona Global Campus.
must document any information used from sources in APA Style as outlined in the Writing Center’s APA: Citing Within Your PaperLinks to an external site. guide.
must include a separate references page that is formatted according to APA Style as outlined in the Writing Center.Review the APA: Formatting Your References ListLinks to an external site. resource in the Writing Center for specifications.

Module 4: Milestone 2
The objective of this milestone is to analyze data using a

Module 4: Milestone 2
The objective of this milestone is to analyze data using aggregate functions, calculated fields, parameters, and table calculations, and create effective data visualizations.
Prompt
In the first milestone, you came up with 10 questions that you could answer using the dataset you chose. You also identified 10 chart types to answer those questions. For this assignment, you will first answer the following questions:
Based on the feedback you have received, will you alter, remove, or change any questions you have chosen? Why or Why not?
Based on the feedback received, will you alter, remove, or change any chart type you have chosen? Why or Why not?
Next, you will construct charts using Tableau. It is expected that you have one chart for each question. Thus, if you have 10 questions, you should have 10 charts minimum. As you construct your charts, address the following:
Use one of the following in one of your charts: aggregate functions or calculated fields.
Use one of the following in one of your charts: parameters or table calculations.
Consider the Gestalt principles that are covered in Chapter 3 of Story Telling with Data (alignment, white space, and contrast) to answer this question. What things can you add or change to make your charts more effective? Apply at least two of the three principles to at least two different charts.
Consider preattentive attributes and traditional design concepts that are covered in Chapters 4 and 5 in Story Telling with Data to answer this question. What things can you add or change to make your charts more effective? Use one of the preattentive attributes and one of the traditional design concepts to improve the effectiveness of at least two different charts.
Next, you will write a short paper on the data analysis process by addressing the following questions:
How did you use an aggregate function or calculated field in your data analysis?
How did you use parameters or table calculations in your data analysis?
How did the Gestalt principles you have used improve your visuals?
How did preattentive attributes and traditional design concepts you have used improve your visuals?
Is the story you want to tell the same? Did you change your story? If yes, what is the purpose of your updated story?
To successfully complete this assignment, view the following:
Milestone 2 RubricDownload Milestone 2 Rubric

View Rubric
Milestone 2 Rubric
Milestone 2 Rubric
CriteriaRatingsPts
Aggregate Functions or Calculated Fields10 pts
Proficient
Demonstrates a sophisticated knowledge of aggregate functions or calculated fields through the correct use of aggregate functions or calculated fields on the charts; and explains in detail how to use aggregate functions or calculated fields in data analysis.8.5 pts
Satisfactory
Uses aggregate functions or calculated fields on the charts correctly; and explains how to use aggregate functions or calculated fields in data analysis.5.5 pts
Needs Improvement
Uses aggregate functions or calculated fields on the charts; but the explanation how may be unclear, or the use of aggregate function or calculated field may be incorrect.0 pts
Not Evident
Does not use aggregate functions or calculated fields./ 10 pts
Parameters or Table Calculations
10 pts
Proficient
Demonstrates a sophisticated knowledge of parameters or table calculations through the correct use of parameters or table calculations on the charts; and explains in detail how to use parameters or table calculations in data analysis.8.5 pts
Satisfactory
Uses parameters or table calculations on the charts correctly; and explains how to use parameters or table calculations in data analysis.5.5 pts
Needs Improvement
Uses parameters or table calculations on the charts; but the explanation how may be unclear, or the use of parameters or table calculations may be incorrect.0 pts
Not Evident
Does not use parameters or table calculations/ 10 pts
Gestalt Principles
5 pts
Proficient
Demonstrates a sophisticated knowledge of Gestalt Principles through the appropriate and correct application of two of the three principles to make at least two charts more effective and explains in detail how these principles improve the charts.4.25 pts
Satisfactory
Applies two of the three Gestalt principles to make at least two charts more effective and explains how these principles improve the charts.2.75 pts
Needs Improvement
Applies one or two Gestalt principles to one or more charts, and the explanation how may be unclear, or the application of Gestalt principles may be incorrect.0 pts
Not Evident
Does not apply Gestalt principles./ 5 pts
Preattentive Attributes
5 pts
Proficient
Demonstrates a sophisticated knowledge of Preattentive Attributes through the appropriate and correct application of one of the attributes to make at least two charts more effective and explains in detail how this attribute improves the charts.4.25 pts
Satisfactory
Applies one of the Preattentive Attributes to make at least two charts more effective and explains how this attribute improves the charts.2.75 pts
Needs Improvement
Applies one Preattentive Attributes to one or more charts, and the explanation how may be unclear, or the application of Preattentive Attributes may be incorrect.0 pts
Not Evident
Does not apply Preattentive Attributes./ 5 pts
Traditional Design Concepts
5 pts
Proficient
Demonstrates a sophisticated knowledge of traditional design concepts through the appropriate and correct application of one of the design concepts to make at least two charts more effective and explains in detail how this concept improves the charts.4.25 pts
Satisfactory
Applies one of the traditional design concepts to make at least two charts more effective and explains how this concept improves the charts.2.75 pts
Needs Improvement
Applies one traditional design concept to one or more charts, and the explanation how may be unclear, or the application of design concept may be incorrect.0 pts
Not Evident
Does not apply traditional design concept./ 5 pts
Mechanics
5 pts
Proficient
No grammar or spelling errors that distract the reader from the content. Required tables are clearly labeled4.25 pts
Satisfactory
Minor errors in grammar or spelling that distract the reader from the content. Required tables may be missing or not clearly labeled.2.75 pts
Needs Improvement
Major errors in grammar or spelling that distract the reader from the content. Tables are not included.0 pts
Not Evident
Critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas./ 5 pts
Visuals and Storytelling
5 pts
Proficient
The choice of all visuals is excellent given the data and the story derived from the data.4.25 pts
Satisfactory
Most of the visuals that are chosen are appropriate given the data and the story derived from the data.2.75 pts
Needs Improvement
Some of the visuals that are chosen are appropriate given the data and the story derived from the data.0 pts
Not Evident
None of the visuals that are chosen are appropriate given the data and the story derived from the data./ 5 pts
Content of Report
5 pts
Proficient
The content of the written submission is well-presented and argued; ideas are detailed, developed and supported with evidence, data analysis, tables and figures. A non-technical audience can easily understand the content.4.25 pts
Satisfactory
The content of the written submission is sound and solid; ideas are present. Most ideas are developed or supported with evidence, data analysis, tables, and figures. It may include some content that a non-technical audience may find difficult to understand.2.75 pts
Needs Improvement
The content of the written submission is not sound. Few ideas are presented, and most of the ideas are not developed or supported with evidence, data analysis, tables, and figures. The report is too technical.0 pts
Not Evident
The content of the written submission is inaccurate, unsupported, or very technical./ 5 pts
Total Points: 0

Using the IPEDS data set IPEDS DataSet.xlsx complete Visual Analytics Assignment

Using the IPEDS data set IPEDS DataSet.xlsx complete Visual Analytics Assignment Fill the Assignment Scoring Guide document. zip all required documents.