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

Posted on Updated on


SQL Social: Australia’s Premier Data Networking Event!

Register Here!

When: 2015/09/09 From 5:30pm – 8:30pm

Where: The Governors Lounge, The Royal Melbourne Hotel, 629 Bourke Street Melbourne, VIC, Austrlalia

Cost: Free!

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).

Networking

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.

Speaking

As we have mentioned at previous events, we want to encourage you to take your first steps as a new speaker. As an incentive, every speaker wiil receive a free 1 month PluralSight subscription as a thank you. We only need a short 10 minute or so session on any SQL Server related topic – from an interesting query technique to an overview of the functionality of a component. Contact us if you’d like to have a go.

This Month’s Speaker and Topic

Daniel de Sousa – Automated Testing for BI using nUnit

Daniel de Sousa
Daniel de Sousa 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:

Once again we are fortunate to have wonderful sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions, C3 Business Solutions and Pluralsight for their ongoing support of this great community event!

Lobsterpot Solutions:

LobsterPot Solutions™ is an Australian company with staff in Adelaide and Melbourne, offering consultancy and training services around Australia. LobsterPot Solutions specialises in SQL Server, including performance tuning, Business Intelligence, and more.

LobsterPot Solutions is a company of firsts. When the Microsoft Partner Network went live, we were the first company in Australia to become a Gold Competency Partner, the first in the world to gain the Gold Competency in Business Intelligence. Since then we have become the first to have an APS / PDW trainer on staff, and have been involved in training other trainers in the region.

C3 Business Solutions

C3 Business Solutions:

C3 Business Solutions 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 - Hardcore Developer Training

Pluralsight:

Pluralsight 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 and join the @pluralsight community on Twitter.

See you there!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s