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 ...
  • Compare Mining Structures
    Topics include:
    Data Mining Tab
    Data Source
    Saving Results to the Database
    Microsoft Logistic Regression Algorithm
    Microsoft Neural Network Algorithm
    Introduction to SQL Server Data Tools
    Model Usage
    Saving Queries
    Microsoft Time Series Algorithm
    Named Calculation
    Named Queries
    Visio Data Mining Add-In  
    Cross Validation
    Offline Mode and Immediate Mode
    Data Preparation
    Data Modelling
    Accuracy and Validation

  • 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
    Totals within Pivot Tables Advanced Formatting
    Pdf and Print Control
    Ticker View
    Column Formulas Using Primary Views
    Downloading the Answers Report Formatting
    Gauge View
    View XML and SQL Calls Administering The Presentation Catalog
    Launch BI Presentation Services
    About Database Technologies
    Reusing Filters
    Navigating the Answers Interface
    Managing Presentation Catalog Objects Deploying Requests to Dashboards
    Databases and Data Models
    Warehouse Models and Schemas
    Preparing Objects for Dashboard Deployment
    Miscellaneous Tasks Building a Dashboard
    Warehouse Databases
    Filters View
    Controlling the Report Definition
    Using Dashboard Prompts

  • 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 ...
  • Utilise data sources.
    Load data.
    Creating Relationships
    Navigate the Power BI interface.
    Drill Through
    Visualizing Power View Reports
    Filter data.
    Exploring the Power View Interface
    Add time to a presentation.
    Use Bing maps.
    Calculated Columns and Calculated Fields
    Understand querying with natural language
    Importing Data with a Query
    Navigate the Power Map interface.
    Merge datasets.
    Understanding DAX

  • See Training Course Details...

Email us about this courses

Other Uk Enable Technology Training Courses

Microsoft Project Level 3 Uk Training Courses
Power BI - Uk Microsoft Power BI Training Courses
Oracle SQL Uk Training Courses
PL/SQL - Uk SQL Training Courses
Report Builder Uk Training Courses
SSRS 2008 Uk Training Courses
CSS Uk Training Courses
Project 2016 L1 Uk Training Courses
HTML Uk Training Courses