BI Development By Sam Nasr MCAD MCTS Nasr

BI Development By Sam Nasr, MCAD, MCTS Nasr Information Systems February 5, 2011

Agenda Housekeeping/Introduction Presentation Q&A Evaluations

Housekeeping Bathrooms Vending Machines Forum for learning - Feel free to ask questions Cell Phones on vibrate please

Introduction Sam Nasr Independent Software Consultant Nasr Information Systems Software developer since 1995 MCAD, MCTS(WSS/MOSS) President - Cleveland C#/VB. Net User Group President – Cleveland WPF User Group INETA Mentor for Ohio INETA Community Champ

System Requirements 32 -bit or 64 -bit OS (requirements vary) Windows XP Windows 7 Windows Vista Windows Server 2003 Windows Server 2008 CPU Recommended: 2. 0 GHz or faster RAM: 1 GB minimum 4 GB recommended

Demo Environment Intel core Duo CPU 2. 40 GHz 4 GB RAM 500 GB HD Visual Studio 2010 Ultimate (64 -bit) SQL Server 2008 Enterprise (64 -bit) Windows 7 Ultimate (64 -bit) / Windows Server 2008 Implemented using “Shrink volume…”

Audience Poll How many developers? How many DBA’s aspiring to be developers? . Net Expertise (Jr vs. Sr. ) ?

New BI Features Scalable Data Warehousing Master Data Services Stream. Insight - Complex Event Processing Reporting Services Enhancements Power. Pivot

BI with Office 2010 Can use Excel 2010 and Power. Pivot (free download) before you deploy SQL Server 2008 Analysis Services. With SQL Server 2008 R 2 Analysis Services, you can enable Power. Pivot within Share. Point to manage Power. Pivot workbooks more efficiently. Can enable integration with SQL Server 2008 R 2 Reporting Services using another free download to provide rich reporting features to Information Workers with Share. Point 2010.

New RS Features New Data Sources Expression Language Improvement Layout Control Data Visualization Reusability Report Builder 3. 0 Report Access and Management Share. Point Integration

New Data Sources Share. Point List SQL Azure SQL Server Parallel Data Warehouse SQL Server Power. Pivot for Share. Point (via URL from SSAS)

Exp Language Improvements Lookup Multi. Lookup. Set Aggregation Render. Format Global variables Read/Write variables

Reusability Shared Datasets Cache Refresh Report Parts

Report Builder 3. 0 v 1. 0 – SQL Server 2005 v 2. 0 – SQL Server 2008 V 3. 0 – SQL Server 2008 R 2 Edit Sessions Report Part Gallery

Access and Management Report Manager Improvements Report Viewer Improvements Improved Browser Support RDL Sandboxing Atom Data Feed

Share. Point Integration Improved installation and configuration RS Utility Scripting Share. Point lists as data sources Share. Point unified logging

Demo Report Builder

Layout Control Pagination Properties Data Synchronization Text Box Orientation

Data Synchronization (Before)

Data Synchronization (After)

Text Box Orientation

Data Visualization Data Bars Sparklines Indicators Maps

Demo Data Visualization

Conclusion Let’s recap…

References SQL Server 2008 R 2 – Home http: //www. microsoft. com/sqlserver/2008/en/us/r 2. aspx Requirements for Installing SQL Server 2008 R 2 http: //msdn. microsoft. com/en-us/library/ms 143506. aspx Adventure. Works 2008 R 2 Sample Database http: //msftdbprodsamples. codeplex. com/releases/view/45907

Contact Info E-mail: sam@nasr. info Blog: http: //Cleveland. Dot. Net. blogspot. com Twitter: http: //twitter. com/samnasr Linked. IN: http: //www. linkedin. com/in/samsnasr Speaker. Rate: http: //speakerrate. com/samnasr Thanks for attending!