Enable Technology

Training 

Training

Enable Technology offer onsite bespoke training delivered at your premises. We can provide a detailed understanding of how the Microsoft BI Stack can be used to create data warehouse and reporting solutions.

We have particular expertise in combining Excel, VBA and SQL to create surprisingly powerful reporting solutions without the need for custom reporting software.

We will provide the equipment, teaching materials and all training is delivered by Microsoft Certified Experts (MCSE).

Enable Technology can offer on site delivery in the following two day Business Intelligence courses

Please feel free to contact us if you would like to discuss either our standard on site courses or additional Business Intelligence training requirements.


 

SQL Course Content


Relational Databases
Tables  
Rows
Columns  
Relationships  
Data types    
Primary Keys 
Foreign Keys 
Relational Database Management System  
Popular Databases   

Simple SELECT Statements
Comments
Whitespace and Semi-colons 
Case Sensitivity 
Selecting All Columns in All Rows 
Selecting Specific Columns
Sorting Records  
Sorting By a Single Column
Sorting By Multiple Columns   
Sorting By Column Position 
Ascending and Descending Sorts        

The WHERE Clause and Operator Symbols  
Checking for Equality 
Checking for Inequality     
Using the WHERE clause to check for greater or less than
Checking for NULL  
WHERE and ORDER BY   

The WHERE Clause and Operator Words    
The BETWEEN Operator    
The IN Operator  
The LIKE Operator    
The NOT Operator  

Checking Multiple Conditions  
AND 
OR 
Order of Evaluation  

Advanced SELECTs     
Calculated Fields 
Concatenation
Mathematical Calculations 
Aliases 
Aggregate Functions 
Grouping and Aggregating Data     
Selecting Distinct Records 
Common Math Functions     
Common String Functions
Common Date Functions 

Subqueries, Joins and Unions 
Subqueries       
Joins
Table Aliases   
Multi-table Joins   
Outer Joins 

Conditional Processing with CASE

CASE syntax
Using CASE 

Inserting, Updating and Deleting Records
INSERT
UPDATE
DELETE    

Creating and Modifying Tables  
Data Types
Creating Tables
NULL Values  
Primary Keys
Foreign Keys    
Creating Tables
Adding and Dropping Columns 
Renaming Tables     
Dropping Tables 

Views   
Creating Views
Dropping Views 
Benefits of Views  

Stored Procedures 
Creating Stored Procedures  
Dropping Stored Procedures 
Benefits of Stored Procedures

Return to Menu


 

SSRS Course Content


Introduction to SQL Server Reporting Services
Reporting Services Modes
Installing and Configuring Reporting Services

Reporting Services Architecture
Native Mode Architecture
Service Architecture 

Report Building Tools
Report Builder vs. Report Designer
Build a Simple Report
Report Definition Language (RDL)
Creating a Customer Contact List 

Creating Ad Hoc Reports With Report Builder
Introduction to Report Builder
Report Builder Installation and Execution Options
A Tour of the Report Builder Interface

Building a Report with Report Builder
Preview Performance
Using Report Parts

Shared Data Sets
Shared Data Sources
Shared Dataset Design View 

Creating Ad Hoc Reports with Report Builder
Create a Data Source Connection
Create A Shared DataSet for Northwind
Create a Report Based on a Shared Data Set 

Creating Reports With  SQL Server Data Tools
Introducing SQL Server Data Tools
Installing SQL Server Data Tools
Report Project Types 

Working with Report Server Projects
Report Project Files and Folders
Report Designer and Data Windows

Configuring Report Projects
Setting Report Project Properties
Report Project Configurations 

Creating a New Report in the Report Designer
The Report Designer

Creating Reports with SQL Server Data Tools
Create and Configure a Report Server Project
Create Shared Data Sources and Data Sets
Create a Tabular Report 

Using the Tablix Report Type
Exploring the Tablix Report Type
The Tablix Component
Tablix Cell Content and Scope

Building a Tablix Report
Creating a Shared Data Source and Data Sets
Building a Tabular Report
Building a Matrix Report
Building a List Report

