How Do You Complete this Project?
This project is connected with the Introduction to the Data part of the course, but
depending on your background knowledge, you may not need to take this module to
complete this project.
For the final project, you will conduct three tasks:
1) complete your own data analysis and create a presentation to share your
2) develop a dashboard for a Profit and Loss Statement, and
3) create a Financial Forecasting Model using three scenarios.
You should start by taking a look at your dataset and brainstorming which sub-category
and company you want to focus your data analysis on – the questions leading to this
page should have assisted in this process! Then you should use spreadsheets or
another Excel-like software to conduct your analysis and choose a sub-category and
company you are most interested in. This project is open-ended in that there is no one
Here are the three tasks that you will complete in the final project.
a. Identify the question about the data that you will answer based on your data
analysis, and include this in your slide presentation.
• Your question should include at least one categorical variable (GICS
Sector or GICS Sub Industry) and one quantitative variable (one of
the financial metrics) and require the use of at least one of the
• A tab within the Excel spreadsheet that you submit should include the
summary statistics [measures of central tendency (e.g., mean, median)
and measures of spread (standard deviation and range)] you used to
answer your question.
• Deliverable: Slide presentation, Spreadsheet with tab for Summary
b. Your slide presentation should provide at least one visualization to help with
• This visualization might be a bar chart, histogram, scatterplot, box-plot or
other visual that you learned to make. Include your insights from the
measures of center and spread and at least one numeric summary
statistic in the description.
• Deliverable: Slide presentation (includes visualization)
• Create a dashboard for a Profit and Loss Statement that calculates the Gross
Profit, Operating Profit or EBIT for a company selected from a drop-down list.
• Your drop-down list should pull historical fundamentals data to create the P&L
• The P&L statement should include the Gross Profit, Operating Profit or EBIT
values for all the years there is historical data available for that company in
• Deliverable: Spreadsheet with tab for Dynamic P&L statemen
• Create a financial model for a company (different from Task 2) of your choice
that forecasts out the Gross Profit, Operating Profit or EBIT for two more
years using three scenarios (Best case, Weak case and Base case).
• Your assumptions for revenue growth, gross margin and operating margin should
change for each scenario.
• The forecasting model should be dynamic for the selection of the case (Weak,
Base, Strong). However, the forecasting model can be static for the chosen
company sticker symbol.
• Deliverable: Spreadsheet with tab for Forecasting Model
Step One – Get Organized
When you complete your analysis and presentation you’ll want to submit your project.
Get organized before you begin. I recommend creating a single folder that will
• The presentation with the visual and summary
• The original data set
• A copy of the spreadsheet workbook you will use to do the analysis for your
report that contains at least the following tabs:
o Data file
o Summary statistics
o P&L Statement Dashboard
o Forecast scenarios
Step Two – Analyze Your Data
Look through the Tasks described above and select the qualitative variable and
quantitative variable you want to focus your analysis on for the various tasks. Then use
the .csv file to conduct your data analysis.
Step Three – Create Your Presentation
Once you have finished analyzing the data, create a presentation that shares the visual
and summary paragraph. The summary paragraph should clearly communicate your
findings based on your analysis, and provide visual or numeric values associated with
your summary. (upload Submission Template) The submission template is a Google
Slides file. Make a copy of the submission template to complete your project. We
suggest you use the layout provided, though it is not a requirement.
Step Four – Assemble your Worksheet
You will need to include the Excel file with the summary statistics, dashboard and
financial model scenarios.
Put your presentation and spreadsheet workbook you used to do the analysis in a
folder and zip it. Then submit the zipped folder for your project.
Step Five – Check the Rubric
Use the Project Rubric located here. If you see room for improvement, keep working to
improve your project.
Step Six – Assemble your folder ready for submission
If you are happy with your submission, then you’re ready to submit your project. Put
your presentation and spreadsheet workbook in a folder and zip it. Then submit the
zipped folder for your project.
Model correspondence is a kind of nonverbal correspondence. Kind of nonverbal correspondence - According to eight significant nonverbal conduct, "the vast majority of our correspondence is nonverbal" (brain research, creator Kendra Cherry). Nonverbal correspondence incorporates non-verbal communication, hand development, head development, shirking of eye to eye connection, and pressure. Forcefully, nonverbal correspondence is deciphered similarly from culture to culture. Most types of nonverbal correspondence are past grins, embraces, and most hand developments. Exhibition correspondence is a path for us to convey in sentences and discussions. This incorporates body development, stance, signal, and eye to eye connection. My voice is a case of correspondence. There are different dialects in the world and you can impart through articulations and motions regardless of whether you can not comprehend what this individual says. - According to Quintanilla (2014), "... Since numerous nonverbal signals are oblivious or oblivious, consistently focus on nonverbal correspondence and that various motions have various implications for individuals You should comprehend "on page 26) The manner in which individuals and individuals see others might be because of their nonverbal correspondence. Individuals may have great substance about their data, however they may convey themselves such that they can not contact anybody else.Michael I am composing this letter to you with the goal that you can comprehend what is happening in my business correspondence course. I comprehend that this course with English as a local language might be somewhat hard for you, yet don't stress since I am here to help all of you the time. This week we will concentrate on "Word Power" meeting. The meeting has just been set up and understudies can present new words and expressions in a fun new manner. These words and expressions are hard to ace since they have a specific English culture, yet I trust that with the assistance of you can comprehend the significance of the word and the expression that gets it. Business correspondence is objective arranged. Organization guidelines, guidelines, and approaches must be conveyed to individuals inside and outside the association. Business correspondence observes certain guidelines and guidelines. In the good 'ol days, business correspondence was restricted to administrative preparing, phone, etc. In any case, with the approach of innovation, cell phones, video conferencing, email and satellite correspondence got conceivable to help business correspondence. Successful business correspondence will help manufacture generosity inside the association The correspondence that a business association makes to accomplish a particular objective is called business correspondence. Truth be told, business correspondence is an extraordinary method of conveying to address the issues of the association. Solid ideas in contemporary administration, for example, support, inspiration and interest will grow predominantly on correspondence. Compelling correspondence is essential for the development and improvement of the association. HH Hicks called attention to effectively - "From the introduction of the association, correspondence is the establishment of hierarchical presence, authoritative exercises no longer exist toward the finish of correspondence." Improving relational abilities expands the odds of accomplishment can do. Compelling correspondence achieves progress and thriving Correspondence is the soul of an association (organization). Business correspondence is the correspondence used to help items, associations, or administrations that you sell. In business correspondence, data is sent over the Internet, printing (distributing), TV, radio, outside and verbal just as different correspondence channels. In business, correspondence is viewed as the focal point of business, relational aptitudes and decorum. Promoter's job is to address their issues through merchandise and ventures, with an accentuation on meeting normal shoppers. With respect to job of correspondence, this alludes to the reason for mass correspondence that notices can accomplish. This is the most ideal approach to give data to (clients) and to convey the items or administrations you need to buy to clients. Much of the time, the reason for sponsors to make advertisements is to build deals. Model correspondence incorporates non-verbal/non-composing correspondence viewpoints. Speak with praiseworthy dialects through non-verbal communication, sound, articulation and motions. At the point when we speak with one another, we frequently don't have the foggiest idea how our bodies are anticipated to other people. Our nerves can put forth a valiant effort, our demeanor can wipe out an awful mind-set, we can let others show us boundless. - Exemplary correspondence includes nonverbal or composed prompts, for example, outward appearance, sound, or non-verbal communication. By accentuating or genuinely thinking what is being advised, you can supplement verbal correspondence. At the point when a sales rep is slick and looks well disposed, he can be viewed as solid and dependable. Individuals who are grimy and filthy are regularly viewed as conniving and dishonest. Exhibit correspondence is an approach to pass on nonverbal signs. Instances of nonverbal pieces of information incorporate sound, outward appearance, and non-verbal communication. Praiseworthy correspondence is the utilization of motions. Known as non verbal correspondence, it handles the sending and getting of messages. Showing correspondence can be arranged by human non-verbal communication, composed language, and nonverbal correspondence These correspondence can try perception turning into a watchword of correspondence. Part correspondence>GET ANSWER