Building BI Reporting suite with SQL Server Reporting Services (SSRS)

his course provides the knowledge and skills of carrying out tasks to meet demanding requirements
using SQL Server Reporting Services.

Course Duration: 2 days (full-time) 

Daytime Classes | Evening Classes | Virtual & Online Classes                                                        

   

You will learn to…

Produce reports with enhanced visualisation features

Install parameters into reports

Produce reports through Report Server and SharePoint

Leverage SSRS to extract insights from data

Produce reports on SSAS cubes with Report Builder and Report Designer

About this course

This course provides the knowledge and skills of carrying out tasks to meet demanding requirements using SQL Server Reporting Services. Also, you will learn how to provide insights from data and develop business reporting skills with enhanced visualisation features.

4 Benefits of booking this course with us

Book Now
HOW DO YOU LIKE TO ATTEND?
With a strong presence in all the main sites across of UK, Pairview dedicate all the efforts to deliver the most full superior learning experience. Our Education Centre classrooms are designed to provide a unique, inspiring and secure learning environment . Our experienced trainers take our delegates to the next level, supporting all their needs, giving them the skills-set to be ahead of the most in-demand tools of this field.

ENROL NOW

IN-Class

Enjoy a broad choice of courses/ classes and dates – choose from all available of dates and course events anywhere in the UK. Choose one of the Pairview’s site classrooms across of UK to have your training classes. Our classrooms are designed to leverage sophisticated training technology with LIVE virtual classes in order to give you the most live and superior learning experience.

With our virtual classes you can attend to all training sessions in any Pairview’s site classrooms. You will be LIVE in the session and you will be able to communicate easily in real time with your course instructor and classmates – ask questions, get clarification and contribute your insights – everything with live voice and image.


Online – via AnyWhere

Attend all the training sessions Online – via AnyWhere. Control an LIVE in-class computer using our own Pairview’s interface. You will be able to communicate easily in real time with your course instructor and classmates – ask questions, get clarification and contribute your insights – everything with live voice and image. Your instructor will be able to see exactly how you’re doing and can interactively support you at the moment just like in a classroom.

You Can be in your home or in the other part of the world. With this solution you can attend all the Training Courses online – via AnyWhere.

Avoid long journeys to attend your training sessions in some particular site, save your time and your money with this singular option.

ENROL NOW

Testimonials

“The facilitator is very knowledgeable with years of experience, the course delivery was exceptional.”
Anonymous, Course Feedback Form

Related Courses

Share this Training Course

Course Content

Book Now
  • Module 1: Building and Modifying an OLAP Cube
    Classifying measures and their suitable granularities
    Adding new measure groups and creating custom measures
  • Module 2: Creating Dimensions
    Carrying out a Star and Snowflake Schema
    Classifying role-play dimensions
    Adding dimension attributes and properties
  • Module 3: Hierarchies
    Building natural hierarchies and creating attribute relationships
    Discretising attribute values with the Clusters and Equal Areas algorithms
  • Module 4: Key Attributes
    Defining parent and key attributes
    Generating level captions with Naming Template
  • Module 5: Storing Dimension Data in Fact Tables
    Building a degenerate dimension
    Configuring fact relationships
  • Module 5: Saving Space with Referenced Dimension Relationships
    Identifying candidates for referenced relationships
    Utilising the Dimension Usage tab to configure referenced relationships
  • Module 6: Including Dimensions with many-to-many Relationships
    Implementing intermediate measure groups and dimensions
    Reporting on many-to-many dimensions without double counting
  • Module 7: Implementing a Tabular Model Database
    Providing users with analytics via x Velocity and Power Pivot
    Comparing DAX with MDX
    Mapping out the role of SharePoint
  • Module 8: Managing Cubes
    Choosing between ROLAP, MOLAP and HOLAP
    Partitioning cubes for improved performance
    Designing Aggregations with Aggregation Design Wizard
    Leveraging the Usage-Based Optimisation Wizard
  • Module 9: Automating Processing and Deployment
    Exploiting XMLA scripts and SSIS
    Refreshing cubes with Proactive Caching
  • Module 10: Retrieving Data with MDX
    Defining tuples, sets and calculated members
    Querying cubes with MDX
  • Module 11: Monitoring Business Performance with KPI’s
    Building goal, status and trend expressions
    Using Parallel Period to compare past time periods
    Simplifying KPI definitions using KPI Value and KPI Goal
  • Module 12: Enhancing Cubes with MDX
    o Adding runtime calculations to the cube
    o Adding drill-through and URL actions
  • Module 13: Determining the Correct Model
    Identifying business tasks for data mining
    Training and testing data-mining algorithms
    Comparing algorithms with the accuracy chart
  • Module 14: Performing Real-World Predictions
    Classifying with Decision Trees, Neural Network and Naive Bayes algorithms
    Predicting with the Time Series algorithm
This course is intended for Application Developers, Administrators, Database Developers, Data Analysts and Managers.

You will need to have knowledge of SQL Server Integration Services and Analysis Services to take this course.

£990.00 per person, ex VAT

£891.00 per person, ex VAT