What is new in Microsoft SQL Server Code

SQL Server Client Tools Analysis, Reports, Scorecards, Dashboards, Custom Apps BI Semantic Model Data

SQL Server • All Power. Pivot features • BI Development Studio • No size

SQL Server Highly Visual Design Experience • • • Interactive, web-based authoring and sharing

Power U sers IT Pros ers p o l e Dev Sophisticated Design Environment

Crescent Architecture Share. Point Farm Web Front End BIDS Tabular Model App Server RS

• • Crescent on top of Power. Pivot Crescent on top of a

Slides: 10

Download presentation

• What is new in Microsoft SQL Server Code named “Denali”: • BI Semantic Model • Crescent • Modeling for Project Crescent • Optimizing the model for Crescent • Connecting Crescent to a Tabular model • Set reporting properties • Crescent before and after model optimization

SQL Server Client Tools Analysis, Reports, Scorecards, Dashboards, Custom Apps BI Semantic Model Data model Business logic and queries Data access Data Sources Databases, LOB Applications, Odata Feeds, Spreadsheets, Text Files Personal BI Power. Pivot for Excel Team BI Power. Pivot for Share. Point Organizational BI Analysis Services

SQL Server • All Power. Pivot features • BI Development Studio • No size limit • Scalable • Partitioning • Row level security • Direct. Query

SQL Server Highly Visual Design Experience • • • Interactive, web-based authoring and sharing of information Familiar Microsoft Office design patterns Powerful data layout with banding, callout and small multiples visualizations Rich metadata-driven interactivity • • Fully integrated with Power. Pivot Drive greater insight through smart and powerful querying Zero configuration highlighting and filtering Animated trending and comparisons Presentation-ready at all times • • • Interactive Presentation turns pervasive information into persuasive information Deliver and collaborate through Share. Point Full screen presentation mode for interactive boardroom session

Power U sers IT Pros ers p o l e Dev Sophisticated Design Environment Report Viewer Controls Rich Design Capabilities Report Designer Embedded Productive Authoring Re-use of insights Flexible layout Report Builder Operational End Use rs Visual data representation Highly Interactive Rich Presentation Project “Crescent” Business

Demo Building the perfect model

Crescent Architecture Share. Point Farm Web Front End BIDS Tabular Model App Server RS Server Crescent client RS Web service Excel Power. Pivot Model Power. Pivot web service Power. Pivot System Service AS Server Sharepoint Integrated BISM File (optional) AS Server Tabular mode Direct. Query (Optional) Web Front End DAX extension ADOMD. NET SQL Server

• • Crescent on top of Power. Pivot Crescent on top of a Tabular model Move from Power. Pivot to Tabular model How to optimize model for Crescent • • Download Denali CTP 3 image Download Crescent samples File bugs at Connect What is new for • Analysis Services • Reporting services