BI: Building the Data Warehouse Lesson 3

Designing a New Data Warehouse Blue Print
Korry Kelley | Lesson 3


In this lesson I have loaded and reviewed the NorthwindLite DB and determined what fields I needed to include in my data warehouse blue print. Please see details illustrated and called out below:

The image above illustrates that I’ve loaded the NorthwindLite OTLP and table/field associations and key connectors.

The image above illustrates the source NorthwindLite OLTP fields and naming convention

    

The image above illustrates the fields I chose to include from the source into my data warehouse blueprint

§  I chose to convert all Key Fields to int type

§  Any ‘Money’ types I chose to convert to ‘decimal(18,4)’ to avoid any compatibility issues

§  For any char types in the source I chose to convert to either ‘nvarchar(30)’ or ‘nvarchar(35)’ for consistency (Size) and compatibility (Unicode)

 

 

 

BI: Building the Data Warehouse Lesson 2

Microsoft Procurement BI Solution Planning Process
Korry Kelley | Lesson 2

Above summarizes the initial business need and what the high level requirements are with regard to the Microsoft Procurement Spend BI Solution.














Above defines naming conventions and states required tables and process needed for each of early step in the development process.








Above defines the required attributes and the source they can be located and designates the data type they need to be









Above are the team members on this project















Above are the roles the team members are going to be responsible for








Above is the estimated project timeline to complete BI Solution













Above illustrates that the ProcurSpend data base has been created with all required tables in the table tree, as well as, the table mapping by primary and foreign keys tying the Dimensions Tables to the Fact Table.