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 ...
  • Create a Report Using the Standard Report Creation Wizard 
    Previewing the Report 
    Chart 
    Creating Running Totals for a List of 
    Creating Text Objects 
    Browsing Field Data 
    Sorting with a Parameter
    Inserting Special Fields
    Customizing Cross-Tab Group Names
    Using the Chart Options 
    Choosing a Data Source 
    Understanding Crystal Formula Syntax 
    Using Guides and Guidelines to Move and Align Objects 
    Using Multiple Sections in Reports
    Creating Multiple Groups in a Report 
    Grouping on a Formula Field
    Formatting Features 
    Using the Formula Workshop and Editor 
    Quick Formatting with the Template 

  • 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 ...
  • Exporting to Windows Applications 
    Browsing Field Data 
    Understanding How Crystal Reports 
    Record Selection Formula Templates 
    Using Parameters in Conditional 
    Creating an Unlinked Subreport
    Charting Cross-Tabs
    Group Sorting with a Parameter
    Viewing and Editing the Select Formula 
    Importing a Pick List
    Adding Multiple Tables to a Report 
    Cascading Parameter Fields 
    Working with Cross-Tab Reports
    Cross-Tab
    The Main Components of the Design 
    Using the Formula Workshop and Editor 
    Working with the Page Commands 

  • 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 ...
  • Refreshing the Data
    Create a Report Using the Standard Report Creation Wizard
    Drawing a Line
    Learning about Linking
    The Template Dialog Box Power Formatting
    Conditionally Formatting Fields Creating Summary Reports and Charts
    Adding Parameter Values to Text  Objects Allowing Multiple Values in Parameters
    Creating Text Objects
    Creating Report Alerts
    Exporting to a Report Definition Format Using the Report Wizards
    Inserting Lines and Boxes
    Using Evaluation Time Functions
    Creating Hyperlinks Creating Powerful Groups
    Working with the Page Commands
    Creating a Group
    Formatting Sections
    Exploring the Toolbars
    Declaring a Variable
    Creating a Cross-Tab Report
    Quick Formatting with the Template Expert
    Using a Parameter to Select Records

  • See Training Course Details...


