400 College Dr. Suite 216

Middleburg, FL 32068

Hotline: 904-638-5743

sales@pragmaticworks.com

www.pragmaticworks.com

Making Business Intelligent 4 WEEK BI BLITZ SUMMARY

Week 1:

Build Prototype

Design and build a prototype data warehouse and BI solution. Demo solution to business stake holders.

Week 2:

Design Production Enhancements, Finish ETL

In collaboration with business stakeholders define enhancements to be added during weeks 2-4. Plan mini-sprints, assign tasks, build out SSIS ETL for loading DW and cube.

Week 3:

Cube enhancements

Implement cube enhancements and refresh schedule; Audit cube data; Finalize cube security.

Week 4:

Production deployment

Complete production presentation layer. Validate data; User testing; Performance optimization; Deploy to production; Demo for users; Generate solution documentation set.

EVERY BI BLITZ ALSO INCLUDES:

VIRTUAL MENTORING FOR POST ENGAGEMENT SUPPORT.

BEST OF BREED BI DEV TOOLS: BI XPRESS, TASK FACTORY AND BI DOCUMENTER

BI BLITZ DOES NOT INCLUDE PRODUCTION HARDWARE OR SQL SERVER ENVIRONMENT, BUT WE DO PROVIDE SIZING GUIDANCE AHEAD OF TIME.

SCOPE OF THE BI SOLUTION IS NOT UNLIMITED DUE TO TIME CONSTRAINTS. BUSINESS STAKE HOLDERS MUST PRIORITIZE FEATURES AND PARTICIPATE IN FINALIZING SCOPE DURING WEEK 2. SOLUTION IS TYPICALLY LIMITED TO 3 FACT TABLES AND 8 DIMENSIONS DEPENDING ON COMPLEXITY.

PRAGMATIC WORKS BI ARCHITECT IS PRESENT 2 OF THE 4 WEEKS.

Business Intelligence from concept to deployment in 4 weeks

Develop and deploy a BI Analytics solution into production while your team is mentored on the SQL Server Business Intelligence technologies

The Business Intelligence features delivered

with Microsoft SQL Server bring insight to your business at no additional licensing cost.

The Pragmatic Works BI Blitz engagement

designed by SQL Server MVP and Author Brian Knight will deliver a production solution in 4 weeks’ time.

By participating every step of the way in the BI

Blitz your team learns how to design and build a data warehouse on your own data and systems to create a production BI solution.

Excite your user base and customers with a BI

solution that’s in production and delivering

value after 4 weeks.

SQL Server BI Blitz

Our BI Blitz methodology includes your IT team and business stake holders from day one. During week

one we build a functioning prototype and demo it to stakeholders for buy in and feedback. Then

together we define the enhancements to be developed in weeks 2-4. Every step of the way your IT

team is being mentored and helping to build the solution. Our BI Architect is present and leading the

way during weeks 1 & 2 and works remotely for weeks 3 & 4 to guide the production deployment.

Key Features and Benefits

Impress your business stakeholders by delivering a

production BI solution without the usual delays.

Equip your IT team with the Microsoft BI stack skills

and experience to implement BI rapidly with needed Best Practices and developer tools.

Take advantage of the SQL Server features you

already own.

Targeting a SQL Server 2012 platform? Not a

problem. We have worked with SQL Server 2012

since early betas.

Does your BI roadmap include:

BI on mobile devices?

Fast Track or PDW platforms?

Data Mining and Predictive Analytics?

Not a problem. Ask your representative how we can integrate these into your engagement.