Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.


-1.png)
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Classes
Private deliveries of courses for groups
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Cheat Sheets
Quick references for when you need a little guidance.
Prag Guides
Explore our knowledge base for quick tips on syntax, functions, and more!
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Quickstarts
Hands-on training with expert-led collaborative development.
Private Training
Personalized approach for your specific training requirements
Hackathons
Use your own data to take your team's skills to the next level.
Virtual mentoring
Get there faster with your personal trainer.
Enablement
Comprehensive enterprise enablement training for your team.
Admin Hackathon
Tame your power platform environment.
Are you incorporating BI and data warehouse testing into your data world? If not, it’s time to give this more thought. The importance of testing your data warehouse and BI systems cannot be overlooked. Testing early in the process can save you time and effort, as well as allow you to make better business decisions.
In our Real World Data Testing series, we talked more in depth about this topic. Once you are on the bandwagon of BI and data warehouse testing, there is a common testing framework to consider before you sit down to write and execute your test. I discuss this here with John Welch, President of Pragmatic Works Software. This strategy (known as the three As) Arrange, Act and Assert is used in many types of testing.
Here’s where you set up all your preconditions for the test. Make sure there’s test data in place, any parameters are set, and your environment is set up the way you need it to be. Be sure your expectations are met for the preconditions for starting the test.
This is the action you are going to test the results of. In a data system, for example, that may mean running an ETL process, moving data from your source to your target.
Here, you set statements that would be true if the condition was met, and false if things did not go as expected. In our ETL example, your assertion may be: I expect that if I had 20 rows in my source table, I expect 20 rows in my target table.
The key is to consider these 3 steps before you begin testing. Most common test frameworks, such as NUnit or MS Test, all support the methodology of Arrange, Act, Assert. John goes into more detail about this strategy in his whitepaper, which you can download below.
So, if you’re ready to incorporate BI and data warehouse testing into your business, or are interested in learning more about this, Pragmatic Works can help. We are passionate about data testing and we’ve got the software, training and services to get you on your way. Visit our website or contact us today.
ABOUT THE AUTHOR
Tim Moolic is the COO of Pragmatic Works. He has more than 20 years experience executing sales, marketing and alliance strategies for software and consulting companies. Tim founded his first software and consulting business in 1996 and has worked with a wide range of enterprise software solutions including systems management, automated testing, database and online collaboration tools.
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment