Data vaults with Wherescape

           

   

Data Vaults have been gaining huge attention in recent years all over the world. Invented by Dan Linstedt, Data Vaults is truly an optimal way to build enterprise data warehouses. WhereScape – an industry leading information systems software company – fully supports Data Vault methodology. Read the blog for more about it…

WhereScape Data Vaults

WhereScape New Features and Benefits

   

Many new features are added in every RED and 3D release; it is hard to catch up with fast-paced WhereScape software. This article aims at shedding light on those new features so our customers and prospects have a comprehensible picture as to why they would want to use them.

WhereScape New Features and Benefits

Another Great Event on Data Vault Just Ended

           

   

WWDVC — Stowe, VT May 28–30, 2015

World Wide Data Vault Consortium 2015 has been organized and facilitated – just like in the previous years – by Dan Linstedt, the inventor of the Data Vault Architecture (DV 1.0) and its extension – Data Vault 2.0. This time – in the picturesque Von Trapp Family Lodge; remember “High on a hill was a lonely goatherd/ Lay ee odl lay ee odl lay hee hoo…”

However, this was no time for yodeling; the conference was packed with great presentations, demos, and discussions. Some of the speakers were industry’s leaders and well-known publishers such as Claudia Imhoff, Ph.D. (bbbt.us), Scott W. Ambler (SA+A), Kent Graziano (The Data Warrior ), and others. There were around 60 data vault practitioners – consultants, vendors, and customers – from at least 7 countries. And, of course, Dan Linstedt, like a mountain eagle, was watching and facilitated the event from the height of his expertise and know-how…

This year’s themes were dominated by concept and implementation of Data vault 2.0 – the evolution of the world-renown DV1.0; arguably, 7 out of 10 new EDW’s built in Data Vault “flavor”. Some of the presentations were:

• Big Data, NoSQL and DV2.0 Modeling
• Temporal Data Warehouse and Data Vault
• EDW and Data Marts Virtualization
• Event-Driven Real-Time EDW in the Cloud
• Agile Big Data Warehousing with DV2.0
• …and much more!

I was honored to have the opportunity to present WhereScape Solution for DV 2.0. In this presentation I described what both WhereScape products -3D and RED – have to offer to organizations to build an Information System with Big Data inclusion that is fully compliant with the DV2.0.

“Utilizing WhereScape 3D – DW planning tool – in conjunction with WhereScape RED – DW building tool – [WhereScape] provides a complete agile solution for discovering, profiling, planning, building, deploying, managing and  renovating data warehouses and data marts” — Participant

I appreciate Dan for giving me another opportunity to speak at his conventions. I would like to participate in future WWDVC events and highly recommend all the Data Warehouse and Business intelligence practitioners, Big Data enthusiasts and Data vault lovers to partake in the future WWDVC symposia as well as consider the crème de la crème Data Vault coaching from Dan Linstedt.

Big Data Small Scale

   

A common sentiment of a Big Data has been that it is too big and too costly for small and medium businesses because it requires enormous processing power to crunch all those oodles of data. But it is becoming more clear that this is an outdated perception! Processing power is cheaper and more accessible than any time in the past, granting small and medium-sized enterprises ability to tame Big Data and use it for small operations with limited IT resources and shortage of time and money.

  Blog – Big Data Small Scale

Information Systems Challenges and WhereScape Solution

   

A modern information system serves as an integrated set of components for collecting, storing, and processing data and delivering knowledge. Building an information system – whether it is operational store, data warehouse, or accessing layer et al – has always been a difficult task. WhereScape – as productivity tool – provides a holistic answer for information systems build consisting of Automation Solution, Iterative (Agile) Solution, and Integrated Solution.

IS Challenges WhereScape Solution

Integrate Tableau with your Data Warehouse

           

   

With WhereScape RED’s Tableau Integration Suite, you can automatically find the impact to your Tableau workbooks of any Data Warehouse change.You can also create Tableau extracts by drag and drop, send Tableau objects to a Tableau Server and refresh any objects on the Tableau Server as part of you data warehouse schedule.

RED Tableau Data Sheet

Near Real Time Processing

   

A traditional DW architecture should not assume a real time context keeping the system online while updating its data.
However, it is possible, under certain circumstances, to have near real time (NRT) processing in Data warehouse environment. WhereScape RED support NRT processing.

Near Real Time Processing

Loading Excel File into RED Warehouse

   

WhereScape RED can access and load into warehouse virtually any type of data.

One of the most common sources that data loaded from is Excel file. WhereScape can quite gracefully handle almost all the cases of Excel data sources.

Loading Excel File into RED Warehouse

How to Create RED PIT

   

Point-in-Time (PIT) considers a non-core Data Vault object and is used for one reason only – performance. It is defined by DAn Linstedt as “A structure which sustains integrity of joins across time to all the Satellites that are connected to the Hub [or Link]” 

WhereScape has successfully implemented Point-in-Time structures on customers’ sites.

Best Practices for Building a Warehouse Quickly How to create RED PIT

Best Practices for Building a Warehouse Quickly

This presentation has been first presented on the TDWI Florida Chapter meeting, October 16, 2009

To view it please click on the link below

Best Practices for Building a Warehouse Quickly

I have received a thank you note from TDWI Florida Chapter officers for this  presentation

“We wanted to thank you for taking the time to speak at our local chapter meeting.  Your presentation on “Best Practices for Building a Warehouse Quickly”  was very informative and contained a lot of valuable information for our attendees. Your recommendations on delivering results quickly to the business and what to avoid while deploying a warehouse solution were very insightful, and sparked good follow-up conversations with you during our networking breaks.

We will be posting your presentation on our chapter web page for our members to enjoy. Thank you,

Michael Jay Freer Chapter President / Illya Singh Chapter Vice-President /  Maylee Sanchez Chapter Secretary”