SKU: 73949424641

Build Data Warehouses

Sale price$22.45 Regular price$24.95
Save 10%

Pay in installments of $6.24 with ShopPay, AfterPay and Klarna

Shipping Estimate
USA
  • USA
  • CAN

Ships within 48 hours · Estimated delivery Aug 15 - Aug 20

Promo Codes Available:

For Your Every Summer RSVP, with Code: SUMMER15

Description

Build Data WarehousesCOURSE OVERVIEW: Welcome to the course on Build Data Warehouses. This course is designed to provide you with the foundational knowledge and practical skills needed to design, implement, and manage data warehouses effectively, enabling robust data analytics and business intelligence capabilities. We begin with an introduction to data warehousing, defining what a data warehouse is and explaining its importance in todays data driven business environment.

COURSE OVERVIEW:

Welcome to the course on Build Data Warehouses. This course is designed to provide you with the foundational knowledge and practical skills needed to design, implement, and manage data warehouses effectively, enabling robust data analytics and business intelligence capabilities.

We begin with an introduction to data warehousing, defining what a data warehouse is and explaining its importance in today’s data-driven business environment. This section will cover key concepts and terminology essential for understanding data warehousing fundamentals.

Next, we explore data warehousing architecture. You will gain an overview of different data warehouse architectures, including centralised, distributed, and cloud-based architectures. We will also discuss the various components that make up data warehousing systems, providing a comprehensive understanding of their structure and functionality.

Requirements gathering and analysis are crucial for building an effective data warehouse. This section will guide you through identifying business requirements, conducting data requirements analysis, and using stakeholder interviews and workshops to gather essential information.

Data modelling for data warehousing is a critical step in the design process. We will cover conceptual, logical, and physical data models, as well as different schema designs such as star schema and snowflake schema. Understanding fact and dimension tables will also be a focus in this section.

The ETL (Extract, Transform, Load) process is at the heart of data warehousing. You will learn about the ETL process, the tools commonly used (such as Informatica, Talend, and SSIS), and how to design and implement effective ETL workflows to ensure accurate and efficient data processing.

Data integration techniques are essential for combining data from various sources. This section will explore methods for data integration, comparing real-time versus batch integration, and discussing data cleaning and transformation techniques to ensure high-quality data.

Data storage and management are vital for the performance and scalability of a data warehouse. We will discuss choosing the right storage solutions, including on-premise and cloud options, and cover data partitioning, indexing, and strategies for managing data growth and scalability.

Ensuring data quality and governance is crucial for maintaining the integrity of your data warehouse. This section will cover methods for ensuring data accuracy and consistency, tools for data quality management, and how to implement effective data governance policies.

Performance tuning and optimisation are necessary to maintain efficient data warehouse operations. You will learn query optimisation techniques, indexing strategies, and methods for performance monitoring and maintenance to ensure your data warehouse runs smoothly.

Security and compliance are essential considerations in data warehousing. This section will cover best practices for data security, implementing access controls, and ensuring compliance with Australian regulations to protect sensitive data.

Reporting and analytics are the primary outputs of a data warehouse. We will explore tools for reporting and visualisation, such as Tableau and Power BI, and discuss how to design effective reports and dashboards. Advanced analytics and data mining techniques will also be introduced.

Data warehousing in the cloud offers numerous benefits. This section will discuss the advantages of cloud data warehousing, review major cloud platforms (AWS Redshift, Google BigQuery, Azure Synapse), and provide guidance on migrating to a cloud data warehouse.

Finally, maintenance and administration are key to the long-term success of your data warehouse. We will cover regular maintenance tasks, backup and recovery procedures, and methods for monitoring and troubleshooting to ensure continuous and reliable data warehouse operations.

By the end of this course, you will have a comprehensive understanding of how to build and manage data warehouses, enabling your organisation to leverage data for strategic decision-making and competitive advantage.

LEARNING OUTCOMES:

By the end of this course, you will be able to understand the following topics:

1. Introduction to Data Warehousing

  • Definition and Importance of Data Warehousing
  • Key Concepts and Terminology

2. Data Warehousing Architecture

  • Overview of Data Warehouse Architecture
  • Types of Data Warehouse Architectures (Centralised, Distributed, Cloud)
  • Components of Data Warehousing Systems

3. Requirements Gathering and Analysis

  • Identifying Business Requirements
  • Data Requirements Analysis
  • Stakeholder Interviews and Workshops

4. Data Modelling for Data Warehousing

  • Conceptual, Logical, and Physical Data Models
  • Star Schema and Snowflake Schema
  • Fact and Dimension Tables

5. ETL (Extract, Transform, Load) Processes

  • Overview of ETL Processes
  • Tools for ETL (Informatica, Talend, SSIS)
  • Designing and Implementing ETL Workflows

6. Data Integration Techniques

  • Data Integration Methods
  • Real-Time vs. Batch Integration
  • Data Cleaning and Transformation