Crystal Reports 2016

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This two day intensive Crystal Reports 2016 is aimed at report writers. Delegates will learn how to connect to an underlying database and how to design parametrised reports which filter, group and aggregate data. The course will demonstrate how to correctly join database tables, access SQL views and use stored procedures.

    No prior Crystal Reports knowledge is assumed

  • Some of the training topics covered include ...
  • Creative Usage for Report Alerts
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    Sorting Records within a Group
    Starting the Crystal Reports Program
    Creating String Formulas
    Applying a Formatting Style to the Cross-Tab
    Browsing Field Data
    Cascading Parameter Fields Using Advanced Formula Features
    The Summaries Dialog Box
    Inserting Lines and Boxes
    The Group Sorting Dialog Box
    Working with the Page Commands
    Getting Help Formatting Features
    Using the PDF Format for Crystal Reports
    Summarizing Groups
    Creating Boolean (True/False) Formulas
    Displaying Parameter Fields
    Drawing a Line
    Placing Fields on the Report
    Creating Report Alerts
    Sorting with a Parameter

  • 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 ...
  • Determining the Layout of the Report
    Creating a Cross-Tab with Multiple Rows or Columns
    Understanding How Cross-Tabs Affect Your Data
    Grouping on a Formula Field
    Creating Boolean (True/False) Formulas
    The Formula Editor Toolbar
    Exploring the Toolbars
    Ordering Groups Based on Their Subtotals Using the Group Sort Expert Combining Multiple Tables
    Understanding How Crystal Reports Processes the Data
    Starting a New Report
    Adding and Working with Text Objects
    Helpful Hints for Formatting the Report
    Formatting Sections
    The Template Expert
    Suppressing Rows, Columns or Totals
    Importing a Pick List
    Applying the DrillDownGroupLevel
    Summarizing Groups
    Manipulating Dates with Formulas
    Using a Parameter to Select Records
    Formatting the Subreport

  • 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 ...
  • Box Shadow Transitions, Transforms, and Animations
    Text Shadow
    Image Borders
    Video Formats
    Flexible Box Model Vendor Prefixes
    Backgrounds
    Font Services
    Targeting Widths and Devices with CSS3 Media Queries
    Word Wrapping Colors, Gradients, Background Images, and Masks
    Styling Video
    Attribute Selectors
    HTML5 Selectors and Pseudo Classes
    Transitions and Transforms
    Transitions Layout: Columns and Flexible Box
    Negation Pseudo-Class
    What is CSS3?
    Layout: Columns and Flexible Box
    The @font-face Rule
    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 ...
  • Saving Queries
    Microsoft Sequence Clustering Algorithm
    Visio Data Mining Add-In  
    Microsoft Logistic Regression Algorithm
    Saving Results to the Database
    Data View
    Introduction to SQL Server Data Tools
    Accuracy and Validation
    Cross Validation
    Excel PowerPivot Data Mining Add-ins
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Testing and Validation of Mining Models
    Exploring Data
    Microsoft Association Algorithm
    Model Usage
    Concepts and Terminology
    Data Mining Wizard
    Data Source
    Topics include:
    The Mining Model Prediction Tab

  • 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 ...
  • Flexible Background Images
    Flexible Grids
    Flexible Images and Other Media
    Flexible Images and Other Media
    jQuery Mobile
    Swiping to Change Pages
    The Viewport
    The Case for Flexible
    Media Queries
    Other Devices
    The GeoLocation API
    Drag-and-Drop Code Builder
    Google Maps
    Accessing Camera, Contacts, Calendar, and More - But Not Yet
    The Viewport
    Local Storage

  • 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 ...
  • Enabling Tracked Changes
    Using the PivotChart Filter Field Buttons
    Creating Subtotals
    Adding a List Box Control
    Adding Worksheet Comments
    Working With a Protected Worksheet
    Testing a Validation
    Modifying an Inserted Picture Data Linking
    Working With PivotTable Grand Totals
    Understanding How Controls Work
    Finding the Difference From
    Editing Worksheet Comments
    Using Relative Names for Subtotals Data Consolidation
    Providing Total Access to Cells
    Setting the Default File Location
    Creating Relative Names for Subtotals
    Using Formulas as Validation Criteria
    Deleting a Macro
    Protecting a Worksheet
    Creating a One-Variable Table
    Setting Save Options

  • 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 ...
  • Adding Commands to the QAT
    Using the Format Painter Cell Alignment
    Worksheet Wisdom Sorting Data
    Changing Fonts
    Increasing and Decreasing Decimals Row and Column Formatting
    Changing Background Colours
    Formulas That Multiply and Divide
    Selecting a Printer
    Understanding the Charting Process
    Understanding Number Formatting
    The Print Options Creating Charts
    Extracting With Flash Fill Moving Data
    Summing Non-Contiguous Ranges
    Growing and Shrinking Fonts
    Inserting Cells Into a Worksheet
    Recent Files and Folders Editing in a Workbook
    Specifying the Number of Copies
    Vertical Cell Alignment
    Selecting Rows
    Resizing a Chart

  • 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 ...
  • Manipulative Functions
    Freezing Rows and Columns
    Using Shape Styles
    Inserting Table Columns
    Quick Tables Worksheet Tables
    Applying Alternate Currencies
    Extracting Dates and Numbers Worksheet Techniques
    Using the More Borders Command
    Modifying a Custom Fill List
    Hiding a Worksheet
    Applying a Bottom Border
    The NOW Function
    Printing Gridlines
    Erasing Borders
    Using the Name Manager
    Deleting a Table Chart Elements
    Customising the Display of Negative
    Showing Gridlines
    The More Borders Command
    Unhiding Rows and Columns
    Renaming a Table

  • 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 ...
  • Using Calculated Fields
    Switching Visualisations
    Creating a New Query From a File
    Creating a Timeline
    Filtering Data
    Creating a Power View Sheet
    Creating a Calculated Field
    Updating a Power View Report
    Using Related Power Pivot Fields
    Adding a Data Column
    Adding More Power Views
    Managing Data Columns
    Tiling Data in Power View
    Adding Power View to the Ribbon
    Understanding Get & Transform
    Power Map
    Working With a Power View Object
    Changing the Look
    Understanding the Query Editor
    Understanding Power Map
    Working With the Data Model

  • 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 ...
  • Understanding PivotTables
    Using Debugging Tools
    Assigning a Macro to the Quick Access Toolbar
    Working with Properties
    Determining the Value of Expressions
    Working with the Combo Box Control
    Setting Breakpoints
    Introducing Visual Basic for Applications
    Working with Inline Error Handling
    Understanding Control-of-Flow Structures
    Understanding Data Types
    Adding Code to Controls
    Using Visual Basic Help
    Creating a PivotTable Using Worksheet Data
    Writing an Error-Handling Routine
    Using Break Mode during Run mode
    Using the Toolbox
    Working with Variable Scope
    Using the Immediate Window to Call Procedures
    Controlling Program Execution
    Working with Boolean Expressions

  • 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 ...
  • Start Attribute
    Hidden Fields
    Blocks and Inline Elements
    Preformatted Text
    Alternative Text
    Type Selectors
    The HTML Skeleton
    Introduction to HTML
    Exs (ex)
    CSS Comments
    HTML Elements
    Making Images Accessible
    Targeting New Windows
    Image Links HTML Lists
    The title Attribute HTML Images
    Closing Tags
    Form Elements
    Submit and Reset Buttons
    Phrase Elements
    Checkboxes
    Formatting 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 ...
  • Drag and Drop API
    The video Element
    autocomplete
    Scripting Media Elements
    datalist
    Offline Application API
    Modernizr
    Laying out a Page with HTML5
    HTML5 Canvas
    Multiple Sources
    url and email
    The Problems XHTML Addresses
    Browser Support
    Display of HTML5 Structural Elements
    The section Tag
    Local Storage
    Laying out a Page with HTML 4 - the "old" way

  • 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 ...
  • Validating Text areas
    Validating Select Menus
    Function Syntax
    Strings
    Passing Values to Functions
    for in Loop Syntax
    Basic Rules
    do while Loop Syntax
    typeof Operator
    Image Rollover Function
    A Loosely-typed Language
    ParseFloat() and parseInt()
    Conditionals
    Switch / Case
    JavaScript Syntax
    Dot Notation
    The this Object
    Image Rollovers

  • 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 ...
  • Optimize Selectors
    Managing Effects
    Namespacing Events
    The for Loop
    Working with JSONP
    About Custom Events
    Operations on Numbers and Strings
    Managing Dependencies
    Ajax Events
    Chaining
    Reserved Words
    Effects-
    ID-based Selectors
    $.ajax Options
    Triggering Event Handlers
    Changing the Duration of Built-in Effects
    Conclusion
    Built-in Effects
    Manipulating Attributes
    Manipulating Elements

  • 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
    PhoneGap
    Dialogs
    Making Calls
    Levels of Support
    Data-role
    Hosting vs. CDN
    ThemeRoller
    Sending Emails
    Sliders
    Progressive Enhancement
    Virtual Integration with the Phone
    Orientation (Portrait/Landscape)
    Supported Devices/OSs/Browsers
    Accessibility Support
    Creating Your Own Plugin
    Lists and Buttons
    Video The Theme Framework

  • See Training Course Details...


