Real Time Analytic

ANALYTIC REPORT
This is a business analytics project aimed at generating innovative
analytics solutions for a Company. The objective is to analyze the given
datasets from a relevant firm’s perspective in terms of implications and
strategies which the chosen company could adopt to improve its functions,
resources and processes efficiently and effectively.
Project
You are expected to work in groups to find a dataset with minimum of
10,000 rows from publicly available sources. You also need to
hypothetically identify a company (chosen company) who could get
benefits from the analysis of the dataset. You are expected to discuss the
selected dataset with your tutor in labs by Week 7. Please click on the sources
below to access some option to obtain open data:

  1. World Bank Open Data
  2. WHO (World Health Organization) — Open data repository
  3. Google Public Data Explorer
  4. Registry of Open Data on AWS (RODA)
  5. European Union Open Data Portal
  6. FiveThirtyEight
  7. U.S. Census Bureau
  8. Data.gov
  9. UNICEF Dataset
  10. DBpedia
  11. freeCodeCamp Open Data
  12. Australian Govt Data
    Your task is to complete the following tasks:
    Task 1- Background information
    Write a description of the selected dataset and project, and its importance
    for your chosen company. Information must be appropriately referenced.
    [1 Page]
    Task 2- Create Data View/Cube – Data Modelling and Provisioning
    Upon selecting the dataset, convert the dataset into HANA data cube/view
    by following the SAP HANA data modeling and provisioning technique
    Page 2 of 5
    using SAP HANA Web-based development workbench. The name of the
    cube/view should be the student ID of one of the group members.
    Task 3 – Perform Data Mining on data view
    For your project, perform the relevant data analysis tasks on data
    view/cube (created in Task 2) using data mining techniques such as
    classification/association/time series/clustering and identify the BI
    reporting solution and/or dashboards you need to develop for the
    operational manager of the chosen company. [2-3 Pages]
    Task 4 – Research
    Justify why you chose thee BI reporting solution/dashboards/data mining
    technique in Task 3 and why those data sets attributes are present and laid
    out in the fashion you proposed (feel free to include all other relevant
    justifications).
    Note: To ensure that you discuss this task properly, you must include visual
    samples of the reports you produce (i.e. the screenshots of the BI
    report/dashboard must be presented and explained in the written report;
    use ‘Snipping tool’), and also include any assumptions that you may have
    made about the analysis from Task 3. [1-2 Pages]
    Task 5 – Recommendations for CEO
    The CEO of the chosen company would like to improve their operations. Based
    on your BI analysis and the insights gained from your “Dataset” in the lights of
    analysis performed in previous tasks, make some logical recommendations to
    the CEO, and justify why/how your proposal could assist in achieving
    operational/strategic objectives with the help of appropriate references from
    peer-reviewed sources. [2-3 Pages].
    Task 6 – Cover letter
    Write a cover letter to the CEO of the chosen firm with the important data
    insights and recommendations to achieve operational/strategic objectives [1
    page]
    Other Tasks –
    Please refer to the marking scheme at the end of the assignment for other tasks
    and expectations.
    Report Submission:
    • A maximum of 3 people in a group.
    • Check your assignment for plagiarism in turnitin software. Please attach a
    turnitin report along with your assignment. An assignment without a turnitin
    report will not be accepted.
    Page 3 of 5
    • Submit a hard-copy to tutors/lecturers assignment box in week 10. Double-sided
    printing for the hard-copy is encouraged in order to save paper.
    • You will also submit a 9-10 pages report (about 3000 words) not counting
    cover page, references and Appendix) of this project. At least 5 references in
    your report must be from peer-reviewed sources. Include any and all sources of
    information including any person(s) you interviewed for this project.
    • Please note that all references must adhere to APA style. See
    http://owl.english.purdue.edu/owl/resource/560/01 and http://www.apastyle.org/ for
    details on how to format a report and how to cite references. Make sure your follow
    a formal report structure with cover page, introduction, use of headings, subheadings,
    conclusion sand reference section.
    Page 4 of 5
    ITECH7407- Real-Time Analytics
    Assignment 1- Data Analysis- Marking Scheme
    Percentage 20%
    Due Week 11 (Friday 5pm) – Hard and Soft Copies
    Tasks Max
    Marks
    Marks
    Awarded
    Comments
    1- Background of the Project: Description of
    Project, Datasets and firm. The important of
    project for the firm [1+1+1+2]
    5
    2- Create Data View/Cube – Data Modelling and
    Provision – List the various steps with the
    help of screenshots, necessary in your
    modelling and provisioning process of the
    selected dataset to create data cube/view.
    The data view/cube should be named with a
    studentID
    25
    3- Perform Data Mining Technique/s : Perform
    various analysis using SAP expert analysis on
    your created data view cube – [Quality and
    complexity of the analysis –
    association/classification/clustering/time
    series models, dashboard designing and
    relevance for the project]
    25
    4- Research – Justify why these BI reporting
    solution/dashboards are chosen and why
    those attributes are present and laid out in the
    fashion you proposed (feel free to include all
    other relevant justifications).
    Note: To ensure that you discuss this task
    properly, you must include visual samples
    of the reports you produce (i.e. the
    screenshots of the BI report/dashboard
    must be presented and explained in the
    written report; use ‘Snipping tool’), and
    also include any assumptions that you may
    have made about the analysis in your
    assignment report (i.e. the report to the
    operational team of the company).
    [Each analysis/dashboard and report explanation
    with relevant research papers, complexity and indepth of the justification, use of peer-reviewed
    sources] (20 for basic and 5 for advanced)
    15
    5- Recommendations – The CEO of the chosen
    firm would like to improve the operations.
    Based on your BI analysis and the insights
    10
    Page 5 of 5
    gained from “Data Set” in the lights of analysis
    performed in previous tasks, make some
    logical recommendations to the CEO, and
    justify why/how your proposal could enhance
    company operations and could assist in
    achieving operational/strategic objectives.
    [Key data insights, recommendations to
    achieve organisational objectives with
    theoretical justifications with proper
    references. [2+3+5]
    6- Cover letter (Format, key findings and
    recommendation ) [1+1+3]
    5
    7- Other Tasks Report is well-written and
    presented professionally, containing:
    • Title page
    • Table of Contents
    • Introduction
    • Appropriate use of headings within report
    • Appropriate use of figures (i.e. graphs,
    summary tables) and reference to calculations
    and summaries to justify all observations and
    recommendations
    • Overall structure, presentation and formatting.
    Note that the report has to be presented
    formally. It must include discussion of
    calculations, observations and recommendations
    with graphs and/or tables.
    1
    2
    2
    1
    2
    2
    5
    Total Marks 100
    Total Marks out of 20 20%
    You MUST produce the actual visuals in SAP Tools i.e Lumira & Expert Analysis
    If you think the best presentation above is to use, say, only a pie chart, then discuss using
    a pie chart and indicate what the pie chart would show, why you picked the pie chart,
    and so on.
    It may be useful to try with various BI reporting/dashboards/presentations before
    rushing to conclusion.