A wholesale furniture company wants to design a data warehouse for the analysis of the company’s situation with respect to the Furniture, Customers and Time. Moreover, the company needs to analyse:• the furniture with respect to its type (chair, table, wardrobe, cabinet. . . ), category (kitchen, living room, bedroom, bathroom, office. . . ) and material (wood, marble. . . )• the customers with respect to their location, by considering at least cities, regions and statesThe main objective of the company is to know at least the quantity, income and discount of its sales.2|Pagea) Identify facts, measures and dimensions to satisfy the main objectives of the company.b) Design a FACT CONSTELLATION schema to analyse the company’s above needs.

Required informationSkip to questionScaling-Up an Up-Scale Customer Furniture Business This activity is important because there are many different types of businesses that must consider how to manage their operations. This activity highlights the challenges faced by a small customer furniture business in trying to produce enough supply to meet the growing customer demand. Supply is defined as the number of products that businesses are willing to sell at different prices at a specific time. Demand represents the number of goods and services that consumers are willing to buy at different prices at a specific time. In this example, the demand for a product has surpassed a company’s ability to supply the product, and the owner must decide how to manage operations to produce more supply. The goal of this exercise is to demonstrate your understanding of operations management, including planning operations systems and managing the supply chain. Read the case and then answer the questions that follow. Bruce could only attribute his company’s success to luck. His business started as a side project to sell handmade dining room sets at a local farmer’s market. He had created a special finish made from a mixture of varnish and oils and finished in a high temperature in a special industrial oven. The furniture had a unique look, and he originally pursued the business in his spare time. Partially due to Bruce’s gregarious personality, and partially due to a featured article in a local design magazine, Bruce’s furniture was in high-demand by regional customers and was starting to get requests from national and international designers. He could charge more and service custom orders for international clients, but he also wanted to be able to provide affordable furniture to local customers. After all, it was the loyalty of local customers and designers that built his business, and he wanted to be able to continue to fulfill their needs. He found himself embarrassingly behind in order fulfillment. That is, during the summer months when there were frequent orders from individuals seeing his work at the Farmer’s Market, he hated to turn down business. He found himself taking as many orders as he could, then being unable to deliver on his estimated times for completion. Bruce hired a team of craftsman so that he could produce more furniture, but still found himself unable to meet demand. The craftsman were in short supply – he needed individuals who were able to lift heavy equipment and pieces, but also able to do the delicate work necessary to complete the furniture. While he was able to find capable people, many of them needed extensive training in carpentry and woodwork, especially to complete the breadth of tasks necessary to see a piece of furniture built from beginning to end. In addition, Bruce felt like he had to have complete oversight of the purchasing process. For the process to work, it was necessary that the right types of varnishes be paired with the accurate types of wood. Bruce had trouble making sure that he had the supplies he needed so that his craftsman could move quickly on fulfilling orders. Bruce was grateful for the popularity of the furniture he produced but struggled with how to create enough supply to meet his customers' demand.Bruce noticed that the new craftsmen were beginning to understand how to do each process but appeared to be unsure of the order of the processes for different types of furniture. Bruce should engage in which of the following components of operations management?Multiple Choiceschedulingstandardizationroutingcustomizationjust-in-time inventory planning

Data warehouse

Warehouses are critical infrastructures pivotal to the storage and distribution of goods in industrial and commercial sectors. Their expansive dimensions and intricate layouts, however, present signifi

Data Warehouse é “um banco de dados relacional projetado para consulta e análise, em vez de processamento de transações”. Está inserido dentro de um ambiente de processos de extração (extract), transporte (carga/load) e transformação (transform) – ETL – das informações, além de um mecanismo de processamento analítico online (OLAP), entre outras ferramentas que possam agregar informações diversas para auxiliar na tomada de decisão. Algumas características são:I. Baixo nível de granularidadeII. Grande quantidade de dados históricosIII. Tecnologia otimizada para armazenamento e gerência de grandes quantidades de dadosIV. Tecnologia otimizada para acesso de consultas rápidasV. Cada área departamental possui suas características específicasDas alternativas, quais características se referem ao Data Warehouse?I, II e IIII, IV e VIV e VApenas IIIIII, IV e V

Information collected by an organization from a variety of external and internal databases is stored in this special type of database.Multiple ChoiceData warehouseCommercial databaseCompany databaseCompany warehouse