https://publicpagestutorbin.blob.core.windows.net/%24web/%24web/assets/Business_intelligence_2fcfde6e8b.png

Business Intelligence Homework Help | Business Intelligence Assignment Help

Access TutorBin Business Intelligence homework help for improved analytics, conquer SQL challenges & boost grades with personalized guidance from our experts.

https://publicpagestutorbin.blob.core.windows.net/%24web/%24web/assets/Technology_7e7700199f.png

Trusted by 1.1 M+ Happy Students

4.4Trust Pilot

4.4Edu Reviewer

5App Review

4.8Student

Place An Orderand save time

^*Get instant homework help from top tutors—just a WhatsApp message away. 24/7 support for all your academic needs!

Business Intelligence Homework Help - Achieve A+ Grades with Our Expert Guidance

Business intelligence is crucial to analyzing an organization's business information, combining business strategies, technology, and analytical tools. The introduction to business intelligence as a professional pathway for students enrolling in the course is challenging due to the subject's complex framework and concepts. Given the breadth of the field, students must familiarize themselves with each concept and theory before tackling assignments. Recognizing students' difficulties, TutorBin has envisioned providing business intelligence homework to help improve grades.

Our expert tutors possess a deep understanding of the subject, gathering relevant data, including statistics and facts, and incorporating them into assignments with proper citations. Moreover, our subject matter experts meticulously follow task descriptions. By working with us, students receive assistance in completing their business intelligence assignments and gain valuable insights into BI tools. We are adept at presenting ideas concisely, accurately, and satisfactorily. To hire our tutors, drop a message saying, Can you do my business intelligence homework for me?

Business Intelligence Homework Help - Best Online Help for Students

TutorBin is a premier online Business Intelligence homework help platform, ensuring students receive a smooth and user-friendly experience. On TutorBin, students gain access to a pool of experienced tutors specializing in Business Intelligence, providing expert guidance for their assignments. The platform facilitates clear communication between students and tutors, fostering a collaborative learning environment. Students can seek assistance with various BI concepts, data analysis, and reporting techniques. The platform's easy-to-navigate interface allows students to upload their homework, receive personalized solutions, and engage in real-time discussions with tutors.

Business Intelligence Assignment Help

Who Can Benefit from Our Online Business Intelligence Homework Help?

Are you curious about who can benefit from our online Business Intelligence homework help? The answer is straightforward – anyone delving into Business Intelligence studies! Regardless of your educational stage, whether in high school, college, or pursuing advanced degrees, TutorBin Business Intelligence assignment help is tailored to meet the needs of learners at every level. Our adept tutors customize their teaching approaches to align with your academic proficiency, ensuring a personalized and practical learning experience for everyone seeking assistance in Business Intelligence.

Business Intelligence Tutors Online - Is It Worth To Hire Them?

Are you considering Business Intelligence Tutors Online? At TutorBin, our Business Intelligence tutors provide a valuable investment in your academic journey. With a wealth of knowledge and expertise, our experienced tutors deliver personalized guidance, tailoring their approach to address your unique challenges in the realm of Business Intelligence. You can confidently grasp fundamental concepts, apply them effectively, and excel in your studies by engaging with our online Business Intelligence tutors. Elevate your academic success by tapping into the specialized skills and support offered by TutorBin Business Intelligence tutors online.

Do My Business Intelligence Homework

Challenges Where Students Need Business Intelligence Assignment Help

Struggling with the "Do My Business Intelligence Homework" challenge? TutorBin recognizes key hurdles where students often seek Business Intelligence assignment help:

1. Data Analysis Complexity

Struggling with complex concepts in data analysis, such as interpreting complex datasets and drawing meaningful insights.

2. Tool Utilization

Navigating and effectively utilizing Business Intelligence tools like Tableau, Power BI, or others presents a significant learning curve.

3. Case Studies & Applications

Applying theoretical Business Intelligence knowledge to real-world case studies and practical applications, ensuring a comprehensive understanding.

4. Understanding Data Warehousing

Mastering the complexities of data warehousing, including data integration, storage, and retrieval.

5. Decision Support Systems

Comprehending the design and functionality of decision support systems within Business Intelligence.

Logisim Topics & Concepts Covered

Topics	Concepts
Combinational Logic	Multiplexers, Demultiplexers
Sequential Logic	Registers, Counters
Arithmetic Circuits	Adders, Subtractors, Multipliers
Memory Units	SRAM, DRAM, ROM, RAM
Multiplexers & Decoders	Priority encoders, Multiplexers
Clocking & Timing	Clock signals, Clock generation
Custom Components	Designing custom logic components
Simulation	Running simulations, testing circuits
Wiring and Connections	Connecting components, wires, buses

Business Intelligence Homework Help

What Do You Get When You Pay Someone to Do My Business Intelligence Homework?

When you opt for TutorBin for your Business Intelligence homework help, you unlock many advantages beyond mere completion. Here's what you get when you pay someone to do your Business Intelligence homework with us:

1. Data Analysis Mastery

Gain expertise in data analysis with in-depth insights into Business Intelligence topics.

2. Report Crafting Assistance

Receive expert guidance in creating accurate and comprehensive reports for Business Intelligence assignments.

3. Dashboard Interpretation

Understand complex dashboards through step-by-step explanations, enhancing your comprehension of Business Intelligence tools.

4. Decision Support System Clarification

Clarify complex concepts related to Decision Support Systems, ensuring a thorough understanding of their functionality.

5. Case Study Discussions

Engage in discussions on real-world case studies to apply Business Intelligence concepts practically.

6. Research Paper Support

Access assistance in crafting well-researched and documented papers on Business Intelligence topics.

7. Algorithmic Explanations

Comprehend algorithms and analytical models used in Business Intelligence with clear, concise explanations.

TutorBin Business Intelligence Homework Help Benefits

1. Expert Guidance

Receive assistance from subject-matter experts well-versed in Business Intelligence concepts and applications.

2. Timely Submissions

Ensure on-time homework delivery, meet academic deadlines, and adhere to submission schedules.

3. Conceptual Clarity

Gain a deeper understanding of Business Intelligence concepts through detailed explanations and tailored learning materials.

4. Customized Solutions

Access tailor-made solutions that align with your specific homework requirements and academic objectives.

5. Quality Assurance

Submit high-quality, error-free homework with thorough proofreading and quality checks conducted by our expert team.

6. 24/7 Support

Benefit from round-the-clock assistance, ensuring support whenever needed throughout your Business Intelligence coursework.

7. Original Content

Receive plagiarism-free solutions, upholding academic integrity and ensuring the authenticity of your homework submissions.

8. Affordable Services

Avail budget-friendly Business Intelligence homework help without compromising the quality of assistance you receive.

9. Interactive Learning

Engage in interactive learning experiences that enhance your understanding of Business Intelligence principles and applications.

10. Confidentiality

Rest assured that your academic tasks and personal information remain private and confidential throughout the homework help process.

Business Intelligence Assignment Help - Quick Assistance From Expert Tutors

Are you struggling with Business Intelligence assignments and need quick, expert assistance? Look no further than TutorBin. Our specialized Business Intelligence assignment help service ensures that you receive prompt guidance from experienced tutors. We break down complex concepts into clear, simple terms, making it easier for you to grasp complex topics like data analysis and reporting. Our team of experts is dedicated to helping you succeed in your studies, providing the support you need to tackle Business Intelligence challenges effectively.

Business Intelligence Homework Help Online Worldwide

No matter where you are in the world, TutorBin is your go-to destination for Business Intelligence homework help. Our online support is accessible globally, ensuring that students everywhere can benefit from our expertise. Whether you're struggling with BI concepts, analytics, or reporting, our tutors are here to simplify the learning process for you. Trust TutorBin for clear and easy-to-understand solutions, making Business Intelligence studies comprehensible and helping you excel in your coursework.

FAQs on Logisim Help Searched By Students

Can I hire someone to do my Logisim homework for me?

Absolutely! At TutorBin, you can pay for our qualified tutors to handle your Logisim homework, leading to a better understanding and improved proficiency in the subject. Seeking assistance from online Logisim tutors can significantly enhance your academic growth.

Can you provide me with instant Logisim assignment help in the USA?

Yes, you can access instant Logisim assignment help in the USA through our 24/7 online platform to promptly address your needs.

What should I do if I need help with Logisim?

If you're looking for help with Logisim, you're in the right place. Just submit your Logisim assignment on TutorBin, and our tutors will provide the guidance you need.

Can experts provide me with a well-researched Logisim assignment solution?

Yes, our experts are equipped to deliver well-researched and tailored Logisim assignment solutions that meet your specific requirements.

Are there online Logisim homework helpers available?

Yes, at TutorBin, you'll find online Logisim homework helpers who can assist you with your assignments and provide valuable support.

Recently Asked Business Intelligence Questions

Expert help when you need it

