Enable Technology

UK TRAINING COURSES 

TRAINING COURSES UK




Crystal Reports 2008

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A  two day training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using Crystal Reports 2008. No prior Crystal Reports experience is assumed.

  • Some of the training topics covered include ...
  • Managing Resources with Explorers 
    Sorting Records within a Group 
    Selecting and Sizing Objects 
    Inserting Graphics 
    Conditionally Formatting Multiple Sections
    Inserting Special Fields
    Creating a Parameter Field
    Reordering Groups 
    Creating an Unlinked Subreport
    Creating Multiple Groups in a Report 
    Summarizing Groups 
    Basing Report Formulas or Conditional 
    Power Formatting with Multiple Sections
    Parameter Field Considerations
    Creating a Group 
    Conditional Running Totals 
    Group and Sort Direction 
    Creating a Summary Report 
    Using the Section Expert to Work with Sections

  • See Training Course Details...


Crystal Reports 2011

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting,grouping, linking, formula creation and parameters using the Crystal Reports 2011 release.

  • Some of the training topics covered include ...
  • Using Multiple Parameter Fields in Reports
    Customizing Cross-Tab Group Names
    Using Guides and Guidelines to Move and Align Objects 
    The Data Dialog Box 
    Formatting
    Selecting and Sizing Objects 
    Filter Types of the Select Expert 
    Calculating Percentages 
    Modifying Groups 
    Using the Sort Control 
    The Fields Dialog Box 
    Creating Report Alerts
    Formatting Individual Cells
    Format Painter 
    Passing Data from the Main Report into a Subreport
    Processes the Data
    Additional Summary Options 
    Assigning a Value to a Variable
    Conditional Running Totals 

  • See Training Course Details...


Crystal Reports 2013

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day comprehensive training course will prepare participants to build and distribute complex reports which include sorting, grouping, linking, formula creation and parameters using the Crystal Reports 2013. No prior knowledge of Crystal Reports is required.

  • Some of the training topics covered include ...
  • Creating a Dynamic Value List
    The Main Components of the Design  Window
    Using the Parameter Panel
    Choosing a Data Source
    Group and Sort Direction
    Starting the Crystal Reports Program
    The Formula Editor Toolbar
    Using Multiple Parameter Fields in Reports
    Modifying Individual Objects in the Chart
    Using the Group Tree to Navigate the Report
    Starting a New Report
    The Record Selection Dialog Box
    Working with the Page Commands
    Formatting Charts
    Viewing and Editing the Select Formula
    The Template Dialog Box Power Formatting
    Customizing the Cross-Tab Format
    Sorting Records within a Group
    Formatting Sections
    Creating Multiple Groups in a Report
    Record Selection Formula Templates Grouping and Sorting Data

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • By the end of this short intensive Crystal Reports 2016 course participants will be able to create well laid out reports which displays data from multiple database sources. Delegates will able to use conditional formatting, filter, sort, group and aggregate data, use parameters and write formulas. The course is aimed at report writers and developers and assumes no prior Crystal Reports experience.

  • Some of the training topics covered include ...
  • Exploring the Toolbars
    Calculating Percentages
    Creating Custom Groups
    Using the Group Tree to Navigate the Report
    Understanding Running Totals
    Creating Hyperlinks Creating Powerful Groups
    Conditional Running Totals Prompting with Parameters
    Reordering Groups
    Customizing Cross-Tab Group Names Report Alerts
    Understanding How Crystal Reports Processes the Data
    Formatting Objects
    Filter Types of the Select Expert
    Record Selection Formula Templates Grouping and Sorting Data
    Importing a Pick List
    Previewing the Report
    Quick Formatting with the Template Expert
    Modifying Individual Objects in the Chart
    Formatting Part or All of an Object
    Sorting with a Parameter
    Creating Running Totals for a List of Numbers
    Adding Fields into a Text Object

  • See Training Course Details...


Crystal Reports XI

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day comprehensive Crystal Reports XI trainingcourse will prepare participants to build and distribute complex reports whichinclude sorting, grouping, linking, formula creation and parameters.

    Crystal Reports training courses are also available in Crystal Reports versions8.0, 8.5, 9.0 and 10. 

  • Some of the training topics covered include ...
  • Defining the Purpose of the Report
    Applying Chart Templates Exporting Your Reports Within Your Organization
    Creating a Group
    Crystal Reports XI Before You Begin
    Creating On-Demand Subreports
    Creating Custom Groups
    Creating Your Own Templates
    Allowing Multiple Values in Parameters
    Repeating Row Heading for Multi-Page Cross-Tabs
    Creating Report Alerts
    Advanced Grouping
    Selecting Records with Multiple Criteria
    Understanding Running Totals
    Inserting Lines and Boxes
    Summarizing Groups
    What are Report Alerts
    Using the Section Expert to Work with Sections
    Performing Simple Number Calculations
    Starting the Crystal Reports Program
    About the Formula Workshop
    Getting Help Formatting Features

  • See Training Course Details...


CSS3

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This CSS3 course will expose students to new features in CSS3. Participants will learn how to use selectors and pseudo elements, font, color, and layout techniques; transforms, transitions, and animations. The course will explore how CSS media queries can be used to change how websites are presented on mobile devices.

  • Some of the training topics covered include ...
  • Transitions and Transforms
    Embedding Media
    Box Shadow Transitions, Transforms, and Animations
    Text Shadow
    Video Formats
    The History of CSS
    Font Services
    Responsive Images and the viewport Metatag
    The Opacity Property
    Frameworks and Grid Systems
    Attribute Selectors
    Introducing CSS3
    The CSS3 Speech Module
    Styling Video
    Fonts on the Web
    Browser Support
    Targeting Widths and Devices with CSS3 Media Queries

  • See Training Course Details...


