The Knowledge Academy Logo
The Knowledge Academy Logo
+61 1-800-150644 - Available 24/7

Send us your message.

X

Implementing Data Models And Reports With SQL Server M20466 - Australia

Key points about this course


Duration: 5 Days*

Exam: Implementing Data Models and Reports with Microsoft SQL Server

Accredited: Yes

Support: 24/7

Dates & Prices Enquire
  • Microsoft accredited training provided by the largest global training company.
  • Receive experienced tuition from our expert Microsoft training instructors.
  • Our Microsoft training courses are fully accredited by Microsoft.

Available delivery methods for this course

Classroom Icon

Classroom

Virtual Icon

Live Virtual

Onsite Icon

In-house

Course Information

Implementing Data Models and Reports with SQL Server 2014 Course Overview | M20466

This 5-day course focuses on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course is designed for delegates who are interested in learning SQL Server 2012 or SQL Server 2014. It covers the new features in SQL Server 2014 as well as the important capabilities across the SQL Server data platform. This Implementing Data Models and Reports with SQL Server course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.

After completing this course, delegates will be able to:

  • Describe the components, architecture, and nature of a BI solution
  • Create a multidimensional database with Analysis Services
  • Implement dimensions in a cube
  • Implement measures and measure groups in a cube
  • Use MDX Syntax
  • Customise a cube
  • Implement a Tabular Data Model in SQL Server Analysis Services
  • Use DAX to enhance a tabular model
  • Create reports with Reporting Services
  • Enhance reports with charts and parameters
  • Manage report execution and delivery
  • Implement a dashboard in SharePoint Server with PerformancePoint Services
  • Use Data Mining for Predictive Analysis

Implementing Data Models and Reports with SQL Server 2014 Course Outline | M20466

This course includes the following modules:

Module 1: Introduction to Business Intelligence and Data Modelling

As SQL Server database professionals, delegates may be required to participate in, or perhaps even lead, a project with the aim of implementing an effective enterprise BI solution. Therefore, it is important that they possess a good understanding of the various elements that comprise a BI solution, the business and IT personnel typically involved in a BI project, and the Microsoft products that can be used to implement the solution.

Lessons:

  • Introduction to Business Intelligence
  • The Microsoft Enterprise BI Platform

Lab: Exploring a BI Solution

Module 2: Creating Multidimensional Databases

This module provides an introduction to multidimensional databases and introduces the core components of an Online Analytical Processing (OLAP) cube.

Lessons:

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

Lab: Creating a Multidimensional Database

Module 3: Working with Cubes and Dimensions

This module describes how to create and configure dimensions and dimension hierarchies in an Analysis Services multidimensional data model.

Lessons:

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Hierarchies

Lab: Working with Cubes and Dimensions

Module 4: Working with Measures and Measure Groups

This module describes measures and measure groups. It also explains how they can be used to define fact tables and associate dimensions with measures.

Lessons:

  • Working with Measures
  • Working with Measure Groups

Lab: Configuring Measures and Measure Groups

Module 5: Introduction to MDX

This module describes the fundamentals of MDX and explains how to build calculations, such as calculated members and named sets.

Lessons:

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

Lab: Using MDX

Module 6: Customising Cube Functionality

This module describes how to enhance a cube with Key Performance Indicators (KPIs), actions, perspectives, and translations.

Lessons:

  • Implementing Key Performance Indicators
  • Implementing Actions
  • Implementing Perspectives
  • Implementing Translations

Lab: Customising a Cube

Module 7: Implementing an Analysis Services Tabular Data Model

This module describes Analysis Services tabular data models and explains how to develop a tabular data model using the SQL Server Data Tools for Business Intelligence (BI) add-in for Visual Studio.

Lessons:

  • Introduction to Tabular Data Models
  • Creating a Tabular Data Model
  • Using an Analysis Services Tabular Data Model in an Enterprise BI Solution

Lab: Implementing an Analysis Services Tabular Data Model

Module 8: Introduction to Data Analysis Expression (DAX)

