Assessment 2: Descriptive Analysis, Prediction and Communication

Task overview

In this assessment, students will be provided a business scenario and dataset. Students will be required to use the dataset and apply business analytics techniques to it so as to be able generate a comprehensive understanding of the relationship between variables in response to the identified business problem. They will be required to present these insights in a clear and effective manner. This assessment is worth 60% of the subject.

Requirements

You work for Insight Analytics Pty Ltd, a consulting company specialising in firm and capital market analysis for investors and financial advisors, but also companies who are interested in e.g. industry specific drivers of financial performance.

You have been provided with cross-sectional information about a sample of 1,000 Australian companies and are required to analyse these companies to identify drivers of revenue, costs and profits. This dataset Download datasetincludes financial information (revenues and expenses), but also non-financial data (e.g. customer satisfaction scores) and demographic information (e.g. geographic information), all referring to the previous financial year (or end of it). The file also includes a data dictionary explaining the meaning of the variables. Your analysis of the data should also be guided by an extract from an Analysis Guide Download extract from an Analysis Guideprepared by Insight Analytics Chief Data Scientist. The extract refers to typical questions to be asked when analysing high-level company data. Note that you do not necessarily have to address all these questions/recommendations it is more a create awareness checklist.

Tools: As mentioned previously in the subject, MS Excel is the standard tool for analysis in this subject; however, you are totally free to use other tools for data preparation and analysis, either in addition to Excel, or instead of Excel.

Using the data provided (and any other information you feel could be relevant) provide a 6 minute video report which includes an overview of descriptive and predictive analytics of the drivers of financial performance indicators, as well as a proposal to Insight Analytics team of consultants guiding their advisory services for their clients, including 2 actionable insights into how companies could increase their profitability.

Assignment format

Your report is to be recorded as a video file and uploaded to Canvas. The maximum length of the video is 6 minutes (this isnt long so its important to focus and stay concise) and is to be uploaded to Canvas. Within the 6 minutes, you are free to choose a format that works best for you. The maximum media file size that can be uploaded is 500 MB.

Note from user: what kind of data should be included? can you explain step-wise? not technical. so that people can understand it. and the sheet has Revenue, Other Expenses, Marketing Expenses, R&D expenses, Customer satisfaction, industry Foreign Op, chair ferm and region!!

Rubric

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeAnalytics

40 to >30.0 pts Exceeds criteria Provides a clear, comprehensive and succinct overview of the analytics generated as part of the research for this assessment

30 to >20.0 pts Meets criteria Provides a clear overview of the analytics generated as part of the research for this assessment

20 to >0 pts Criteria not met Does not provide a clear overview of the analytics generated as part of the research for this assessment

40 pts

This criterion is linked to a Learning OutcomeProposal

10 to >7.5 pts Exceeds criteria Provides a clear, comprehensive and succinct proposal in relation to a potential strategy

7.5 to >5.0 pts Meets criteria Provides a reasonable proposal in relation to a potential strategy

5 to >0 pts Criteria not met Does not provide a reasonable proposal in relation to a potential strategy

10 pts

This criterion is linked to a Learning OutcomeStructure of presentation

25 to >18.75 pts Exceeds criteria The presentation is structured in an innovative, but efficient manner which covers all key deliverables

18.75 to >12.5 pts Meets criteria The presentation is structured in a cohort, organised fashion

12.5 to >0 pts Criteria not met The presentation is not structured in an coherent, organised way

25 pts

This criterion is linked to a Learning OutcomeDelivery of presentation

25 to >18.75 pts Exceeds criteria The presentation is delivered in a fashion which truly engages the audience

18.75 to >12.5 pts Meets criteria The presentation is delivered in a fashion that makes it easy for the audience to understand

12.5 to >0 pts Criteria not met The presentation is delivered in a fashion which makes it difficult to understand as an audience

AND SO ON.

