Join WhereScape at Big Data & AI World—the...
A low-code data automation solution for SSIS, SQL Server, and Power BI!
Welcome to WhereScape STAR
WhereScape, the global leader in data warehouse automation, has introduced a new offering to benefit data analysts in organizations that are using Microsoft products for business analysis: WhereScape STAR.
Business leaders ask for reports and dashboards. Creating the underlying data structures (data warehouses, data marts, star schemas, or simply third normal form databases) requires technical knowledge and experience with creating data warehouses.
What do you do if you and your organization don’t have all of those skills? You use Google. You create massive functions in Excel spreadsheets. You manually copy and manipulate data. You do whatever you can to deliver the reports and dashboards your business is needing.
WhereScape is about to make your job easier and faster. Think of WhereScape STAR as your digital co-worker who knows the technical details (how to write SQL procedures, DDL, and create database objects), and someone with years of experience in data warehouse modeling!
WhereScape STAR knows how to implement your requirements – you tell WhereScape STAR what you want to do, and it will figure out how to do it.
Are you a data analyst that is tasked with creating spreadsheets and dashboards but have limited IT staff to help you? If so, the solution has arrived!
Use SSIS or ODBC, connect to your SQL Server source, XML spreadsheets, text files, or a variety of other sources. Transform your data and load it into star schema, including fact and dimension tables. You can then query those tables through Power BI, Tableau, or any other data analysis tool, or you can just export that data and import it into Excel.
WhereScape STAR makes creating your data foundation and transforms easy and fast
Click-and-drag your source files and tables to create your data structures. Use the built-in wizards to transform your data to meet your business requirements. Create jobs and tasks to update your repository with a few clicks. Schedule jobs to automatically keep your repository up to date.
And you can do all of this without writing a single line of code, manually creating tables and indexes, and everything works the first time!
Cut down the time it takes to generate your analysis and reports from days to hours. Get things done right the first time. Make changes and adjustments in minutes. And all without having to touch a line of code.
Generate star schemas in minutes!
Drag the source table into the RED application. Congratulations. You’ve created a load table and the code required to populate it from the source. Now click-and-drag to create a stage table from the load table. This is where transforms happen. Within minutes you can create fact tables and dimensions, as well as add transforms, denormalize tables, implement business logic, and everything else you need to set up the data for your dashboards and report.
And it’s fully documented!
WhereScape star is metadata driven. That means you tell it what you want done, and WhereScape STAR implements it using best practices and common design principles. Because everything is captured as metadata, complete and accurate documentation can be created with a couple of clicks. You want to know where your dimension data is coming from and how it was transformed? The ‘track back’ diagrams will show you that. Similarly, ‘track forward’ diagrams can show you how source data is transformed and used.
It’s fast and easy
It’s definitely worth a few minutes of your time to check this out. Starting with a blank database, you can create facts, dimensions, reports, and dashboards in minutes. Get prototypes in front of the users wanting the reports. Make modifications quickly. All with WhereScape STAR, your new digital expert.
Simplify Cloud Migrations: Webinar Highlights from Mike Ferguson
Migrating your data warehouse to the cloud might feel like navigating uncharted territory, but it doesn’t have to be. In a recent webinar that we recently hosted, Mike Ferguson, CEO of Intelligent Business Strategies, shared actionable insights drawn from his 40+...
2025 Data Automation Trends: Shaping the Future of Speed, Scalability, and Strategy
As we step into 2025, data automation isn’t just advancing—it’s upending conventions and resetting standards. Leading companies now treat data as a powerful collaborator, fueling key business decisions and strategic foresight. At WhereScape, we’re tuned into the next...
Building Smarter with a Metadata-Driven Approach
Think of building a data management system as constructing a smart city. In this analogy, the data is like the various buildings, roads, and infrastructure that make up the city. Each structure has a specific purpose and function, just as each data point has a...
Your Guide to Online Analytical Processing (OLAP) for Business Intelligence
Streamline your data analysis process with OLAP for better business intelligence. Explore the advantages of Online Analytical Processing (OLAP) now! Do you find it hard to analyze large amounts of data quickly? Online Analytical Processing (OLAP) is designed to answer...
Mastering Data Warehouse Design, Optimization, And Lifecycle
Building a data warehouse can be tough for many businesses. A data warehouse centralizes data from many sources. This article will teach you how to master data warehouse design, optimization, and lifecycle. Start improving your data strategy today. Key Takeaways Use...
Revisiting Gartner’s First Look at Data Warehouse Automation
At WhereScape, we are delighted to revisit Gartner’s influential technical paper, Assessing the Capabilities of Data Warehouse Automation (DWA), published on February 8, 2021, by analyst Ramke Ramakrishnan. This paper marked a significant milestone for the data...
Unveiling WhereScape 3D 9.0.5: Enhanced Flexibility and Compatibility
The latest release of WhereScape 3D is here, and version 9.0.5 brings a host of updates designed to make your data management work faster and smoother. Let’s dive into the new features... Online Documentation for Enhanced Accessibility With the user guide now hosted...
What Makes A Really Great Data Model: Essential Criteria And Best Practices
By 2025, over 75% of data models will integrate AI—transforming the way businesses operate. But here's the catch: only those with robust, well-designed data models will reap the benefits. Is your data model ready for the AI revolution?Understanding what makes a great...
Guide to Data Quality: Ensuring Accuracy and Consistency in Your Organization
Why Data Quality Matters Data is only as useful as it is accurate and complete. No matter how many analysis models and data review routines you put into place, your organization can’t truly make data-driven decisions without accurate, relevant, complete, and...
Common Data Quality Challenges and How to Overcome Them
The Importance of Maintaining Data Quality Improving data quality is a top priority for many forward-thinking organizations, and for good reason. Any company making decisions based on data should also invest time and resources into ensuring high data quality. Data...
Related Content
Simplify Cloud Migrations: Webinar Highlights from Mike Ferguson
Migrating your data warehouse to the cloud might feel like navigating uncharted territory, but it doesn’t have to be. In a recent webinar that we recently hosted, Mike Ferguson, CEO of Intelligent Business Strategies, shared actionable insights drawn from his 40+...
2025 Data Automation Trends: Shaping the Future of Speed, Scalability, and Strategy
As we step into 2025, data automation isn’t just advancing—it’s upending conventions and resetting standards. Leading companies now treat data as a powerful collaborator, fueling key business decisions and strategic foresight. At WhereScape, we’re tuned into the next...
Building Smarter with a Metadata-Driven Approach
Think of building a data management system as constructing a smart city. In this analogy, the data is like the various buildings, roads, and infrastructure that make up the city. Each structure has a specific purpose and function, just as each data point has a...
Your Guide to Online Analytical Processing (OLAP) for Business Intelligence
Streamline your data analysis process with OLAP for better business intelligence. Explore the advantages of Online Analytical Processing (OLAP) now! Do you find it hard to analyze large amounts of data quickly? Online Analytical Processing (OLAP) is designed to answer...