Microsoft Access

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This is a two day intensive course in which participants learn how to build and interrogate a Microsoft Access database. The course covers working with tables, queries, forms, reports and macros. No prior knowledge of Access is assumes but the course progresses to advanced topics.

  • Some of the training topics covered include ...
  • Adding Transactional Records
    Action Queries
    An Introduction to VBA
    Creating a Relational Database
    Database Security
    Adding Records to a Table
    Creating a Lookup Database
    Creating and Using Reports
    Creating and Using Macros
    DIY Forms
    Querying Techniques
    Using a Navigation Form
    Calculations in Queries
    Sorting and Filtering
    Modifying Forms
    Designing a Lookup Database
    Modifying Table Structures
    Formatting Tables
    Aggregation Queries
    Data Validation
    Multi Table Queries

  • See Training Course Details...


Microsoft Access Programming Using VBA

  • 3 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This three day short intensive course introduces candidates to Visual Basic for Applications (VBA) programming. We don't assume any prior programming experience. Candidates will learn how to build and use user defined functions, manipulate data, build switchboards and fully automate Microsoft Access applications.

  • Some of the training topics covered include ...
  • Using Message Boxes
    Using the Select Case...End Select Structure
    Handling Errors
    Using Visual Basic Help
    Working with Inline Error Handling
    Creating a Function Procedure
    Stepping through Code
    Understanding the Form Object
    Creating a Standard Module
    Using the With Statement
    Working with Methods
    Setting Breakpoints
    Understanding Modules
    Using Input Boxes
    Understanding the Order of Events
    Working with the Application Object
    Understanding Recordset Cursor Properties - Optional
    Why Program in Access?
    Using the CacheSize Property - Optional

  • 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 ...
  • Working with Folders and Files
    Loading into Power BI Desktop
    Summarising WORKING WITH THE POWER QUERY LANGUAGE “M”
    Understand and utilize merges. LOADING YOUR DATA
    Importing, Transforming, and Loading Data into Excel and Power Pivot
    Understand working with relational data.
    Understand the M interface.
    Combining Worksheets
    Understand and perform importing from SQL Server Analysis Services Multidimensional.
    Transforming Data
    Understand Power Query formulas.
    Loading into Power Pivot
    Loading Data
    Appending Operations
    Course topics include- INTRODUCTION TO POWER QUERY
    Loading into Excel
    Understand and perform importing from SQL Server Analysis Services Tabular. PERFORMING MERGES
    Data Sources GROUPING AND SUMMARISING WITH POWER QUERY
    Using PivotTables CONNECTING TO DATABASES
    Importing Data
    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
    Logical Functions
    Date Functions
    Single Table Evaluation Context
    Multiple Table Evaluation Context Working with Dates
    Using Multiple Calendars Utilising Advanced DAX Functionality
    Working with Calendars
    Many-to-Many Relationships
    Exploring Data Types
    Utilizing Operators
    Mathematical Functions
    Information Functions
    The CALCULATE Function
    PowerPivot Data Model
    Explaining Syntax
    Relational Functions Understanding Evaluation Contexts
    Conversion Functions
    Introduction to DAX
    Introduction to DAX
    Handling Errors Using DAX Functions

  • 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 ...
  • Viewing reports from Excel files Shaping and Combining Data
    Create relationships between data tables.
    Using Excel as a data source for Power BI
    Overview of the Power BI Data Model. Using Power BI
    The developer API
    Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimentional mode. The Developer API
    Power BI desktop queries
    Create calculated columns, calculated tables and measures. Interactive Data Visualisations
    Use Power Bi desktop to create interactive data visualisations. Direct Connectivity
    Direct connectivity from Power BI desktop
    Understand the DAX syntax and use DAX functions to enhance your dataset.
    Create a Power BI dashboard
    Using the Power BI mobile app
    Topics covered include- Introducing Power BI
    Shape data using formatting and transformations.
    Importing different data sources into Power BI
    Managing a Power BI solution
    The Power BI Interface
    Connecting to Power BI data
    Creating Power BI reports
    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 ...
  • Importing Large Datasets
    Merge datasets.
    PowerPivot
    Applying Filters
    Creating Relationships
    Use Bing maps.
    Visualizing Power View Reports
    Utilizing DAX Functions
    Utilize themes.
    Filter data.
    Configuring Drill Through
    Exploring the Power View Interface
    Perform data cleaning.
    Understand querying with natural language
    Creating Charts
    Load data.

  • 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 ...
  • Removing a Custom View and Its
    Assignments
    Understanding WBS Codes
    Deleting an Unwanted Filter
    Syncing Tasks With SharePoint
    Steps in Creating a Project
    Running an Edited Macro
    Showing and Collapsing the Ribbon
    Inserting Subprojects
    Manipulating Report Data
    Using a Lookup Table WBS Codes
    Examining Task Information
    Working With a Resource Master Downsizing Larger Projects
    Working With Project Files
    Entering Variable Costs
    Formatting a Visual Report
    Adding Simple Custom Fields
    Understanding Project VBA
    Scheduling

  • 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 ...
  • Selecting a Printer
    Working With Fixed Duration Tasks
    Contouring Work Hours
    Work Times for Multiple Assignments
    Exiting From Project  Project Management
    Working With Fixed Unit Tasks
    Understanding the Backstage
    Working With Split Screens
    Project Operations
    Adding Additional Resources
    Checking Progress
    Using the Ribbon
    Entering File Properties Creating Tasks
    Adding More of the Same Resource
    Working With Non Effort Driven Tasks
    Making Multiple Assignments
    Navigating the Help Window
    Working With Task Views
    Creating a New Resource Calendar
    Specifying Resource Usage
    Understanding Scheduling Icons

  • 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 ...
  • Checking Work For Materials Costs
    Highlighting Tasks With Specific
    Printing Specific Dates and Pages
    Working With the Standard Views
    Contouring Materials Usage
    Formatting Table Fields
    Hiding Open Files Tables
    Viewing Task Slippage Project Views
    Exporting to PDF
    Rescheduling Tasks
    Using a Custom Table
    Using Elapsed Time
    Understanding Gantt Chart Bars
    Assigning Cost Resources
    Keeping New Views Local
    Changing Time Periods
    Placing Printing Commands on the
    Creating a New Table
    Saving an Existing View
    Creating Resource Problems
    Adding Simple Custom Fields

  • 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 ...
  • Applying a Newly Organised Item
    Setting Project Links
    Understanding Resource Sharing
    Entering Lookup Table Values
    Using Only Subproject Files
    Running a Localised Macro
    Breaking Subproject Links
    Using a Lookup Table WBS Codes
    Creating Custom Fields
    Saving a Visual Report as a Template
    Saving and Closing a Combined
    Managing Shared Resources
    Saving a Project as a Template
    Using the Personal Template Folder
    Removing a Custom View and Its
    Opening Shared Resource Projects
    Understanding Excel Visual Reports
    How Graphical Reports Work
    Formatting a Visual Report
    Custom Fields

  • 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 ...
  • Disaster Recovery - backup / restore 
    Most-used Functions & Common tasks 
    Excel Services 12 and AS (Web Services)
    Actions - regular, drill-through and reporting 
    SPS RS web parts & .NET 2.0 report viewer controls 
    Cube Storage and Aggregation 
    Cube processing options 
    Intermediate SSAS
    Refining Dimensions and Measures in BIDS 
    Adding named sets 
    Excel 2003 Pivot Tables 
    OLAP Modeling 
    Data Mining clients 
    Understanding the development environment 
    Beginning MDX 
    Modeling intermediate fact tables 
    MS BI is comprehensive - more than Analysis Services on SQL Server 
    Adding scripts 
    Understanding dimensional modeling - Dimensions (Type 1, 2, or 3) or rapidly changing 

  • 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 ...
  • SSIS for DBAs: Using SQL Server Management Studio
    The Execute SQL Task 
    The Lookup Transformation 
    The Properties window 
    SSIS system variables 
    The Data Mining Model Training Destination 
    The Copy Column Transformation 
    Control Flow: The OnError event handler 
    Containers – grouping and looping 
    Creating Database Maintenance Plans using SSMS 
    The SSIS menu 
    Launching BIDS 
    The Aggregate Transformation 
    Scheduling packages with SQL Server Agent
    The Variables window 
    The Slowly Changing Dimension Transformation 
    Using variables in control flow 
    Importing and Exporting Data 
    Data Transformations 

  • 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 ...
  • Introduction to MDX Queries
    Understand the Calculation Subtab
    Understand Writeback in Dimensions
    Customize Aggregation Designs
    Use the MDX Query Editor in SSMS
    Understand SSAS Database Backup and Restore
    Explore how to add MDX Script Commands
    Review Semi-Additive Measures in OLAP Cubes
    Understand the Cube Structure
    Implement SSAS Security
    Advanced Administration and Optimization
    Discover how to add .NET Assemblies
    Understand Data Mining Concepts
    What Is Microsoft Business Intelligence?
    Understand Performance Tuning and Optimization
    Deploy and View a Sample Cube
    Define Business Intelligence
    Design Reports by using Report Builder
    Model with SQL Server Business Intelligence Development Studio (BIDS)

  • 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 ...
  • Data Flow Best Practices 
    Control Flow
    Understanding Variables 
    Packaging Logging 
    Transactions Support in Integration Services
    Installing a Package 
    Configurations 
    Handling Slowly Changing Dimensions 
    Using Variables in Control Flow 
    Custom Integration Services Components 
    Extending Integration Services Capabilities through Code 
    Using Integration Services Beyond ETL 
    Advanced Data Flow
    Going Beyond ETL
    Best Practices for Package Development and Design 
    Advanced Control Flow Overview 
    Using Advanced Transformations 
    Exploring and Executing a Package Outside of BIDS 

  • 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 ...
  • Understanding the Multidimensional Model
    The Multidimensional Solution
    Calculated Members.
    Querying the Solution and Understanding DAX
    Analysis Services Tools.
    Common Analysis Services Solutions
    Browsing the Model
    Deploying
    Understand and utilize security.
    Understanding Perspectives
    Handling Hierarchies.
    Introduction to Microsoft SQL Server Analysis Services
    Managing Measures
    Deploy a multidimensional model.
    Utilizing Translations
    Choosing the Right 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 ...
  • Managing with Control Flow
    Version Changes of SSIS From 2008-2012
    Examining the SSIS Engine
    Using the Workflow Tasks
    Choosing the Script Task or Script Component
    Understanding Variables
    Utilizing Connection Managers SQL Server Integration Services Tasks
    Understanding Packages
    Utilizing Data Preparation Tasks
    Utilizing Cache Modes in Joins Tuning SQL Server Integration Services Packages
    Coding the Script Task
    Using Expressions in Packages Containers
    Define and Use Variables and Parameters
    Handling Errors Common SQL Server Integration Services Design Patterns
    The SQL Server Integration Service
    Data Loading with the Analysis Services Tasks
    Administration of SQL Using the SQL Management Objects Tasks Data Flow
    Using the Best Practices Debugging SQL Server Integration Services Packages
    Designing to Troubleshoot: Using Precedence Constraints
    Utilizing SQL Server Integration Services Data Typing
    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 ...
  • Exploring Matrix
    Utilizing Data Sources
    Understanding HTML5 and Textboxes
    SQL Server 2016 Report Builder Graphics
    Planning Your Reports
    Working with Map Wizard
    Using the List Object to Combine Other Items
    Formatting Reports
    SQL Server 2016 Report Builder Basic Reports
    SQL Server 2016 Report Builder Advanced Reporting
    Filtering, Grouping, and Sorting
    Utilizing Chart Wizard
    Understanding Variances Between SQL Versions
    Examining Management
    Utilizing Charts
    Exploring Subscriptions
    Working with Expressions
    Examining Maps
    Utilizing Lists
    Visualizing Your Company Report Templates

  • 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 ...
  • Error Configuration Roles and Permissions
    Configure Analysis Services Project Properties
    Designing Aggregations
    Partition Writeback Calculations
    KPIs Actions
    Data Source object permissions
    Change a Partition Source
    Dimension permissions
    Define a Referenced Relationship and Referenced Relationship Properties
    Define Time Intelligence
    Attach and Detach Analysis Services Databases
    Create Measures and Measure Groups
    Define a Data Source View
    BI Wizard
    Create Local Partitions
    Define a Many-to-Many Relationship and Many-to-Many Relationship Properties Measures and Measure Groups
    Create a Dimension by Generating a Non-Time Table in the Data Source
    Add or Remove Tables or Views in a Data Source View
    Create a Dimension Using the Dimension Wizard
    Use Aggregate Functions
    Define Logical Primary Keys in a Data Source View

  • 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 ...
  • Data sources supported in tabular 1400 models
    Manage Roles by using SSMS
    Test a model in DirectQuery mode
    Delete Relationships
    Enable DirectQuery mode in SSMS
    Delete a Column
    Create and Manage Measures KPIs
    Analyze a tabular model in Excel Deploy tabular model solutions
    Row filter mappings
    Import from Power Pivot
    Data sources supported in SSAS  tabular 2016 Create Tabular Models
    Create and Manage Tabular Model Partitions
    Import Data
    Object-level security
    Add columns to a table
    Tabular model designer
    Create a New Tabular Model Project
    Import from Analysis Services
    Change table, column

  • 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 ...
  • Sorting and grouping
    Databars, sparklines, indicators, gauges, and maps
    Secure access to reports by using authentication, permissions, and SSL encryption.
    Publish a report to reporting services Working with Reporting Services Data
    Drillthrough in mobile reports
    Drilldown and drill through Sharing Reporting Services Reports
    Preparing data for mobile reports
    Overview of mobile reports
    Schedules
    Using Datasets Creating Paginated Reports
    Data filters
    Topics include Introduction to Reporting Services
    Report parameters
    Report caching, snapshots, and comments
    Extend reporting services functionality with external assemblies.
    Images and charts
    Formatting data
    Configuring data access with report builder
    Configuring data access with report designer
    Introduction to reporting services
    Mobile report publisher

  • 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 ...
  • Legend View
    Report Attributes
    A Pivoting Scenario
    Customizing the Table View
    Using Dashboard Prompts
    Adding Columns to a Request
    View XML and SQL Calls Administering The Presentation Catalog
    Logical Data Models
    Previewing the Answers
    Defining the Pivot View
    Physical Data Models Data Warehousing and BI
    Managing the Views Using Secondary Views
    Navigating the Answers Interface
    Sorting Data
    Oracle BI Architecture
    Downloading the Answers Report Formatting
    Filtering Data
    Reusing Filters
    About Business Intelligence
    Chart View
    Creating a New Request

  • 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 ...
  • Nesting Blocks 
    PL/SQL Blocks and Programs 
    Procedures and Functions 
    Declaring and Opening Cursors 
    Networking Packages 
    Oracle-Supplied Packages 
    Exception Handlers 
    Cursor Parameters 
    Dependencies and Validation 
    Records and Collections
    Oracle Directories 
    The DBMS_UTILITY Package 
    Creating a Stored Function 
    Packages 
    Creating a Stored Procedure 
    External LOBs 
    Maintaining Stored Programs
    Stored Functions and SQL 

  • 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 ...
  • Deleting a Table Definition 
    Viewing Table Characteristics 
    Intervals 
    Compound Expressions 
    SQL Queries 
    Constraints 
    Data Inconsistencies 
    Datatypes 
    The Aggregate Functions 
    Oracle Pseudocolumns 
    Oracle Versioning and History 
    Combining SELECT Statements 
    Other Database Objects 
    Using Oracle SQL*Plus 
    Using SQL Functions 
    Updatable Views 
    Connecting to a SQL Database 

  • 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 ...
  • Authenticating Users 
    PHP Statements and Whitespace
    Opening a File 
    Looping through Arrays 
    Single Quotes vs. Double Quotes 
    PHPMailer 
    How HTML Forms Work 
    Escape Character ( \ ) 
    Writing to a File 
    Code Organization 
    Querying a Database 
    Grouping ( [] ) 
    Sessions 
    Sending a Password by Email 
    flock() 
    Looping through Associative Arrays 
    Superglobals 
    PHP Operators 
    Processing Form Input 
    Array Manipulation Functions 

  • 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 ...
  • Applying a Picture Style
    Understanding the Chart Format
    Applying Multiple Effects
    Understanding Picture
    Creating a Photo Album
    Saving a Custom Template
    Applying Colour Corrections
    Using Presenter View
    Applying a Theme
    Using Quick Layouts
    Inserting an Online Video
    Resizing an Image
    Chart Elements
    Rehearsing Timings
    Understanding Media in PowerPoint
    Using a Custom Template
    Saving and Sharing Presentations
    Applying a Chart Style
    Inserting a Screen Clip
    Inserting Slide Numbers
    Deleting a Customised Theme

  • 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 ...
  • Presentation Methods and Hardware
    Editing Shapes
    Keyboard Shortcuts for Navigating
    Arranging Shapes
    Creating a Presentation
    The PowerPoint Screen
    Applying Paragraph Formatting
    Creating a Hyperlink to Another
    Inserting New Slides
    Planning a Presentation
    Adding Shapes Below
    Understanding Font Formatting
    Understanding the Status Bar
    Printing Your Presentation
    Understanding Dialog Boxes
    Converting Text to SmartArt
    Resizing Shapes
    Printing Handouts

  • See Training Course Details...