This module explains the fundamentals of the DAX language. It also explains how delegates can use DAX to create calculated columns and measures, and how they can be used in your tabular data models.

Lessons:

  • DAX Fundamentals
  • Using DAX to Create calculated Columns and Measures in a Tabular Data Model

Lab: Creating Calculated Columns and Measures by using DAX

Module 9: Implementing Reports with SQL Server Reporting Services

This module introduces Microsoft SQL Server Reporting Services and discusses the tools and techniques that a professional BI developer can use to create and publish reports.

Lessons:

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports Using Parameters

Lab: Creating a Report with Report Designer

Module 10: Automating Report Execution and Delivery

This module describes how to apply security and report execution settings, and how to create subscriptions to deliver reports.

Lessons:

  • Managing Report Security
  • Managing Report Execution
  • Delivering Reports with Subscriptions and Data Alerts
  • Troubleshooting Reporting Services

Lab: Implementing Report Subscriptions

Module 11: Delivering BI with SharePoint PerformancePoint Services

This module introduces Microsoft SharePoint Server as a platform for BI, and then focuses on building BI dashboards and scorecards with PerformancePoint Services.

Lessons:

  • Introduction to SharePoint Server as a BI Platform
  • Planning Security for a SharePoint Server BI Solution
  • Planning for PerformancePoint Services

Lab: Implementing PerformancePoint Services

Module 12: Performing Predictive Analysis with Data Mining

This module introduces data mining, describes how to create a data mining solution, how to validate data mining models, how to use the Data Mining Add-ins for Microsoft Excel, and how to incorporate data mining results into Reporting Services reports.

Lessons:

  • Overview of Data Mining
  • Using the Data Mining Add-in for Excel
  • Creating a Custom Data Mining Solution
  • Validating a Data Mining Model
  • Connecting to and Consuming Data Mining Data

Lab: Using Data Mining to Support a Marketing Campaign

Who should attend this Microsoft SQL Server Training?

This course is intended for delegates who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions. Their responsibilities may include:

  • Implementing analytical data models, such as OLAP cubes
  • Implementing reports and managing report delivery
  • Creating business performance dashboards
  • Supporting data mining and predictive analysis

Prerequisites

Before attending this course, delegates should possess or be able to demonstrate:

  • At least 2 years’ experience of working with relational databases
  • Designing a normalised database
  • Creating tables and relationships
  • Querying with Transact-SQL
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas)
  • Some exposure to basic programming constructs (such as looping and branching)
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable

 

Please arrive at the venue at 8:45am.
The course is aimed at anybody who wishes to expand their skills with SQL Server 2014.
Anyone who is interested in pursuing a career in IT or Microsoft Technologies.
We are able to provide support via phone & email prior to attending, during and after the course.
Delegate pack consisting of course notes and exercises, Manual, Experienced Instructor, and Refreshments
This course is 5 day(s)
Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts
The price for Implementing Data Models and Reports with SQL Server M20466 certification in Australia starts from $1599
The Knowledge Academy is the Leading global training provider in the world for Implementing Data Models and Reports with SQL Server M20466.

Implementing Data Models and Reports with SQL Server 2014 Exam Information | M20466

 

What's included in this Microsoft SQL Server Course?

  • Delegate pack consisting of course notes and exercises
  • Manual
  • Experienced Instructor
  • Refreshments

Key points about this course


Duration: 5 Days*

Exam: Implementing Data Models and Reports with Microsoft SQL Server

Accredited: Yes

Support: 24/7

View dates & prices

Find out more

Please enter Name
Please enter valid Email
Please enter valid phone
The information you provide shall be processed by The Knowledge Academy – a professional training company. Your data shall be used by a member of staff to contact you regarding your enquiry. View privacy policy

We cannot process your enquiry without contacting you, please tick to confirm you consent to us contacting you about your enquiry

Or call us now
+61 1-800-150644

Implementing Data Models And Reports With SQL Server M20466 Dates & Prices

Select your preferred delivery method

Choose a Region

Choose a Location

Choose a Month