Configuring Tablix  Properties and Groups
The Tablix Properties Dialogue Box
No Data Rows
Groups before Row Headers
Synchronized Data Alignment 

Using the Tablix Report Type
Create a Shared Data Source and Two Data Sets
Create a Matrix Report
Create a Form-Like Report from a list

Calculations Using Expressions And Functions
Writing and Using Report Expressions
Using the Expression Editor 

Using Built-in Report Operators and Functions
Expression Operators
Built-in Functions
Null Handling

The Global Collections
Field Collection
Globals Collection
User Collection
Report Items Collection
Variable Collection
Globals Collection

Creating Custom Functions
Creating a Custom Age Function
Sharing Custom Code with Multiple Reports

Calculations Using Expressions and Functions
Overview
Rein in the Length of a Text Field
Create a Custom Function 

Managing Page Layout and Adding Interactivity
Designing the Page Layout
Considering Report Layout Options
Page Structure Properties
Page Headers and Footers

Report Formatting Options
Formatting Text Boxes from the Toolbars
Formatting Text Boxes in the Properties Window
Formatting Text Boxes in the Text Box Properties Dialogue Box
Formatting Tablix Rows and Columns

Making Reports Interactive
Interactive Sorting
Drilldown Reports

Managing Page Layout and Adding Interactivity
Overview
Creating a Columnar Report
Create a Report with Interactive Sorting

Dynamic Reports with Parameters
Creating Report Parameters
Parameters and Stored Procedures
Using Parameters with Ad Hoc SQL
Using Unbound Parameters

Understanding Report And Data Set Parameters
Report Parameters
Data Set Parameters
Reordering Report Parameters

Using Drop-Down List Parameters
Providing a Drop-Down List for a Report Parameter
Displaying the Parameter Value and Label for a Drop-Down List Parameter
Cascading Parameters
Multivalued Parameters

Dynamic Reports with Parameters
Create a  Parameterised Report
Create a Drop-Down List Parameter
Work with Multivalued Parameters 

Enhancing Reports with Data Visualisations
Using Charts in a Report
Formatting a Chart 

Visualising Performance with Data Bars, Sparklines and Indicators
Data Bars
Sparkline
Indicators
Working with Maps and Spatial Data 

Enhancing Reports with Data Visualisation
Create a Pie Chart with Point Labels
Create a Map Report

Return to Menu


 

SSIS Course Content


SQL Server Integration Services Architecture
Version Changes of SSIS From 2008-2012
The SQL Server Integration Service
Understanding Packages
Managing with Control Flow
Moving Data with Data Flow
Understanding Variables
Understanding Parameters

SQL Server Integration Services Tools
Utilizing the Import/Export Wizard
Working in the Explore Window
Creating SQL Server Integration Services Packages
Utilizing Connection Managers

SQL Server Integration Services Tasks
Coding the Script Task
Looping and Sequence Tasks
Utilizing Data Preparation Tasks
Data Loading with the Analysis Services Tasks
Using the Workflow Tasks
Managing SQL with the SQL Tasks
Administration of SQL Using the SQL Management Objects Tasks

Data Flow
Optimizing Sources for Extraction
Using Destinations and Understanding choices
Examining the Transformation and Other Tasks

Variables, Parameters and Expressions
Creating Dynamic Packages
Utilizing SQL Server Integration Services Data Typing
Define and Use Variables and Parameters
Using Expressions in Packages

Containers
Overview of Containers
Utilizing Sequences in a Container
Utilizing Container Loops

Performing Joins
Performing Joins with the Lookup Transformation
Performing Joins with the Merge Transformation
Utilizing Cache Modes in Joins

Tuning SQL Server Integration Services Packages
Examining the SSIS Engine
Using the Best Practices

Debugging SQL Server Integration Services Packages
Designing to Troubleshoot: Using Precedence Constraints
Working with Advanced Logging and Reporting
Handling Errors

Common SQL Server Integration Services Design Patterns
Choosing the Script Task or Script Component
Working with XML
Using Package Hierarchies: Parent Child
Understanding Deployment Strategies 

