Data Warehousing and BI Certification Training

The Data Warehousing and BI training provides in-depth knowledge about the business intelligence and data warehousing tools and technologies. Data Warehousing is the collection of business data and that is transformed into business information which is used for profitability. Data Warehousing using for Business intelligence and that helps to provide a coherent picture of the business at any time. The training also helping the stakeholders arrive at decisions that are important for the running the business.

Throughout the training, the delegates will enhance their design and data manipulation skills. With the help of Data Warehousing and BI training, the delegates will learn to integrate and visualise data by using the Visual Analytics and dashboards. At the end of the Data Warehousing and BI training, the delegates will be able to design and build a data warehouse for BI incorporating all the advanced concepts, tools and technologies that they have learned.

The Data Warehousing and BI training introduces the delegates to create and work with leading ETL & BI tools such as:

  1. Talend 5.x to create, monitor, implement and schedule ETL processes. It will cover the advanced concepts including Migration, Integration Operations and Data Replication.
  2. Tableau 9.x for data visualisation to understand how easy and reliable data visualisation can become for representation with dashboards
  3. Data Modeling tool ERwin r9 to create a Data Warehouse or Data Mart

Prerequisites

For attending this training, the delegates should have basic knowledge of SQL, Microsoft Windows GUI, General Relational Database (Oracle), Windows Command line and Basic Unix. 


Course Objectives

After the completion of Data Warehousing and BI Certification Training at Silicon Beach Training, the delegates will be able to:

  • Understand the fundamentals of Database management, the foundation for Data Warehousing and Business Intelligence
  • Understand the Master SQL coding for answering business intelligence questions
  • To design data warehouses
  • Understand how to build data integration workflows
  • Learn how to use the features of relational database management systems in Business Intelligence reporting
  • Understand about the Tools and Applications of Business Intelligence
  • Understand about the DW Architecture, Data Modeling, ETL fundamentals, ERwin, Data Visualisation and Business Reporting and

Who is this course for?

The course is designed for all those delegates who wants to learn more about the Data Warehousing and Business Intelligence and below professionals also can attend this training:

  • Data warehousing enthusiasts
  • ETL Developers and BI Developers
  • Data Modelers
  • Analytics Managers

Introduction to Data Warehouse & Business Intelligence

  • An overview of Data Warehousing
  • Inmon Vs Ralph Kimball
  • Data Warehousing tools
  • Schema Modeling Tools
  • CA and Erwin
  • About the Dell Toad Data Modeler
  • Oracle Data Modeler
  • ETL Tools:
  • Informatica Power Center
  • SAS
  • IBM Data Stage and categories of Data Warehousing
  • Talend DI Open Studio
  • Introduction to Business Intelligence?
  • Tools of Business Intelligence
  • Classification of BI Tools

Data Warehouse Architecture

  • Relational Vs Analytical
  • Introduction to OLTP and OLAP
  • Categories of OLAP - MOLAP, HOLAP and ROLAP
  • Data Warehouse Vs Data Mart
  • Dependent and Independent Data Mart
  • About the Data Warehouse Architecture
  • Source System, ETL Extraction and Transformation
  • Introduction to cube?
  • Advantages of the cube
  • How to create a report using a cube?
  • How to create and deploy the cube?

Data Warehouse Dimension & Fact Tables

  • About Dimension table
  • Dimension table categories
  • Introduction to Fact Table
  • Fact Table Granularity
  • Categories of Fact table

Data Modeling

  • Introduction to Data Normalization?
  • Overview of the Data Normalization Rules - 1NF, 2NF, 3NF
  • Data De-Normalization
  • What is Dimensional Modeling
  • Principles and Benefits of Dimensional Modeling
  • Dimensional Modeling type and technique

Building Data Warehouse with Erwin

  • Source System Understanding
  • Understand of Future Data Requirement
  • Designing and Developing Fact Table, Dimension Table and Entity Relationship Modeling
  • Designing and Developing ER Model With Erwin