Data Mining using Excel and Microsoft SQL Server Analysis Services

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This course is intended for Power Users, IT Professionals, Report Developers, BI Professionals and  Project Managers interested in exploring the Microsoft toolsets for data mining, machine learning and predictive analytics. Participants will fully explore the potential of Excel PowerPivot and Excel Data Mining Add-ins used in  conjunction with Microsoft  SQL Server Analysis Services (SSAS).

  • Some of the training topics covered include ...
  • Microsoft Sequence Clustering Algorithm
    Concepts and Terminology
    Microsoft Neural Network Algorithm
    Accuracy and Validation
    Microsoft Association Algorithm
    Testing and Validation of Mining Models
    Creating Reports Using Reporting Services
    Data Source
    Model Usage
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Types of Data Mining Algorithms
    Microsoft Decision Trees Algorithm
    CRISP-DM
    Exploring Data
    Cross Validation
    Multiple Nested Tables Microsoft Data Mining Algorithms
    Cross Validation
    Data Mining Concepts
    Microsoft Clustering Algorithm

  • See Training Course Details...


Developing Websites for Mobile Devices

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day intensive course will demonstrate how to use HTML5, CSS, JavaScript, and other tools to create websites which adapt their layout to the client device, whether it be a smartphone, tablet computer or desktop computer. The course assumes prior knowledge of HTML, CSS and some familiarity with SQL.

  • Some of the training topics covered include ...
  • Optimizing for Mobile
    Media Queries
    jQuery Mobile
    Flexible Grids
    The Viewport
    Swiping to Change Pages
    New HTML5 Features
    Using the Accelerometer
    Video Formats
    Designing for Mobile Devices
    Handling Orientation Change
    Optimizing the Video Experience for Mobile
    Using data Attributes
    Drag-and-Drop Code Builder
    The Flexible Grid: A More Responsive Layout Strategy
    Hosting Your Own Videos

  • See Training Course Details...


Excel Advanced

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A one-day course covering Microsoft Excel advanced topics.

  • Some of the training topics covered include ...
  • Creating Calculated Items
    Enabling Tracked Changes
    Setting Excel Options
    Understanding Data Importing
    Using the Cell Link to Display the Selection
    Inserting a Timeline Filter PivotTable Features
    Using the DMIN Function
    Exporting Data as Text
    Working With an Outline
    Creating Scenarios
    Understanding Types of Controls
    Creating Subtotals
    Merging Scenarios PivotTables
    Editing a Macro
    Creating Relative Names for Subtotals
    Using Formulas in Criteria
    Sharing Workbooks via the Network
    Disabling Tracked Changes
    Disabling Worksheet Protection
    Working With a Protected Worksheet
    Using Relative Names for Subtotals Data Consolidation

  • See Training Course Details...


Excel Basic

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A one day course introducing Excel.  Participants will learn how to writing formulas, use conditional formatting, create charts and print workbooks.

  • Some of the training topics covered include ...
  • Approximating Row Height
    Resizing a Chart
    Creating a Chart Sheet
    What if Formulas
    Changing the Chart Layout
    Deleting Rows and Columns
    Understanding the Backstage View
    Vertical Cell Alignment
    Growing and Shrinking Fonts
    Using the Ribbon
    Understanding Number Formatting
    Understanding How Help Works
    Understanding Font Formatting
    Understanding Printing
    Changing Background Colours
    Printing a Chart Sheet
    Using the Thousands Separator
    Printing an Embedded Chart
    Formatting Percentages
    Understanding the Charting Process
    Creating Mixed References Font Formatting

  • See Training Course Details...


Excel Intermediate

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A one day course covering Microsoft Excel Intermediate topics.

  • Some of the training topics covered include ...
  • Drawing Borders
    Using Names to Select Ranges
    Extracting With Flash Fill
    Understanding Chart Formatting
    Applying Alternate Date Formats
    Removing Page Breaks
    Hiding Rows and Columns
    Formatting
    Grouping Worksheets
    The MOD Function
    Defining Names From Worksheet
    Clearing Print Titles
    Creating a Table From Scratch
    Understanding Filling
    Pasting Defined Names Into
    Understanding Defined Names
    Clearing Conditional Formatting
    Understanding Tables
    Using Counting Functions
    Preparing for Complex Formulas

  • See Training Course Details...


Excel Power Pivot

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A one day course introducing candidates to Power View and Power Pivot Excel tools.

  • Some of the training topics covered include ...
  • Working With Merged Queries
    Working With Data Model Fields
    Rearranging and Sorting Fields
    Working With Location Fields
    Updating a Power View Report
    Exporting a Tour as a Video
    Formatting Power View Data
    Working With Height and Category
    Switching Visualisations
    Editing Query Steps
    Creating a Calculated Field
    Understanding Power Map
    Understanding Relational Data
    Transforming Data
    Understanding Power Pivot
    Understanding Get & Transform
    Working With the Data Model
    Creating a New Query From the Web
    Merging Queries
    Creating a Power View Sheet

  • See Training Course Details...


Excel Programming Using VBA

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day Excel VBA programming course which introduces advanced Excel users to the process of writing and editing Macros. No prior programming experience is assumed.

  • Some of the training topics covered include ...
  • Using Debugging Tools
    Working with Variable Scope
    Working with the Label Control
    Using the For...To...Next Structure
    Introducing Visual Basic for Applications
    Working with UserForm Properties, Events, and Methods
    Working with Option Button Controls
    Using Expressions, Variables, and Intrinsic Functions
    Understanding Constants
    Understanding VBA's Error Trapping Options
    Using the Object Browser
    Creating a Function Procedure
    Controlling Program Execution
    Using the Toolbox
    Understanding Modules
    Understanding Collections
    Creating a PivotTable Using Worksheet Data
    Working with Properties
    Setting Breakpoints
    Assigning a Macro to the Quick Access Toolbar

  • See Training Course Details...