7. Data Storage and Management

  • Choosing the Right Storage Solution (On-Premise, Cloud)
  • Data Partitioning and Indexing
  • Managing Data Growth and Scalability

8. Data Quality and Governance

  • Ensuring Data Accuracy and Consistency
  • Data Quality Management Tools
  • Implementing Data Governance Policies

9. Performance Tuning and Optimisation

  • Query Optimisation Techniques
  • Indexing Strategies
  • Performance Monitoring and Maintenance

10. Security and Compliance

  • Data Security Best Practices
  • Implementing Access Controls
  • Compliance with Australian Regulations

11. Reporting and Analytics

  • Tools for Reporting and Visualisation (Tableau, Power BI)
  • Designing Effective Reports and Dashboards
  • Advanced Analytics and Data Mining

12. Data Warehousing in the Cloud

  • Benefits of Cloud Data Warehousing
  • Cloud Platforms for Data Warehousing (AWS Redshift, Google BigQuery, Azure Synapse)
  • Migrating to a Cloud Data Warehouse

13. Maintenance and Administration

  • Regular Maintenance Tasks
  • Backup and Recovery Procedures
  • Monitoring and Troubleshooting

COURSE DURATION:

The typical duration of this course is approximately 2-3 hours to complete. Your enrolment is Valid for 12 Months. Start anytime and study at your own pace.

ASSESSMENT:

A simple 10-question true or false quiz with Unlimited Submission Attempts.

CERTIFICATION:

Upon course completion, you will receive a customised digital “Certificate of Completion”.

Shipping Notes
  • Free Standard Shipping on $100+ Orders to the USA.
  • Except Preorder products are shipped in 48 hours.
  • Delivery to the USA:
  1. Standard Shipping : 3-10 business days
  • If time is of the essence, please consider selecting expedited delivery for faster service.
Exchange/Return Notes
  • We offer a 30-day return/exchange service after receiving.
  • Final sale items are not eligible for returns or exchanges.
  • To process your return/exchange, please contact us at [email protected]
  • Please click here for more details>>> Return & Exchange Policy
SKU: 73949424641

Discover Niche Categories That Outsell

Top-Converting Item to Boost Your Average Order

