Business Intelligence Training Courses

Business Intelligence Training

Business Intelligence (BI) training

Business Intelligence Course Outlines

Code Name Duration Overview
68780 Apache Spark 14 hours Why Spark? Problems with Traditional Large-Scale Systems Introducing Spark Spark Basics What is Apache Spark? Using the Spark Shell Resilient Distributed Datasets (RDDs) Functional Programming with Spark Working with RDDs RDD Operations Key-Value Pair RDDs MapReduce and Pair RDD Operations The Hadoop Distributed File System Why HDFS? HDFS Architecture Using HDFS Running Spark on a Cluster Overview A Spark Standalone Cluster The Spark Standalone Web UI Parallel Programming with Spark RDD Partitions and HDFS Data Locality Working With Partitions Executing Parallel Operations Caching and Persistence RDD Lineage Caching Overview Distributed Persistence Writing Spark Applications Spark Applications vs. Spark Shell Creating the SparkContext Configuring Spark Properties Building and Running a Spark Application Logging Spark, Hadoop, and the Enterprise Data Center Overview Spark and the Hadoop Ecosystem Spark and MapReduce Spark Streaming Spark Streaming Overview Example: Streaming Word Count Other Streaming Operations Sliding Window Operations Developing Spark Streaming Applications Common Spark Algorithms Iterative Algorithms Graph Analysis Machine Learning Improving Spark Performance Shared Variables: Broadcast Variables Shared Variables: Accumulators Common Performance Issues
3119 Business Intelligence in MS SQL Server 2008 14 hours Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008. Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008. Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS. The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line. The participant will acquire knowledge of scripting XML / A and MDX. basis, objectives and application of data warehouse, data warehouse server types base building ETL processes in SSIS basic design data cubes in an Analysis Services: measure group measure dimensions, hierarchies, attributes, development of the project data cubes: measures calculated, partitions, perspectives, translations, actions, KPIs, Build and deploy, processing a partition the base XML / A: Partitioning, processes and overall Incremental, delete partitions, processes of aggregation, base MDX language
mdlmrah Model MapReduce and Apache Hadoop 14 hours The course is intended for IT specialist that works with the distributed processing of large data sets across clusters of computers. Data Mining and Business Intelligence Introduction Area of application Capabilities Basics of data exploration Big data What does Big data stand for? Big data and Data mining MapReduce Model basics Example application Stats Cluster model Hadoop What is Hadoop Installation Configuration Cluster settings Architecture and configuration of Hadoop Distributed File System Console tools DistCp tool MapReduce and Hadoop Streaming Administration and configuration of Hadoop On Demand Alternatives
powerbi Power BI 14 hours Power BI Architecture Data sources On-premises and online data sources Data transformations + M language Direct connections to selected sources (SQL Server, OLAP) Modeling Relationship between tables (single and multidirectional data filtering) DAX - templates and best practices Introduction to DAX Most commonly used functions and context of calculations Working with the time dimension (including fiscal periods, comparing periods, YTD) Hierarchie parent-child Filtering data relative to hierarchy Popular DAX templates Visualizations Interactive data analysis Select the appropriate visualization Filters, grouping, exclusions Visualization on maps Visualizations using the R language Visualization enhancements (so-called custom visuals) Data Access Management - Row-Level Security Team work and mobile with Power BI Dashboards and reports Q & A mechanism Workspaces Mobile applications    
JasperSoftBI JasperSoft BI 14 hours JasperReports is an open-source reporting library that can be embedded into any Java application. JasperReports Server is a Java EE web application with advanced reporting capabilities, including scheduling and permissions. In this instructor-led, live training, participants will learn to view and interact with business data as well as create and design reports and dashboards that are viewable on phones and tablets. By the end of this training, participants will be able to: Set up and configure a JasperSoft ETL project Design and run an ETL job Use iReport to generate charts, images, sub-reports, and cross tabs Audience BI analysts ETL developers Database professionals Format of the course Part lecture, part discussion, exercises and heavy hands-on practice   To request a customized course outline for this training, please contact us.  
TalendDI Talend Open Studio for Data Integration 28 hours Talend Open Studio for Data Integration is an open-source data integration product used to combine, convert and update data in various locations across a business. In this instructor-led, live training, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig.   By the end of this training, participants will be able to Explain the concepts behind ETL (Extract, Transform, Load) and propagation Define ETL methods and ETL tools to connect with Hadoop Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements Audience Business intelligence professionals Project managers Database professionals SQL Developers ETL Developers Solution architects Data architects Data warehousing professionals System administrators and integrators Format of the course Part lecture, part discussion, exercises and heavy hands-on practice To request a customized course outline for this training, please contact us.  
PentahoDI Pentaho Data Integration Fundamentals 21 hours Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations. In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle, maximizing the value of data to the organization. By the end of this training, participants will be able to: Create, preview, and run basic data transformations containing steps and hops Configure and secure the Pentaho Enterprise Repository Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format. Provide results to third-part applications for further processing Audience Data Analyst ETL developers Format of the course Part lecture, part discussion, exercises and heavy hands-on practice To request a customized course outline for this training, please contact us.

Upcoming Courses

CourseCourse DateCourse Price [Remote / Classroom]
Business Intelligence in MS SQL Server 2008 - HamburgTue, 2017-10-10 09:302630EUR / 3130EUR
Apache Spark - StuttgartTue, 2017-10-10 09:304530EUR / 5030EUR
Power BI - DüsseldorfMon, 2017-10-16 09:301410EUR / 1910EUR

Other regions

Weekend Business Intelligence courses, Evening Business Intelligence training, Business Intelligence boot camp, Business Intelligence instructor-led , Business Intelligence classes, Business Intelligence instructor, Business Intelligence private courses, Evening Business Intelligence courses, Business Intelligence coaching, Business Intelligence training courses,Weekend Business Intelligence training, Business Intelligence on-site, Business Intelligence trainer

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients