Data Warehousing and BI Training in Singapore

Data Warehouse Dimension & Fact Tables:

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.

Data Modeling:

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.

Building Data Warehouse with ERwin:

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.

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

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 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.

Building ETL Project With Talend DI Open Studio 5.x:

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 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.

Introduction to Data Visualization BI Tool Tableau 9.x:

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.

Building Data Visualization BI Project With Tableau 9.x:

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.

An Integrated Data Warehousing & BI Project:

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.

Vidya

Python Flask

I am from Robert Bosch and have taken up Python Flask corporate training from myTectra. I am very much satisfied and happy with this customized training. The tutor was extremely helpful and adjustable and provided the best insightful training.

Top

Trainers

Placement

Assistance

Quality

Training

Sanjana

AI & ML

I did Machine Learning(ML) & Artificial Intelligence(AI) in mytectra. myTectra was very helpful for me during my whole journey of this course. The trainer was very nice. He taught me all the basics concepts very nicely. myTectra provided me the opportunity to work on live projects of my course.

100+ Popular IT Courses to Learn.

15+ Categories. 500+ IT Courses to Learn.

Leadership Program

100+ Popular IT Courses to Learn.

15+ Categories. 500+ IT Courses to Learn.

Leadership Program

Data Warehousing and Business Intelligence Training in Singapore

Learn Virtually Anywhere. Award-Winning Training Company.

Success Factors:

About Program

Join myTectra to Up-Skill on the most popular programming languages Python !

Curriculum

Reviews

Drop Us a Query!

Training Features

Classroom Training

Live-Online Training

Real-life Case Studies

Forum

24 x 7 Expert Support

Certification

Ask for Free Demo Now!

Yes, I want a demo!

Blogs →

Interviews Questions →

Community →

Drop us a line