Scribd
Upload
3 views9 pages

Business Intelligence Project Overview

The document outlines a course project focused on developing a data warehouse for analyzing complications in pregnancy, emphasizing its importance in improving healthcare provider performance and patient outcomes. It details the project's goals, data source tables, transformations, target tables for the data warehouse, data aggregation for reporting, and quality assurance tests. Additionally, it includes sections for authorship and references used in the project.

Uploaded by

razdadon777
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views9 pages

Business Intelligence Project Overview

The document outlines a course project focused on developing a data warehouse for analyzing complications in pregnancy, emphasizing its importance in improving healthcare provider performance and patient outcomes. It details the project's goals, data source tables, transformations, target tables for the data warehouse, data aggregation for reporting, and quality assurance tests. Additionally, it includes sections for authorship and references used in the project.

Uploaded by

razdadon777
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Business Intelligence

Course Project

Project Subject
(e.g.: A data warehouse for the analysis of complication in pregnancy)

Authors: ______________________ ID: _____________________

______________________ _____________________

______________________ _____________________
Introduction

In this section you have to explain the importance of the project, why it is needed, how it can impact
on the healthcare provider / professional performance and the possible effects on patient’s health,
disease or lives.
Goals

In this section you have to state the goal of the project. Please be specific and give a general goal
that describes what you did, and give then the steps that are needed to achieve this goal.
Source tables

Describe here the tables used as the source of your data. Fill in the following table with the relevant
data. Please add only the relevant tables/columns for your specific project

Source Table Source Column Column Unique Min/Max Description


Type values values
Transformations

In this section you need to describe the transformation you make to your data which were needed
to prepare for the generation of the Data warehouse. Describe the programs / languages that you
used to assess this section. Copy here also the code for each transformation, and explain in detail
the goal of the transformation and how you achieved this. All the tables generated on this phase are
populated separately from the source database, by creating a Stage area (a new database called
“stage_area”).
Data Warehouse (Target Tables)

In this section you have to describe the tables you generated, the relations between them (keys) and
describe which kind of data added to each table. The tables must include dimension tables and a
central fact table as described by Kimball.

Fig 1. Example of the tables and their relations for a DWH.


Data Aggregation

To check the generated DWH, you have to create a “case study” composed of an aggregation of the
data that could be used for the generation of a report. Please use the most relevant data from each
of the dimensions and from the fact table.
Quality Assurance

In this section you have to describe the tests you made to check the validity and reliability of the
data. The tests should be based on the aggregation done in the previous section, and have to be
done on a separate excel file. Please describe here the result of the tests (in addition to those tests,
you must include here the total number of rows on each table in the DWH).
References

In this section cite the papers and sites that you have used on this work.

You might also like