Skip to content

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

Pairview Training

Summary

Price
£1,188 inc VAT
Study method
Classroom + online
Duration
2 days · Part-time or full-time
Qualification
No formal qualification
Certificates
  • Certificate of completion - Free
Additional info
  • Tutor is available to students

Location & dates

Location

Address
Level 33
25 Canada Square
East London
London
E145LQ
United Kingdom
View on Map

Overview

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.

Description

  • 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

Questions and answers

Certificates

Certificate of completion

Digital certificate - Included

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: IT, Data analysis, Business