Overview

During the Eight (8) weeks training, you will learn about the different ingredients of Data Warehouse such as Dashboards, Data Modeling, Teradata and Advance SQL.

In the subsequent weekly distribution of the course, participants will have hands-on experience on live platforms with different tools of the Business Intelligence such as Talend and Power BI. In the hands-on projects, you will be able to implement your learnings throughout this course.

At the end of the course, candidates will have an in-depth understanding & hands-on related to DWH & Business Intelligence.

Tools Covered

Who Should Attend?

Graduate or Masters Students with IT, CS or Business background who want to start their career in the Data Analytics domain People who are working in the BI domain and want to advance their career in the field of Data Analytics Executive who want to build a Data Analytics department in their start-ups/organizations

What are the Takeaways?

Understand the fundamentals of data warehousing, including its architecture, components, and benefits.
Comprehend the key concepts and techniques of business intelligence, such as data analytics, data visualization, and reporting.
Design and implement an efficient and scalable data warehouse solution, considering data modeling, data integration, and data transformation.
Utilize various data warehousing technologies and tools, such as ETL (Extract, Transform, Load) processes, data integration platforms, and data warehouse management systems.

Course Outline

Week 1
Week 2

Data Analytics Ecosystem
Scorecard vs Dashboard
Implementations of DWH
Hands on SQL basics
Data Science vs Business Intelligence
DWH Planning
Introduction to DWH
Databases VS RDBMS
Exercise on DWH Importance
Hands on SQL Advanced
Overview of DWH & BI Certifications
OLTP vs OLAP
DWH Soft Architecture & layers
Introduction to Teradata
Introduction to Teradata HW Architecture
DWH Project Distribution on Retail Industry

Teradata Architecture
Data Quality & Automation
Retentions, Compressions
Data Modeling (Conceptual and Logical Data Model and Physical Data Model)
DWH Operations
Modern Data Warehouse vs Traditional
Normalization
ETL/ELT/ELTL/Data Lake

Week 3
Week 4

Hands on Logical Data Model
Queries/Processes Monitoring through TD Viewpoint
Hands on Physical data model (Staging layers)
Implementing Data Quality in ETL development

Hands on physical Data Model (Foundation layer)
ETL Automations using SLJM
Viewpoint Query Monitoring, Health Monitoring, Workload Management, Query Spotlight
Hands on Physical Data Model (Aggregate layer)
Performance Tuning
Learning importance of Explain Plan & query Performance Optimization
Building Reconciliation Mechanism across layers of DWH
Statistics

Week 5
Week 6

What is Talend?
Components introduction
Sample Job Development
Export/Import jobs
Type casting
Date manipulation
Die on Error
Talend’s Global position
Teradata Components
Metadata Management
File Management
If else (case statement)
Join specifications

Pre & Post job components
SCD 1 job
Flow meter
Defining start component
Versioning
Job Scheduling
Parent-Child jobs & Batches
SCD 2 job
Talend job settings
Sending Emails
Creating Custom Java functions
ELT components

Week 7
Week 8

Business Intelligence & its importance
Dimensional Modelling Design with industrial use case
Slowly Changing Dimensions (SCDs) with use cases
Hands on Business Analysis (Ad hoc Reporting)
Design Steps – Dimensional Modeling (Hands on)
ROLAP VS MOLAP
OLAP – Dimensional Modelling Fundamentals
Implementation – Dimensional Modeling (Hands on)
Design and implementation of Dimensional Model on Retail Store Data (Assignment)

How to Connect & Import Data from multiple Data sources
Data Modelling
Animated Visualization Implementation
Introduction to Power BI Service
Sharing Dashboards All across Organization
Reshaping and Transforming Data in Query Editor
Understanding Cardinalities
Roll-up/Roll-Down Capabilities
Scheduling Automated Reports Refresh
Mobile Dashboard Design
Data Enrichment (New business Fields)
Building Interactive Visualizations on previously implemented Dimensional Model

Our Methodology

Industry Usecases

With real world projects and immersive content built in partnership with top tier companies, you’ll master the tech skills companies want.

Technical Support

Our knowledgeable mentors guide your learning and are focused on answering your questions, motivating you and keeping you on track.

Career Mentorship

You’ll have access to resume support, portfolio review and optimization to help you advance your career and land a high-paying role.

Frequently Asked Questions

How much hands-on will be performed in this course?

Since our trainings are led by Industry Experts so it is made sure that content covered in workshop is designed with hand on knowledge of more than 70-75 % along with supporting theory.

What are the PC requirements?

For this professional workshop, you need to have a PC with minimum 4GB RAM and ideally 8GB RAM.

What If I miss any of the lectures?

Don’t worry! We have got you covered. You shall be shared recorded lectures after each session, in case you want to revise your concepts or miss the lecture due to some personal or professional commitments.

How will this training ensure hands-on practice?

For executing the practical’s included in the DWH & BI Training, you will set-up tool on your machine. The installation manual for tool prep will be provided to help you install and set-up the required environment.

What sort of projects will be part of this trainings?

This Training course includes multiple real-time, industry-based projects, which will hone your skills as per current industry standards and prepare you for the future career needs

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and recommend the shinning students in industry for relevant positions.

LATEST NEWS

CONTACTS