Power BI Expert

Today I am sharing an update on my journey to be a professional Power BI freelancer.  I often get emails from people asking me what it is like as they are also interested in taking the plunge to become a full time Power BI pro.   I thought that readers of p3adaptive.com may also be interested particularly given Rob is such a strong advocate of the new BI economy and what it has to offer.

It was 3 year ago almost to the day that I told my story on p3adaptive.com.  So much has happened and changed since then:

  • I started a blog
  • I wrote a book
  • I learnt a lot
  • I made a living
  • I have presented at a lot of conferences
  • I became a Microsoft MVP
  • and not least of all, I have (and continue to) watch and be amazed by the rise and rise of Power BI

I unashamedly told Rob up front – “I am going to model my new career on you Rob”.    I want to share some salient points about these things mentioned above.  Even if you are not thinking of taking the plunge yourself, you may be interested to hear about the journey.

I Started a Blog

Taking the lead from Rob’s model I decided to start a blog.  The blog was the easiest thing for me to do because I was already blogging about topics that I was interested in.  Making the move to a blog that also supported my business was therefore a snap.   I only really made 1 mistake in my first year and that was not prioritising my blog as much as I should have.  Three years down the track I have a lot of great content that generates a lot of help for many in the community and a lot of web traffic for me.  The truth however is I am only 2 years down the track because I didn’t put enough effort in during the first year.  If you are starting out on a journey of independence yourself, then do yourself a favour and start sharing some content on the web.  It takes time to reach critical mass and the sooner you start the sooner you will get the benefit.

I Wrote a Book

learn-to-write-DAX-450-highWriting my book “Learn to Write DAX” was both challenging and rewarding.  It was challenging because there was so much else to do.  It is hard to focus on things that are important but not urgent (hard for me anyway).  But thanks to good coaching by my publisher (Bill Jelen, Mr Excel) I set a plan with the number of pages I needed to write each week, and tracked it in Excel (of course).   I am no JK Rowling so I wont be retiring any time soon from the proceeds of my book.  Gosh, I am not even a Collie/Singh.  But I have carved out a niche for myself by creating a unique product that gives new Power BI/Power BI users everything they need to get started with DAX (and nothing they don’t) at a very affordable price.  Many readers tell me they wished they had found my book earlier (read their reviews here – it has 4.9 stars on Amazon).  If you are interested in buying the book, please consider buying from Mr Excel in the USA or from my shop in Australia.  You will get a DRM free copy of the book as well as the paperback if you buy from Bill or me.

The book has been important to me for a number of reasons.

  • It rounded out my knowledge of Power Pivot and DAX to a “full house”.
  • I use it for my course material for students of my live training classes in Australia.
  • It creates awareness of me in my industry.

If you are going out on your own and you can afford the time and effort to write a book, then you should certainly consider it.

I Learnt a Lot

This is probably the most rewarding of all the points I am covering today.  I have learnt so much by getting involved.  I am a strong advocate for helping others on forums (as outlined in this article I wrote last week). I have learnt such a lot by helping others.  I have also been blessed to learn about many other industries apart from my heritage at The Coca-Cola Company.  I have worked for clients that deal with …

  • Retail
  • Wholesale
  • Vending
  • Finance
  • Mining maintenance
  • Utilities management
  • Government
  • Drug companies

…to name a few.  It is a privilege to learn about these different industries let alone stimulating.  And what is amazing is how different and yet how similar they all are.  The thing that ties all these industries together (every industry in fact) is that they all have data and they all need to analyse that data.  I can’t think of a better job to have than to be a data analytics guy – what fun!

I Made a Living

None of what I have talked about would have been possible if I wasn’t making a living.  Admittedly I was at a life stage when I could afford to take a bit of a risk – I doubt I would have done the same thing 10 years earlier when I still had a lot of significant financial commitments.  The key to making a living (for me) was to find 1 solid consistent client that needed what I had to offer.  I effectively worked part time as a business analyst for an extended period of time, and that paid the bills while I was building my business.  I am convinced there are plenty of opportunities like this out there.  Not every company has the resources it needs to do analytics well.  If you are a data person, then you have something that many companies need.  If you can find such a company that has a need and can take you on for 1-2 days per week, then you have the foundation to grow from (it worked for me anyway).  Three years in and I have many varied clients around the world and enjoy engaging with them all.

I Became a Microsoft MVP

I always wanted to be an Excel MVP, for as long as I knew what that was.  Becoming a Data Platform MVP last year was good enough for me even if it wasn’t the Excel kind.  Being an MVP has helped others (people that don’t know me) to understand that I have got what it takes.  I also really appreciate the recognition from Microsoft for the work I do in the community and for the support Microsoft provides to its MVPs.

Thankfully for those that want to become an MVP, the process has never been better (I’m not saying easier, just better).  You can now submit your case as to why you should be an MVP and you will normally get an answer within 4-8 weeks.  When I submitted it took 10 months before I heard back.  If you are doing great things for the community with any of Microsoft’s products, you can submit your case to be an MVP here.

I Have Presented at a Lot of Conferences

This is actually one of the things I enjoy most.  You can’t tell me this group doesn’t know how to enjoy itself

Unfortunate its not like the good old days at Coke when someone else paid for my Business Class airfare, accommodation, and importantly my salary while I was away.  No, these days I pay for my own economy airfare, my own accommodation and I don’t get paid when I am away.  But hell, you can’t have everything!  I do love speaking at conferences, but not really for the reason you may think.  What I like most is the people I meet.  I’ve met a lot of great people that are speakers, and a lot of people that are conference delegates.  I will be speaking at the Microsoft Data Insights Summit in early June.  I will be presenting with Will Thompson about DAX 050 – DAX for the rest of us at 10:00am on 12 June (this is the lesson you get before DAX 101).  The objective is to start from the very beginning of DAX and not get too complex.  I will also be presenting on the topic of Evaluation Contexts at 11:10 am on 12 June – be sure to see that one!

I also do a lot of local speaking events including running the Sydney Power BI User Group with co-founder Iman Eftekhari.  If you live in Sydney, we would love to see you there.

The Rise and Rise of Power BI

This is actually what has underwritten my success – the rise and rise of Power BI.  Call me lucky, call it timing, call it what you like.  But it if weren’t for this fabulous product I doubt I would have been so successful and happy.  I actually started out thinking I would be a custom Excel shop.  While I am certainly capable of doing that, I find the data world (in the presence of Power BI, Power Pivot and Power Query) so much more interesting and exciting.  In fact I hardly ever use regular Excel at all any more.  So a big thank you to Microsoft for building (and continuously improving) such a great product.  This product is laying the foundation for careers for people like me and Rob, and maybe also you.

What Next

The opportunity to make a career as an independent Business Analyst using Power BI has never been better.  Or if independence doesn’t appeal to you, there is plenty of career options too. Going independent is not for everyone.  If you want to take the plunge to become a Power BI consultant and don’t want to go it alone, there are always people like Rob that are looking for the best of the best to work for him.  At this stage I am not looking to hire people myself but have instead elected to be a one man band. But who knows, that may change one day particularly for the right person.