SQL Social No. 37 - Automated Testing for BI using nUnit

This is a past event

50 people went

Location image of event venue


Food, Drinks will be provided!

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below).


This is not your usual SQL Server User Group event. At SQL Social our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

This Month's Speaker and Topic

Daniel de Sousa - [Automated] Test Driven Development with SQL Server

Daniel De Sousa (https://au.linkedin.com/pub/daniel-de-sousa/28/198/b4) is a BI Consultant for EMIS Health, a provider of solutions to help improve quality of business and clinical decision making in healthcare organisations. He has been working with SQL Server for the last 10 years, doing development, data warehousing and Reporting in the BI Space. He has worked before for three of Melbourne's biggest Health Organisations.

Testing software is hard work. Testing BI solutions is harder still; lots of moving parts, the tools are thin and it takes a lot of time and effort. Software development uses unit testing and while this can be applied to the different parts of a BI solution, most people are more interested in the numbers the solution produces and proving that they are right.

So can you validate the numbers in your BI solution? And can you do it quickly and easily?

The session will give an introduction to an approach for automating the validation of your BI solution.

Using nUnit as a framework and some free codeplex tools, we can run a suite of tests every time we load data into our BI platform. This is not continuous integration, and it is not unit testing in the true sense either. It is, instead, "continuous validation", and it can provide you with an awful lot of assurance for not very much extra effort

Our Sponsors:

As always, we are very fortunate to our core sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions, C3 and Pluralsight for their ongoing support of this great community event!

LobsterPot Solutions is a specialist SQL Server consultancy. Founded in 2008 we specialise in Data Platform and Business Intelligence including Data Warehousing and Reporting technologies. LobsterPot Solutions also has a strong focus on training with most of our consultants being Microsoft Certified Trainers who regularly present at local and international events. This combination allows us to offer advice, mentoring and customised training as part of our standard service offering.

C3 Business Solutions (http://c3businesssolutions.com/) is an award winning Australian Information Management, Business Analytics and Business Intelligence company that delivers measurable business improvements for our clients.

C3 specialise in developing and deploying successful strategies end-to-end for large public & private sector organisations. While remaining vendor independent, C3 work with clients to establish current as well as future needs. Their team of top tier consultants continuously focus on delivering measurable business change.

Pluralsight (http://pluralsight.com/) is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com (http://pluralsight.com/) and join the @pluralsight (http://www.twitter.com/pluralsight) community on Twitter.

See you there!