Having a comprehensive database solution is important to any organization but being able to report out on the data and visualize it in ways that provide breakthrough insights is even better. This Microsoft SQL server training course is designed for IT professionals understand how to implement the new features of Microsoft SQL Server 2012 that will enable them to provide insightful and visual reports. The 9 modules of this Microsoft SQL training course will teach you:
- Introduce you to Self-Service Alerting - What’s new in Microsoft SQL Server 2012 Analysis Services and PowerPivot - How to use Power View for insightful visual reports - How to build great Business Intelligence Semantic Models for Power View - Deploying and managing PowerPivot in Microsoft SQL Server 2012 for SharePoint - A Deeper understanding of PowerPivot in Microsoft SQL Server 2012 - How to install and configure Reporting Services in SharePoint Integration mode - An overview of Reporting Services in Microsoft SQL Azure - What's new Microsoft SQL Server 2012 Reporting Services
You will learn how to gain valuable insights from the reports that you create, how to create interactive visual reports and presentations as well as how to move on-premise reports to the cloud using SQL Azure Reporting tools.
Exploring Certification? Free SQL Server Certification Prep Tools
In this session we will cover the new capabilities and enhancements in Reporting Services including Power View, Self-Service Alerting, improved SharePoint integration mode, and SQL Azure Reporting.
This session covers the other big new feature of SQL Server Reporting Services in Microsoft SQL Server 2012: Self Service Alerting. Lots of Demos in this session that will take you from end user Self Service experience to the underlying architecture design. All you wanted to know about this new Alerting services.
In SQL Server 2008 R2, we introduced PowerPivot which is a self-service BI experience that enables information workers to build, share and collaborate on their personal and team BI applications within the familiar environment of Excel and SharePoint. In Microsoft SQL Server 2012, we’re bringing some of the breakthrough technologies in PowerPivot into Analysis Services to support Corporate BI applications. At the same time, we’re also bringing some of the more sophisticated BI capabilities in Analysis Services and making them available to information workers in PowerPivot v2. The goal of this session to bring you up to speed on the new developments in Analysis Services and PowerPivot for the SQL Server 2012 release.
Power View is a brand new ad-hoc visualization experience in Microsoft SQL Server 2012. This session is all about demo, demo, demo so you can experience how the full benefits of what Power View will enable for Self-Service Business Intelligence. It will cover all the latest functionality as well as how to build your PowerPivot workbooks so that you can get the most from your Power View experience.
In this session, we’ll explore what it takes to create the right BI Semantic Models to help your users get the answers they need and insightful results with Power View.
A deep tour of the PowerPivot v2 with SharePoint that is coming in Microsoft SQL Server 2012 including architecture, capacity planning, deployment and management.
This session will provide you with a deep understanding of PowerPivot in SQL Server 2012. PowerPivot empowers Information Workers to build & share BI solutions on their own using familiar tools while maintaining IT control.
We've come a long way from an add-in to a Shared Service for SharePoint. In this session we will discuss the new Reporting Services Shared Service. We'll discuss and identify why we evolved the add-in into a shared service, what the underlying benefits are, and identify the differences. We'll also identify new scenarios this shared service enables, what you need to do to set it up and configure.
From on premise to the Cloud, a software's journey. This session will walk you through all the steps needed to take a report designed on premise and move it to the cloud. From provisioning, to report design and publishing, to Report server tenet management experience, to end user consumption. SQL Azure Reporting will leave no stone unturned and you'll be ready for the cloud at the end of this session. One you don't want to miss.
Free Microsoft Training Delivered by Experts