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.

Course Price
Early Bird Price
29 Aug - 2 Sep 2016
$2975+GST if paid by Aug 19
26/9, 27/9, 5/10, 6/10, 7/10
$2975+GST if paid by Sep 23
Introducing Server-Based Reporting Services
- Server-based Reporting Fundamentals
- Creating Reports
- Common Report Items
- Deploying Reports
- LAB: Creating and Deploying Reports
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
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
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
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
Discovering and Preparing Data with Power Query and Power BI Desktop
- 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
Creating and Enhancing Data Models using Power Pivot and Power BI Desktop
- 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
Creating and Querying Dashboards with the Power BI Site and Power Q&A
- Working with the Site
- Creating Datasets, Reports, and Dashboards
- Interacting with Data Using Power Q&A
- Using Power BI Desktop and Apps
- Accessing On-Premises Data via Gateways
- LAB: Enhancing Power Pivot Data Models
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
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
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
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
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
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
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
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
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
Loading Dimension Tables
- Issues with Loading Dimension Tables
- Implementing Slowly-Changing Dimensions
- Implementing Inferred Members
- Useful Additional Transformations
- LAB: Loading Dimension Tables
Loading Fact Tables
- Issues with Loading Fact Tables
- Working with Granularity and Calculations
- Useful Additional Transformations
- LAB: Loading Fact Tables
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 2016 by SQL Down Under | Terms Of Use | Privacy Statement | Client login