MIS271: Business Intelligence and Data Warehousing - Management Assessment Answer

Subject Code: MIS271 Internal Code: 1AGCCH

Management Assessment Answer

Scenario KoalaAir is a new airline proposing to fly domestic routes exclusively within the United States. With a flurry of low-cost carriers recently entering the US market, the budget-carrier market has undoubtedly become saturated. KoalaAir's business strategy is to become an airline that excels in customer service providing all of the creature comforts to the passenger segment that is willing to pay a higher price. KoalaAir hopes to attract and grow its cashed-up customer base. Your organization, Deakin-BI, is a business intelligence consulting firm that has been contracted to advise KoalaAir on execution of its business strategy going forward. The CIO has revealed that he has access to an extensive collection of data on passenger satisfaction across different airlines. He is pleased to make the dataset available to Deakin-BI to perform data analytics. CIO is adamant that any recommendations provided must stem from a fact-based analysis rather than ‘gut feel’. Assignment Tasks 1. CLEANING AND STANDARDISING THE DATASET Sample dataset is adapted from combining a series of operational databases and surveys. The dataset is susceptible to typical issues encountered in real-life datasets such as inconsistent units, missing data values, outliers, incomplete entries, erroneous entries, etc. First step is to clean and standardise the dataset. You may use Power BI, Microsoft Excel or a combination of both. Outline how this was achieved. What should be included in the report from task 1? I. What problems or issues have you detected in the dataset? II. How were those data issues dealt with?

This Management Assessment has been solved by our Management experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.