HTML

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day course introducing HTML (Hyper Text Markup Language). Delegates will learn to create and edit simple web pages containing text, lists, images, hyperlunks, forms and tables.

    No prior HTML or web development knowledge is assumed. 

  • Some of the training topics covered include ...
  • Anchors with the id Attribute
    Id and Name Attributes
    Blocks and Inline Elements
    The HTML Skeleton
    Password Fields
    TheElement TheElement
    Unordered Lists
    Inches (in), Centimeters (cm), and Millimeters (mm)
    External Style Sheets
    Form Elements
    Case Sensitivity
    Exs (ex)
    ID Selectors
    Benefits of Cascading Style Sheets
    Introduction to HTML
    Creating Tables
    Get vs. Post
    Checkboxes
    Phrase Elements

  • See Training Course Details...


HTML 5

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Participants on this two day courses will learn about HTML5 structural, semantic, and form tags, how to use Canvas to create drawings natively in the browser, how to work with HTML5 audio and video, the methods for storing variables client-side, and how you build applications that work offline. The course is aimed at delegates with an existing knowledge of HTML 4 or xhtml.

  • Some of the training topics covered include ...
  • autofocus
    drawImage() - Sprites
    Video Tag Attributes
    HTML5 New Form Attributes
    Laying out a Page with HTML 4 - the "old" way
    Audio Tag Attributes
    Accessibility
    Page Structure
    Offline Application API
    Graceful Degradation
    Creating and Converting Video Files
    datalist
    Prefixing your Keys
    HTML5 Forms
    novalidate
    HTML5 Web Storage
    date/time input types

  • See Training Course Details...


JavaScript

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This introductory two day JavaScript training course aimed at Web Designers will enable participants to interpret, adapt and write their own JavaScript code.

    No prior programming knowledge is assumed.-

  • Some of the training topics covered include ...
  • Built-In JavaScript Objects
    JavaScript Form Validation
    typeof Operator
    do while Loop Syntax
    Strings
    Validating Radio Buttons
    Image Rollovers
    Built-in Functions vs Methods
    Backward Compatibility
    while Loop Syntax
    Validating Checkboxes
    Built-in Functions
    Image Rollover Function
    isNaN(object)
    Switch / Case
    Function Syntax
    Validating a Registration Form
    Arrays

  • See Training Course Details...


JQuery

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This intensive three day jQuery training course provides a comprehensive overview of the jQuery JavaScript library. Ideally candidates should have a working knowledge of HTML and CSS.

  • Some of the training topics covered include ...
  • Same-origin Policy and JSONP
    The Setup
    Getting and Setting Information about Elements
    jQuery's Ajax-related Methods
    Utility Methods
    Switch Statements
    Ajax and Firebug
    Functions
    Manipulating Attributes
    Keep Things DRY
    Working with Selections
    The for Loop
    A Sample Application
    Cache Length during Loops
    Refining and Filtering Selections
    Working with JSONP
    Events-
    Plugins-

  • See Training Course Details...


JQuery Mobile

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course in which participants develop single sites for all popular smartphone, tablet, and desktop platforms. You'll learn how to use jQuery Mobile to handle touch events, build mobile-optimized forms and widgets, incorporate HTML5 features, leverage phone capabilities such as making calls and texting, and more. Along the way, we'll cover jQuery Mobile's extensive theme framework and plugin architecture.

    Prior knowledge of HTML, CSS and JavaScript is required.

  • Some of the training topics covered include ...
  • Buttons and Toolbars
    Supported Devices/OSs/Browsers
    Orientation (Portrait/Landscape)
    Dialogs
    Lists and Buttons
    Video The Theme Framework
    Buttons and Linking Pages
    Levels of Support
    Collapsible Blocks Events
    Sliders
    Ajax-driven Page Navigation
    plugin Architecture
    Virtual Integration with the Phone
    Hosting vs. CDN
    Data-role
    Basic Page Template
    Page Transitions

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which assumes no prior Access knowledge. Candidates will learn how to design and build a relational database, build forms and dashboards, automate tasks using Macros. Delegates will also learn how to query the database, filter and aggregate data and build parametrised reports.

  • Some of the training topics covered include ...
  • Formatting Tables
    Macros on Forms
    Creating and Using Macros
    Data Validation
    Parameter Queries
    Using a Navigation Form
    Getting to Know Access 
    Creating a Relational Database
    Calculations in Queries
    Creating and Using Reports
    Modifying Forms
    Aggregation Queries
    Creating a Lookup Database
    An Introduction to VBA
    Importing and Exporting Records
    Understanding VBA
    Action Queries
    DIY Forms
    Navigation Pane Protection
    Database Wellness
    Querying Techniques

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course introduces candidates to Visual Basic for Applications (VBA) programming. Participants can use VBA to build distributed fully automated Access database applications. No prior programming background is assumed.

  • Some of the training topics covered include ...
  • Understanding Constants
    Understanding the Form Object
    Locking Records for Updating
    Setting Breakpoints
    Creating a Sub Procedure
    Understanding Recordset Cursor Properties - Optional
    Using Message Boxes
    Understanding Control-of-Flow Structures
    Determining the Value of Expressions
    Creating a Standard Module
    Understanding the Err Object
    Understanding the Development Environment
    Working with Variable Scope
    Using the Immediate Window to Call Procedures
    Using the For...Next Structure
    Guidelines for use of Branching Structures
    Understanding Procedures
    Using Debugging Tools
    Using the If...End If Decision Structures

  • See Training Course Details...


Microsoft Excel Power Query

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel.  The course uses Excel 2016, however Power Query works with Excel 2010 and above.  

    Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.

  • Some of the training topics covered include ...
  • Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Course topics include- INTRODUCTION TO POWER QUERY
    Using Ranges in Excel
    Loading into Excel
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understanding Data Types WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Performing Merges
    Introduction to Power BI Desktop
    Loading into Power Pivot
    Importing Data
    Using PivotTables CONNECTING TO DATABASES
    Understand working with relational data.
    Transforming Data
    Understand the M interface.
    Understanding the Issues
    Working with Folders and Files
    Understand Power Query formulas.
    Understanding and Handling Special Situations

  • See Training Course Details...


Microsoft Excel PowerPivot Data Analytic Expressions DAX Language

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This course is intended for Power Users, Business Intelligence Developers and IT Professionals who will be involved with the development of Excel PowerPivot queries and tabular modelling. The course is intended to expose the delegates to the technology of DAX and to familiarise them with functionality of DAX at an advanced level.

     Prior experience with Excel and Microsoft SQL query writing is useful.

  • Some of the training topics covered include ...
  • Aggregation Functions
    Text Functions
    Utilizing Operators
    Information Functions
    Explaining Syntax
    Filter Functions
    Exploring Data Types
    Conversion Functions
    Multiple Table Evaluation Context Working with Dates
    Introduction to DAX
    Many-to-Many Relationships
    Understanding Values
    Logical Functions
    Date Functions
    Statistical Functions
    PowerPivot Data Model
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Working with Calendars
    Relational Functions Understanding Evaluation Contexts
    The CALCULATE Function

  • See Training Course Details...


Microsoft Power BI

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This course is intended for Managers, Report Developers and Data Participants who will learn how to use Microsoft Power BI to transform organisational data into rich visuals that facilitate new ways of thinking. This course covers both Power BI On Line and Power BI desktop. 

  • Some of the training topics covered include ...
  • Create a Power BI dashboard
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Managing a Power BI solution
    Using databases as a data source for Power BI
    Importing data into Power BI
    Shape data using formatting and transformations.
    Direct connectivity from Power BI desktop
    The Power BI Interface
    Overview of the Power BI Data Model. Using Power BI
    The developer API
    Power BI desktop queries
    Power BI embedded
    Combine data together from tables in your dataset. Modeling data
    Custom visuals Power BI mobile app
    Using Excel as a data source for Power BI
    Connecting to Power BI data
    Direct connectivity from the Power BI service
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Topics covered include- Introducing Power BI
    Importing different data sources into Power BI
    Use Power BI direct connectivity to access data in Azure SQL data warehouse

  • See Training Course Details...


Microsoft Power Graphics

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • The course is targeted towards business analysts, business intelligence developers and reporting professionals. Participant will learn how to combine the functionality of Power View, PowerPivot, Power Query and Power BI into graphs, charts, KPIs, reports and other data visualisations.

  • Some of the training topics covered include ...
  • Load data.
    Aggregations
    Manage modifications.
    Use Bing maps.
    Power Map
    Exploring the Power View Interface
    Theming Reports
    Perform data cleaning.
    Applying Filters
    Understanding Aggregations
    Introduction to Power BI
    Importing Large Datasets
    Navigate the Power Query interface.
    Navigate the Power Map interface.
    Hierarchies
    Importing Data with a Query

  • See Training Course Details...


Microsoft Project Integrated Course

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A short intensive course covering Microsoft Project Levels 1, 2 and 3. This course teaches you everything you need to know to get up and running with using Microsoft Project competently.

  • Some of the training topics covered include ...
  • Creating Resource Problems
    Entering File Properties Creating Tasks
    Custom Fields
    Resources
    Creating a Custom View
    Changing Calendar Options
    Linking to Microsoft Excel
    Creating a Custom Table for the View
    Modifying a Schedule Using
    Dependencies
    Understanding Resource Levelling
    Creating a Summary Milestone Shared Resources
    Working With the QAT
    Assigning Specific Work Times
    Simple Resource Assignments
    Auto Scheduling Tasks
    Opening Shared Resource Projects
    Adding More of the Same Resource

  • See Training Course Details...


Microsoft Project Level 1

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • The skills and knowledge acquired in this course are sufficient for the learner to be able to use Microsoft Project 2016 to create a new project, enter and work with tasks and resources, create a schedule, and print effective project information.

    At the completion of this course you should be able to:

    Start Microsoft Project and identify how it works
    Explain some of the key concepts associated with project management
    Create a new project file in Project
    Enter tasks into a project file
    Create relationships between tasks in a project
    Add resources, including labour, materials and equipment to a project
    Understand and use resource assignment calculations
    Assign resources to tasks using a number of different methods
    Print various aspects of a project
    Obtain help for Project whenever you need it

  • Some of the training topics covered include ...
  • Creating Dependencies in a Sheet View
    Entering Cost Resources
    Entering Work Resources
    Creating Dependencies in Task Entry
    Changing Calendar Options
    Checking Progress
    Understanding Your Project
    Working With Views
    Understanding Scheduling Icons
    Getting to Know Project 
    Entering Lead Time
    Examining Task Slack
    Accessing the Help Window
    Assigning Calendars to Resources
    Adding Additional Resources
    Understanding Lag Time
    Working With Fixed Unit Tasks
    Entering Task Durations
    Working With Calendars
    Working With Task Views
    Understanding Tasks

  • See Training Course Details...


Microsoft Project Level 2

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Microsoft Project - Level 2 is designed for existing users of Microsoft Project who wish to extend their skills and knowledge beyond the creation of simple projects.

    At the completion of this course you should be able to:

    Use various techniques for levelling over allocation of resources
    Assign material resources in a project
    Assign and track costs within a project
    Apply constraints and deadlines to tasks in a project
    Track the progress of a project
    Work more productively with project views
    Work with tables in Project
    Work with some of the features that allow you to control your data
    Format projects to make them more appealing and relevant
    Print data from Gantt Charts in a variety of ways and presentations

  • Some of the training topics covered include ...
  • Resource Levelling
    Setting Page Breaks
    Changing Text Styles
    Assigning Variable Usage Material
    Adding a Constraint
    Assigning Fixed Costs
    Changing Bar Styles Advanced Printing
    Highlighting a Range of Tasks
    Adding To A Material Assignment
    Assigning Per Usage Costs
    Exploring Tables
    Changing Time Periods
    Using Print Preview
    Moving a Project’s Start Date Project Tracking
    Checking Resource Usage
    Adding Fields Using Insert Column
    Creating an Over Allocation Report
    Saving an Existing View
    Understanding the Timescale
    Assigning Overtime
    Understanding the Data Tools

  • See Training Course Details...