\begin{tabular}{|c|c|c|c|c|c|} \hline 8,813,519 industry 018,537,522 & 6 & 8 & 0 East & 191,900 & 170,197 \\ \hline 4,362,822 Industry 043,203,724 & 6.5 & 5 & 0 southeast & 78,121 & 58,115 \\ \hline 5,704,238 Industry 023,985,950 & 11.1 & 6 & O East & 274,791 & 2,851 \\ \hline 8,233,116 industry 027,061,395 & 0.8 & 3 & 0 North & 179,902 & 18,718 \\ \hline 4,398,435 Industry 053,181,074 & 4.4 & 5 & 0 south & 23,564 & 82,421 \\ \hline 9,788,092 Industry oe 9,965,625 & 16.5 & 7 & 0 West & 264,019 & 2,557 \\ \hline 348,731 Industry 04253,295 & 2.9 & 0 & 0 North & 78 & 35,571 \\ \hline 3,158,701 Industry oe 2,895,475 & 1.4 & 5 & 0 south & 19,285 & 117,540 \\ \hline 5,394,125 Industry 07 4,497,319 & 4.3 & 1 & 1 West & 62,499 & 125,034 \\ \hline 7,844,136 Industry 07 8,167,966 & 7.8 & 6 & O Capital & 312,358 & 36,147 \\ \hline 8,010,806 industry 046,997,363 & 15.2 & 3 & 0 North & 51,843 & 87,652 \\ \hline 9,607,461 Industry 07 8,177,359 & 4.7 & 5 & 0 Northwest & 461,466 & 168,250 \\ \hline 5,290,031 Industry 045,267,287 & 17.4 & 6 & 0 southeast & 243,865 & 81,959 \\ \hline 7,530,011 Industry os 7,320,496 & 10.4 & 5 & 1 Northwest & 289,301 & 23,891 \\ \hline 961,942 Industry OS 690,935 & 6 & 0 & o North & 449 & 23,223 \\ \hline 1,807,281 Industry of 1,379,977 & 4.9 & 0 & 0 East & 175 & 9,342 \\ \hline 6,291,640 Industry 094,260,742 & 9.2 & 0 & 0 southwest & 1,264 & 75,035 \\ \hline 2,125,177 Industry 021,301,266 & 5.6 & 4 & o Capital & 34,069 & 62,734 \\ \hline 8,017,021 Industry 047,756,971 & 21.3 & 5 & O Capital & 200,963 & 66,143 \\ \hline 2,443,507 Industry 091,578,633 & 1.8 & 0 & 0 southwest & 1,128 & 18,566 \\ \hline 4,869,215 & 10.3 & 4 & 0 East & 258,958 & 37,184 \\ \hline 1,715,930 Industry 081,063,655 & 3.8 & 0 & 0 North & 435 & 31,593 \\ \hline 9,958,716 Industry 018,421,125 & 16.5 & 6 & 0 East & 231,240 & 124,561 \\ \hline 7,985,117 industry 076,641,317 & 9.5 & 7 & O North & 318,535 & 86,396 \\ \hline 956,965 Industry 06878,662 & 8.8 & 2 & 0 south & 6,236 & 24,840 \\ \hline 2,171,864 Industry 051,819,631 & 4.7 & 1 & 1 Southeast & 14,628 & 99,191 \\ \hline 7,357,233 industry 084,895,228 & & 4 & 0 southwest & 317,172 & 175,039 \\ \hline 9,499,352 Industry 088,876,522 & 11.6 & 0 & 0 North & 1,073 & 33,036 \\ \hline 5,976,079 Industry of 4,384,222 & 11.5 & 4 & 0 south & 4,831 & 119,089 \\ \hline 4,607,297 industry 013,419,552 & 7.9 & 0 & 0 East & 2,067 & 13,170 \\ \hline 4,667,283 Industry 043,357,272 & 8.1 & 5 & 0 North & 195,334 & 112,183 \\ \hline 6,428,789 Industry os 5,203,377 & 11.8 & 1 & 0 south & 28,656 & 86,476 \\ \hline 6,144,820 Industry 094,029,558 & 3.8 & 7 & 0 Northwest & 322,822 & 167,573 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 4,257,406 industry 074,236,019 & 6.4 & 0 & 0 Northwest & 1,940 & 116,319 \\ \hline 1,458,177 Industry of 919,488 & 3.1 & 1 & o Capital & 87 & 9,158 \\ \hline 1,600,661 Industry 031,101,323 & 4.8 & 2 & o Capital & 35,274 & \\ \hline 288,905 Industry 08219,894 & 1.6 & 0 & 0 East & 29 & 15,109 \\ \hline 8,418,195 Industry 048,582,114 & 16.2 & 8 & 0 East & 210,075 & 3,371 \\ \hline 3,454,494 Industry 042,117,892 & 9.2 & 1 & 1 south & 20,588 & 6,179 \\ \hline 5,382,648 & 11.4 & 8 & O Capital & 474,348 & 136,947 \\ \hline 265,221 Industry 03174,641 & 0.2 & 1 & 0 East & 3,008 & 21,498 \\ \hline 7,400,716 Industry 086,206,303 & 12.7 & 2 & o Capital & 147,657 & 11,799 \\ \hline 8,783,843 Industry 038,669,665 & 21.1 & 8 & 0 North & 27,783 & 10,037 \\ \hline 4,057,172 Industry 013,469,182 & 4.4 & 2 & 0 East & 59,854 & 16,821 \\ \hline 8,792,906 Industry of 7,775,745 & 10.2 & 3 & 0 West & 198,637 & 114,129 \\ \hline 283,329 Industry 07223,207 & 1.9 & 0 & 0 southwest & 24 & 36,743 \\ \hline 1,433,121 Industry 051,022,069 & 4.1 & 0 & o south & 254 & 56,704 \\ \hline 9,036,323 Industry 017,148,756 & 11.3 & 0 & o Capital & 214 & 0 \\ \hline 5,546,605 Industry 045,055,195 & 6.6 & 6 & 0 Southeast & 117,323 & 53,089 \\ \hline 9,907,239 Industry 019,549,606 & 2.5 & 9 & 0 East & 948,411 & 170,735 \\ \hline 9,326,347 Industry 017,231,691 & 7 & 1 & o Capital & 85,963 & 5,516 \\ \hline 674,709 Industry 07 652,339 & 2.1 & 1 & 0 Northwest & 2,126 & 102,608 \\ \hline 5,495,035 Industry 093,953,647 & 8.2 & 4 & 1 West & 5,732 & 186,718 \\ \hline 9,405,666 Industry 036,759,224 & 9.4 & 3 & 0 North & 135,616 & 28,361 \\ \hline 4,174,471 Industry 03 3,978,619 & 2.5 & 3 & 0 North & 118,721 & 4,757 \\ \hline 5,951,266 Industry 016,180,328 & 3.8 & 1 & 0 East & 9,530 & 17,527 \\ \hline 5,700,873 & 8.9 & 7 & 0 North & 72,277 & 80,348 \\ \hline 7,989,578 Industry 026,048,780 & 11.3 & 0 & 0 East & 2,877 & 14,741 \\ \hline 3,811,792 Industry 043,500,091 & 8.1 & 2 & 0 south & 67,853 & 52,502 \\ \hline 8,681,382 Industry 085,364,330 & 8.8 & 7 & 0 Southwest & 446,839 & 216,029 \\ \hline 8,676,502 Industry 057,326,112 & & 9 & 0 North & 578,646 & 204,927 \\ \hline 1,280,732 Industry 04962,087 & 3.7 & 2 & 0 North & 327 & 25,200 \\ \hline 4,813,792 Industry 034,912,524 & 12.7 & 5 & 0 East & 60,213 & 79,156 \\ \hline 5,552,690 industry 025,421,367 & 2.2 & 3 & 0 North & 71,605 & 88,191 \\ \hline 8,641,317 Industry 047,070,120 & 25.4 & 6 & 0 East & 227,405 & 32,727 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline 1,668,527 industry 041,315,948 & 3.8 & 2 & 0 south & 37,857 & 60,537 \\ \hline 4,681,467 Industry 0S2,851,081 & 5.9 & 5 & 0 Northeast & 183,685 & 248,966 \\ \hline 5,795,188 Industry 055,321,456 & 16.3 & 0 & 0 southeast & 859 & 13,930 \\ \hline 440,900 industry 03279,869 & 2.8 & 1 & 0 East & 16 & 10,067 \\ \hline 8,904,995 Industry 036,191,268 & 24.8 & 5 & 0 North & 149,272 & 44,271 \\ \hline 8,413,400 Industry 0S8,134,782 & 4.1 & 3 & 0 West & 59,830 & 122,658 \\ \hline 1,005,202 Industry 051,025,309 & 2.8 & 2 & 0 North & 5,024 & 29,088 \\ \hline 694,874 industry oe 598,360 & 4.1 & 1 & 0 southeast & 2,122 & 53,938 \\ \hline 6,510,765 Industry 045,691,459 & 8.3 & 0 & 1 North & 174 & 50,281 \\ \hline 4,174,621 Industry 032,849,235 & 7.7 & 6 & 0 East & 118,827 & 59,419 \\ \hline 2,202,341 Industry 011,321,556 & 8.2 & 0 & O Capital & 919 & 0 \\ \hline 6,105,935 Industry oe 5,648,760 & 7.5 & 7 & 0 south & 358,931 & 189,829 \\ \hline 8,930,165 Industry oe 9,144,249 & 11 & 1 & 0 East & 62,178 & 17,200 \\ \hline 2,791,144 Industry 092,058,673 & 5.5 & 4 & 0 West & 102,237 & 54,911 \\ \hline 9,511,860 Industry oe 5,854,672 & 10.3 & 2 & 0 Northwest & 5,028 & 17,087 \\ \hline 5,335,754 Industry 054,763,563 & 4.7 & 3 & 0 southeast & 30,422 & 81,871 \\ \hline 5,746,688 Industry 043,506,091 & 6.5 & & 0 North & 112,428 & 18,247 \\ \hline 4,343,040 Industry oS 3,270,133 & 7 & 5 & 0 East & 65,059 & 64,154 \\ \hline 4,628,197 industry 082,811,748 & 10.8 & 4 & 0 East & 132,540 & 46,841 \\ \hline 2,074,773 Industry 021,409,159 & 1.6 & 1 & 1 East & 2,364 & 31,767 \\ \hline 8,173,878 Industry 055,407,135 & 7.1 & 0 & 0 southwest & 3,668 & 69,881 \\ \hline 2,605,121 industry oe 1,841,207 & & 4 & o Capital & 61,745 & 44,374 \\ \hline 8,371,368 Industry 075,836,687 & 8.7 & 3 & 1 Capital & 277,248 & 78,531 \\ \hline 1,898,214 Industry 081,937,025 & 1.4 & 3 & o Capital & 17,373 & 4,332 \\ \hline 4,436,590 Industry 023,036,977 & 4.9 & 2 & 1 East & 40,922 & 19,883 \\ \hline 7,837,859 Industry 016,925,813 & 11.6 & 0 & 0 East & 802 & 13,990 \\ \hline 5,434,812 Industry 024,618,215 & 3.5 & 3 & 0 East: & 152,815 & 41,492 \\ \hline 8,287,290 Industry 036,704,772 & 3 & 4 & o Capital & 24,688 & 19,458 \\ \hline 9,520,518 industry 036,630,386 & 11.6 & 8 & 0 southeast & 511,998 & 203,166 \\ \hline 6,736,689 Industry oe 5,720,280 & 10.6 & 2 & 0 West & 133,555 & 81,454 \\ \hline 9,958,849 Industry 078,925,178 & 7.3 & 3 & 0 Northwest & 334,575 & 132,423 \\ \hline 6,431,858 Industry 054,374,906 & 3.5 & 2 & 0 West & 73,905 & 112,119 \\ \hline 5,445,180 industry 01,4,927,307 & 9.4 & 0 & 0C & 771 & \\ \hline \end{tabular}