Office Icon Attend your course from the office or home
Trainers Icon Interactive support from experienced trainers
Simple Icon Simple to setup and easy to use on any device
Brisbane
Mon 9th Dec 2019
Places available
$5995
Mon 9th Dec 2019
Places available
$5995
Sydney
Mon 16th Dec 2019
Places available
$5995
Adelaide
Mon 16th Dec 2019
Places available
$5995
Mon 13th Jan 2020
Places available
$6495
Canberra
Mon 20th Jan 2020
Places available
$6695
Adelaide
Mon 20th Jan 2020
Places available
$7595
Perth
Mon 20th Jan 2020
Places available
$7595
Melbourne
Mon 20th Jan 2020
Places available
$6695
Brisbane
Mon 20th Jan 2020
Places available
$7595
Sydney
Mon 20th Jan 2020
Places available
$6695
Mon 24th Feb 2020
Places available
$6495
Melbourne
Mon 16th Mar 2020
Places available
$6695
Brisbane
Mon 16th Mar 2020
Places available
$7595
Sydney
Mon 16th Mar 2020
Places available
$6695
Canberra
Mon 16th Mar 2020
Places available
$6695
Adelaide
Mon 16th Mar 2020
Places available
$7595
Perth
Mon 16th Mar 2020
Places available
$7595
Mon 30th Mar 2020
Places available
$6495
Mon 20th Apr 2020
Places available
$6495
Mon 4th May 2020
Places available
$6495
Sydney
Mon 18th May 2020
Places available
$6695
Melbourne
Mon 18th May 2020
Places available
$6695
Brisbane
Mon 18th May 2020
Places available
$7595
Canberra
Mon 18th May 2020
Places available
$6695
Adelaide
Mon 18th May 2020
Places available
$7595
Perth
Mon 18th May 2020
Places available
$7595
Mon 1st Jun 2020
Places available
$6495
Mon 6th Jul 2020
Places available
$6495
Canberra
Mon 20th Jul 2020
Places available
$6695
Adelaide
Mon 20th Jul 2020
Places available
$7595
Perth
Mon 20th Jul 2020
Places available
$7595
Sydney
Mon 20th Jul 2020
Places available
$6695
Melbourne
Mon 20th Jul 2020
Places available
$6695
Brisbane
Mon 20th Jul 2020
Places available
$7595
Mon 10th Aug 2020
Places available
$6495
Mon 7th Sep 2020
Places available
$6495
Canberra
Mon 21st Sep 2020
Places available
$6695
Adelaide
Mon 21st Sep 2020
Places available
$7595
Perth
Mon 21st Sep 2020
Places available
$7595
Brisbane
Mon 21st Sep 2020
Places available
$7595
Sydney
Mon 21st Sep 2020
Places available
$6695
Melbourne
Mon 21st Sep 2020
Places available
$6695
Mon 5th Oct 2020
Places available
$6495
Mon 2nd Nov 2020
Places available
$6495
Brisbane
Mon 16th Nov 2020
Places available
$7595
Sydney
Mon 16th Nov 2020
Places available
$6695
Melbourne
Mon 16th Nov 2020
Places available
$6695
Canberra
Mon 16th Nov 2020
Places available
$6695
Adelaide
Mon 16th Nov 2020
Places available
$7595
Perth
Mon 16th Nov 2020
Places available
$7595
Mon 14th Dec 2020
Places available
$6495

Complete the steps below to receive a quote or more information

How will you be funding your training?

Self funding

Company funding

Not sure

Key points about this course


Duration: 5 Days*

Exam: Implementing Data Models and Reports with Microsoft SQL Server

Accredited: Yes

Support: 24/7


Why choose TKA logo


Gold Tag

Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.

Trusted Icon

Trusted & Approved

Microsoft Silver Learning Partner

Delivery Icon

Various delivery methods

Flexible delivery methods are available depending on your learning style.

Resource Icon

Resources

Resources are included for a comprehensive learning experience.

Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

Google Logo
Samsung Logo
Shell Logo

"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."

Diane Gray, Shell

hsbc-logo
mercedes-logo