Microsoft Project Level 3

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Microsoft Project - Level 3 aims to take the learner to more advanced levels of Microsoft Project. It covers a diverse range of topics including working simultaneously on multiple projects, sharing resources between several projects, downsizing very large projects, using templates, and automating operations with VBA.

    At the completion of this course you should be able to:

    Create and work with several types of custom fields
    Create and work with WBS Codes
    Create a custom view with a custom filter, group and table
    Run and modify standard graphical reports as well as create your own custom reports
    Create and work with visual reports
    Work with and create project templates
    Work with and link multiple projects in Project
    Create shared resources for use amongst multiple projects
    Downsize large project files into more manageable entities
    Export project data to other applications
    Collaborate on projects with others using Skype for Business and SharePoint
    Create VBA macros to automate operations in a project file

  • Some of the training topics covered include ...
  • Components Graphical Reports
    Setting Project Links
    Understanding Project Templates
    Formatting a Visual Report
    Understanding Excel Visual Reports
    Creating the Custom View
    Localising a Macro
    Creating a Read Only Subproject
    Saving a Project as a Template
    Creating a Summary Milestone Shared Resources
    Preparing for the Master Project
    Making Reports Global
    Removing Unwanted Reports Visual Reports
    Creating a Common Resource Pool
    Creating a Custom Table for the View
    Finalising the Master Other Applications
    Running a Macro
    Creating a Visual Report From a

  • See Training Course Details...


Microsoft SQL Server 2005 Analysis Services SSAS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • In this course participants learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services.

  • Some of the training topics covered include ...
  • SharePoint 12 and AS 
    Processing mining models 
    Modeling intermediate fact tables 
    Using the Add Business Intelligence Wizards - write-back, semi-additive measures, time intelligence, account intelligence 
    Creating Data Sources and Data Source Views 
    Perspectives 
    New MDX functions 
    Report Center (type of dashboard) uses KPIs, Reports, Excel Web, Filter 
    Partitions - relational and Analysis Services partitions 
    Security - roles and permissions 
    Using the MDX query editor in SQL Server Management Studio 
    Best practices - health monitoring 
    Cube Storage and Aggregation 
    Clustering - high availability 
    XMLA scripting (SQL Mgmt Studio) 
    Data Mining clients 
    Storage topics - basic aggregations, MOLAP 

  • See Training Course Details...


Microsoft SQL Server 2005 Integration Services SSIS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day course will familiarise participants with SQL Server Integration Services 2005 (SSIS) tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.

  • Some of the training topics covered include ...
  • The Copy Column Transformation 
    SSIS debugging overview 
    Data Viewers 
    Deployment options 
    Configuring Package Logging 
    Script in Control flow: The Script Task 
    Importing and Exporting Data 
    Configuration options 
    Advanced Data Flow
    Breakpoints in SSIS 
    Working with Packages 
    Executing packages – DTExec and DTExecUI 
    The Send Mail Task 
    Creating Database Maintenance Plans using SSMS 
    The SSIS Service 
    Scheduling and Executing Plans 
    SSIS Package Management
    Configuration discipline 
    Precedence Constraints 

  • See Training Course Details...


Microsoft SQL Server 2008 Analysis Services SSAS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • In this two day course participants learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition, SQL Server Business Intelligence Development Studio (BIDS) Microsoft SQL Server 2005 Integrated Services and Reporting Services.

  • Some of the training topics covered include ...
  • Model with SQL Server Business Intelligence Development Studio (BIDS)
    Explore Advanced Dimension Types
    Understand Measure (fact) and Cube Modeling
    Explore how to add MDX Script Commands
    Understand Dimensional Modeling (stars and snowflakes)
    Deploy and View a Sample Cube
    Advanced Administration and Optimization
    Cube Storage and Aggregation
    Understand Data Mining Concepts
    Create Cubes by using the Cube Wizard
    Design Reports by using Report Builder
    Understand Basic MDX Syntax
    Using SSAS in BIDS
    Work with Multiple Fact Tables and the Dimension Usage Subtab in BIDS
    Explore Clustering
    Understand Performance Tuning and Optimization
    Implement SSAS Security
    Understand Writeback in Dimensions
    Review the Algorithms that SSAS Includes

  • See Training Course Details...


Microsoft SQL Server 2008 Integration Services SSIS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling, and logging techniques.

  • Some of the training topics covered include ...
  • Using Variables and Configurations between Packages 
    Data Flow Best Practices 
    Custom Integration Services Components 
    Data Flows
    Migrating and Maintaining SQL Servers with Integration Services 
    Working with Workflow Tasks 
    Scripting in Control Flows with the Script Task 
    Event Handling 
    Control Flow
    Scripting in Data Flows with the Script Component 
    Using Variables in Control Flow 
    Exploring and Executing an Integration Services Package in BIDS 
    Understanding Variables 
    The Data Flow Task 
    Configurations 
    Best Practices

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Analysis Services SSAS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This intensive instructor-led course is intended for IT professionals who are interested in quickly learning how to utilize an Analysis Services multidimensional or tabular solution. This course also discusses how to use the Analysis Services development tools to create both multidimensional and tabular projects, and follows with explanations on how to use the management and administrative tools to manage both Analysis Services solutions.

  • Some of the training topics covered include ...
  • Utilizing Attributes
    Creating a Tabular Project
    Utilizing Translations
    Understanding the Multidimensional Model
    Examining Deployment Options
    Dissecting with Dimensions
    Relating with Relationships
    Calculated Members.
    Understanding Perspectives
    Developing Dimensions
    Configuring Cube Options
    Maintaining and Optimizing
    Deploying
    Handling Hierarchies.
    Browsing the Model
    Version Changes of SSAS from 2008-2014
    Deploy a multidimensional model.
    Understanding the Tabular Model

  • See Training Course Details...


