In this video we provide a comprehensive look at WhereScape's capabilities in streamlining the entire data warehouse development process. It begins by highlighting WhereScape’s ability to extract data from diverse sources such as JSON files, web APIs, Excel spreadsheets, XML, ADLS Gen 2, Google APIs, S3 buckets, and traditional databases, and land them into the data warehouse using load tables.

Once the data is loaded, WhereScape enables users to apply transformations through stage tables, eventually building a star schema that supports BI tools for reporting and dashboarding. Throughout the process, WhereScape automates metadata generation and self-documentation, ensuring transparency and traceability of the data journey. It also includes a pipeline scheduling tool to automate data workflows.

We demonstrate the creation of load tables and stage tables through user-friendly wizards and templates. It also touches on type 2 dimensions, showcasing key elements like start date, end date, current flag, and versioning. Furthermore, WhereScape generates both user and technical documentation, complete with glossaries, transformation details, and trackback diagrams for full traceability of the data's origin.

Don't forget to subscribe for more tutorials and updates from WhereScape! If you found this video helpful, please like, comment, and share it with your colleagues.