A data warehouse is a key component of business intelligence, and is the core of data reporting and analysis. Data is uploaded from systems such as marketing and sales, and is stored with recent data alongside historical. This allows for comparisons to be made, and trends to be observed in terms of a business’ success. A typical data warehouse uses an ‘ETL’ model, meaning that the data goes through a process of extraction, transforming and loading. The end result is an organized, retrievable set of data, often with extraneous data removed during the process through ‘data cleansing’.
Data is organized into hierarchical groups, and categorized as either facts or aggregate facts. Managers and business professionals are then able to use the data for market research and decision support.Punësoni Data Warehouse Experts
Creación de un Datamart que genere 3 reportes diferentes relacionado al área de producción de una repostería. -Definición de tablas de hechos -Creación de ETL -Creación de cubos OLAP -Creación del DataMart
Based on the list of questions the client wants answered (will provide details), in report write what you see as being the most appropriate level of granularity for your data warehouse. Your discussion will need to explain why you have made this choice, and why the alternatives have been discarded. Based on your answer to the above , design a Star Schema that will support the analyses as listed a...