Q1:How did the technology come to exist? Who is the "inventor" or other "key players"? What problem the technology was intended to solve? See Answer
Q2:What risks do you see in using this technology in the legal industry? See Answer
Q3: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)See Answer
Q4: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. ********NOTESee Answer
Q5: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.See Answer
Q6: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.See Answer
Q7: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?See Answer
Q8: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?See Answer
Q9: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).See Answer
Q10: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)See Answer
Q11: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.See Answer
Q12:Concepts and Applications of Information Technology (IFSM201) Class Project Purpose of this Assignment The Class Project is the most significant assignment in this course, Concepts and Applications of Information Technology. As such, it accounts for 40% of the course points. This assignment is comprised of two deliverables; a SWOT Analysis and a Presentation. The SWOT Analysis is due in Week 4 (worth 15% of course grade), and the Presentation is due in Week 8 (worth 25% of course grade). This assignment gives you the opportunity to demonstrate your ability to research, evaluate, and describe business strategy focused on information technology tools and services. This assignment specifically addresses the following course outcomes: • Identify the basic components of the information system: hardware, software, data, processes, and people, and how these components are used to support strategic decision making. • Apply information technology tools for research, data gathering and information analysis, problem-solving, decision-making, and communicating information that aligns with business needs and objectives. Start Here The Class Project for this course focuses on the evaluation of a business or organization and how they might strengthen their operations through technology, including their information systems. There are two parts to the Class Project; the SWOT Analysis and the Presentation. You will use the same business/organization for both parts; however, the grade received on the SWOT Analysis will not affect the grade for the Presentation (they are separate assignments). Step 1: Choose a Business or Organization To begin, choose a business or organization that you would like to evaluate - it can be where you work, a school (UMGC), a place of worship, government entity (e.g., DMV, Secretary of State, courthouse, etc.), or any other type of organization. Since the focus of the analysis will involve information technology, the best type of organization to choose is one where you can envision technology playing a key role in improving products, processes, or services./nStep 2: The Presentation (due week 8) Now that you have chosen a business or organization for your Class Project and completed the SWOT Analysis, it is time to complete the second deliverable - the Presentation. As you demonstrated, the SWOT analysis is a framework for identifying and analyzing an organization's strengths, weaknesses, opportunities and threats --SWOT stands for: Strength, Weakness, Opportunity, Threat. Commonly used by businesses, this tool focuses on factors that are important to strategic decision making. These factors include both internal and external influences on the viability of the organization. The Presentation is a methodology for illustrating and explaining information to stakeholders in an organization. You will use the Microsoft PowerPoint tool to create a presentation for the leadership of the organization you chose for this Project. The SWOT Analysis you did provides the context for the presentation and you will use the attributes you identified in your SWOT Table to justify the recommendations you will make for improvements to the organization. The goal of the Presentation is to inform your audience, the senior leadership of the organization, of the internal and external factors most critical to the health of the organization, and recommend alternatives based on Information Technology that can help mitigate weaknesses and threats. For more explanations on a PowerPoint Presentation, go to the following resources, available in the week 8 Content: • Getting Started with PowerPoint 2016 • POWERPOINT 2016 FOR MAC QUICK START GUIDE POWERPOINT 2016 QUICK START GUIDE (Windows) PowerPoint: Managing Slides • Step 3: Create the PowerPoint Presentation Now that you have completed a SWOT Analysis on the organization you chose, it is time to create a PowerPoint presentation that will be submitted to your instructor/classroom. The presentation should include the following and be a minimum of 10-12 slides in length (not including Title or Reference slides): 1. Title slide - the title of presentation, company/organization name, your name, course, and date of submission. 2. Purpose - briefly describe the purpose of the presentation and a summary of the organization, including the business the organization is in (e.g., retail, production, technology services, education, etc.) 3. SWOT Findings- 6-7 slides including a slide with the SWOT Table you created. Use slides and notes to explain the business's strengths and weaknesses, as well as the/nopportunities and threats it faces in the marketplace. In addition to the SWOT Table, each quadrant (strengths, weaknesses, opportunities, threats) should have its own slide and in-depth Notes. Last, answer the question: how are the strengths, weaknesses, opportunities, and threats interconnected? 4. Focus on Information Systems - 2-3 slides describing recommendations based on the SWOT analysis; how can the information system components (hardware, software, data, people, processes) contribute to overcoming external barriers and bettering the health of the organization? 5. Summary/Conclusion - synthesize the presentation - what were the most important points? 6. References - cite at least two resources with APA formatted citation and reference. a. Remember to correctly cite and reference all sources. Any direct quotes should be indicated within the slide text with appropriate quotation marks and an in- text citation (however, direct quotes should be short and used sparingly, if at all). Complete references for sources should be included in the corresponding Notes section. Paraphrased material can just be referenced within the Notes section of the slides without an in-text citation on the slide. This deviates from APA style but keeps the slides more readable. *ALL Slides MUST Have Notes-provide a comprehensive explanation of what is on the slide. Since there is no oral presentation, the Notes serve to explain what the audience sees on the slide* The bullet points in your presentation will be supported by relevant details in the Notes section of the slides, which contain the actual words you would say to the stakeholders as you present each slide. Since you cannot actually present the slides in person, the Notes will show what you would actually say. This is an important part of your presentation. Presentations with limited or no "Notes" will receive much lower grades, because the bullets cannot tell the whole story. Tips for a good PowerPoint Presentation: • Include relevant graphics, including the SWOT Table. • Each slide should have a title and a limited amount of text. The presentation should capture key bullet points and not include complete paragraphs and detailed text. The Notes feature will provide that explanations/narration for what the audience sees on the slide. • There are options in PowerPoint to make a presentation stylish and unordinary, including background colors, but keep it professional looking - remember your audience. • Font size should be readable, as in at least 16 point and good contrast with background. • Use animations sparingly to enhance your presentation. • Keep Your Slides Simple.See Answer
Q13: CIS 3380 (Kelley) Activity #1: Large Databases (Access/Excel) Mining Business Intelligence from a Large Operational Database *Last Updated 1/13/2020* Due Dates: Data Files: Setup Steps: The Scenario: Grading: (50 pts max) Refer to Semester Schedule! Refer to Assignment Tab: Activity #1: Large Databases(Access/Excel) Right click each file below and save to your local drive/device: 1. Foodmart4c.accdb 2. HW1-LnameFname.doc (Note: This is your solution/answer sheet) *Rename Lname & Fname to YOUR Last Name & First Name! *Open and replace "(My Name is ???)" with "Your Name" in the Header You have been appointed to a management committee at Foodmart tasked with examining strategies to improve sales at the chain. At the kick-off meeting, it was observed that Foodmart had not attempted to construct profiles of their customers or their purchases let alone analyze how the data varies by country. You drew the short straw and were charged to do some research and analyze the data given to you and make some recommendations at the next meeting. Specifically, you are charged to do the following: 1. Identify the top 10 products sold given the data we have available 2. Identify the top 10 customers for 2017 fro our USA stores and comment on any common characteristics or traits like Income Group, Age, Location Showcase Foodmart total sales by store 3. 4. Profile Foodmart sales by various customer traits from total customer sales data by these data dimensions: › CustomerID, Country, Age & Income Groups, Gender, Marital Status 5. Do some high level customer analysis of your findings and make a recommendation on how to increase sales from our non & low-spending customers -Answers/data for EACH task on your answer sheet -Label ALL Excel tabs appropriately -Follow all directions for maximum points -Refer to the answer sheet for the breakdown of the points per task/sub-task 5 Files (Deliverables) to submit to Assignment Tab: Activity #1: Large Databases(Access/Excel) Page 1 of 8 CIS 3380 (Kelley) Activity #1: Large Databases (Access/Excel) Mining Business Intelligence from a Large Operational Database * You do not need to upload the Access Database to the LMS since it is rather large and, at times, when using a slower internet connection - will time out your session BUT if you have issues and want me to review the Access DB, it "cannot" be emailed since it is blocked so you will need to upload it to the LMS with your other files. Deliverable #1: HW1-LnameFname-Top10Products.pdf Deliverable #2: HW1-LnameFname-Top10Custs.pdf Deliverable #3: HW1-LnameFname-SalesByStore.pdf Deliverable #4: HW1-LnameFname.docx Deliverable #5: HW1-LnameFname.xlsx Optional Deliverable #6: Foodmartb.mdb or accdb Task 1*: Open the Foodmart4c.accdb with Microsoft Access then Update the Customers table: *Note: If you have a Mac or a "lighter version" of MS-Office on your PC - just go to a campus lab and complete the Access portions of the Assignment and save it to a USB drive to later import it to Excel on the device of your choice! 1. Open the 'Customers' table 2. Go to the last record in the table 3. Replace the following 3 field contents for the last record as follows: # Field Name Current Value 1 2 3 Annual Income 4. Save & Close the table. 5. As a result of doing this step, your name will appear in the query results as well as one of the income brackets in some of the pivot tables that will be constructed in the subsequent steps. 6. NOTE: Failure to do this step or task will result in -10 points to your grade ● ● LastName FirstName *** Task 2: DATABASE QUERIES: You will be creating 4 different queries Task 2a: Query #1: Top 10 Products SOLD (best practices: use Design Mode/View): 1. Click Create then Query Design 2. Add/Select the Products and the Facts tables 3. In the QBE grid, build a query with the following Tables & Fields (in sequence): TABLE FIELD(s) Products ProductName, ProductCategory, ProductSubCategory Facts: 4. Sort the data by Revenue (Descending) so as to show the highest product sales first 5. Now turn your detail query into a summary query: ??? ??? your name here *** Revenue NEW Value Your Last Name Your First Name Your First & Last Name Click the "Summation Symbol" at the top (far right) of the Query Design screen In the New "Totals:" row that appears in the QBE grid, we need to indicate how we want the results of our query to be summarized so that we don't have detail instances but summarized data by our stated criteria. Page 2 of 8 CIS 3380 (Kelley) Activity #1: Large Databases (Access/Excel) Mining Business Intelligence from a Large Operational Database * Click the chevron then select the option "Sum" so as to summarize the values of this field as it is unique (aka Group By) ALL the other fields in our query Make the query reveal only the Top 10 results and you do this by finding the Query Setup Comments area and click the dropdown next to the Results Option select 10 6. Save your Query as Top10Products 7. Run your Query to view the results and adjust as needed to correct the results (resave as necessary) 8. Record your "observations" about any common traits about the data in the answer document 9. Save the Query Results as a PDF to later submit to the Assignment tab as follows: ● For the "Revenue" field from the Facts Table, select the phrase "Group By" in the Totals row and you will notice a chevron appears 1. Click Create then Query Design 2. Add/Select the ALL but the Products table Click: File, Save As, Save Object as, PDF or XPS, Save As, navigate to where you want to save it plus name it properly as: HW1-LnameFname-Top10Products.pdf Task 2b: Query #2: Top 10 Customers for 2017 from our USA stores: 3. In the QBE grid, build a query with the following Tables & Fields (in sequence): FIELD(s) and Optional Criteria denoted by (xxx) TABLE ● Stores Dates The Year (select 2017 only) Revenue Facts: 4. Add Selection Criteria to our query so that we ONLY see these results: USA Stores AND for the year 2017 ONLY 5. Sort the data by Revenue (Descending) so as to show the highest customer sales first 6. Just like you did in the previous query (Task 2) Customers CustID, LastName, FirstName, City, State/Province, Country, Gender, AnnualIncome, BirthDate, Marital Status ● Country (select USA stores only) Sort the Revenue Descending so that the highest Revenue will show first Make it a summary query for the Revenue field selecting SUM 7. Review the data and zero in on the Highest & Lowest spending customer (ignoring the record for yourself) and record your answers in the answer sheet 8. Next, adjust your query to show only the Top 10 results then save it as Top10Custs 9. Run your Query to view the results and adjust as needed to correct the results and resave as needed 10. Record your "observations" about any common traits about the data in the answer document 11. Save the Query Results as a PDF to later submit to the Assignment tab as follows: Click: File, Save As, Save Object as, PDF or XPS, Save As, Navigate to where you want to save it naming it properly as: HW1-LnameFname-Top10Custs.pdf Task 2c: Query #3: Sales by Store: 1. Click Create then Query Design 2. Add/Select the ALL the tables Page 3 of 8 CIS 3380 (Kelley) Activity #1: Large Databases (Access/Excel) Mining Business Intelligence from a Large Operational Database * 3. Knowing what you know NOW in terms of query building - create a query that will reflect Total Sales by Store showcasing the highest store total sales 1st and lowest last 4. Save your Query as SalesByStore 5. Record your observations about the highest and lowest store sales wise in the answer document 6. Save the Query Results as a PDF to later submit to the Assignment tab as follows: Click: File, Save As, Save Object as, PDF or XPS, Save As, Navigate to where you want to save it naming it properly as: HW1-LnameFname-Sales ByStore.pdf ● Task 2d: Query #4: Summary Query (best practices - in Design Mode/View): 1. Create our last Query and select ALL the tables 2. In the QBE grid, build a query with the following Tables & Fields (in sequence): TABLE Customers FIELD(s) a. CustomerID, Gender, Birthdate, AnnualIncome, Marital Status b. Stores Country c. Facts: Revenue 3. *Optional Query Check: Run your query to verify it works and if you did it correctly, you will have 251,397 records (actually Sales Transactions) 4. Just like you did for the previous2 queries: Summarize the results by Revenue 5. *Optional Query Check: Run your query again to verify it works properly (8,738 records) 6. Save your Query as SalesData 7. Now IDENTIFY the one HIGHEST & LOWEST Spending Single Customer a. Click the Chevron Tool Next to the field SumOfRevenue and select "Largest to Smallest" sequence b. Ignoring the record for yourself – note the CustomerID for BOTH the absolute highest and lowest spending customers (just scroll down to the bottom for lowest) c. NOW OPEN the Customers table and you can merely scroll up/down to find the single record for the highest & lowest customer or more efficiently, click the chevron next to CustomerID and select Number Filters entering your target CustomerID's! d. Navigate to the 2 targeted records (specific CustomerID's) and reecord the specific data fields for the Highest & Lowest spending customers on your answer sheet in the appropriate table cells e. BONUS Extra Credit +3 points: i. What single product did the lowest spending customer buy? ii. Use the Access table drill down features (hint + symbol) to find it and record your answer in the answer sheet and a screen shot of the details 8. Close all the open tables and queries (do not save anything since creating/saving the SalesData query as it was only sorting/filtering data on the fly 9. Close and Exit Access Task 3: Importing Access Query Results/Data into Excel for further analysis Page 4 of 8 CIS 3380 (Kelley) Activity #1: Large Databases (Access/Excel) Mining Business Intelligence from a Large Operational Database * 1. Start Excel 2. We "need data" so we will import the Access Database Query Sales Data results you just created: a. Make command selections so as to get ready to “Get External Data from an Access Database" b. Navigate to the data source (where you have saved your Foodmart4b database with your query) and click "Open" c. Select your Sales Data query from the list (as a Table into the Existing Worksheet) d. Verify that all 8,738 records made it (plus 1 for the header row/column headings) 3. Rename the tab "Data" to make it easy to find/locate 4. Observation: Did you notice what format/style the imported data is in and what features or benefits it offers the savvy Excel user? (Record your answer on the worksheet: Task 5) Task 4: Work The Data: We are going to create Age Groupings! 1. New Field: Enter the phrase "Age" on Row 1 and the 1st column to the right of the data 2. Format time: Right click the "Age" COLUMN, click "Format Cells", Number and then set it to 0 decimal places. Failure to do this properly will generate "strange" numbers at times! 3. Now our formula/function to calculate Age (Row 2 - Cell H2): Enter as you see it below: a. =YEAR(TODAY()) *You see the current year appear in the column b. Now APPEND the formula you just typed with " – YEAR( <Click Cell C2>) And you will subsequently see: =YEAR(TODAY()) - YEAR([@Birthdate]) *Note: Cell C2 is the Customer BirthDate field and it will translate it to @Birthdate *Note: Magically - we have a calculation for their Age in ALL cells! 4. Next, we introduce our age categories: a. Click the Sheet2 tab at the bottom and Rename it "AgeCategories" b. Copy the table below into this tab (Cell A1) *or* Just enter it as is: age group 0 Under 20 20 20 to 29 30 30 to 39 40 40 to 49 50 50 to 59 60 60 to 69 70 70 to 79 80 80+ c. Now we are going to use this table to categorize our data by Age Group d. Go back to the Data Tab and in Column I, enter the header "AgeGroup" Page 5 of 8/n Assignment Instructions You have 5 deliverables which MUST be submitted/attached to this Canvas Assignment which include (Lname & Fname are YOUR Last & First Names): last name: first name: 1. HW1-LnameFname-Top10Products.pdf 2. HW1-LnameFname-Top10Custs.pdf 3. HW1-LnameFname-Sales ByStore.pdf 4. HW1-LnameFname.docx or doc 5. HW1-LnameFname.xlsx or xls Have fun with Excel and Access - and re-live those CIS1323. Also, it does not matter which version of Office use as the functions are ALL there. Remember to view the mini-lectures shown below for refreshers that is focused on successfully completing this homework activity/assignment. They were recorded a few years ago and don't 100% match the current version of the assignment but still give you a great refresher on both Access & Excel focused on the skills and tasks for this homework assignment. you NOTE: When grading it, if you make anything less than the max score, there will be either some comments via the feedback tab or a separate grading feedback worksheet document available. NO printouts are required "at all" - just the files submitted to TRACS via the Assignments tab. Additional items of note: 1. TxState offers FREE Microsoft Office 365 to all students but Access is "only" available on Windows Computers. http://www.tr.txstate.edu/software/office-students.html 2. McCoy 336 is the home for CIS tutors for selected courses including CIS3380 in the event that you need additional help/assistance and you don't want to or can't ask me for it or I'm not on campus/in my office during office hours. This is more focused on CIS courses than the SLAC lab in Alkek but in either case - they are not there to do your homework for you but to answer your questions and perhaps see/determine if you are on the right track. 3. When in doubt about something you did, were told to do or something.....ask ME as I am here to help and support you succeed in the class and the skills. VLOOKUP Additional Hints (and refer to the Vlookup jpg/pic file too that a past student did) 1. Copy/Paste the age chart/table onto a separate tab in XLS (from the Word document) 2. start the =VLOOKUP function in the 2nd row of the data tab (under the heading) 3. for the VLOOKUP components of the formula: -You are looking up the age of that row of data (click that cell) -You then define the table (but exclude the header rows) on the other tab (highlight it all and hit F4 to make it an absolute cell references) -The cell you want returned from the table is column 2 (the words)See Answer
Q14:Student note : you just need to add my ID and give me back the code just add my id and run the code I NEED THE SAS CODE FILE IN TXT this is my ID 2128942/n ECO520 Homework 4 Regression Analysis Review on Median House Price by County Use the following American Community Survey data for the MSAS (Metropolitan Statistical Areas) in U.S.: TITLE "American Community Survey Data (2014): Counties in U.S." ; filename webdat url "https://bigblue.depaul.edu/jlee141/econdata/eco520/acs_msa_2014.csv"; PROC IMPORT OUT= acs msa DATAFILE= webdat DBMS=CSV REPLACE; RUN; proc contents ; run ; /* Create your own random sample data. Make sure type your student ID as seed number Replace your_depaul_id with your student id (only numbers) */ proc surveyselect data= acs_msa method=srs seed = your_depaul_id n = 100 out= msasample ; run; /* Create Regression data in $1000 */ Data regdata; set msasample ; Y = MHPRICE / 1000 ; X = MHINCOME / 1000 ; RUN ; 1. Simple regression Model (12 points, 1)-3) 1 point each, 4) 5 point, 6),7) 2 point each) Let's investigate the relationship between the median house price in $1,000 (Y) and the median household income in $1,000 (X) using SAS. 1) Find the correlation coefficient and covariance between X and Y. Variable Y X The CORR Procedure Y 2 Variables: YX X Covariance Matrix, DF = 99 Y X Simple Statistics N Std Dev Sum Minimum 100 174.03100 81.05497 17403 79.40000 100 50.31738 8.47661 5032 34.80100 Y 6569.907817 464.919250 X 464.919250 71.852860 Pearson Correlation Coefficients, N = 100 Prob > Ir| under H0: Rho=0 Y Mean 1.00000 0.67667 <.0001 X 0.67667 <.0001 1.00000 Maximum 590.60000 75.68200 2) Scatter plot between X and Y with regression line Y 600 500- 400 300 200- 100 40 Scatter Plot with Regression Line 00 0000 be@o X 50 ΟΥ /* Simple Regression */ Y = bo + blx + e proc reg data= regdata ; model Y = X ; run ; офф Source DF Model Error Corrected Total 99 1 98 X O O 3) Perform the following regression analysis using the SAS code: Regression The REG Procedure Model: MODEL1 Dependent Variable: Y O 60 Number of Observations Read 100 Number of Observations Used 100 Analysis of Variance Sum of Squares 297815 352606 3598.02176 650421 Parameter Estimates Parameter Standard Variable DF Estimate Intercept 1 -151.54433 36.28500 1 6.47043 0.71120 O O O Mean Square F Value Pr> F 297815 82.77 <.0001 59.98351 R-Square 0.4579 Root MSE Dependent Mean 174.03100 Adj R-Sq 0.4523 Coeff Var 34.46714 Error t Value Pr>|t| -4.18 <.0001 9.10 <.0001 O 70 O 00 Residual Residual Percent 200 100 0 -100 200 100 0 -100 00 40 30 20 10 0 100 150 200 250 300 350 Predicted Value -2 -1 0 Quantile 1 T -150 -30 90 O Residual O T 2 210 RStudent Y The REG Procedure Model: MODEL1 Dependent Variable: Y Fit Diagnostics for Y 4 N O -2 600 500 400 300 200 100 200 100 0 -100 100 150 200 250 300 350 Predicted Value 100 200 300 400 500 600 Predicted Value Fit-Mean Coooox Residual 0.0 0.4 0.8 0.0 0.4 0.8 Proportion Less RStudent Cook's D 4 2 O -2 1.0 0.8 0.6 0.4 0.2 0.0 00 O O O 0.02 0.04 0.06 0.08 0.10 Leverage Observations 100 Parameters 2 Error DF MSE R-Square 00 0 20 40 60 80 100 Observation 98 3598 0.4579 Adj R-Square 0.4523 Residual 200 100 00 -100 600 400 200 O O O O 0 O O 40 ooo o 40 O 8 of O O 8 O O ܘܘ ܘ ܘ 8 ooooo @800 50 Residuals for Y 50 O O O o O X X o O Fit 95% Confidence Limits O Fit Plot for Y O O O 60 60 O O O O 70 O 70 O O 95% Prediction Limits O 00 100 Observations Parameters Error DF 2 98 3598 MSE R-Square 0.4579 Adj R-Square 0.4523 4) Find or calculate the following statistics using the regression output and explain their meanings. a. Total Sum of Square (SST) The SST is 650421. SST is the total variation in the dependent variable i.e. Y around its mean. IT is the summation of SSR and SSE. b. Regression Sum of Square (SSR) The SSR is 297815. SSR is the variation in the dependent variable Y explained by the regression model. C. Error Sum of Square (SSE) The SSE is 352606. SSE tells the variation in the dependent variable Y that is not explained by the regression model. d. e. Variance and Standard Deviation of Y Variance of Y is 6569.9. It is the spread of Y from its mean. and the Standard Deviation is 81.05. Standard deviation is the measure of the average by which Y is deviated from the mean. f. R square and Adjusted R square R square is 0.4579. It tells how much percentage of variation in Y is explained by X. It ranges from 0 to 1. The higher the R square, the more efficient the predictability will be. The adjusted R square is 0.4523. It adds a penalty to the R-square for every new junk variable added. It increases only if the variable added is meaningful. Variance and Standard Deviation of error (e) Variance of e is 3598.02. It gives how much the actual values differ from the values predicted by regression model. and the Standard Deviation is 59.98. Standard deviation is the measure of the average by which the actual values differ from the values predicted by regression model. g. Standard Error and Variance of bo Standard error of b0 is 36.28500 and the variance is 1316.60. Standard error indicates uncertainty in the estimated intercept b0 and variances indicate the spread in intercept values. i. h. Standard Error and Variance of bl Standard error of b1 is 0.71120 and the variance is 0.50. Standard error of b1 indicates the precision in the slope coefficient estimated by the regression model and variance indicates how much estimated slope changes from each sample. t statistic and P-value of t statistic of b1 T static value of b1 is 9.10 and p value is <.0001. The T value is how many standard errors the slope is away from zero. The p value is how confident the model is of t static value. 5) Perform the following hypothesis tests using the output Ho: B1 = 0, Ha: B1 #0 Here for X, T static = 9.10 and p <.0001 The t value is much larger at the significance level of 0.05. We can reject the null hypothesis and can conclude that there is a statistically significant relationship between X and Y./nSee Answer
Q15:Need this work in 2 pages double spaced with the help of information of APPLE, BEAUTY STORE we need to review it against patatonias information and make genraized projections and address the the questions student note: my chosen company is apple for the provided screenshot you need to have this information in regards to apple then take the findingds from all this and review it against patatonias informations and answer the questions presented everything starting with "consolidating" refers to the beauty store the first 5 links, which i sent already, pertain to beauty. the other u will have to find in regrads to apple/n Overview As you get ready to review and analyze the financial performance of the company you work for in Project Two, it would be helpful to analyze another company and learn from their business model, especially related to corporate social responsibility (CSR), sustainability, and activism. Therefore, you will review Patagonia's activism and corporate social responsibility initiatives and identify potential key financial performance indicators (KPIs). Because Patagonia is a privately held company, its financial records are not available in the public domain. So, you are required to analyze the mission, vision, values, CSR initiatives, and financial records of the health and beauty company as well as the company you chose in Module One. You will then deduce which financial key performance indicators likely align with a company's mission, vision, values, and CSR initiatives. Prompt To complete this assignment: 1. Review the resources you will be using in Project Two: Assessing Financial Performance. • Marketing and sales executive summary. • Vision, mission, and values of your company. • Consolidated balance sheet of your company. • Consolidated cash flow statement of your company. • Consolidated income statement of your company. • Balance sheet of your chosen company • Cash flow statement of your chosen company • Income statement of your chosen company 2. Review information related to Patagonia's corporate social responsibility and activism, as well as their mission, vision, and values. Use the following resources to help guide your research: • WileyPlus: Patagonia Case Analysis • Patagonia's Corporate Social Responsibility and Activism • Patagonia-Our Footprint • Patagonia-Mission, Vision, Values 3. Based on your review of the financial records of the health and beauty company as well as the company you chose in Module One, identify common financial KPIs and explain how these could also align with Patagonia's CSR initiatives and its mission, vision, and values. 4. Based on your review of Patagonia's information, describe how CSR activism can lead to a better brand image and financial results. 5. Explain what the health and beauty company could do to incorporate CSR activism strategies to meet its own KPIs. What to Submit In a Word document, use double-spacing, 12-point Times New Roman font, and one-inch margins. This consulting report should be 2 pages in length and include references cited in APA format. Consult the Shapiro Library APA Style Guide for more information on citations./n• Balance sheet of your chosen company • Cash flow statement of your chosen company • Income statement of your chosen company/n Financial KPIs-Stakeholders Identifying the important financial performance metrics that our stakeholders would find most interesting is based on which position they are holding in the organization. A variety of variables are evaluated from the perspectives of community groups, shareholders, and employees. KPIs related to each of these stakeholder's hinges upon the unique expectations and advantages these stakeholders are expecting from the company. • Employees: Employees want to be assured that the company for which they work is successful and profitable and provides job security and opportunities for growth within the company. Keeping this in mind, one KPI that is important for employees is the gross profit margin. Gross profit margin is a valuable indicator of the state of affairs of the company. It measures the overall profitability of the company and establishes the fact as to whether there is an opportunity of growth of the company. Employees shall also be concerned with the sales figures because decreasing sales trend would signify an alarming factor for the sustainability as well as the job security of the employees because decreasing sales would decrease gross profit margin as well as net profit margin. In the given case, the company has experienced a 15% growth in sales from 2016 to 2017 and 16% growth in sales from 2017 to 2018. Further, gross profit margin for 2016, 2017 and 2018 are 46.58%, 41.33% and 42.31% respectively. This signifies that there has been slight decrease in gross profit margin to the tune of 2.31% in 2017 and increase in gross profit margin from 2017 to 2018 to the tune of 12.69%. Hence, considering the growth in sales, gross margin % for the above-mentioned periods, financial health of the company would not indicate any alarming signal to employees in terms of their job security and the long-term survival of the company. Shareholders: Shareholders primarily concerned with the profitability of the company as they are the suppliers of capital expecting high return on their investment. High return on investment is the prerogative of the shareholders as they want to earn good return on their investment. So, return on investment is the most important KPI for shareholders. Further, the shareholders would be interested on the debt-to-equity ratio as KPIs as this ratio indicates how much money of the shareholders are utilized for various investment proposals and how much money is procured through debt financing. Since debt has low cost of capital and the company pays interest on debt regardless of the profit or loss of the company, any default in payment of interest on debt may expose the company to liquidation. This is why, shareholders are more concerned about the debt financing of the company as high quantum of debt in the capital structure of the company may increase the riskiness of the capital recovery of the shareholders in the event of liquidation or winding up of the company. Here Return on investment uses the formula: ROI= Earnings before interest and tax/Capital employed. Here capital employed is (Total assets- current liabilities). Using the said formula, we get ROI for 2016, 2017 and 2018 as 51.32%, 40.37% and 45.17% respectively. So, there has been decrease in ROI from 2016 to 2017 to the tune of 21.33% and increase in ROI from 2017 to 2018 for 11.87%. Debt to equity ratio = Total debts/Shareholders' equity. Here total debts comprise both long term and current liabilities. Using the said formula, we get Debt equity ratio for 2016, 2017 and 2018 as .39614, .63945 and 1.3751 respectively. It indicates that the debt was high in 2016 and subsequently reduces to .63945 and .39614 in 2017 and 2018 respectively. Hence the KPIs that the shareholders are interested are favorable for their long term association with the company. Community groups: Community groups want to ensure that how much the company is returning back to the community in terms of charitable contributions. So, community groups must see the profits as the measuring guide as to how much the company can contribute to the community in terms of charitable donations. Here it is evident from the income statement of my organization that the charitable contributions have increased to the tune of 13% from 2016 to 2017 and increased to 11% from 2017 to 2018 respectively. Key financial line items- TBL It is evident from the analysis of the consolidated income statement of my company that the there has been an absolute increase of $50,000 from 2016 to 2017 and from 2017 to 2018 respectively towards charitable contributions. This has been reflected in the company's TBL strategies to give back donations or charity to low-income neighborhoods. Further, there has been significant increase in salary expense to the tune of $4,500,000 from 2016 to 2017 and $6,000,000 from 2017 to 2018 under operating and administrative heads. Thus, it signifies that the company is focusing on the human resources development both operational and administrative perspective. From the financial statements it is observed that the company has increased its investment in property, plant and equipment to the tune of $8,18,000 from 2016 to 2017 and $5,974,000 from 2017 to 2018 respectively. This shows the continuous effort of the company in finding out ways to become more environmentally viable and friendly. Further, the company has experienced a continuous increase in profitably from 2016 to 2018 after the induction of Triple bottom line focused business model. In 2017, Net income increased to the tune of $640,000 and in 2018 the said increase was to the tune of $7,142,000. So, introduction of TBL increased net income from 2017 to 2018 to the extent of 63%. Apart from net income, gross profit has increased significantly by the introduction of TBL plan i.e., 31% in 2018 from its previous level of 13%. Hence, we witness the continued growth in sales and profit margins of the company along with the more environmentally and socially aware results and overall success by the introduction of Company's triple bottom line strategy. References: 1. Oldenburg Accountants and advisors (2006). Table of Kpis- oaa-cpa.com. 2. XYZ (2018), Consolidated income statement of XYZ corporation. 3. XYZ (2018), Consolidated Balance sheet of XYZ corporation.See Answer
Q16:AutoSave Alt Lab 1.3 Data Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) Paste BIU AA A- Wrap Text Morge & Center Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx data set using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required: 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Data: Alt Lab 1.3 Data.xlsx Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. A1 xfx SKU A Description Sales Price Cost 2 FU-16H T1600M FCS Hotas 97.3 52.53 3 FU-TMX TMX Force Feedback Racing 159.84 87.3 4 FLI-HOX T-Flight Hotas X Flight Stick 39.99 20.53 5 FU-H04 T-Flight Hotas 4 Flight Stick 34.65 19.76 6 PED-FCS T16000M FCS 39.19 23.36 7 FU-H01 T-Flight Hotas One 59.99 30.17 8 COM-FCS T16000M FCS Flight Pack 172.35 89.15 9 PED-TFR TFRP Rudder 69.99 41.18 10 WHL-TMX TMX Pro Racing Wheel 249.99 147.62 11 PED-T80 T80 Ferrari 488 GTB Edition F 94.99 52.58 12 PED-T3P FB T3PA-Pro 3-Pedal Add-Or 129.99 66.14 13 PCG-HOW Hotas Warthog PC 462.81 266.04 14 PED-FER Ferrari Racing Wheel Red Leg 79.99 43.51 15 PED-T3A T3PA Add-On 69.99 36.4 16 FU-16M T16000M Space SIM Duo St 117.83 69.36 17 WHL-T30 T300RS Officially Licensed PS 319.99 170.61 18 FL-USB USB Joystick 21.99 12.06 19 PED-TPR TPR Pedals Windows 497.38 284.93 Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. 1. Take a screenshot of your detailed listing of fruit products sold from the 0.4 to 0.425 gross margin percentage range, paste it into a Word document named "Alt Lab 1.3 Submission.docx", and label the screenshot Submission 1. 22 FLI-STX 20 WHL-T3S VG T300RS Racing Wheel Ser 159.99 92.63 21 FU-THR TWCS Throttle 59.99 35.18 T-Flight Stick X PS3 39.99 21.04 23 WHL-TGT T-GT Racing Wheel (PS4/PC) 614.91 354.66 24 WHL-T3P T300RS Racing Wheel 426.41 231.54 25 26 28 29 2. Take a screenshot of your histogram as a pivot chart, paste it into the same Word document, and label the screenshot Submission 2. Sheet1 + Ready Accessibility: Good to go General 5-%9 +88 Conditional Format Cell Formatting as Table Sty Insert Delete Format H Share Q Comments Σ v 0. Sort 5 Find & Fiber Select Analyze Date 125%See Answer
Q17:Required: 1. Create calculated fields for the gross margin and gross margin percentage. 2. Create a histogram to visualize the distribution of gross margin percentage across SKUs. 3. Adjust the automated bin size to 0.025. 4. Create a list of SKUs in the highest bin. Data: Lab 1.3 Data.xlsx Specify the Question: Which products (SKUs) are the most profitable to sell? Obtain the Data: Fancy Fruits is a fictitious mail-order business that sells exotic fruit from around the world to customers throughout the United States. The company keeps a price list for each product. We will work from this price list to find the items that are most profitable per dollar of sales. Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. Answer the following questions based on the details computed. Question 1. What is the size of each bin? 2. Is this dataset negatively (left) or positively (right) skewed? 3. Which gross margin percentage bin does the FRT-COU SKU fit in? 4. How many products (SKUS) have gross margin percentages in the 0.325-0.35 range? 5. How many products (SKUS) have gross margin percentages in the 0.35 -0.375 range? AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Α' Α' = Wrap Text Paste BI U V A Merge & Center H5 × ✓ fx ' . A " • • AV LIP 175 19 961 175 M 17 17 JAL IM 101 941 181 17 104 204 LH 834 141 211 3 201 152 18 241 1 110 M 181 LIN in SH M IM IN 941 652 19 19 33 L 71 645 IM 10 IN 957 EAT 18 AA 201 Answer IM 147 FRT HAR M 061 12 30 106 118 AT 134 995 1.75 IM 106 *** 181 LOP 11 S IM 181 L 671 206 1.34 131 937 FRY-PLY P 21 1.36 337 134 45 943 101 101 843 23 152 314 11 2 "M M WH 24 144 959 Sheet1 08 301 947 821 31 15 23 + Lab_1_3_Data General $ % 9 ✓ W .See Answer
Q18:Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.1 to the Lab 1.1 Data.xlsx data set with two modifications. The same scenarios exist as before, with labor costing either $13/lawn or $25/lawn. Assume that your mowing business will mow 350 lawns per month rather than 200 lawns per month. Also assume that the cost for advertising increases from $50 to $300 per month. Label these two new scenarios Scenario 3 (with labor costing $13/lawn) and Scenario 4 (with labor costing $25/lawn). Specify the Question: What is the profit on each lawn if the mowing business mows 350 lawns per month? What is the business's total profit per month? Required: 1. Assess whether this mowing business will be profitable if you mow 350 lawns per month. 2. Show a visualization of the change in monthly margin based on a range of labor costs per lawn. Data: Lab 1.1 Data.xlsx Analyze the Data: Refer to lab 1.1 in your text for additional instructions and steps. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. 1. Take a screenshot of the completed spreadsheet, paste it into a Word document named "Alt Lab 1.1 Excel Submission.docx", and label the screenshot Submission 1. 2. Take a screenshot of the scatterplot showing labor cost per lawn and monthly margin, paste it into the same Word document, and label the screenshot Submission 2. AutoSave OFF Home Insert Draw Page Layout Calibri (Body) v Paste BI UV L17 : x ✓ fx A 1 Base Scenario 4 Assumption: Total Lawns Serviced Each Month Revenue 7 8 Costs 9 10 11 12 15 16 18 21 24 25 27 Lab_1_1_Data Formulas Data Review View Tell me 11 ν Α' Α' Wrap Text General A v Merge & Center $ % 588 Conditional Form Formatting as Ta B Scenario 1 Per Lawn 0 Scenario 2 Per Lawn E F ' J K Enhanced Scenario MonthlySee Answer
Q19: Home AutoSave OFF ABG ... Insert Draw Page Layout Formulas Data Alt_Lab_1_3_Data Review View Tell me Calibri (Body) 12 A A = Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx data set using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required: 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Data: Alt Lab 1.3 Data.xlsx Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. 7 FU-HO1 8 COM-FCS 9 PED-TFR 10 WHL-TMX 11 PED-T80 12 PED-T3P 12 PED-T3P 13 PCG-HOW FB T3PA-P A-Pro 3-Pedal Add-Or Hotas Wart Warthog PC Ferrari Racing Wheel Red Leg Paste B I U v Hv AA Wrap Text General Merge & Center v S %9 Share Comments 5 v Conditional Format Formatting as Table Cell Styles Insert Delete Format Find & Sort & Filter Select Analyze Data A1 × ✓ fx SKU A B C D E F G H I J K L Σ N о P 1 SKU Description Sales Price Cost 2 FLI-16H T1600M FCS Hotas 97.3 52.53 3 FLI-TMX TMX Force Feedback Racing 159.84 87.3 4 FLI-HOX T-Flight Hotas X Flight Stick 39.99 20.53 5 FLI-HO4 T-Flight Hotas 4 Flight Stick 34.65 19.76 6 PED-FCS FED-FCS T16000M FCS 39.19 23.36 T-Flight Hotas One 59.99 30.17 30.17 T16000M FCS Flight Pack 172.35 89.15 TFRP Rudder 69.99 41.18 TMX Pro Racing Wheel 249.99 249.99 147.62 147.62 T80 Ferrari 488 GTB Edition F 94.99 94 99 129.99 462 81 462.81 52.58 66.14 66.14 266.04 52.58 14 PED-FER 79.99 42.51 43.51 15 PED-T3A T3PA Add-On 69.99 36.4 16 FLI-16M T16000M Space SIM Duo St 117.83 69.36 17 WHL-T30 T300RS Officially Licensed PS 319.99 170.61 18 FLI-USB USB Joystick 21.99 12.06 19 PED-TPR TPR Pedals - Windows 497.38 284.93 Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. 1. Take a screenshot of your detailed listing of fruit products sold from the 0.4 to 0.425 gross margin percentage range, paste it into a Word document named "Alt Lab 1.3 Submission.docx", and label the screenshot Submission 1. 21 FLI-THR 22 FLI-STX 20 WHL-T3S VG T300RS Racing Wheel Ser 159.99 92.63 TWCS Throttle 59.99 35.18 T-Flight Stick X PS3 39.99 21.04 23 WHL-TGT T-GT Racing Wheel (PS4/PC) 614.91 354.66 24 WHL-T3P T300RS Racing Wheel 426.41 231.54 25 26 27 28 29 2. Take a screenshot of your histogram as a pivot chart, paste it into the same Word document, and label the screenshot Submission 2. Sheet1 Ready Accessibility: Good to go 凹 -1+ 125% AutoSave OFF Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) ✓ 11 ▾ Aˆ A | ab Wrap Text Paste B I G v v = H5 x fx U ▾ B с D E G 3 FRT-APO Apricot Required: 1. Create calculated fields for the gross margin and gross margin percentage. 2. Create a histogram to visualize the distribution of gross margin percentage across SKUs. 3. Adjust the automated bin size to 0.025. 4. Create a list of SKUs in the highest bin. Data: Lab 1.3 Data.xlsx Specify the Question: Which products (SKUs) are the most profitable to sell? Obtain the Data: Fancy Fruits is a fictitious mail-order business that sells exotic fruit from around the world to customers throughout the United States. The company keeps a price list for each product. We will work from this price list to find the items that are most profitable per dollar of sales. Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. 11 FRT-CHI Chico fruit 2 FRT-APL Apple 4 FRT-AVD Avocado FRT-BAN Banana 1.7 1.09 28 1.76 1 0.59 05 031 6 FRT-BIT Biberty 2 1.17 7 FRT-BLB Blueberry 1.07 8 FRT-BLN Blackcurrent 2 1.18 9 FRT-BLR Blackberry 2 129 10 FRT-BOR Boysenberry 1 0.62 1.75 1.03 12 FRT-CHR Cherry 25 156 13 FRT-CHY Cherimoya 1.75 1.11 14 FRT-CLR Cloudberry 1.75 1.09 15 FRT-COU Coconut 2.41 154 16 FRT-CRR Cranberry 1.01 0.61 17 FRT-CUE Cucumber 1.82 1.09 18 FRT-CUN Currant 1.04 19 FRT-DAO Damson 2.04 1.34 20 FRT-DAT Date 0.83 0.54 21 FRT-DRI Dragonfruit 163 098 22 FRT-DUA Durian 132 23 FRT-ELR Bderberry 1.52 24 FRT-FEO fejpa 198 13 25 FRT-FII F 2.41 155 26 FRT-GOR Goji berry 1.18 0.74 27 FRT-GOS Gooseberry 182 1.19 FRT-GRF Grapefruit 098 0.65 29 FRT-GRI GrapeRaisin 125 0.74 30 FRT-GUV Guava 0.94 0.56 31 FRT-HOR Honeyberry 094 0.59 32 FRT-HUR Huckleberry 0.96 0.63 33 FRT-JAB Jabuticaba 0.89 0.52 34 FRT-JAI Jackfruit 0.63 0.37 35 FRT-JAU Jambul 195 1.13 36 FRT-JUB Jujube 0.95 37 FRT-JUR Juniper berry 13 0.86 38 FRT-KII Kiwifruit 2.32 137 39 FRT-KUA Kumquat 0.71 0.45 Answer the following questions based on the details computed. 40 FRT-LEO Lemon 2.46 1.48 41 FRT-LIM Ume 0.96 0.57 42 FRT-LOA Loquat 0.38 43 FRT-LOG Lengan 1.85 11 44 FRT-LYE Lychee 2.01 1.25 Question Answer 45 FRT-MAG Mango 1.47 46 FRT-MAR Marionberry 0.95 0.61 47 FRT-MEO Melon 194 12 1. What is the size of each bin? 2. Is this dataset negatively (left) or positively (right) skewed? 3. Which gross margin percentage bin does the FRT-COU SKU fit in? 4. How many products (SKUS) have gross margin percentages in the 0.325 -0.35 range? 5. How many products (SKUS) have gross margin percentages in the 0.35 -0.375 range? 48 FRT-MII Miracle fruit 2.05 12 49 FRT-MUR Mulberry 0.44 0.72 51 FRT-NEN Nectarine 0.96 52 FRT-OLV Ove 0.95 53 FRT-ORG Orange 0.75 0.49 54 FRT-PAI Passionfruit 0.94 0.61 55 FRT-PAY Papaya 0.63 56 FRT-PEA Par 183 1.07 57 FRT-PEC Peach 1.15 0.71 58 FRT-PEO Parsimmon 199 123 59 FRT-PHI Physalis 1.82 1.12 60 FRT-PIL Pineapple 0.77 0.46 61 FRT-PLI Plantain 2.06 1.24 62 FRT-PLM PlumPrune (dried plum 1.31 0.77 63 FRT-PLT Plumcot (or Pluot) 2.1 1.24 64 FRT-POL Pamdo 2.37 1.54 65 FRT-POT Pomegranate 0.65 0.42 66 FRT-PUE Purple mangosteen 0.59 67 FRT-QUC Quince 0.63 68 FRT-RAA Rambutan 23 1.52 69 FRT-RAR Raspberry 1.14 0.7 70 FRT-REN Redcurrant 1.42 0.85 71 FRT-SAA Salak 081 0.5 72 FRT-SAM Satsuma 0.69 0.44 73 FRT-SAR Salal berry 1.12 0.66 74 FRT-SOO Soursop 24 1.46 75 FRT-SOS Solanum quitoense 094 0.59 76 FRT-STI Star fruit 25 1.57 77 FRT-STR Strawberry 08 0.52 78 FRT-SUL Sugr apple 101 0.62 79 FRT-TAL Tamarillo 0.77 0.51 80 FRT-TAN Tamarind 1.38 81 FRT-UGI Ugi fruit 1.12 0.69 82 FRT-YUZ Yuzu 15 093 Ready Sheet1 + Accessibility: Good to go Lab_1_3_Data Merge & Center General $ % 950000 ✓ M 0 a R S U V W x Y 2 AA AB AC AD AE Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.3 Excel (or Lab 1.3 Tableau or Lab 1.3 Power BI) to the Alt Lab 1.3 Data.xlsx data set using your tool of choice. Open Excel file Alt Lab 1.3 Data.xlsx and follow similar directions to those in Lab 1.3 Excel. ThrustMaster is a fictitious company that sells game controllers, joysticks, and steering wheels for PCs and for Xbox, Nintendo, and PlayStation consoles. A summary of the price list of its products by SKU is included in the Excel spreadsheet. Required: 1. Draw a histogram of the gross margin percentages using bins of 0.025 size. Use bins 0.425, 0.45, 0.475, 0.5. 2. Get a list of SKUs in the highest 0.025 bin (from 0.475 to 0.50). Data: Alt Lab 1.3 Data.xlsx Analyze the Data: Refer to lab 1.3 in your text for additional instructions and steps. Answer the following questions based on the details computed. Q Share Comment General m Συ Merge & Center S % 9 898 Conditional Format Cell Formatting as Table Styles Insert Delete Format Sort & Filter Find & Select N Analyze J K L M N o P a R $ T AutoSave OFF ABAD C... Alt_Lab_1_3_Data Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body) 12 B I U ▾ AA A Wrap Text A1 × ✓ fx SKU A B C D E F H 1 SKU 2 FLI-16H Description T1600M FCS Hotas Sales Price Cost 97.3 52.53 3 FLI-TMX TMX Force Feedback Racing 159.84 87.3 4 FLI-HOX T-Flight Hotas X Flight Stick 39.99 20.53 5 FU-HO4 T-Flight Hotas 4 Flight Stick 34.65 19.76 6 PED-FCS T16000M FCS 39.19 23.36 7 FLI-HO1 T-Flight Hotas One 59.99 30.17 8 COM-FCS T16000M FCS Flight Pack 172.35 89.15 9 PED-TER TFRP Rudder 69.99 41.18 TMX Pro Racing Wheel 249.99 147.62 11 PED-T80 T80 Ferrari 488 GTB Edition 94.99 52.58 12 PED-T3P FB T3PA-Pro 3-Pedal Add-On 129.99 66.14 13 PCG-HOW Hotas Warthog PC 462.81 266.04 14 PED-FER Ferrari Racing Wheel Red Le 79.99 43.51 15 PED-T3A T3PA Add-On 69.99 36.4 16 FLI-16M T 16000M Space SIM Duo St 117.83 69.36 17 WHL-T30 T300RS Officially Licensed P 319.99 170.61 18 FL-USB USB Joystick 21.99 12.06 19 PED-TPR TPR Pedals Windows 497.38 20 WHL-T3S VG T300RS Racing Wheel Si 159.99 92.63 21 FL-THR TWCS Throttle 59.99 35.18 22 FUI-STX T-Flight Stick X PS3 39.99 21.04 23 WHL-TGT T-GT Racing Wheel (PS4/PC 614.91 354.66 24 WHL-T3P T300RS Racing Wheel 426.41 231.54 25 26 27 28 29 Answer 30 31 $ 42.41 32 33 42.410 34 35 36 27 Sheet1 + Note: Round gross margin to 2 decimal places and gross margin percentage to 3 decimal places. Question 1. What is the gross margin (dollars) for SKU PED-T80? 2. What is the gross margin percentage for SKU PED-T80? 3. What was the highest gross margin percentage among all the SKU's? 4. How many total SKU's are there? 5. How many SKU's are in the 0.45-0.475 bin? 23 7 Required information [The following information applies to the questions displayed below.] Lab Insight: Apply the same steps in Lab 1.1 to the Lab 1.1 Data.xlsx data set with two modifications. The same scenarios exist as before, with labor costing either $13/lawn or $25/lawn. Assume that your mowing business will mow 350 lawns per month rather than 200 lawns per month. Also assume that the cost for advertising increases from $50 to $300 per month. Label these two new scenarios Scenario 3 (with labor costing $13/lawn) and Scenario 4 (with labor costing $25/lawn). Specify the Question: What is the profit on each lawn if the mowing business mows 350 lawns per month? What is the business's total profit per month? Required: 1. Assess whether this mowing business will be profitable if you mow 350 lawns per month. 2. Show a visualization of the change in monthly margin based on a range of labor costs per lawn. Data: Lab 1.1 Data.xlsx Analyze the Data: Refer to lab 1.1 in your text for additional instructions and steps. Upload one Word or PDF document containing all of your screenshots for this Lab using the button below. Note: Please submit your file attachment response in one of the approved file formats; Word file (.doc or .docx), Excel file (.xls or .xlsx), or PDF. To submit photo or image files please paste them into Word or PDF. Consult with your instructor as needed on their preferred file attachment format. 1. Take a screenshot of the completed spreadsheet, paste it into a Word document named "Alt Lab 1.1 Excel Submission.docx", and label the screenshot Submission 1. 2. Take a screenshot of the scatterplot showing labor cost per lawn and monthly margin, paste it into the same Word document, and label the screenshot Submission 2. AutoSave OFF Home Insert Draw Page Layout Lab_1_1_Data Formulas Data Review View Tell me X Calibri (Body) ✓ 11 ✓ A A ab v ab Wrap Text v General ˇ Paste B I U v Hv A ✓ Merge Center v $ % 9 8.00 Conditional Form Formatting as Ta L17 x ✓ fx A 1 Base Scenario 2 B C D E F Scenario 1 Scenario 2 Per Lawn Per Lawn G Enhanced Scenario H J K 10 22 23 24 25 27 28 29 Assumption: Total Lawns Serviced Each Month. Revenue Costs Monthly Required: To run this business, you'd have to leave your day job, where you earn $4,000/month. 1. Assess whether this mowing business will be profitable if you mow 200 lawns per month. 2. Show a visualization of the change in monthly margin based on a range of labor costs per lawn. Data: Lab 1.1 Data.xlsx AutoSave OFF Lab_1_1_Data Home Insert Draw Page Layout Formulas Data Review View Tell me v Calibri (Body) 11 ✓ Aˆ A ab Wrap Text v General Paste P BI U ▾ H ✓ A ✓ Merge & Center $ % 9 800 Condi Forma L17 × ✓ fx A B C D E F Scenario 1 Per Lawn Scenario 2 Per Lawn G Enhanced Scenario H 1 J 1 Base Scenario 2 3 Specify the Question: What is the profit on each lawn if the mowing business mows 200 lawns per month? What is the business's total profit per month? 4 Assumption: Total Lawns Serviced Each Month 5 6 Revenue 7 Obtain the Data: Open Lab 1.1 Data.xlsx and browse its contents. The data will come from the various assumptions given. Analyze the Data: Refer to lab 1.1 in your text for additional instructions and steps. 8 Costs 9 10 11 12 13 14 15 16 Answer the following questions based on the details computed. Note: Round the margin and cost per lawn to 2 decimal places. 17 18 19 20 21 Question Answer 22 23 1. What is the total monthly margin for scenario 1? 2. In scenario 1, what is the expected number of lawns that will be mowed each week? (assuming 4 weeks in a month) 24 25 26 27 3. What is the total margin per lawn for scenario 1? 28 4. What is the total monthly margin for scenario 2? 5. In scenario 1, what is the cost of the monthly truck payment per lawn? 29 30 31 32 33 34 35 36 37 38 39 MonthlySee Answer
Q20: COMM 395: <Business Forecasting> COURSE PROJECT This assessment takes the form of an essay along with class presentation and accounts for 20% of your total mark and the deadline for submission is on 28 march 2024 by 11:59pm. The Task The objective of this coursework is to go through forecasting steps and propose and build a framework to forecast daily and monthly time series of the given dataset. Specify Tidy Visualise Estimate Forecast Evaluate Figure 1: process of producing forecasts for time series data Once you prepare your data for forecasting and conduct a preliminary analysis to determine whether they contain any key feature (Part A), then you need to identify suitable forecasting models (Part B), specify and train models on your data (Part C), check the validity of your model and evaluate its point and interval forecast accuracy and use the most accurate model to forecast the future (Part D). Submission format You should submit, a Zip file containing your report in a Pdf format and your R code. Data The dataset is provided in a CSV file. The dataset chosen for this assessment is the sales of 40 products from a retailer. It contains multiple variables. • item_id • dep_id • store_id state_id month • sales Part A: prepare data and visualise. Once you have the data, you can start by importing them into R. you need to make sure your data is a quality data and if required you need to clean data, remove duplication, deal with explicit and implicit missing values. You need to create suitable graphs to identify key features of your data. You need to describe and interpret key features available in your data. Part B: Select a suitable toolbox of forecasting models. Your toolbox should contain: • exponential smoothing models regression model • arima models . • A simple benchmark method The selected models should be able to capture collectively different underlying time series characteristics of data (level, trend, seasonality, autocorrelation). You need to describe the models in the report. A full justification of the selected models should be provided. Part C: Train models on your data and forecast. In this part, you need to specify models discussed in Part B and train them on your data. Forecast sales for 6 months ahead. Part D: Model performance evaluation • • You need to select a strategy to decide which forecasting model is the most accurate one. Evaluate the forecasts produced using at least three appropriate point error measures and one interval accuracy measure and one distributional accuracy measure. Compare the forecast accuracy measures. Which model do you select as the most accurate model to suggest it to the decision maker for use in the future? Perform residual diagnostics for the most accurate model. What does the residual diagnostics tell you? Please note that in all the above parts the quality of presentation, critical discussion and appropriate references to the literature will be taken explicitly into account towards the mark to be allocated. You need to use R software to do all analysis, any other tools such as Excel is not allowed. The essay should be NO MORE THAN 3,000 WORDS IN LENGTH and all sources should be acknowledged in the appropriate place in the text. You are advised to use the Harvard referencing system. References are excluded from world count. Unfair Practice This is an individual assignment and you are advised not to engage in any activity that might lead to suspicions of Unfair Practice. Course Project marking-criteria For 90%+ An outstanding piece of work, showing mastery of the subject matter, with a highly developed ability to analyse, synthesise and apply knowledge and concepts. All objectives of the assignment are covered, and the work is free of error with very high level of technical competence. There is evidence of critical reflection; and the work demonstrates originality of thought, and the ability to tackle questions and issues not previously encountered. Ideas are expressed with fluency. All coursework requirements are met and exceeded. For 70%-89% An excellent piece of work, showing a high degree of mastery of the subject matter, with a well-developed ability to analyse, synthesise and apply knowledge and concepts. All major objectives of the set work are covered, and work is free of all but very minor errors, with a high level of technical competence. There is evidence of critical reflection, and of ability to tackle questions and issues not previously encountered. Ideas are expressed clearly. However, the originality required for a 90+ mark is absent. All coursework requirements are met and some are exceeded. For 60%-69% A very good piece of work, showing a sound and thorough grasp of the subject-matter, though lacking the breadth and depth required for a first-class mark. A good attempt at analysis, synthesis and application of knowledge and concepts, but more limited in scope than that required for a mark of 70+. Most objectives of the work set are covered. Work is generally technically competent, but there may be a few gaps leading to some errors. Some evidence of critical reflection, and the ability to make a reasonable attempt at tackling questions and issues not previously encountered. Ideas are generally expressed with clarity, with some minor exceptions. All coursework requirements are addressed adequately. For 50%-59% A fair piece of work, showing grasp of major elements of the subject-matter but possibly with some gaps or areas of confusion. Only the basic requirements of the work are covered. The attempt at analysis, synthesis and application of knowledge and concepts is superficial, with a heavy reliance on course materials. Work may contain some errors, and technical competence is at a routine level only. Ability to tackle questions and issues not previously encountered is limited. Little critical reflection. Some confusion and immaturity in expression of ideas. Most coursework requirements are addressed. For 40%-49% A poor piece of work, showing some familiarity with the subject matter, but with major gaps and serious misconceptions. Only some of the basic requirements of the work set are achieved. Little or no attempt at analysis, synthesis or application of knowledge, and a low level of technical competence, with many errors. Difficulty in beginning to address questions and issues not previously encountered. Some intended learning outcomes are achieved. For 30%-39% Work not of passable standard, with serious gaps in knowledge of the subject matter, and many areas of confusion. Few or none of the basic requirements of the work set are achieved, and there is an inability to apply knowledge. Technical competence is poor, with many serious errors. The student finds it difficult to begin to address questions and issues not previously encountered. The level of expression and structure is very inadequate. Few intended learning outcomes are achieved. Below 30% A very poor piece of work, showing that the student has failed to engage seriously with any of the subject matter involved, and/or demonstrates total confusion over the requirements of the work set. Virtually none of the intended learning outcomes are achieved.See Answer

Popular Subjects for Business Intelligence

You can get the best rated step-by-step problem explanations from 65000+ expert tutors by ordering TutorBin Business Intelligence homework help.

Business Intelligence Experts of TutorBin

Shakuntala jain

Expertise

Statistics,Renewable Energy,American History,Structural Geology,Sociology,Business Intelligence

Ratings(4.81)

Orders243

Mamta tarachandani

Expertise

Cost Accounting,Financial Accounting,Standard Costing,Managerial Accounting,Business Intelligence

Ratings(4.72)

Orders341

Kavita Shah

Expertise

Essay/Summary,Psychology,Sociology,Business Communication,Human Resource Management,Business Intelligence

Ratings(4.89)

Orders2137

Ashish Kumar Shukla@

Expertise

Intercultural Management,Business Communication,Business Organization,Human Resource Management,Leadership Skills,Business Intelligence

Ratings(4.77)

Orders116

Vivek Jain

Expertise

Hydrology,Environmental Engineering,Hydraulics,Hydrology,Strength of Material,Business Intelligence

Ratings(4.75)

Orders952

Aseem Jain

Expertise

International Trade And Finance,Microeconomics,Operation Research,Corporate Finance,Financial Management,Business Intelligence

Ratings(4.97)

Orders504

Anil Kumar Sabharwal

Expertise

Operation Research,Quantitative Analysis For Business Management,Statistics,Business Intelligence

Ratings(4.54)

Orders230

Anisha Singh

Expertise

English(Essay Writing/Summary),Operation Research,Management Science,Financial Management,Business Intelligence

Ratings(4.92)

Orders116

Paila sowjanya

Expertise

Business Organization,Corporate Financial Management,Business Intelligence,Deterministic Models In Management Science

Ratings(4.79)

Orders845

Sakshi Sharma

Expertise

Intercultural Management,Digital Marketing,Enterprise Architecture,Business Communication,Financial Derivative And Risk Management,Business Intelligence

Ratings(4.93)

Orders638

Get Instant Business Intelligence Solutions From TutorBin App Now!

Get personalized homework help in your pocket! Enjoy your $20 reward upon registration!

Download on the
App Store

Download on the
Google Play

Claim Your Offer

Moneyback

Guarantee

Free Plagiarism

Reports

$20 reward

Upon registration

Full Privacy

Unlimited

Rewrites/revisions

Testimonials

TutorBin has got more than 3k positive ratings from our users around the world. Some of the students and teachers were greatly helped by TutorBin.

TutorBin turned my business intelligence nightmares into success stories! The tutors here are not just experts; they're miracle workers. Thanks to their guidance, I understood complex concepts and aced my assignments. My confidence has soared, and my grades reflect it. TutorBin is the secret weapon every BI student needs!

Sophia

TutorBin business intelligence homework help is a lifesaver! The experts met my tight deadlines and crafted assignments that impressed my professors. Their dedication to understanding the subject and attention to detail are commendable. If you're struggling with BI, TutorBin is the rescue team you've been waiting for!

Benjamin

Homework stress was taking a toll on my BI journey until I found TutorBin. Their tutors are wizards in simplifying the most intricate BI topics. The assistance I received not only helped me complete assignments but also deepened my understanding of the subject. TutorBin is the homework ally I never knew I needed.

Hudson

Business intelligence was daunting until TutorBin provided me with a reliable rope. The tutors' expertise and commitment are unmatched. They solved my homework challenges and empowered me to tackle similar problems on my own. TutorBin is not just a service but a mentorship every BI student deserves.

Amelia

TutorBin is my go-to solution for conquering the complexities of business intelligence. The tutors are knowledgeable and patient in guiding through the intricacies. The assignments I received were not just answers; they were stepping stones to a better understanding BI. Choosing TutorBin was one of the best academic decisions I've made!

Audrey

TutorBin helping students around the globe

TutorBin believes that distance should never be a barrier to learning. Over 500000+ orders and 100000+ happy customers explain TutorBin has become the name that keeps learning fun in the UK, USA, Canada, Australia, Singapore, and UAE.