Pragmatic Works SQL Server BI Quick Start accelerates your BI/Data Warehouse project by taking advantage of SQL Server 2005 and 2008 Enterprise scalable architectures. Kick off your BI initiative with confidence using the reliable, pre-tested implementation BI methodology designed by SQL Server MVP and author Brian Knight.

The BI features delivered with Microsoft SQL Server 2005 and 2008 brings insight to your business at no additional licensing cost.

The Pragmatic Works Business Intelligence Quick Start designed by SQL Server MVP and Author Brian Knight will provide you a working prototype in one weeks time.

You can rest easy knowing that aside from their deep technical ability; they are also published authors, conference speakers, Microsoft Certified Professionals, bloggers, and all-around fun guys!

Mary Jackson,
Senior Executive, Stein Mart

Day 1: Discovery and Design
Review existing database environment and establish goals with BI stakeholders. Deliver conceptual database diagram for data warehouse. (See below for “Fast Track” edition activities.)

Day 2: Data Model & ETL
Deliver data model and physical database for fact tables and related dimensions. Implement an SSIS framework to load the data mart. (See below for “Fast Track” edition activities.)

Day 3: Cubing
Demonstrate cube technology with SSAS on top of the data warehouse and KPI functionality.

Day 4: Presentation Layer
Build a sample SSRS report(s) using the cube and data warehouse. Connect Share Point BI Dashboard with KPI’s to Cube and fact tables. Excel power pivot for ad hoc analysis.

Day 5: Review
Review findings and best practices with stakeholders. Transition knowledge to staff members. Deliver roadmap and high level project plan with client guidance..