24HOP Back Again With Business Analytics

In 12 hours back to back live sessions and 12 hours on-demand reply, industry experts will take to the virtual stage to deliver a series of one-hour webcasts focused on data analytics and visualization, big data innovations and integration, information delivery, advanced analytics, and much more! This 24 Hours of PASS event is a preview of PASS Business Analytics Conference to be held in April later this year.

Starting at 1:00 PM GMT / 8:00 AM EST /  5:00 AM PST on Jan 30th 2013 (or midnight on Jan 31st, 2013 Sydney), the live sessions are listed below:

January 30th, 2013 13:00 GMT
Session 01 Live: PowerPivot for Excel 2013 in Action
Presenter: Alberto Ferrari

January 30th, 2013 14:00 GMT
Session 02 Live: Putting the Business into Business Analytics
Presenter: Jessica Moss

January 30th, 2013 15:00 GMT
Session 03 Live: Big Data on the Microsoft Platform
Presenter: Andrew Brust

January 30th, 2013 16:00 GMT
Session 04 Live: Why? Where? Spatial Analysis in Excel 2013
Presenter: Peter Myers

January 30th, 2013 17:00 GMT
Session 05 Live: Finding Rare Needles in the Haystack – Predictive Modeling with Unbalanced Data
Presenter: Paul Bradley

January 30th, 2013 18:00 GMT
Session 06 Live: Ensuring Compliance of Patient Data with Big Data and BI
Presenter: Denny Lee

January 30th, 2013 19:00 GMT
Session 07 Live: Dashboard Design Dos and Don’ts
Presenter: Stacia Misner

January 30th, 2013 20:00 GMT
Session 08 Live: What Is Big Data?
Presenter: Mark Whitehorn

January 30th, 2013 21:00 GMT
Session 09 Live: Marketing Forecasting with Excel
Presenter: Wayne Winston

January 30th, 2013 22:00 GMT
Session 10 Live: Visualizing Data with Power View
Presenter: Sean Boon

January 30th, 2013 23:00 GMT
Session 11 Live: Analyzing Data with Power View
Presenter: Jen Stirrup

Date/Time: January 31st, 2013 00:00 GMT
Session 12 Live: From Data to Insight – Views from Microsoft Finance
Presenter: Marc Reguera



I am very excited to host not one, but two 24 Hours of PASS Sessions tomorrow. The sessions I’ll be hosting are two of my favourite topics, Putting the Business into Business Analytics (Jessica Moss) and Why? Where? Spatial Analysis in Excel 2013 (Peter Myers).

See you there!




Starting 2013 with BI Talks

After the great PASS Summit 2012 finished, I have been counting down to the next SQL community events. Partly because I have learning withdrawals, and mostly because I miss my SQL Family!

Luckily, there are two SQL Saturdays scheduled near* my area. One of them is SQL Saturday #198 in Vancouver, Canada (16 Feb 2013) and another one is SQL Saturday #177 in Silicon Valley, US (23 Feb 2013). What I love the most about SQL Saturday is that it’s the best bang for your buck! If you look at the schedule for SQL Saturday #198 (Vancouver) here, you can immediately recognize many of the speakers are MVPs! Same goes to SQL Saturday #177 (Silicon Valley), the Partial List of Speakers shows that you will be in for a treat.


Also, if you are in the Business Analytics arena, the PASS BA Conference 2013 in Chicago is surely not to be missed. It’s a one stop shop for business analysts, data scientists, data architect and BA/BI practitioners. Not convinced yet? Twelve of these talks are going to be previewed for free on the upcoming 24 hours of PASS.  So check them out!


I am very delighted to also announce that I will be speaking at all those three events with the following topics:

1. Power View for Geographical Analysis for SQL Saturday #198.

2. The Essential 8: Narrative Reporting Techniques, with an expert BI architect and a friend, Josh Fennessy, for both SQL Saturday 198 and PASS BA Conference.

3. Analytic Cartography: Master Geospatial Reporting for SQL Saturday #177.


That’s my way of starting 2013!

Hope to see you, SQL Family, in some (or all!) of these events.


Standing Firm – Story of a WIT

This is my first blog for T-SQL Tuesday. The theme for this month is Standing-Firm, which could be a story relating to one of these words: resolve, resolution, or resolute. I picked resolute.

My story is in relation to Women In IT/Engineering. Looking back, the first woman in Engineering, I have known, is my mum. Growing up, I was aware about this but never really gave it the proper recognition it deserved. Today I would like to do that.

I was born and grew up in the tropical country of Indonesia, where, as a child I learned so much about the limitations and boundaries that females could face. I became interested in data, specifically business data, in my early teens as my parents owned a business supplying standard and custom nuts and bolts. While their business was small it did well enough to keep all four children fed and educated.

One of my role models and inspirations is my mum. For 45 years, she has managed the day-to-day goings on within the workshop, negotiating deals, organising stocks and giving advise to engineers. Her understanding did not come from school (as she only finished year 8), but from practical experience that she learned from my dad and peers. There were no associations in Indonesia designed to help women in Engineering or IT. She came from a poor family, with little education, but she did it all. She raised four children and embedded these principles when we were growing up: passion, determination and helping others.

My mum has lived a very interesting and admirable life. For just over 14 years while I was still living under the same roof as my parents, my mum always said that “Our gender should never inhibit us from pursuing our dreams”. I held on to that, moved out of home and left Indonesia to live in Australia so I could pursue studying IT in high school and university. While studying IT, it was not uncommon that I would be the only girl, or the only one from a non-English speaking background. This didn’t quiver my passion for or my determination to excel in IT. Even with entering IT at a professional level, it is still not uncommon to be the only female in my area. I have become so used to this situation that I don’t see gender difference as an issue.

Map of places I have lived in

In 2012, I was determined that I wanted to learn more and to help others, by blogging and speaking at community events. I was nervous, not because I was a female, because I considered myself inexperienced compared to some others. Even so, if my blog posts or presentations could help even one person, I would be happy. My determination to help others has helped me to overcome my nervousness and learnt more about SQL Server. PASS and #SQLFamily have also been very supportive in this.

This year, I want to become a more confident speaker and a more knowledgeable SQL professional who helps and learns from #SQLFamily. I also want to be involved more with Women in IT activities via PASS and on personal level. My Women in IT/Engineering inspiration started with my mum at a young age, and I would like to help other females to pursue their professional dreams. We should be able to show our abilities within the workplace and still embrace our female nature (for me this would include my inability to open jars, but that’s why jar opener was invented, right?). We are all unique, female or male.


This post is dedicated to my mum.

“Our gender should never inhibit us from pursuing our dreams” – Paulin Koesmarno

Wrap Up

Thank you to Jason Brimhall (b | t) for hosting TSQL Tuesday – Standing Firm this month. The original invitation is available here.  The rules for participation are in the invite. You can also read others’ submissions for the theme this month.

If you are a PASS Member and interested in Women in IT events and activities, please check our website here.