Microsoft SQL Server 2012/2014 Integration Services SSIS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day intensive course introduces SQL Server Integration Services using the SQL Server 2012 or 2014 versions. No prior knowledge of Integration Services is assumed.

  • Some of the training topics covered include ...
  • Define and Use Variables and Parameters
    Understanding Variables
    Managing SQL with the SQL Tasks
    Examining the Transformation and Other Tasks Variables, Parameters and Expressions
    Moving Data with Data Flow
    Working with XML
    Overview of Containers
    Optimizing Sources for Extraction
    Utilizing SQL Server Integration Services Data Typing
    Using Destinations and Understanding choices
    Using the Workflow Tasks
    Handling Errors Common SQL Server Integration Services Design Patterns
    Using Package Hierarchies: Parent Child
    Utilizing Container Loops Performing Joins
    Data Loading with the Analysis Services Tasks
    Managing with Control Flow
    Creating Dynamic Packages
    Examining the SSIS Engine
    Understanding Deployment Strategies 
    SQL Server Integration Services Architecture
    Performing Joins with the Merge Transformation

  • See Training Course Details...


Microsoft SQL Server 2016 Report Builder SSRS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Aimed at Data Analysts and SQL users this instructor-led course provides participants with the necessary knowledge to develop reports using Microsoft SQL Server 2016 Report Builder. The course covers Report Builder wizards, basics of report design, report parameters, report expressions, filters, report visualisations including graphs, charts, images and gauges. The course also covers the use of maps, interactive reports, report parts, sub reports, subscriptions and exporting options.

  • Some of the training topics covered include ...
  • Formatting Reports
    SQL Server 2016 Report Builder Wizards
    Utilizing Data Sources
    Using the List Object to Combine Other Items
    Examining Security
    Understanding HTML5 and Textboxes
    Exploring Gauges
    Using Tables
    Understanding Variances Between SQL Versions
    Creating Subreports and Drillthrough Reports
    SQL Server 2016 Report Builder Basic Reports
    Working with Expressions
    Exploring Subscriptions
    Introduction to SQL Server 2016 Report Builder
    Visualizing Your Company Report Templates
    Examining Maps
    Utilizing Dynamic Headers and Footers
    SQL Server 2016 Report Builder Graphics

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services SSAS Multdimensional Modelling

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This intensive two day course is intended for SQL professionals and business intelligence professionals. The course covers the use of Analysis Services development tools to create and deploy multidimensional SSAS projects.

  • Some of the training topics covered include ...
  • Configure Measure Group Properties
    Rename a Multidimensional Database Processing a multidimensional model
    Create Remote Partitions
    Create Measures and Measure Groups
    Modify or Delete an Analysis Services Database
    Define a Data Source View
    Create Local Partitions
    Add a Standard Action
    Partition Writeback Calculations
    Set Data Source Properties
    Define Attribute Relationships
    Change a Partition Source
    Create Calculated Members
    Work with Diagrams in Data Source View Designer
    Create a Time Dimension by Generating a Time Table
    Designing Aggregations
    Define a Regular Relationship and Regular Relationship Properties
    Ragged Hierarchies
    Read Definition permissions
    Processing Databases, Dimensions and Partitions
    Define a Referenced Relationship and Referenced Relationship Properties

  • See Training Course Details...


Microsoft SQL Server 2016/2017 Analysis Services Tabular Modelling

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course detailing how to create, deploy, use and manage tabular models in Microsoft SQL Server Analysis Services (SSAS) 2016 – 2017. The course is aimed at Data Analysts and SQL professionals.  No prior knowledge of SSAS is assumed.

  • Some of the training topics covered include ...
  • Create and Manage Partitions in the Workspace
    Import from Analysis Services
    Process Database, Table, or Partition
    Data types supported
    Enable DirectQuery mode in SSDT
    Version comparison
    Delete a Column
    Change table, column
    Rename a Table or Column
    Connect to a tabular model database
    Analyze in Excel
    Object-level security
    Create and Manage Tabular Model Partitions
    Specify Mark as Date Table for use with Time Intelligence
    Database Process Partitions in the Workspace Database Perspectives
    Create a Calculated Table
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Deploy from SQL Server Data Tools Manage Tabular Model Databases
    Add sample data to DirectQuery models
    Create a Relationship Between Two Tables

  • See Training Course Details...


Microsoft SQL Server Reporting Services SSRS 2016

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This three day intensive course will give delegates a comprehensive understanding of how to design and publish parametrised reports, manage permissions, schedule automated reporting and configure report caching. The course also demonstrates how to build reports designed for tablets and mobile devices.

  • Some of the training topics covered include ...
  • Report subscription and delivery Administering Reporting Services
    Implementing report filters and parameters Visualizsng Data with Report Services
    Create a report using report builder or report designer.
    Formatting data
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Publish a report to reporting services Working with Reporting Services Data
    Work with expressions and embedded code.
    Report caching, snapshots, and comments
    Add a drillthrough to a custom URL
    Extend reporting services functionality with external assemblies.
    Monitor and optimize the performance of SSRS on a given set of server hardware Extending and Integrating Reporting Services
    Integrate reporting services with other software Designing Reports for Tablets and Mobile Devices
    Drillthrough in mobile reports
    Using Datasets Creating Paginated Reports
    Topics include Introduction to Reporting Services
    Mobile report publisher
    Use databars, sparklines, and indicators in reports Summarising Report Data
    Overview of mobile reports
    Creating a report with the report wizard
    Sorting and grouping
    Drilldown and drill through Sharing Reporting Services Reports

  • See Training Course Details...


