Data Warehouse And BI Certification Training

Data Warehousing and BI Certification Training

Become an expert in Data Warehousing and Business Intelligence techniques covering concepts like DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Data Warehousing And Bl Certification Training UpComing Batches

Dec-21 - Feb-01

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-14 - Jan-25

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-21 - Feb-01

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-28 - Feb-08

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Jan-04 - Feb-15

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-11 - Feb-22

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

DOWNLOAD BROCHURE

Data Warehousing and BI Certification Training

SELF PACED

Become an expert in Data Warehousing and Business Intelligence techniques covering concepts like DW Architecture, Data Modeling, ERwin, ETL fundamentals, Business Reporting and Data Visualisation.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Data Warehouse And BI Techniques

Learning Objectives - In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling. 

Topics :

  • What is Data Warehousing?.
  • Definitions by W.H. Inmon [Top-Down Design], Ralph Kimball [Bottom-Up Design], Inmon Vs Ralph Kimball.
  • Data Warehousing Tools.
  • Schema Modeling Tools, CA, ERwin, Dell Toad Data Modeler.
  • Oracle Data Modeler.
  • ETL Tools: Informatica Power Center.
  • Talend DI Open Studio.
  • IBM Data Stage.
  • SAS.
  • Data Warehousing Categories.
  • What is BI - Business Intelligence?
  • BI Definition.
  • BI Tools.
  • Classification of BI Tools.

Learning Objectives - In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e., Production Data into Relational, Flat File and various legacy system to Staging Area and finally into the Data Warehousing/Data Mart for presentation layer. 

Topics :

  • Relational Vs Analytical.
  • What are - OLTP.
  • OLAP categories - MOLAP, ROLAP, HOLAP.
  • Data Warehouse Vs Data Mart, Dependent and Independent Data Mart.
  • Data Warehouse Architecture.
  • Source System.
  • ETL Extraction, Transformation.
  • What is a Cube?
  • Benefits of Cube?
  • How to Create the Cube?
  • How to Deploy a Cube?
  • How to Create a Report using a Cube?

Learning Objectives - In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension - Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact - Granularity for the fact data and also talks about the Measure Type. 

Topics :

  • DIMENSION TABLE - What is a Dimension Table?
  • Dimension Table Categories.
  • FACT TABLE - What is Fact Table?
  • Fact Table Granularity.
  • Fact Table Categories.

Learning Objectives - In this module, you will learn about What is Data Normalization and their 3 types of forms. Here you learn about the type of dimensional modeling, benefits, principles and characteristics 

Topics :

  • What is Data Normalization?
  • Data Normalization Rules - 1NF, 2NF, 3NF.
  • Data De-Normalization.
  • Dimensional Modeling - What is DM?
  • Principles.
  • Benefits.
  • Type and Technique.

Learning Objectives - In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERwin r9. 

Topics :

  • Source System Understanding.
  • Future Data Requirement and Understanding.
  • Designing and Developing Dimension Table.
  • Designing and Developing Fact Table.
  • Designing and Developing ER Model With ERwin.
  • Designing and Developing Entity Relationship Modeling.

Learning Objectives - In this module, you will learn about the open source and commercial ETL Tools available into the market and it various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations. 

Topics :

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

Learning Objectives - In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD[Business Requirement Document] and TDD [Technical Design Document] and its uses. 

Topics :

  • Building ETL Project with Talend DI Open Studio.
  • Understanding the Data Source System which will be a future Data Requirement.
  • Identify Business Requirement Gathering.
  • Building the ETL Talend Technical Design Document.
  • Building an ETL Project.

Learning Objectives - In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions. 

Topics :

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

Learning Objectives - In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirement. 

Topics :

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

Learning Objectives - This is an integrated Data Warehousing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments. 

Topics :

  • 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.
  • Designing and Developing the Staging Area.
  • Finalizing the Dimension Modeling Type.
  • Designing and Developing Dimension Modeling.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Curriculum

Projects

Which case studies will be the part of this course?

Creation of Sales Data Warehouse & Data MartsIndustry : Retail Data : North-wind/Adventure Works dataset. Problem Statement: Creation Sales Data Mart using erwin r9.

What are the pre-requisites for this course?

The pre-requisites for this course include basic knowledge of SQL, General Relational Database (Oracle), Microsoft Windows GUI, Basic Unix, Windows Command line.

How will I execute the practicals?

For doing the practicals we will help you to setup erwin r9,Talend 5.x and Tableau 9.x. The detailed installation guides are provided in the LMS for setting up the environment. In case you come across any doubt,the 24*7 support team will promptly assist you.

Course Description

About The Course
About Kubernetes Certification Training DevOps improves collaboration and productivity by automating infrastructure and workflows and continuously measuring applications performance. In this course you will learn about Version Controlling, Code Automation, Continuous Integration, Continuous Deployment, Configuration Management, and Monitoring of application.
Objectives Of Our Online PySpark Training Course
Course Objective. OL Tech Edu's Kubernetes Certification Training introduces you with the advantages provided by containers over the virtual machines.
  • You will understand why we need an orchestration tool for containers. You will also get to know the boundaries of Kubernetes – what it does and what is it not supposed to do.
  • You will also understand the inherent architecture of Kubernetes – master components, node components and the addons provided by it.
  • The course will start off with learning the basic components of Kubernetes like Node, Pod, Deployment, Services, APIs etc and then teach you to create a local cluster using Ubuntu VMs.
  • You will also learn to deploy stateful and stateless apps on the cluster. Finally, you will learn, how to expose these app outside of the kubernetes cluster and will also get to know how to scale their apps either manually or using auto scaling.
  • Learn the best security practices that must be followed during this container and cluster orchestration.
Go For Online Spark Training
Who should go for this training? There is a huge shift in Devops from virtualization to containerization. Docker has been the buzzword in the technology sphere, in the recent past to ship applications as containers. A research states that there are already 10,000 companies who have adopted containers for taking their application to production and there are already 185 million containers on use in the world. The rate of adoption of Docker is increasing by 40% every year. Now that Docker has become the most integral part of production environment, various organizations are now looking out for tools that can help them effectively manage and orchestrate their containers. Here is when industries started adopting a Google open sourced tool called Kubernetes for effectively managing the containers.
Learning With Our PySpark Certification Training
Who should go for this Kubernetes Certification course? This course is designed specifically for:
  • Professionals who want to Advance their career as a Devops Engineer.
  • Professionals who want to ace the Certified Kubernetes Application Developer (CKAD) program by Cloud Native Computing Foundation.
  • Individuals using containers to deploy applications to production.
Who Should Go For Our PySpark Training Course
What are the pre-requisites for this Kubernetes Certification Training? Following are the pre-requisites:
  • Basics of Devops and it's need.
  • Understanding the process of deploying an application from scratch to production servers.
  • Knowing the difference between stateful and stateless application.
  • Basic Understanding of Docke.
Who Should Go For Our PySpark Training Course
What are the objectives of Kubernetes Certification Training? After completing the training, you will be able to:
  • Understand the basics of Kubernetes.
  • Understand the architecture of Kubernetes.
  • Install and Configure a cluster on bare metal machines.
  • Deploy any app (stateless and stateful) to the cluster and scale it manually or automatically.
  • Manage the state with deployments.
  • Understand about Services, Pods, Volumes, data and Ingress.
  • Know how to schedule applications on the containers.
  • Audit logs and troubleshoot the cluster.
  • Create federations to manage clusters.
  • Know the best security practices to follow.

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Course FAQ's

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers