Enable Technology



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 ...
  • Data Mining Concepts
    The User Interface
    Accuracy and Validation
    Creating Reports Using Reporting Services
    Concepts and Terminology
    Data Source
    Exploring Data
    Data Preparation
    Named Calculation
    Microsoft Decision Trees Algorithm
    Microsoft Association Algorithm
    Multiple Nested Tables Microsoft Data Mining Algorithms
    Microsoft Sequence Clustering Algorithm
    Microsoft Logistic Regression Algorithm
    Topics include:
    Visio Data Mining Add-In  
    Microsoft Neural Network Algorithm
    Models, Induction and Prediction SQL Server Analysis Services Data Mining Tools
    Types of Data Mining Algorithms
    Testing and Validation of Mining Models

  • 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 ...
  • Understanding DAX
    Creating PivotTables
    Utilize themes.
    Use Bing maps.
    Add time to a presentation.
    Using Cards
    Power View
    Merge datasets.
    Adding Slicers to Reports
    Importing Data with a Query
    Navigate the Power Query interface.
    Calculated Columns and Calculated Fields
    Perspectives Power Query
    Importing Data
    Manage modifications.
    Examine map data.
    Understanding Aggregations
    Creating a Cascading Relationship

  • 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 ...
  • Warehouse Models and Schemas
    Chart View
    Basic Navigation Using A Dashboard
    Sections and Pages
    Previewing the Answers
    Accessing The Presentation Catalog
    Controlling the Report Definition
    Filters View
    Report Attributes
    Viewing the Request Results
    Warehouse Databases
    Sorting Data
    Defining the Pivot View
    Column Formulas Using Primary Views
    A Pivoting Scenario
    Databases and Data Models
    Understanding The Dashboard Interface
    Pdf and Print Control
    Preparing Objects for Dashboard Deployment
    Understanding the Dashboard Structure
    Managing Dashboard Objects Creating a Report

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Data Warehouse - Uk SQL Training Courses
Project 2016 L1 - Uk Microsoft Project Training Courses
Power BI - Uk Microsoft Power BI Training Courses
SSRS 2014 Uk Training Courses
SSAS 2017 Uk Training Courses
PL/SQL Uk Training Courses
VBA - Uk Excel Training Courses
Crystal 2011 - Uk Crystal Reports Training Courses
SQL Uk Training Courses