moving forward um just wanted to point out before we get started that uh we're very excited WhereScape's 25 years old this year celebrating 25 years of helping organizations automate accelerate and simplify data infrastructure um we've got we're a very mature product obviously over those 25 years they've got well over,500 customers around the globe small organizations as well as large global enterprises you'll see this number quite a bit but eight times developer output some folks say it's even greater than that depending on your skill level and uh it's all about ROI we automate the routine steps that slow developers down and uh increase productivity significantly so what is data automation data automation divide by TDWI is a solution that encompasses all of the core processes of data warehousing including design development testing deployment operations impact analysis and change management all of that you can uh find within WhereScape we automate all of those processes for you WhereScape provides a complete solution for building and managing full data warehouses we're one solution no add-on costs were licensed by uh per named user and that is it so there's no additional fees that go along when you purchase WhereScape worescape's comprised of two products we're going to focus on 3D today but we have 3D and red and uh these tools automate code development data modeling profiling we do model conversion rules data prototyping scheduling documentation and data lineage all automated both user and technical documentation and Worcape WhereScape essentially automates the full ELT life cycle for you again uh Worcape's comprised of two solutions worescape 3D this is where you're going to be and you're going to see Brad doing the presentation around 3D today but this is where you're going to be doing all your discovery your profiling your modeling um and then we automate that process and document all that for you then we have WhereScape red which is our builder tool we autogenerate all the code for you within that tool streamlining and automating the creation and deployment of management of the full data warehouse and then we have a suite uh for data data vault express if you're doing something more exotic like data vault um it combines red and 3D with all of uh Dan Lindstead standards built right into the templates so if you're doing data vault wherecape and our automation is really a need to have not a nice to have urge you to explore that further so who benefits from data automation i'm sure we've got a lot of different personas on the call today here whether you're a DBA and you're managing the data platform and sources if you're a developer generating the code data architects if you're designing the full build of your data warehouse all of you folks are going to uh uh benefit greatly from WhereScape if you're an executive maybe you're just concerned with saving money speed to value cost you're going to find that uh Wearcapes automation provides a lot of value for you and speed to uh reducing your project's time to completion and then of course you have your analysts and scientists the uh consumers of the data you're going to benefit greatly and appreciate Wescap's automation as well so again talking about 3D this is uh where you're going to do all your data discovery and profiling in 3D you're going to design your source models you're going to do your model conversions you're going to build out your physical models your star schemas your D full data warehouse and of course we're going to provide all that documentation user and technical documentation as well for you um and that's with a click of a button all up to date every time you make a change so with Wearcape we eliminate 95% of the manual coding from the data management process increasing your development team's productivity by 8x again 8x you see that number a lot but our our depending on the skill level a lot of our customers come back to us and tell us it's far greater than 8x um especially if you're doing something more complex like data bomb but we complete the development projects in a fraction of the time there's no more errors in debugging wearcape Red autogenerates template driven code standardized it works as it should the first time through so you don't have those challenges anymore um we consolidate data sources into a unified system build entire data warehouses in days not years if you ever do a P withcape I think you'll see a lot of folks that have been working and trying to build a data warehouse project out uh in 6 months we can do and duplicate that in just 2 and 1/2 days and uh that's really where the light bulb goes off so um really really um reduce the uh the project build time for building data warehouses then of course we assist by with rapid platform migration through automation so if you're going from onrem to fabric or snowflake or any other uh target platform we can help you do that in days not months so since we're talking about fabric today I put uh together this slide it's uh really about why wearcape with fabric and of course we just talked about accelerated migrations we're cutting migration timelines from months to days automating that simplifies transitions from legacy platforms to fabric low code no code automation building out all your models in 3D and then of course with RED eliminating the need for hand coding no manual scripting required full data lineage and documentation automatically capturing data or the the lineage and generating audit ready documentation full visibility for fabric for compliance with fabric um built-in data vault support again we've talked about that um if you're doing something exotic like data vault you're really going to want to use WhereScape to automate that process in fabric and then of course scalable seamless workflow orchestrating enterprise scale jobs using WhereScape scheduling monitoring integration with fabrics managed networks and endpoints one of the really cool things about WhereScape is that we are platform agnostic we don't really care what uh target platform you're on we support that so um we obviously know that companies uh overhaul their data platforms every 5 to seven years so if you're on prem uh today and you have plans to move to fabric you're covered if you're on fabric maybe somewhere down the line things change and you want to move to data bricks or whatever the next shiny object is you're futurep proofed with WhereScape you don't have to worry about going out and buying new tools just a brief slide to show you some of the organizations we work with around the world now don't get me wrong you don't have to be a Nike or a Costco to benefit from Wears WhereScape we have a number of just small shops one or two people that benefit greatly from our automation the idea between behind WhereScape is to do more with less and we can make one or two people look like you're doing the work of of many with Wearcape we don't just sell you software we also offer unparalleled support expert implementation training is always provided uh we provide guidance from technical account managers dedicated customer success managers and this is if you're planning a migration an upgrade anything like that we want to make sure you have the technical team surrounding you to make that project smooth seamless and uh successful those are the folks that technical team that can help you with that and then of course we offer WhereScape University which is designed to really reduce the learning curve of WhereScape it's self-paced online training that your team can access um goes through all the modules 3D RED data vault if you're doing that um but always continuing to train our customers we do free m monthly training sessions webinars like we're doing today we also do hands-on labs uh just a number of ways to ensure that the team's getting the most out of WhereScape and is uh very successful so with that I am going to conclude my portion i'm going to hand it over to Brad and uh Brad's going to get into the fun stuff and the technical um things you came here to see today but I would just add that if you're interested in learning more you know and you want to set up a demo go to warescape.com that's wherecape.com a big old red button that says uh book a demo and if you do that I'll reach out to you or one of my uh my uh uh colleagues will reach out to you and we'll make sure we get that set up for you but I believe we're going to do a Q&A after Brad's presentation as well if I'm not mistaken so feel free to post any questions that you have in chat and then uh we'll certainly address those after the after the presentation and uh I will put a link to the uh to the book a demo in the chat as well so you can click on that if you're interested but with that I'm going to turn it over to Brad cool thanks Matt you bet let me share out my screen
today we're going to take a look at Microsoft Fabric and using Wherescape 3D to generate a star schema and then using Wherescape RED to push that out into Microsoft Fabric so what we're looking at here is Microsoft Fabric I have this item here this is OneLake I have a workspace in Fabric called Dev WS Test and if I go into the lakehouse here we have these folders, these files and tables if I go into my SQL endpoint which is the shortcut here on the right hand side and open up the data warehouse experience this will take me into the tables and views and this is where we're going to land that star schema after we build it in Wherescape 3D.
So let’s go ahead and hop into 3D now. This is Wherescape 3D. The first thing we’ll do here is profile the source data. You can do this from any kind of delimited file or database—you just point to it. I’m going to go ahead and import a file that’s stored in OneLake, so let me point to that file now. We'll choose the Fabric connection and go from there.
Once connected, I can scan the file and bring in metadata. I can profile it to see row counts, null values, and unique values. Now, I’ve already done that work to save time, so we’ll jump right into a preloaded project. Over here, you can see the source model that’s been brought in, and we've identified all the fields.
Now, using Wherescape 3D, we can model our star schema. That’s where I’ll convert the source model into a dimensional model using our Model Conversion Rules. These let you define the logic for converting raw sources into fact and dimension tables. This is really helpful if you’re doing repeatable work across different projects—it helps enforce consistency.
Once that’s done, I have my dimensions and fact tables in a visual layout. I can then use 3D to auto-document everything, generate metadata lineage, and prepare for deployment. You’ll see lineage from raw source to dimensional model, including any changes.
Next, I’ll open Wherescape RED. We’ll push this model directly into Fabric’s SQL endpoint. I’ve already set up my Fabric connection in RED, so all I have to do is generate the code and deploy.
In RED, we generate all the ELT code for staging, transformations, and load—no manual scripting. You can customize templates if needed, but most customers find the default templates cover 95% of what they need.
We click "Deploy," and you’ll see the objects show up in Fabric within seconds. That includes the fact table and dimension tables. RED handles object creation, indexes, constraints—everything you’d expect.
Let’s switch back to Fabric and do a refresh. Now we can see our star schema tables live in the SQL endpoint.
Back in RED, we also get a full audit trail. You can generate technical documentation with one click, which includes table definitions, data types, mappings, and load frequency. That documentation is available in HTML or PDF format and is kept up to date automatically.
And that's a quick overview of how to go from raw source in OneLake to a deployed star schema in Fabric using Wherescape 3D and RED.
All right, we got three minutes—I'll answer lots of questions in the Q&A section there. So let’s see if I can get to a few. I don't know if we'll have time to answer them all, but certainly, like I mentioned, if you're interested in scheduling a more in-depth demo, we can take a deeper dive and answer all your questions for you as well. We've really just scratched the surface today—there's a lot more to show you.
Wherescape—if you can dream it up, we can do it in Wherescape. So we'd love to have the opportunity to do a demonstration for you based on your use case, your specific requirements, and talk through those in great detail.
Okay, so I can hit a couple of them here in these last few minutes.
One person asks: "Once many objects have been brought into 3D, it could become quite difficult to manage the layout of the model. Is there a way to manually move around entities or relationships to make the model more legible?"
Yes, you can do that. You saw earlier, I clicked a button to auto-arrange the layout. There are a bunch of different layout options you can choose from. Also, if you've got a diagram laid out in a way that you really like, you can copy that layout to another diagram. There's also a button to reroute the joins—so if the lines get messy, it’ll clean them up automatically. And don’t forget the Groups functionality—you can view a subset of the tables in 3D, which really helps.
Another question: "If you already have dim tables in RED and just need to bring in three new fact tables, would you recommend going through 3D or just do it in RED? If 3D, what are the primary efficiencies?"
So the answer is: it depends. We have customers who do both. Some use 3D for the initial big-bang warehouse build, and then for smaller changes, they make updates in RED and sync back to 3D. In your case, if the facts are being built off existing structures, RED might be faster. But if these are new sources and you want lineage and transformation, 3D is probably better—especially if you have model conversion rules like the one I used earlier to split out private data.
Another question: "If I export from 3D but the model only has two new tables, will it export everything?"
No—it will only export the changes. When 3D compares the model to the target, if there’s no difference, it won’t deploy anything unnecessary.
One last question: "If I have a table and want to test a new transformation or apply new logic, can I duplicate it or create a new version?"
Yes, you can do both. You can bring in the table again, or use the quick copy function to duplicate the version. You can also use the comparison tool in 3D to see what’s changed between versions.
Matt: That brings us right to the hour, so Brad, great job as always—thank you.
Brad: Thank you.
Matt: Again, everybody, we really just scratched the surface. If you want a deeper dive, go to wherescape.com and click the big red button to book a demo. One of us will reach out to schedule a session based on your use case and requirements. We’ll also talk more about exporting 3D models into RED, code generation, and building out the full data warehouse with ELT automation.
Appreciate your time today and we look forward to continuing the conversation.
Moderator: Just a reminder—we’ll send out the recording once it’s processed. Any questions Brad didn’t get to will be answered either via email or in a blog post on our website that we’ll send to all attendees. Thanks again to Brad and Matt—and thank you all!
Brad: Thanks, everybody. Have a great day!