Oracle Business Intelligence - Create Reports and Interactive Dashboards

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Oracle Business Intelligence (BI), formerly known as Siebel Business Analytics, empowers business users with sophisticated data analytic capabilities without any knowledge of database structures or the SQL database language. This training course will guide students through all of the features available from the product to allow one to build sophisticated dashboards and reports.

  • Some of the training topics covered include ...
  • View Selector View
    Miscellaneous Tasks Building a Dashboard
    Logical Data Models
    Ticker View
    Defining the Pivot View
    Accessing The Presentation Catalog
    Managing the Views Using Secondary Views
    About Database Technologies
    Totals within Pivot Tables Advanced Formatting
    Column Formulas Using Primary Views
    Sorting Data
    Using the Dashboard Editor
    Managing Dashboard Objects Creating a Report
    View XML and SQL Calls Administering The Presentation Catalog
    Managing Saved Content
    Viewing Supplementary Content
    Column Formatting
    Understanding the Dashboard Structure
    Report Attributes
    Sections and Pages
    Warehouse Models and Schemas

  • See Training Course Details...


Oracle PL/SQL

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This three day course gives participants a sound understanding of working with Oracle PL/SQL. The courses assumes no prior programming knowledge and is hands on in character.

  • Some of the training topics covered include ...
  • Exception Handlers 
    Associative Array Collections 
    Oracle Directories 
    Stored Subprograms 
    Creating a Stored Function 
    Assignment and Conversions 
    Exception Handling
    The DBMS_METADATA Package 
    Procedures and Functions 
    The DBMS_OUTPUT Package 
    Using Packages 
    Iterating Through Collections 
    Triggers
    Privileges for Stored Programs 
    Internal LOBs 
    Collection Methods 
    LOB Locators 

  • See Training Course Details...


Oracle SQL

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course familiasing participants with the use of SQL in an Oracle context. SQL statements will be written and executed using a number of Oracle environments including SQL* Plus and Oracle SQL Developer.

  • Some of the training topics covered include ...
  • Combining SELECT Statements 
    Nulls and DISTINCT 
    Datatypes 
    Constraints 
    Aggregate Functions and Advanced Techniques 
    The EXISTS Operator 
    Literal Values 
    Data Manipulation and Transactions 
    IN and BETWEEN 
    Pattern Matching: LIKE and REGEXP_LIKE 
    Using SQL Functions 
    The CASE...WHEN Expression 
    Intervals 
    Synonyms
    Concurrency 
    Scalar Functions 
    Tailoring Your SQL*Plus Environment 
    Sample Database 
    Relational Database and SQL Overview 

  • See Training Course Details...


PHP

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course introducing PHP and equipping candidates with the skills necessary to build PHP driven dynamic web sites. Participants should have a sound knowledge of HTML.

  • Some of the training topics covered include ...
  • Working with Associative Arrays 
    PHP Basics
    Constants 
    By Reference vs. By Value 
    User Functions 
    do...while 
    Uploading Files via an HTML Form 
    When not to use a database abstraction layer? 
    Getting a Directory Listing 
    mysqli Prepared Statements 
    Form Variables 
    Writing to a File 
    preg_replace() 
    fopen() 
    Working with Enumerated Arrays 
    fgets() 
    Creating a Resume Management Page
    Cookies 
    Type Strength 

  • See Training Course Details...


PowerPoint Advanced

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Microsoft PowerPoint - Advanced Level is designed for users who are keen to extend their understanding and knowledge of the software beyond creating basic presentations.

  • Some of the training topics covered include ...
  • Inserting an Online Picture
    Applying a Picture Style
    Changing the Theme Colours
    Applying Artistic Effects
    Viewing the Slide Master
    Sending a Presentation via Email
    Working With PowerPoint Designer
    Saving a Custom Template
    Saving a Presentation as a PDF
    Creating a Template From a
    Merging and Splitting Cells
    Using Slide Transitions
    Applying a Table Style
    Using Quick Layouts
    Using an Existing Template
    Inserting Action Buttons
    Working Collaboratively
    Saving to OneDrive
    Setting Up a Speaker-Led Show

  • See Training Course Details...


PowerPoint Basic

  • 1 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • The skills and knowledge acquired in Microsoft PowerPoint Basic Level are sufficient to be able to create real-world slide shows. You will learn how to create, print and publish presentations.

     

  • Some of the training topics covered include ...
  • Starting PowerPoint From the Desktop
    Inserting and Formatting Text
    Converting Text to SmartArt
    Adding an Assistant
    Using Ribbon KeyTips
    Inserting a Picture With Caption Slide
    Typing Text Into a Slide
    Understanding the Status Bar
    Editing Text
    Switching SmartArt Right to Left
    Printing the Outline
    Applying WordArt to Text
    Presentations
    Creating a Presentation
    Changing the Slide Layout
    Promoting and Demoting Shapes
    Working With Text

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This short intensive SQL (Structured Query Language) course assumes no prior knowledge. Candidates will learn how to write SQL queries which can extract filtered, grouped and aggregated data from a relational database. The course also covers creating tables, views, updating, inserting and deleting data. This course focuses on core SQL which is applicable to almost all database platforms.

  • Some of the training topics covered include ...
  • Calculated Fields
    Benefits of Views
    NULL Values
    Checking for Equality
    Relational Databases
    The LIKE Operator
    Creating Tables
    Grouping and Aggregating Data
    Using CASE Inserting, Updating and Deleting Records
    Selecting All Columns in All Rows
    Selecting Distinct Records
    Multi-table Joins
    Creating Stored Procedures
    Creating Tables
    Popular Databases

  • See Training Course Details...


