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!
- Slides: 26