Training
SQL Server Business Intelligence Core Skills
There has never been a better time to have skills in BI (Business Intelligence) and the Microsoft BI platform is well placed in the market. This course is designed to take you through the most important components of the Microsoft BI platform, with just the right amount of depth, within five days.

The course is most suitable for developers that need to learn to work with the Microsoft BI platform or for existing SQL Server developers and DBAs that want to cross-train into BI work. The course can also help business analysts and project managers that need a solid understanding of the technologies involved. While not essential to complete the labs (as full detailed instructions are provided), some knowledge of T-SQL would be helpful.

The course starts by looking at the final result with reporting. The course covers how to build and secure reports using SQL Server Reporting Services and how end-users can make use of Report Builder to create their own reports. On the second day, the course looks at how the Power BI tools (such as Power Pivot, Power View, Power Query, Power Map, Power Q&A, and Power BI Sites) can provide self-service BI options in conjunction with Excel and/or Sharepoint. On the third day, the course looks at creating an underlying data model that is suitable for supporting the reports, using SQL Server Analysis Services. Both the multi-dimensional and tabular data models are discussed. The fourth day shows how the SQL Server Integration tools can be used for ETL (Extract-Transform-Load) processing. The final day covers core concepts in dimensional modelling and how SSIS can be used to populate these models.

While our courses are based on SQL Server 2014, we realise that many customers are not yet running that version. Rather than provide you a course that only covers a single version of SQL Server, our courses are designed to be relevant (wherever possible) to a range of SQL Server versions including SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Server 2014. Where there are differences between versions, the differences are clearly highlighted.

City
Dates
Course Price
Early Bird Price
Melbourne
12 Jan - 16 Jan 2015
$3500+GST
$2975+GST if paid by Jan 2
Sydney
09 Feb - 13 Feb 2015
$3500+GST
$2975+GST if paid by Jan 30
Brisbane
13 Apr - 17 Apr 2015
$3500+GST
$2975+GST if paid by Apr 3
Perth
18 May - 22 May 2015
$3500+GST
$2975+GST if paid by May 8
Canberra
17 Aug - 21 Aug 2015
$3500+GST
$2975+GST if paid by Aug 7
Day
Code
Module
1
RS201
Introducing Server-Based Reporting Services
- Server-based Reporting Fundamentals
- Creating Reports
- Common Report Items
- Deploying Reports
- LAB: Creating and Deploying Reports
1
RS202
Working with Common Report Elements and Creating Dynamic Reports
- Additional Common Report Elements
- Creating Dynamic Reports Using Parameters
- Creating Dynamic Reports Through Links and Document Maps
- LAB: Creating Dynamic Reports
1
RS203
Managing Report Execution and Security
- Extending Reports with Custom Logic
- Reporting from Analysis Services
- Optimising Report Execution
- Securing Report Server Items and Data
- Delivering Reports with Subscriptions
- LAB: Managing Report Execution and Security
1
RS204
End-User Reporting with Report Builder
- Introduction to Report Builder
- Report Models and Earlier Report Builder Versions
- Report Builder 3.0
- Creating Map-Based Reports
- Data-Feeds as Data Sources
- LAB: Report Builder Self-service Reporting
2
PB201
Visualizing Data with Excel, Power View, and Power Map
- Introduction to Power BI
- Creating Pivot Tables and Charts in Excel
- Interactively Visualising Data using Power View
- Interactively Visualising Data using Power Map
- LAB: Visualizing Data with Excel and Power View
2
PB202
Discovering and Preparing Data with Power Query
- Acquiring Data using Power Query
- Preparing Data using Power Query
- Managing Queries and Data Sources in Power Query
- LAB: Discovering and Preparing Data with Power Query
2
PB203
Creating and Enhancing Data Models using Power Pivot
- Creating a Power Pivot Data Model
- Adding Measures and Calculations to Power Pivot Data Models using DAX
- Enhancing a Power Pivot Data Model with Hierarchies, KPIs and Properties
- LAB: Creating Data Models using Power Pivot
2
PB204
Sharing Insights with Power BI Sites and Power Q&A
- Understanding Power BI and Power BI Sites
- Sharing Workbooks using Power BI
- Interacting with Data Using Power Q&A
- Accessing On-Premises Data using the Data Management Gateway
- LAB: Enhancing Power Pivot Data Models
3
AS201
Introduction to SQL Server Analysis Services
- Introduction to Analysis Services
- OLAP and Multi-dimensional Analysis vs Tabular Data Models
- Building Analysis Services Cubes
- LAB: Creating a Cube
3
AS202
Enhancing a Multi-dimensional Cube Design
- Enhancing Cube Dimensions and Forming Hierarchies
- Adding MDX Calculations, Key Performance Indicators (KPIs) and Actions
- Implementing Perspectives, Translations and Cube Write-back
- LAB: Enhancing an OLAP Cube
3
AS203
Creating and Enhancing a Tabular Data Model
- Creating and Importing Tabular Data Models
- Analysis Services vs PowerPivot
- Adding Calculated Columns and Measures with Data Analysis Expressions (DAX)
- Implementing Hierarchies and Perspectives
- LAB: Creating and Enhancing a Tabular Data Model
3
AS204
Processing, Aggregations and Data Mining
- Processing Multi-dimensional Cubes and Deployed Tabular Data Models
- Improving Performance Through Aggregations
- Introduction to SQL Server Analysis Services Data Mining
- LAB: Processing, Aggregations and Data Mining
4
IS201
Overview of SQL Server Integration Services
- Integration Services Features Overview
- Working with SQL Server BI Tooling
- Creating SSIS Projects and Packages
- LAB: Creating SSIS Projects and Packages
4
IS202
Working with SSIS Control Flow
- Introduction to Control Flow Tasks and Precedence Constraints
- Working with Containers
- Passing Information Between Tasks with Variables and Expressions
- LAB: Working with SSIS Control Flow
4
IS203
Working with SSIS Data Flow
- Introduction to Data Flow Data Sources, Destinations and Assistants
- Transforming Data
- Debugging Using Data Viewers and Breakpoints
- LAB: Working with SSIS Data Flow
4
IS204
SSIS Configuration, Deployment, Scheduling and Logging
- Project and Package Configurations
- Deploying Projects or Packages
- Scheduling Package Execution
- Logging Package Activity
- LAB: SSIS Configurations, Deployment, Scheduling and Logging
5
IS301
SSIS Case Study: Dimensional Modelling Core Concepts
- Why Implement Dimensional Models?
- Dimension Table Core Concepts
- Fact Table Core Concepts
- Profiling Incoming Data
- LAB: Dimensional Modelling Core Concepts
5
IS302
Loading Dimension Tables
- Issues with Loading Dimension Tables
- Implementing Slowly-Changing Dimensions
- Implementing Inferred Members
- Useful Additional Transformations
- LAB: Loading Dimension Tables
5
IS303
Loading Fact Tables
- Issues with Loading Fact Tables
- Working with Granularity and Calculations
- Useful Additional Transformations
- LAB: Loading Fact Tables
5
IS304
Designing for Restartability and Performance
- Designing for Restartability
- Improving SSIS Package Performance
- SSIS Tasks vs T-SQL Tasks
- LAB: Designing for Restartability and Performance
Phone: 1300 SQL SQL (1300 775 775) l International +61 1300 775 775 l Fax: +61 3 8676-4913
Copyright 2014 by SQL Down Under | Terms Of Use | Privacy Statement | Client login