4.2 ★★★★★
Based on 11 reviews
Sort
Highest Rating
Newest First
Oldest First
Product Reviews
A
Verified Purchase
Amazon Customer
Massapequa, US
★★★★★ 3
Interesting take on the genre
Format: Kindle
True rating: 3.25 ⭐️ I enjoyed the fresh take on the genre. The best way I could describe the setting and world is an apocalyptic dystopian version of Farie where vampires, fae, and angles struggle to survive in what is left of the world. It was definitely interesting throwing the academy/hunger games aspect into this world as well. Even though I guessed the final reveal early on in the book, I kept hoping I was wrong, and it would take a surprising turn. While the "plot twists" were a bit predictable to me, I still enjoyed the ride this book took me on. Another downfall for me was the plot holes in the world building... I.E. if society has fallen and the world is in the aftermath of war, how are there trains running around the world? Just to take young adults to the trials to get into the golden city? How is the train maintained, the tracks clear, etc? However, I did enjoy the FMC & MMC and thought they were fleshed out nicely. I also enjoyed the side characters but wish some were developed more like Ashalin (sp?). I do find myself rooting for the MCs to succeed and find happiness together, which is obviously an important aspect for romantasy. Overall, was this an earth-shattering, mind-bending, terrific piece of literature? No. But was it the worst thing I've read this year? Also, no. This book has, to me, the bones of a great read & just needs a bit more to push it from an alright book to a great book. Overall ratings: Plot- 3.5⭐️ World building 3⭐️ Spice 2.5 🌶🌶 Main characters 4 ⭐️ Supporting characters 3.5⭐️
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 12, 2024
I
Verified Purchase
Irene zamora
West Palm Beach, US
★★★★★ 5
great book
Format: Kindle
I am really excited to meet the author at the book retreat this month. I really enjoyed this world that she built and most of the female main character Huntress is so awesome. She goes through a lot in this book and the ending; wow! I wouldn't have even guessed. I highly recommend everyone to read this book. I have been so lucky this year that almost all the books I have read have been, so far, 5 out 5 stars.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on June 2, 2026
A
Verified Purchase
Anastasia Goygova
Houston, US
★★★★★ 4
Fallen for the Fallen Angel – A Guilty Pleasure Worth Every Page
Format: Kindle
There’s something deeply irresistible about a dark academia or trial-based setting, a brooding and arrogant fallen angel, and a fierce heroine with enough sass to go toe-to-toe with him. Wings So Wicked is exactly that kind of book—and I devoured it in just a couple of days. To be fair, the plot isn’t groundbreaking. If you’re looking for something fresh and innovative in terms of storyline, this might not be it. But if your reader heart beats faster at the mere mention of enemies-to-lovers, jealousy-fueled banter, magical trials, betrayals, and forbidden tension—you’ll feel right at home. It’s like catnip for those of us with this particular weakness. The chemistry between the leads could have used a slightly slower burn to make the tension sizzle longer, but I still found myself completely invested in their dynamic. There are moments and phrases that feel a bit cheesy or underdeveloped, but honestly? I didn’t care. The vibes were exactly what I wanted. This book isn’t trying to reinvent the genre—it’s here to give readers like me what we crave: high-stakes magical drama, angsty romance, and the thrill of watching a badass girl and her brooding counterpart clash and spark. If that sounds like your kind of story, Wings So Wicked will hit the mark. Here’s hoping Book 2 turns up the heat and keeps the magic alive.
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on May 20, 2025
M
Verified Purchase
Madi lohr
Battle Creek, US
★★★★★ 5
my new favorite book
Format: Kindle
Ok so I never write reviews but this book was so good I felt the need to write this. Firstly your introduced to Huntyr you see her closed off hard core badass than towards the end you see the most subtle change and growth it’s amazing and the enemies to friends to lovers was just perfect, AND THE TWIST AT THE END GOT ME GOOD! You see one spicy scene the whole book but it doesn’t even MATTER BECAUSE THE BOOK WAS THAT GOOD. I’ve read 85 books in 2023-2024 so far and I’m pround to say this is my all time favorite. I’m so excited to read more of Emily Blackwoods books, this was my first time reading one of hers and I’m glad I did because HOLY!! Well done Emily well done
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on February 23, 2024
R
Verified Purchase
Robin
Houston, US
★★★★★ 4
Fast paced romantasy you will not want to put down!
Format: Kindle
4.25 stars! I LOVED this book with similar vibes to Hush Hush, Fourth Wing, and The Serpent and the Wings of Night! It was fast paced with easy world building and will keep you turning the pages late into the night because you will not want to put it down! Huntyr is a fierce bad@ss FMC trained to kill vampyres her entire life. She is sent on a mission to go to the academy and earn her spot into The Golden City. Upon arrival, she is forced to room with the delicious fallen angel, Wolf, who is the only one who knows about her assassin identity. The romance, the plot twists, the secrets revealed, the battles, and the tantalizing training scenes had me hooked! And that ending…. I’m holding my breath in need to know hell! Read if you love: 🪽 Fae, Vampyres, Fallen Angels 🪽 Academy setting with magical trials 🪽 Forced proximity and slow burn 🪽 Rivals to lovers 🪽 Hidden identities and secrets 🪽 Tend your wounds “𝘖𝘧 𝘤𝘰𝘶𝘳𝘴𝘦 𝘐 𝘸𝘢𝘴 𝘸𝘢𝘵𝘤𝘩𝘪𝘯𝘨 𝘺𝘰𝘶. 𝘐 𝘤𝘰𝘶𝘭𝘥𝘯’𝘵 𝘭𝘰𝘰𝘬 𝘢𝘸𝘢𝘺 𝘧𝘰𝘳 𝘢 𝘮𝘰𝘮𝘦𝘯𝘵, 𝘦𝘷𝘦𝘯 𝘪𝘧 𝘐 𝘵𝘳𝘪𝘦𝘥.” “𝘐𝘧 𝘺𝘰𝘶 𝘸𝘢𝘯𝘵 𝘮𝘦 𝘰𝘯 𝘮𝘺 𝘬𝘯𝘦𝘦𝘴, 𝘏𝘶𝘯𝘵𝘳𝘦𝘴𝘴, 𝘢𝘭𝘭 𝘺𝘰𝘶 𝘩𝘢𝘷𝘦 𝘵𝘰 𝘥𝘰 𝘪𝘴 𝘢𝘴𝘬.” “𝘠𝘰𝘶 𝘥𝘰 𝘯𝘰𝘵 𝘬𝘯𝘰𝘸 𝘵𝘩𝘦 𝘷𝘪𝘰𝘭𝘦𝘯𝘤𝘦 𝘵𝘩𝘢𝘵 𝘳𝘶𝘯𝘴 𝘵𝘩𝘳𝘰𝘶𝘨𝘩 𝘮𝘺 𝘷𝘦𝘪𝘯𝘴, 𝘣𝘦𝘨𝘨𝘪𝘯𝘨 𝘮𝘦 𝘵𝘰 𝘰𝘣𝘭𝘪𝘵𝘦𝘳𝘢𝘵𝘦 𝘢𝘯𝘺𝘰𝘯𝘦 𝘸𝘩𝘰 𝘭𝘢𝘺𝘴 𝘢 𝘩𝘢𝘯𝘥 𝘰𝘯 𝘺𝘰𝘶.”
WAS THIS REVIEW HELPFUL?YesReportShare
Reviewed in the United States on June 12, 2024

recommand products