BUS5WB - Data Warehousing and Big Data Assignment

Assignment Help Database Management System

Reference no: EM132500502

BUS5WB - Data Warehousing and Big Data Assignment - La Trobe University, Australia

Assignment Title - Smart City Design - Data Warehousing and 5G Networks

The first assignment aims to assess your knowledge and skills in data warehouse design and modern networking technologies, in the context of a real-world setting. As we have discovered in lectures and related reading, the design phase is crucial for the effective use of a warehouse and modern networks for analytics and AI strategy.

Melbourne City Council, the local government authority for central Melbourne and the surrounding suburbs, is exploring opportunities and challenges of implementing "Smart City" infrastructure and technologies for effective delivery of facilities and services, as well as efficient management processes.

Having been in local government for the past 30 years, the CEO of the Council is confident that large volumes of data accumulated in operational systems can be capitalised towards the foundations of a "Smart City" analytics infrastructure. She is keen to implement an organisation-wide data warehousing solution to explore this potential. She has approached an analytics consultancy firm to start on this project. The business requirements analysis and feasibility study were completed on a positive note. You have been recruited as the dimensional model specialist to complete the data warehouse design phase.

During the first meeting with senior management of the Council, it was revealed that Urban planning and building regulation, Public events, Community health services, Regulation of food premises, and Waste management, are the primary areas of strategic interest that can equal parts generate new revenue and provide a personalised service to residents and visitors, at scale. There was also discussion about the forthcoming opportunities of new technologies; IoT, 5G and Edge computing that can significantly improve the individual and community experience offered within a Smart City context. Several others raised concerns about the ethical issues of using wearables and sensors to track or monitor individuals, but also drew parallels to other smart city initiatives, in Singapore, Oslo and London.

Following this meeting, the Council conducted a full-day workshop for requirements scoping. A large volume of information about Council operations was shared.

The Council is organised into eight functional units. They are,

1. Executive Services

2. Governance and Organisational Development

3. Strategy, Planning and Climate Change

4. City Design

5. Finance and Corporate

6. City Economy and Activation

7. Capital Projects and Infrastructure

8. Community and City Services

Out of the eight, it was determined that 5) Finance and Corporate, 6) City Economy and Activation, 7) Capital Projects and Infrastructure and 8) Community and City Services are the most data-intensive units that can directly contribute towards strategic insights, and thereby the most relevant for a data warehouse initiative. The head of each unit provided the following summaries of operation.

Tasks -

1. Strategic insights: Based on the information provided, identify current and future strategic decision-making scenarios for a Smart City initiative of the Melbourne City Council.

2. SQL: Using the given ER diagrams, compile SQL statements to address five decision making needs identified above. Use of advanced SQL syntax is recommended, and you are free to make any assumptions with justification

3. Data Warehouse Design: Follow Kimball's four step approach to create a data warehouse design. You must determine the required number of dimensional models, with justification. Each dimensional model should be further improved by applying fact table and dimension table techniques. Demonstrate how the warehouse design facilitates insights generation for current and future decision-making scenarios.

4. 5G Networking: Determine five use cases for the application of 5G and Edge computing technologies within a Smart City context. Provide adequate technical detail and examples that demonstrate your competence in the technologies.

Attachment:- Data Warehousing and Big Data Assignment File.rar

Reference no: EM132500502

Questions Cloud

Solve the sales revenue required to earn net income : Calculate the company's breakeven point in sales dollars and number of units. Your answer should identify the number of Homeowner, OfficeBasic.

Find what was the cost of goods sold for september : Find What was the cost of goods sold for September. In September, Lauren Ashley Company purchased materials costing $240,000 and incurred direct

Identify the fixed and step and variable costs : What is the cost incurred by the campus for 150 people over a 1-week period? Desert Vista Homeless Campus provides shelter and breakfast to individuals.

Compare the competitive outcome with the cartel outcome : Compare the competitive outcome with the cartel outcome. What is the individual firm's incentive to cheat on the cartel? (show the procedure you reach your conc

BUS5WB - Data Warehousing and Big Data Assignment : BUS5WB - Data Warehousing and Big Data Assignment Help and Solution - La Trobe University Australia. Title- Smart City Design - Data Warehousing and 5G Networks

Find context-free grammars generating : Find context-free grammars generating the following languages, and justify that they generate and Describe how to construct a PDA accepting the language L

What are the variable costs and contribution margin : What are the variable costs, fixed costs, and contribution margin? Sales Commissions 280,000 Fixed Advertising Expenses 20,000 Variable Administrative Expenses.

What price will it set for fee : The only golf course in an isolatd town incurs a marginal cost of $5 per round of golf. It wishes to charge a membership fee and a fee per round of golf.

Determine the cournot equilibrium : There are only two firms, A and B, and each has a marginal cost of 2. Determine the Cournot equilibrium.

User Account

All Pages