Introduction to Open Source ETL Tool Talend DI Open Studio 5.x

  • Open source ETL Talend DI Open Studio
  • Difference between Licensed and Open Source ETL Tools
  • What are Open Source ETL Tools and Licensed
  • Working with ETL Transformation in Talend Open DI Studio

Building ETL Project with Talend DI Open Studio 5.x

  • Building ETL Project Talend DI Open Studio
  • Understanding the Data Source System
  • Identify Business Requirement Gathering
  • Building the ETL Talend Technical Design Document, Building an ETL Project 

Introduction to Data Visualization BI Tool Tableau 9.x

  • Data Visualization BI Tool: Tableau 9.x-Introduction to Data Visualization with Tableau and Exploring Data Visualization with Tableau
  • Introduction to the Data Visualization
  • Exporting Data and Working With Tableau

Building Data Visualization BI Project with Tableau 9.x

  • Building Data Visualization BI Project With Tableau 9.x,
  • Understanding of BI Reporting
  • Report and Dashboard Template Document
  • Development Database Source Connection

An Integrated Data Warehousing & BI Project

  • An Integrated Data Warehousing & BI Project, Developing a Data Warehouse and BI Project
  • Source System understanding today's data that will be the future data requirement
  • Identify the Business Requirement Gathering
  • Report and Dashboard Template Document
  • Designing and Developing Models and the Staging Area
  • Designing and Developing Dimension Modeling
  • Designing and Developing Finalizing the Dimension Modeling Type

Keypoints

keypoints

Starting Price:£875

Duration:1 Day

Data Warehousing and BI Certification Training Calendar

Filters

Select Your Course

Select Your Location

Select Delivery Method

Keypoints

keypoints

Starting Price:£875

Duration:1 Day

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Buxton, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Corby, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Derby, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Hinckley, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Leicester, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Lincoln, UNITED KINGDOM

duration

Duration : 1 Day

dates

5 Nov 2021

£2195

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

29 Oct 2021

£795

Data Warehousing and BI Certification Training

Best Selling Course in UNITED KINGDOM

flag

Virtual, UNITED KINGDOM

duration

Duration : 1 Day

dates

19 Nov 2021

£795

Data Warehousing and BI Certification Training

Complete the steps below to receive a quote or more information

Enter Your Details

What is your name?*
user
Course Name
course

How Many Employees Need Training?

Enter More Details

call
company
address
message

When Would You Like to Take the Course?

Add Additional Features

Your Online (Data Warehousing and BI Certification Training) Package

Upon purchase you will receive a password via the email you used to purchase the course.

You will then be able to login to our online learning platform with your email and password.

You will have access to the platform for 90 days to complete your course.

Enroll Now for Our Online Course

£875

enquire Enquire Now
meeting

Upcoming Dates

Onsite Training

Our Onsite/In-house Training method is most selected by organisations, as it allows them to train their employees at their choice of place. We can also tailor the course content to focus on your needs.

Leading Path to Success

step-1

Find a course and let us know how you would like to learn.

Step 1

step-2

Select your preferred method of training for the course.

Step 2

step-3

Confirm your seats.

Step 3

step-4

Get an excellent experience with our qualified instructors.

Step 4

step-5

Acquire skills and achieve your career goals.

Step 5

460+

Courses

92+

Locations

126K+

Learners

Some Facts Worth Shouting About

To win in this competitive world, you need to be constantly moving forward, and Silicon Beach Training is the one that can help you. Our courses are highly engaging as we have high-quality and certified training courses for both individuals and organisations that are structured in easy to digest modules. We don't compromise on the quality of our trainers. We have:

Our Clients

With extensive experience working with large organisations, national and local government, universities, charities, SMBs and individuals we believe that no client is too big or too small. This creates a diverse atmosphere on our scheduled courses with the opportunity to discuss solutions for a wide range of problems. We excel at developing bespoke training solutions for prestigious clients including EDF Energy, Sport England and Tesco PLC.

Banco Central Do Brasil

Nationwide Building Society

EDF Energy

EDF Energy

Sport England

Sport England

Tesco PLC

Tesco PLC

Imperial College London

Imperial College London

Request info Get Free Advice Quick Enquiry
LOADING