SQL Server Reporting Services is a powerful tool for data visualization. In addition to providing end users the data they need in an endless variety of ways, it is also a great first step for those wanting to enter the realm of BI.
- In this course, you’ll learn to set up subscriptions, data-driven subscriptions and the new data alerts available starting in SQL Server 2012
- Learn how to automate delivery of SSRS reports, how to use a subscription to pre-cache reports so performance is at its best when users log on first thing in the morning
- Learn how to create a columnar report that grows vertically as well as horizontally and how to do more useful things with fewer reports
- Learn to create a meaningful dashboard and provide the ad-hoc functionality that is necessary to dig deep into the data and have a look at the functionality and limitations of Excel, PerformancePoint and Power View
- Learn to build dynamic datasets that will allow users to change the fields represented in an SSRS report
- Understand the worst practices of Reporting Services Designs
- Understand the new features that can be used to create an “Information Portal” for reports, Business Intelligence, and Mobile data on SSRS 2016
Power View has the capability of creating eye-popping visualizations within SharePoint and Excel 2013. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions.
- Learn to create Power View reports from organizing a PowerPivot source to preparing the actual Power View report
- Learn how to combine these technologies to build interactive dashboards without losing the power of Reporting Services, with dynamic measures and chart axes
- Learn to visualize and measure strategy to executing
- Learn how to create a strategy map diagram in Visio, KPIs in Performance Point and connect them together to create an interactive visualization
Visio is the tool of choice for visualizing process flow – in this session, Mark will demonstrate connecting Visio objects to data from tables and cubes, and deploy this diagram to Visio services to show an updating diagram useful for monitoring process flow.
- Learn some real-world subscription requests and how to implement them
- Understand SQL administrators, who are now responsible for SharePoint’s DBs
- Learn Farm sizing’s & architecture to considerations for Enterprise Search and considerations for crawling the dreaded G:\, H:\ Z:\ drives, to the myriad of SharePoint Databases and which to watch out for and finally what tasks in SharePoint are the heavyweights in terms of IOPS, CPU & RAM
Excel Services is an extremely powerful tool that you can use inside your environment to help improve workflow and collaboration.
- Learn how to use Excel Services, Power View, PowerPivot, Report Builder and Power View for ad-hoc reporting
- Learn how to cascade report parameters, use .Net functions in your reports, and create subscrip..
- Learn to build beautiful dashboards for your organization in SSRS using some of the SQL Server 2008 R2 SSRS features
- Learn about Performance Point’s business intelligence capabilities, combining analytic charts with scorecards to enable rich visualizations of business data
Course Features
- Lectures 27
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 8542
- Certificate Yes
- Assessments Yes