McLean, Virginia — 1-18-2018 — NuWave Solutions, a leader and innovator in Analytics and Data Management solutions, was selected to present a webcast on Self-Service…
McLean, Virginia — 11-13-2017 — NuWave was certified as a great workplace today by the independent analysts at Great Place to Work®. NuWave earned this…
In this week’s blog, we will discuss constraints and indexes. In data warehousing, like in life, constraints are things we love to hate. Constraints keep…
Brian Frutchey, a Vice President at NuWave, will speak about Machine Learning on Dirty Data. MCLEAN, VA, July 25, 2017 /24-7PressRelease/ — NuWave has accepted the opportunity…
In this week’s blog, we will discuss how to optimize the performance of your data warehouse by using aggregates. What are Aggregates? Aggregates are the…
Getting the correct answer is one of the most important requirements of a data warehouse, but this is only part of the requirement. The full…
This blog article is a follow-up to the Ragged Hierarchical Dimensions article I posted a few weeks ago. In this article, I spoke of using…
Today we will look at a different type of fact table, the accumulating fact. Accumulating Fact Tables Accumulating Fact tables are used to show the…
Last week we defined the three types of fact tables and have established a solid foundation in the definition and use of transactional fact tables.…
Now that we have established a solid foundation with dimension tables we will now turn our focus to the fact tables. Fact tables are data…
There will be times when you arrive at a many to many relationship between a fact and a dimension. This many to many relationship is…
In my last post, we discussed the creation of simple hierarchical dimensions. In this post, I will discuss how to handle those ragged hierarchies, those…
Today, continuing through our look at the advanced modeling techniques of dimensional data warehouses, we will take a look at simple hierarchical dimensions. Simple Hierarchical…
Virginia Business and Best Companies Group name NuWave Solutions Best Place to Work in Virginia – Small Employer Category MCLEAN, VA, February 08, 2017 /24-7PressRelease/…
We will continue our deep dive through advanced dimensional data warehouse design techniques by discussing snowflaking. Snowflaking Dimension Tables According to Dr. Kimball, dimensions should…
Today we will look at the advanced dimensional data warehouse design techniques of Degenerate and Junk Dimensions. Degenerate Dimension Tables As I stated in an…
In my last blog post, I showed how to capture changes for slowly changing dimensions. Today we will see how to handle rapidly changing dimensions.…
In my last blog post, I demonstrated the importance of conformed dimensions to the flexibility and scalability of the warehouse. This week we will discuss…
In my last blog post, I presented to you some of the more widely used advanced technical dimensional design techniques. Over the next several of…
In an earlier blog post, I walked you through the basics of dimensional data warehouse design by introducing you to dimension tables, fact tables and…