University : Dublin Business School UniLearnO is not sponsored or endorsed by this college or university.
Assignment Task :

PART I  

Design and Implement a Data Warehouse/Data Mart (proof of concept) and develop BI reports based on it 

1. Data Warehouse is developed to obtain business intelligence from data. Develop a proof of concept data warehouse/mart (using dimensional model) capturing data from an existing data source(s).  Document your reasons for selecting the subject area(s), identify key stakeholders, formalise the business vision for developing the data warehouse from the given data source.  Also explain the insights that a company may attain from the given data.  It should be reflected in the SSRS reports and Tableau visuals.   

Develop a dimensional model/star schema for developing Data warehouse. 

3. Implement the data warehouse in SQL Server by creating dimension and fact tables. Write SQL code for ETL or use an ETL tool to populate the data warehouse from operational database(s)/sources.

4. Develop 4 reports using SQL Server Reporting Services (SSRS) demonstrating BI.

5. Using your data warehouse, develop a dashboard in Tableau with four different multi-dimensional visualisations presenting data analysis/analytics of your data using several features such as colours, calculated fields, filters, trend lines, etc.  

6. Conclusions / Bibliography.

7. Include all code in Appendices.

Write a report to include all the above sections. 

                                           

PART II

You are required to carry out a series of analyses on a dataset and develop a predictive model using the Python programming language used in this module. The dataset can be obtained from data warehouse implemented as first part of your assessment or from some other source. Dataset should have at least 1,000 records (rows). 

 

You are required to: 

  • Prepare and analyse the data using a number of techniques in Python

  • Explore the data by implementing several data visualisations 

  • Develop a model using suitable data mining algorithms

  • Analyse the results and provide a comparative evaluation using different data mining and visualisation methods.

 

You are required to compile a report of your analysis. Your report (Word document) should provide unique insights based on your data analysis. Examples of insights might include relationships, trends/patterns, correlations, models based on the data, visuals, etc. 

All the Python code elements must be included in an appendix. Dataset or link to dataset must be uploaded.

 

This Business Assignment has been solved by our Business  Experts at UniLearnO. 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.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

 

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Grace
  • Posted on : January 21st, 2018

Whatsapp Tap to ChatGet instant assistance