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.