Return to Menu


 

Crystal Reports Course Content


Creating a Simple Report
Starting the Crystal Reports Program
Starting a New Report 
Choosing a Data Source
The Main Components of the Design  Window
Exploring the Toolbars
Managing Resources with Explorers 
Placing Fields on the Report
Selecting and Sizing Objects 
Browsing Field Data
Moving and Aligning Objects 
Using Guides and Guidelines to Move and Align Objects 
Creating Text Objects 
Saving the Report 
Autosaving the Report 
Previewing the Report 
Refreshing the Data
Using the Status Bar
Getting Help

Formatting Features
Quick Formatting with the Template Expert
Formatting Objects
Format Painter 
Inserting Lines and Boxes 
Drawing a Line 
Drawing a Box
Inserting Graphics
Working with the Page Commands
Working with Text Objects 
Adding Fields into a Text Object 
Formatting Part or All of an Object
Inserting Special Fields

Selecting Specific Records from the Database
Filter Types of the Select Expert
Database Filtering with the Select Expert
Selecting Records with Multiple Criteria 
Viewing and Editing the Select Formula 
Case Sensitive vs. Case Insensitive 
Record Selection Formula Templates

Grouping and Sorting Data
When and Why to Group Records
Creating a Group
Group and Sort Direction 
Customize Group Name Field
Modifying Groups
Creating Multiple Groups in a Report
Using the Preview Panel
Using the Group Tree to Navigate the Report 
Reordering Groups 
Sorting Records within a Group
Using the Sort Control
Summarizing Groups 
Grouping Data in Date/Time Intervals
Calculating Percentages
Ordering Groups Based on Their Subtotals Using the Group Sort Expert

Combining Multiple Tables
Understanding Tables, Records, and Fields
Learning about Linking 
Adding Multiple Tables to a Report

Creating and Using Formulas
Understanding Crystal Formula Syntax 
Using the Formula Workshop 
Using the Formula Editor 
The Formula Editor Toolbar 
Performing Simple Number Calculations
Manipulating Dates with Formulas
Creating Boolean (True/False) Formulas
Creating String Formulas
Using Bookmarks to Navigate Through Formulas

Conditional Formatting
Formatting Sections
Formatting Sections Conditionally 
Conditionally Formatting Fields

Creating Summary Reports and Charts
Creating a Summary Report 
Applying the Drill-Down Feature 
Applying the Drill-Down Group Level 
Producing Charts 
Editing Charts 
Formatting Charts 
Using the Chart Options
Modifying Individual Objects in the Chart
Using the Chart Options
Modifying Individual Objects in the Chart
Applying Chart Templates

Exporting Your Reports
Understanding Export Formats and Destinations 
Using the PDF Format for Crystal Reports
HTML Preview
Exporting to Windows Applications
Exporting to a Report Definition Format

Using the Report Wizards
Create a Report Using the Standard Report Creation Wizard 
The Data Dialog Box
The Fields Dialog Box
The Grouping Dialog Box
The Summaries Dialog Box 
The Group Sorting Dialog Box 
The Chart Dialog Box
The Record Selection Dialog Box 
The Template Dialog Box

Power Formatting
Using Multiple Sections in Reports
Using the Section Expert to Work with Sections

Using the Running Totals Feature
Understanding Running Totals
Creating Running Totals for a List of Numbers
Conditional Running Totals

Prompting with Parameters
Parameter Fields Overview
Parameter Field Considerations
Creating a Parameter Field
Using a Parameter to Select Records
Using a Parameter Field
Using the Parameter Panel
Creating a Dynamic Value List
Importing a Pick List
Adding Parameter Values to Text  Objects

Allowing Multiple Values in Parameters
Using Multiple Parameter Fields in Reports
Specifying and Limiting a Range for a Parameter
Using Parameters in Conditional Formatting
Using an Edit Mask to Limit String Parameters
Sorting with a Parameter
Group Sorting with a Parameter
Using a Parameter to set N in a Top N or Bottom N report
Displaying Parameter Fields
Cascading Parameter Fields

