1 / 19

Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services

Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services. Julie Strauss Senior Program Manager Microsoft. Demos. Agenda. Demos. The Next Generation Design Tools. Demos. Demos. Demos. Demos. Demos. Demos. Demos. Demos. Demos. Demos. Demos. Demos.

mahon
Download Presentation

Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing the Next Generation Design Tools for Microsoft SQL Server Analysis Services Julie Strauss Senior Program Manager Microsoft

  2. Demos Agenda Demos • The Next Generation Design Tools Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos Demos

  3. The BI Semantic Model One Semantic Model for BI Powerful and Flexible Enterprise Ready • For reporting, analytics, scorecards, dashboards • For all users – Personal BI, Team BI, Organizational BI • One model for client tools, two ways to build it – tabular and multidimensional Tabular and multidimensional APIs for client tools Tabular and multidimensional modeling environments Sophisticated business logic using DAX and MDX Cached and pass-through storage options Optimized for latest hardware – multi-core, in-memory Supports enterprise grade security and data volumes Professional development and management tools

  4. SeamlessTransitionof the Semantic Model Across BI Spectrum Personal BI Team BI Corporate BI Empowered Aligned My Context BI solution created by user. Context is only for user & exists as document. Our Context BI Solution created by power user. Context is for a small team & it’s managed on a server. The Org’s Context BI Solution created by IT, Established corporate context & is reusable, scalable and backed up. PowerPivot for Excel PowerPivot for SharePoint Analysis Services

  5. Design Tools PowerPivot for Excel BI Development Studio Feels like Visual Studio Feels like Excel One file, Save to SharePoint Optimized for BI Pros It’s a project (business case, budget, dates) Rapid response to business problems Large data volumes Teams building BI solutions Solutions live for weeks or months Deployment scripts, versions • Optimized for Excel power user Source Control, TFS Personal Team Corporate

  6. The Excel Power UserBuilding Models in PowerPivot demo

  7. The IT ProfessionalRestoring Models in SSMS demo

  8. The BI ProfessionalBuilding Models in BIDS demo

  9. Demo Review • Richer Models • KPIs • Descriptions • Persisted formatting • Advanced sorting • Distinct count • Drillthru • Perspectives • Hierarchies • Multiple relationships • Parent child • Optimized Usability • Diagram • Measure grid • Various usability enhancements • Reporting Properties All features available in both PowerPivot and BIDS

  10. Demo Review Pro Features… • Transition Across the BI Spectrum • Restore of PowerPivot models in SSMS • Import of PowerPivot models into BIDS projects • New Tabular Projects in BIDS • DirectQuery • Security • Deployment • Data management: Partitioning • Management of Tabular Databases in SSMS Features specific to BIDS and SSMS

  11. Summary Security Demos KPIs Demos Reporting Properties Drillthru Demos Demos Sort by Other Column Partitions Demos Descriptions Demos Demos Demos SSMS Update Diagram Demos Measure Grid Demos Hierarchies Demos Formatting Demos Demos Demos Perspectives Drag & Drop Relationships Demos Multiple Relationships Demos Demos

  12. Get Ready… • Go Download PowerPivot (www.PowerPivot.com) • Build Solutions, Try it Out • Get Ready for the CTP3 Availability

  13. Related Sessions

  14. What’s Next? • Follow, Tweet and Enter to win an Xbox Kinect Bundle • GAME ON! Join us at the top of every hour at the BI booth to compete in the Crescent Puzzle Challenge and Win Prizes • Sign up to be notified when the next CTP is available at: microsoft.com/sqlserver Join the Conversation @MicrosoftBI /MicrosoftBI

  15. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

  16. Complete an evaluation on CommNet and enter to win!

  17. © 2011 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

More Related