COURSE OVERVIEW
Dive into the world of data warehousing, discover the differences between data lakes and warehouses, and learn to harness modern tools like BigQuery. Gain hands-on experience in transforming data and elevate your skills for today’s data-driven world.
Learning path objective
- Master the distinctions between data lakes and data warehouses
- Understand and build effective data pipelines
- Confidently use modern data warehouses like BigQuery for advanced analytics
Recommended for
This course is ideal for those who possess a solid intermediate proficiency in Excel.
COURSE HIGHLIGHTS
Understand data lakes vs. data warehouses.
Build data pipelines with Excel and BigQuery.
Discover the power of modern data warehouses.
Hands-on ELT process using Google BigQuery.
Course Outline
Introduction to Data Warehousing
Discover the vital role data warehousing plays in modern businesses by understanding its definition, significance, and how it helps overcome organizational data silos. Explore the key objectives and benefits that effective data warehousing brings to your enterprise.
1
Data Lakes vs. Data Warehouses
Learn the fundamental differences between data lakes and data warehouses, along with their unique use cases. Understand how integrating these two approaches can enhance enterprise-level data management and drive better decision-making.
2
Components of Data Pipelines and Processing
Delve into the essential components of data pipelines, focusing on Extraction, Transformation, and Loading (ETL). Explore various data processing techniques, including both batch and real-time processing, to streamline your data operations.
3
Excel vs. Modern Data Warehouses
Evaluate the limitations of Excel for data analytics and reporting, and discover the advantages of using modern data warehouses like BigQuery. Compare features, scalability, and performance to see how BigQuery outperforms traditional spreadsheet tools.
4
Hands-On Workshop: ELT with Excel and BigQuery
Engage with a real-world large dataset in a practical session where you’ll perform an Extract, Load, Transform (ELT) process using Excel. Follow up with a guided demonstration of the same process using Google BigQuery, gaining hands-on experience with both tools.
5
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Trainers Profile
Mazlita Mat Hassan
Director / Lead Trainer, MatrixC Academy
Mazlita Mat Hassan, known as “MEM,” is an accomplished IT corporate trainer and data science expert with a BSc in Computer Science from University College London. With over a decade of experience, she has trained more than 10,000 professionals across Southeast Asia, specializing in Microsoft Office, Google Apps, and Tableau.
As the CEO of RECQA, she drives DeLIMA 2.0, Malaysia’s National Digital Learning Platform, and leads MatrixC Academy’s Change Management training with Google Tools. Globally recognized, she is the SEA & Pacific Leader for UNCTAD’s “e-trade for women” initiative and received the 2023 Women in STEM award from Business and Professional Woman Malaysia for her contribution in co-developing DeLIMA 2.0 with MOE and Google Malaysia.
Ikmal Nordin
Data & AI Lead, Matrix Connexion
A distinguished data analytics trainer, data scientist, and AI specialist with deep expertise in data science, AI, and economic analysis. Renowned for architecting cutting-edge data solutions, he translates complex concepts into practical, high-impact training for both corporate teams and individuals.
Ikmal has successfully trained and consulted for leading companies like Proton, Star Media Group, and BE International, empowering professionals across industries to harness the power of big data and AI for significant productivity gains and career advancement.