Transcript Document

• 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
Data model
Business logic
and queries
Data access
Personal BI
PowerPivot for Excel
Team BI
PowerPivot for
SharePoint
Organizational BI
Analysis Services
SQL Server
•
•
•
•
•
•
•
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 PowerPivot
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 SharePoint
Full screen presentation mode for interactive boardroom session
Sophisticated
Design Environment
Report
Viewer Controls
Rich Design
Capabilities
Report Designer
Embedded
Productive
Authoring
Re-use
of insights
Flexible
layout
Report Builder
Operational
Visual data
representation
Highly
Interactive
Rich
Presentation
Project “Crescent”
Business
Crescent Architecture
SharePoint Farm
Web Front End
BIDS
Tabular Model
App Server
RS Server
Crescent client
RS Web
service
Excel PowerPivot
Model
PowerPivot
web
service
PowerPivot
System
Service
AS Server
Sharepoint
Integrated
BISM File
(optional)
AS
Server
Tabular
mode
DirectQuery
(Optional)
Web Front End
DAX
extension
ADOMD.
NET
SQL Server
•
•
•
•
Crescent on top of PowerPivot
Crescent on top of a Tabular model
Move from PowerPivot to Tabular model
How to optimize model for Crescent
•
•
•
•
Download Denali CTP3 image
Download Crescent samples
File bugs at Connect
What is new for
• Analysis Services
• Reporting services