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