SQL

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • This generic SQL course which is applicable to most databases assumes no prior knowledge. Participants will learn how to write queries which can extract required data from a relational database SQL also enables users to aggregate and group the filtered data. The course includes topics on to manipulating data with write insert, update and delete statements. On the second day delegates learn how to create tables, views and stored procedures.

  • Some of the training topics covered include ...
  • Creating Tables
    Table Aliases
    Popular Databases
    Dropping Tables
    Benefits of Stored Procedures
    Creating Views
    Relationships
    Aliases
    The IN Operator
    Sorting By Multiple Columns
    The BETWEEN Operator
    Foreign Keys
    Sorting By a Single Column
    CASE syntax
    Aggregate Functions
    Relational Database Management System
    Creating Tables
    Conditional Processing with CASE
    NULL Values

  • 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 ...
  • Settings
    General
    The Toolbox
    Navigation
    Tables Pane
    Starting SQL Server Business Intelligence Development Studio
    Creating a Chart Report
    Design Area
    Adding Fields to the Table Data Region
    Reporting Services 2005 Client Components
    The Main Components of the Design Environment
    Using the Expression Editor Dialog
    Filters
    Static Subscription
    Model Statistics
    Data Output
    Add Report Parameter to a Dataset
    Explorer Pane
    Designing the Layout
    Reporting Services 2005 Distribution Options
    Report Design Options

  • 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 ...
  • Security
    Managing Reporting Services
    Find out how to use Report Manager to manage user accounts and roles 
    Investigate how to manage Reporting Services projects using Report Manager 
    Investigate how to use the Report Views controls inlocal mode to display reports that don’t involve Reporting Services 
    Investigate the scheduling of report snapshots 
    Explore how to use Report Builder to build ad-hoc tabular, matrix and chart reports Discover how to create Report Builder reports without using the wizards 
    Explore the potential deployment and security issues that might arise when working with custom assemblies 
    Programming Reporting Services
    Learn how to calculate group totals and percentages 
    Find out how to display parameter values in report headers 
    Explore how to create expressions in your reports using 
    Learn how to enable and control report caching 
    Learn about report variables and when you might need to use them 
    Ad-Hoc Reporting with Report Builder 2.0
    Learn how to create Report Model projects using Visual Studio and deploy them to a Reporting Services server 
    Discover the various global collections that you can reference in your expressions 
    Grouping and Sorting
    Dig into the use of unbound, multivalued, and cascading 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 ...
  • Work with MDS Databases
    Change Granularity Creating Fact Tables and Columnstore Indexes
    Introduction to Data Warehouses
    Debugging and Troubleshooting Packages
    Add Script Tasks and Script Components to an SSIS Package
    Configure MDS
    Install Integration Services Working with Integration Services
    Work with Windows Azure
    Add Data Flow Components to a Data Flow Task
    Cleanse Data Using DQS Managing SSIS Package Execution
    Secure Packages
    Introduction to Data Analysis and Reporting Concepts Creating Dimensions and Changing Granularity of Dimensions
    Track Changed Data Managing Data Flow
    Configure the Package Execution Strategy
    Create Columnstore Indexes Implementing Data Warehouses in SQL Server 2012
    Create Dimensions
    Create an SSIS Project
    Add Packages to an SSIS Project Managing Control Flow
    Profile OLTP Data
    Deploy a Control Flow
    Troubleshoot Package Failures Deploying 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 ...
  • Sharing Custom Code with Multiple Reports Calculations Using Expressions and Functions
    Creating a Customer Contact List  Creating Ad Hoc Reports With Report Builder
    Introduction to SQL Server Reporting Services
    User Collection
    Displaying the Parameter Value and Label for a Drop-Down List Parameter
    Create a Custom Function  Managing Page Layout and Adding Interactivity
    Reporting Services Modes
    Create A Shared DataSet for Northwind
    A Tour of the Report Builder Interface
    Multivalued Parameters Dynamic Reports with Parameters
    Report Project Configurations  Creating a New Report in the Report Designer
    Create a Report Based on a Shared Data Set  Creating Reports With  SQL Server Data Tools
    Sparkline
    Formatting Text Boxes in the Text Box Properties Dialogue Box
    Report Definition Language (RDL)
    Indicators
    Working with Maps and Spatial Data  Enhancing Reports with Data Visualisation
    Building a Report with Report Builder
    Create a  Parameterised Report
    Creating a Custom Age Function
    Installing and Configuring Reporting Services Reporting Services Architecture

  • 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 ...
  • Analyze Data from Query Plans
    Work with System Catalog Views Optimizing Query Performance
    Manage Views
    Filter the Queried Results
    Create Queries Using Built-in Functions
    Implement Error Handling
    Work with Window Functions
    Manage Triggers
    Work with Binary Data Types
    Work with System Databases
    Work with Subqueries
    Work with Data Access Technologies Implementing Stored Procedures
    Assign Aliases Using Queries
    Modifying Data
    Update Data
    Create Queries Using Join Algorithms
    Work with Table Expressions Working with Set Operators, Conditional Operators, and Window Functions
    Configure User-Defined Functions (UDF)
    Work with SSMS Working with T-SQL
    Control Program Flow
    Work with Variables and Batches

  • See Training Course Details...


Visio

  • 2 day course
  • Location: Uk
  • Telephone on 01952 305730
  • Course Outline
  • Some of the training topics covered include ...
  • Drawing tools
    Basic diagrams
    Shape properties
    Block, tree, and onion diagrams
    Creating a basic diagram
    Network diagrams
    Windows, stencils, and objects
    Getting started
    Working with pages
    Web site maps
    Formatting shapes and lines
    Drawing scales

  • See Training Course Details...



Email us about this courses