Data Engineering for Corporates without a Data Strategy

Exploring data engineering without a data strategy!

Duration

2 Days

Level

Basic Level

Design and Tailor this course

As per your team needs

Edit Content

The program is focused on understanding basics of BI Architecture, Data warehousing, and ETL concepts.

Edit Content

This program is designed for students who aspire for Data Engineers roles.

Edit Content

Building a Data Driven Organization

What is a Data Driven Organization?
How can this be enabled in an Organization?
Factors to consider
Roles and Responsibilities of Key Stakeholders
Enterprise Architecture of a Data Driven Company
Minimal Tools/Technologies
Summary

Data Extraction, Preparation & Governance

Terms & Concepts
- Facts
- Dimensions
- Data Sources
- Data Warehouse
- Data Marts
- Cubes
- Operational Data Stores (ODS)
- Data Staging
- Best Practices & Best Fit Considerations
ETL using DataFusion
What is ETL?
How is it different from ELT?
What are the key tools involved in extraction, loading and transformation?
Why is Data Preparation important?
How to prepare Data?
Who prepares it?
What is Data Governance?
Why is it important to the success of an organization?
Who is responsible for it?
What is Data Quality?
How to ensure DQ?
Key Tools available
Role of Metadata
Demo
DataFusion Hands-on
Summary

Data Storage & Modeling

Online Transaction Processing Systems
Online Analytical Processing Systems
OLTP vs OLAP
Key Data Storage Options
Which one to choose when?
Approaches of Data Modeling
Logical Model, Physical Model
Entity-Relationship & Dimensional Modeling
Thinking like a Data Modeler
Types of Star vs Snowflake
Normalized vs Denormalized
Google Cloud Storage
NoSQL Databases
Data Formats
Which one to choose when?
Demo
Hands-on
Summary

Business Intelligence using DataStudio

What is Business Intelligence?
Importance of Data in BI Tools
Dashboard Reporting Concepts
Effective use of BI Tools
Connect to Data In DataStudio
Creating Datasets from Data Models and Data Files
Getting Started with DataStudio
Using Quick Insights to Explore a Dataset
Viewing Reports
Summary

Edit Content

Participants should preferably have basic knowledge of any programming language constructs.

our Footprints

Quick Links

our Offerings

Follow Us

Sign up for DataCouch Communications

Copyright 2024 © DataCouch

Apache, Apache Kafka, Apache Spark, Apache Trino, Apache Iceberg, Apache Hive, Kafka, Spark, Trino, Iceberg, Hive, and other associated open-source project names are the Apache Software Foundation trademarks. Starburst, Starburst Data, Starburst Enterprise, and Starburst Galaxy are registered trademarks of Starburst Data, Inc. All rights reserved. DataCouch is not affiliated with, endorsed by, or otherwise associated with the Apache Software Foundation (ASF) or any of its projects.