| Available 24 Hours Monday - Friday | 01344 203999
Please enter course

Got a quick question or comment?
Send us enquiry.

Enter your details and we will call you back to discuss your requirements

Data Management

  • Recommended for business intelligence specialists, data warehouse designers and more
  • Gives an overview of new developments and their inter-relationships
  • Learn about new BI developments
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Courses delivered by world class training instructors
  • Training provided in in luxury venues 
  • The training course includes material, manuals and exam preparation
  • Book Online or Call 01344 203 999 to speak to a training advisor today

Course Dates, Locations & Prices (Top) | View Course Info

Course Name Date Location Duration Price Book Online
Data Modelling Fundamentals 06/04/2017 London
2 days £1949 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Doncaster
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Darlington
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Buxton
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Teesside
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Poole
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Preston
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Guildford
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Peterborough
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Maidstone
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Edinburgh
2 days £2249 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Newcastle
2 days £2249 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Bromley
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Swindon
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Warrington
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Bracknell
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Harrogate
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Corby
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Heathrow
2 days £2549 Book now Enquire
Data Modelling Fundamentals 06/04/2017 Sunderland
2 days £2549 Book now Enquire

Course Information (Top) | View Dates & Pricing

Overview

Introduction

This course provides delegates with a clear and extensive overview of the new developments within Business Intelligence, Big Data and Big Warehousing, and their inter-relationships. It also provides a unique opportunity for delegates to see and learn about the new BI developments. It provides an update for those interested In knowing how to make BI systems ready for the coming 10 years.

Pre-Requisites

  • There are no prerequisites for this course

Who should attend?

This course is recommended for:

  • Business Intelligence Specialists
  • Data Warehouse Designers
  • Business Analysts
  • Technology Planners
  • Technical Architects
  • Enterprise Architects
  • IT Consultants
  • IT Strategists
  • Systems Analysts
  • Database Developers
  • Database Administrators
  • Solutions Architects
  • Data Architects
  • IT Managers

Course Outline

The Changing World of Business Intelligence

  • Big Data: Hype or reality?
  • Operational intelligence: does it require online data warehouses?
  • Data warehouses in the cloud
  • Self-service BI
  • The business value of analytics

Overview and Status of Analytical SQL Database Servers

  • Are classic SQL database servers still suitable for data warehousing?
  • Important performance improving features
  • Market overview of analytical SQL database servers, Actian Matrix and Vector, EMC/Greenplum, Exasol, HP/Vertica, IBM/Netezza, Kognitio, Microsoft, SAP HANA and Sybase IQ, Teradata Appliance and Teradata Aster Database

Big data, Hadoop and NoSQL for Data Warehouses

  • The relationship between big data and analytics
  • The Hadoop software stack explained, including HDFS, MapReduce, YARN, Hive, and HBase
  • Classification of NoSQL database servers: key-value stores,  document stores, column-family stores and graph data stores
  • The balancing act: productivity versus scalability
  • Market overview: Apache Hadoop and CouchDB, Cassandra, Cloudera, DataStax, IBM InfoSphere BigInsights, InfiniteGraph, MapR, Microsoft SQL Azure, MongoDB, Neo4j and Oracle Big Data Appliance
  • Making big data available to a larger audience with SQL-on-Hadoop engines, such as

New Business Intelligence Architectures

  • Discussion of different BI architectures, including Kimball’s Data Warehouse Bus, Architecture, Inmon’s Corporate Information Factory, DW 2.0, the Federated Architecture, the Centralized Warehouse Architecture, the Data Virtualization Architecture, and the SaaS BI Architecture
  • Do we still need data marts?
  • What is the role of master data management in BI architectures?
  • Enforcing data quality in different BI architectures
  • Using data vault to create more flexible data warehouses
  • Data warehouse automation to create data warehouses and data marts faster
  • New Forms of Reporting and Analytics
  • Mobile BI, Exploratory analysis, self-service BI
  • Collaborative analytics: the marriage of social networks and BI
  • Tools for embedded analytics
  • Investigative analytics and the data scientist
  • Data Virtualization for Agile BI systems and Lean Integration
  • Data virtualization offers on-demand data integration
  • Open versus closed data virtualization servers
  • Market overview:  Cirro Data Hub, Cisco/Composite Information Server, Denodo Platform, Informatica Data Services, RedHat Jboss Data Virtualization and Stone Bond Enterprise Enabler
  • Importing non-relational data, such as XML documents, web services, NoSQL and Hadoop data, and unstructured data
  • Differences with data blending
  • Operational Business Intelligence
  • Analytics at the speed of business
  • Different forms of operational BI: operational reporting, operational dashboarding, operational analytics and embedded analytics
  • What is time-series analysis?
  • Integrating operational and historical data
  • The role of data replication, rule engines, complex event processing and ESBs
FAQs
  • Course Availability

    The spaces remaining on all courses across the website reflect the availability of the maximum printed course materials and equipment available in stock for any given event. If the spaces remaining do not appear, then there is comfortably enough lead time to provision course materials and equipment upon booking.

  • What time shall I arrive at the venue?

    Please arrive at the venue for 08:45am

  • What are the pre-requisites?

    There are no pre-requisites for this course

  • What is the duration of this course?

    This course is 2 days

  • Who should attend this course?

    This course is recommended for: • Business Intelligence Specialists • Data Warehouse Designers • Business Analysts • Technology Planners • Technical Architects • Enterprise Architects • IT Consultants • IT Strategists • Systems Analysts • Database Developers • Database Administrators • Solutions Architects • Data Architects • IT Managers

  • What does The Knowledge Academy provide me with on the course?

    Manual, Certificate, Experienced Instructor, Refreshments

  • How long until I receive the course confirmation details?

    Once your booking has been placed and confirmed, you will receive an email which contains your course location, course overview, pre-course reading material (if required), course agenda and payment receipts

  • What is the experience of the instructor(s) delivering my course?

    All of our instructors are fully accredited and have over ten years of experience

What's Included?
  • Manual
  • Certificate
  • Experienced Instructor
  • Refreshments
Video

We do not currently have a video for this topic

Send us your onsite requirements and we will
provide a tailor made course for you!

Happy Customers

There hasn't been any testimonials submitted to this topic