SQL Server 2005 Reporting Services SSRS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day course which equips participants with the skills necessary to effectively use SQL Server 2005 Reporting Services. Enable Technology also run a comparable two day Reporting Services 2000 training course.

  • Some of the training topics covered include ...
  • Grouping Data
    Filters
    Adding Groups and Users
    Understanding Reporting Services 2005 Subscriptions
    Parts of the Chart
    Formatting Textboxes with the Textbox Properties Dialog
    Navigation
    Deploying the Auditing and Management Reports
    Using Reporting Services 2005 Expressions
    Understanding Reporting Services 2005 Caching
    Understanding Snapshots
    Identifying Field
    Understand the Report Model Architecture
    The Reporting Services 2005 Report Designer
    Starting SQL Server Business Intelligence Development Studio
    Report Builder Design Layout
    Report Borders Toolbar
    Database Components
    Creating Formulas
    Data Output

  • See Training Course Details...


SQL Server 2008 Reporting Services SSRS

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • A two day intensive course introducing the comprehensive range of SQL Server Reporting Services 2008 report writing and deployment features.

  • Some of the training topics covered include ...
  • Explore exporting reports to a variety of formats and using the client-side printing feature of Reporting Services 
    Learn how to solve common parameter issues 
    Learn how to work with rich text to produce mail merge style reports 
    Find out how to use Report Manager to manage user accounts and roles 
    Investigate the list data region 
    Investigate what SQL Server Reporting Services can do 
    Managing Reporting Services
    Advanced Reporting Services Programming
    Learn how to create custom functions using the Code window 
    Find out how to create drill-down reports 
    Investigate the scheduling of report snapshots 
    Learn about report variables and when you might need to use them 
    Learn about datasets and data regions 
    Discover the various global collections that you can reference in your expressions 
    Discover how to improve parameter prompts using drop-down list parameters 

  • See Training Course Details...


SQL Server Data Warehouse Implementation

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Participants will learn to perform ETL (Extraction Transformation and Loading) operations by creating SSIS packages, managing a control flow and data flow, executing packages, and troubleshooting errors. To ensure the smooth functioning of the ETL operations, you will manage SSIS packages and secure them. Delegates will use SSIS packages to design and build a Data Warehouse.

    The course requires a working knowledge of SQL.

  • Some of the training topics covered include ...
  • Add Packages to an SSIS Project Managing Control Flow
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Create Dimensions
    Add Data Flow Components to a Data Flow Task
    Secure Databases Working with MDS and Windows Azure
    Securing Packages and Databases
    Configure MDS
    Install Integration Services Working with Integration Services
    Troubleshoot Package Failures Deploying Packages
    Introduction to Data Warehouses
    Execute Packages from Different Control Flow Working with Dynamic Variables
    Overview of Data Warehouses
    Examine Data Warehousing Concepts
    Deploy SSIS Packages
    Create Expressions with Variables
    Create Fact Tables
    Work with Windows Azure
    Examine MSI Packages
    Perform Transformation Tasks
    Secure Packages

  • See Training Course Details...


SQL Server Reporting Services SSRS 2012/2014

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Aimed at Report Writers using SQL Server Reporting Services (SSRS) 2012 and 2014 this intensive two day course demonstrates how to create and deploy parameterised reports using Report Builder and Report Designer. No prior Reporting Services experience is assumed but a reasonable grasp of SQL is essential.

  • Some of the training topics covered include ...
  • Work with Multivalued Parameters  Enhancing Reports with Data Visualisations
    Designing the Page Layout
    Multivalued Parameters Dynamic Reports with Parameters
    Null Handling
    Building a List Report Configuring Tablix  Properties and Groups
    Building a Report with Report Builder
    Page Structure Properties
    Exploring the Tablix Report Type
    Create a Report with Interactive Sorting Dynamic Reports with Parameters
    Using Parameters with Ad Hoc SQL
    Report Builder vs. Report Designer
    Create a Matrix Report
    Overview
    Synchronized Data Alignment  Using the Tablix Report Type
    Formatting Tablix Rows and Columns Making Reports Interactive
    Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Service Architecture  Report Building Tools
    Page Headers and Footers Report Formatting Options
    Native Mode Architecture
    Drilldown Reports Managing Page Layout and Adding Interactivity

  • See Training Course Details...


Transact SQL

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day Transact SQL course introduces delegates to querying and manipulating data in Microsoft SQL Server. The course explores how to write select statements, join tables, create subqueries, write update, delete and insert statements. It differs from the generic SQL course in that if explores Microsoft SQL Server product specific functions and the notation associated with creating Microsoft SQL Server User Defined Functions, Stored Procedures and Triggers.

    The course id practical, hands on and does not assume prior SQL or programming experience.

  • Some of the training topics covered include ...
  • Work with Subqueries
    Work with Data Access Technologies Implementing Stored Procedures
    Manage Stored Procedures
    Delete Data
    Work with Advanced Functions Working with PIVOT, UNPIVOT, and Grouping Sets
    Work with System Databases
    Work with String and Numeric Data Types
    Analyze Data from Query Plans
    Group and Aggregate Data Programming in T-SQL
    Work with PIVOT and UNPIVOT
    Perform Advanced Filtering Querying Data from Multiple Tables
    Write CASE Expressions Working with SQL Data Types
    Work with SSPs and SMOs
    Getting Started with SQL Server 2012
    Merge Data Working with SQL Server Built-in Functions
    Work with Variables and Batches
    Work with Dynamic SQL Working with Subqueries and Table Expressions
    Work with Set Operators
    Configure Indexes
    Work with Binary Data Types
    Update Data

  • See Training Course Details...


Visio

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Some of the training topics covered include ...
  • Rack diagrams
    Integration with PowerPoint
    Business diagrams and Web site mapping
    Custom stencils
    Software and database diagrams
    Layout and connection techniques
    Working with Web-enabling features
    Network diagrams
    Sharing diagrams using a browser
    with background pages
    Formatting drawings
    Flowcharts
    Presentation Mode
    Working with text
    Creating a basic diagram
    Drawing scales

  • See Training Course Details...



Email us about this courses