Using Advanced Formula Features
Understanding How Crystal Reports Processes the Data
Using Evaluation Time Functions
Working with Variables
Declaring a Variable
Variable Scope
Separating Statements in Complex Formulas
Working with Arrays
Understanding the Formula Evaluation

Subreports
Understanding Subreports
Unlinked versus Linked Subreports
Creating an Unlinked Subreport
Linking a Subreport
Formatting the Subreport
Passing Data from the main Report into a Subreport
Creating on-demand Subreports
Creating Hyperlinks

Creating Powerful Groups
Creating Custom Groups
Customizing Group Sort Order
Using Group Selection to Filter the Records in the Report
Grouping on a Formula Field
Grouping Hierarchically

Working with Cross-Tab Reports
Understanding How Cross-Tabs Affect Your Data
Creating a Cross-Tab Report
Crating a Cross-Tab with Multiple Rows or Columns
Applying a Formatting Style to the Cross-Tab
Customizing the Cross-Tab Format
Changing the Summary Operation
Charting Cross Tabs
Customizing Cross-Tab Group Names

Report Alerts
Creating Report Alerts
Basing Report Formulas or Conditional Formatting on Report Alerts
Creative Usage for Report Alerts

Return to Menu


 

VBA Course Content


Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

Return to Menu


 

Power BI Course Content


Introducing Power BI
The Power BI Interface
Overview of the Power BI Data Model.

Using Power BI
Connecting to Power BI data
Create a Power BI dashboard
Using Excel as a data source for Power BI
Using databases as a data source for Power BI
Importing data into Power BI
Importing different data sources into Power BI
Viewing reports from Excel files

Shaping and Combining Data
Power BI desktop queries
Shape data using formatting and transformations.
Combine data together from tables in your dataset.

Modeling data
Create relationships between data tables.
Understand the DAX syntax and use DAX functions to enhance your dataset.
Create calculated columns, calculated tables and measures.

Interactive Data Visualisations
Creating Power BI reports
Managing a Power BI solution
Use Power Bi desktop to create interactive data visualisations.

Direct Connectivity
Direct connectivity from Power BI desktop
Direct connectivity from the Power BI service
Use Power BI direct connectivity to access data in Azure SQL data warehouse
Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode.

The Developer API
The developer API
Custom visuals

Power BI mobile app
Using the Power BI mobile app
Power BI embedded

Return to Menu


 

Power Pivot Course Content


Power View
Understanding Power View
Enabling Power View
Adding Power View to the Ribbon
Creating a Power View Sheet
Working With a Power View Object
Working With Power View Fields
Rearranging and Sorting Fields
Working With Measure Fields
Formatting Power View Data
Tiling Data in Power View
Filtering in Power View
Switching Visualisations
Adding More Power Views
Adding Titles and Images
Updating a Power View Report

Power Pivot
Understanding Power Pivot
Understanding Relational Data
Enabling Power Pivot
Connecting to a Data Source
Working With the Data Model
Working With Data Model Fields
Changing a Power Pivot View
Creating a Data Model PivotTable
Using Related Power Pivot Fields
Creating a Calculated Field
Creating a Concatenated Field
Formatting Data Model Fields
Using Calculated Fields
Creating a Timeline
Adding Slicers

Get & Transform
Understanding Get & Transform
Understanding the Navigator Pane
Creating a New Query From a File
Creating a New Query From the Web
Understanding the Query Editor
Displaying the Query Editor
Managing Data Columns
Reducing Data Rows
Adding a Data Column
Transforming Data
Editing Query Steps
Merging Queries
Working With Merged Queries
Saving and Sharing Queries
The Advanced Editor

Power Map
Understanding Power Map
Creating a Power Map Tour
Working With Location Fields
Working With Mapping Confidence
Working With Height and Category
Fields
Filtering Data
Navigating a Data Map
Changing the Look
Working With Layers
Working With Scenes
Working With Scene Options
Working With Time Settings
Viewing and Editing a Tour
Exporting a Tour as a Video

Return to Menu