fbpx
Search
Close this search box.

CP003: Business Intelligence for Masses – Interview with Mike Alexander

Share

Facebook
Twitter
LinkedIn

In the third session of Chandoo.org podcast, we are going to get BI curious. 😉

Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members.

CP003: Business Intelligence (BI) for masses - Interview with Mike Alexander - Chandoo.org Podcast

First some good news: We hit #1 on iTunes in our category

That is right. Around 14th of March, we hit #1 in our category of podcasts. Yay!!!

Chandoo.org Podcast - become awesome in analysis, charting, dashboards & VBA is at #1 position on iTunes

Please take a minute to subscribe to our podcast:

What is in this session?

In this session, I am happy to feature Mike Alexander – Microsoft MVP, Author, Blogger & a good friend. Mike talks about how Excel is shaping the BI (Business Intelligence) revolution with advent of Power BI functionality.

2 special gifts for our listeners:

  • 10% discount on Mike & Bill’s upcoming Power BI Bootcamp in USA
  • Free Excel Dashboard Tools add-in

Listen to the podcast to know how to get these.

You will learn,

  • Introduction, what Mike is up to these days?
  • What is BI, what does it mean to an average Excel analyst?
  • What BI capabilities Excel has – brief intro to each of them
    • Power Pivot & what it does
    • Power Query & why it is important
    • Power View & how it works (and where it sucks)
    • Power Maps
  • How to learn about these new technologies
    • Recommended Books
    • Websites
    • Courses
    • Live classes
  • Special gift for our listeners

 

Go ahead and listen to the show.

Links & Resources mentioned in this session:

Mike’s website – Data Pig Technologies

Books mentioned

Power Pivot related articles & resources

Add-ins mentioned:

Dashboards mentioned:

Courses mentioned:

Mike & Bill’s upcoming Live Class

Transcript of this session:

Click here to download the transcript.

Thanks to Mike

Thanks Mike for joining me and sharing your knowledge, humor and passion with our podcast community. As always, it was fun talking to you. I look forward to featuring you again in our show sometime.

2 special gifts for our listeners:

  • 10% discount on Mike & Bill’s upcoming Power BI Bootcamp in USA
  • Free Excel Dashboard Tools add-in

Listen to the podcast to know how to get these.

If you enjoy the podcast…,

Please do these 2 things. It means a lot me & our community.

  1. Subscribe to our podcast on iTunes
  2. Please leave an honest review on iTunes by clicking here.. It will help the show & its rankings immensely. Thank you so much.

Do you use Excel’s BI capabilities?

Do you use Power Pivot et al? How do you like them? Do you feel these tools empower you & your business? Please share your experiences & thoughts in comments.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

86 Responses to “CP003: Business Intelligence for Masses – Interview with Mike Alexander”

  1. Robert Guers says:

    Chandoo and Mike,
    Love the POD cast on Business Intelligence (BI) and should have more sections like this. it was great...

  2. Chris Macro says:

    Another great podcast Chandoo. Probably my favorite to date! Learning more about these Excel BI tools is definitely on my list. I do have one question for you....my current company is using Office 2007 and therefore doesn't have access to some of these BI tools (PowerPivot, etc...). I do however own Office 2013 at home. How would you suggest learning these tools from a home setting with no 'real world' data or databases to use?

  3. Munir Haider says:

    Good day Chandoo & Maike,

    loved the podcast, it was really both informative and entertaining. looking forward for the upcoming BI for analyst book.

    Thank you both for such an awesome post.

    Cheers,
    Munir

  4. Arturo says:

    Chandoo and Mike,

    Love the podcast!!!!!

    Between the neighbors, the adoption and chandoo's archive
    the discussion on Business Intelligence (BI) was powerful and insightful....

    Well done guys!!!

  5. Ben says:

    Thank you Chandoo and Mike, that was a great discussion. I've seen bit and pieces about BI in excel, but haven't worked out how they would fit into what I sdo at work. Now I've got a great list of resources, and the motivation to find out more.

  6. Chris:
    Yeah Office 2007 doesn't support the new BI stuff. I hope your company moves up.

    As far as your Excel 2013 version at home, it depends on the version you have.

    To be able to use the new BI tools in Excel 2013, you'll have to have either:

    Office 2013 Professional Plus
    OR
    Excel 2013 Standalone Edition (you can buy on Amazon for around $99)
    OR
    Office 365 Premium subcription.

    Provided you have the right version of Excel 2013, you can start playing with sample data.

    The Windows Azure Data Marketplace is an excellent source for all kinds of free datasets. Just visit the URL below, sign up for free, then you'll be able to download hundreds data tables to play with.

    https://datamarket.azure.com/browse/data

  7. Geoff Koch says:

    Great episode. I can definitely relate to Mike regarding the ETL process in his beginning years. Have a couple macros set up for this exact reason right now actually.

    I await our institution's move to Excel 2013 with much anticipation.

  8. Dan says:

    Good podcast! Looking forward to checking out the add-in...

  9. João says:

    Loved the talk! Nice info and good fun.

  10. Shaz says:

    I enjoyed the podcast and the washing machine bit was hilarious. Excel and PowerPivot are more powerful than ever and definitely worth investing time into learning.

    After listening to the podcast, I am anxious to give Power Query a try. Thank you for sharing your knowledge, and for both and educational and entertaining podcast!

  11. Curtis says:

    Great podcast. Appreciate the information presented here, and looking forward to future information.

  12. Sue Voelker says:

    I have only recently been working with the Power Pivot and have become even more impressed with Excel. Thank you for the podcast and sharing your thoughts about the relative merits of the various pieces of Microsoft technology and where this stuff seems to be heading. Thanks!

  13. Ethan says:

    Great podcast topic covering BI using Excel. I wasn't aware of the new technologies/capabilities as I'm still on Excel 2010. Keep up the great work!

  14. Nation says:

    Thanks Chandoo and Mike, great session! Mike's a character, definitely hope to see him back on the show.

    On somewhat of a side note, hope that MS will look to broaden the availability of their BI offerings (ref Mike's reply to Chris above)... Give businesses and personal/individual users, i.e., everyone - more options for getting their hands on this stuff.

  15. Biju Chacko says:

    Great podcasts! Keep up the good work! Am I in to receive Mike's dashboard addin?

  16. David says:

    Your website is a great help. Loved the podcast

  17. samtheman says:

    Great podcast. This is the first podcast I listened to the end. Great insight into BI. Thanks a lot to Mike Alexander and you. Hope you will have other great Excel Gurus in your future podcasts.

  18. AMBARISH N says:

    Hi Chandoo & Mike,

    The Podcast cast on Business Intelligence (BI) is really awesome...

  19. Abhi says:

    Chandoo... Are you on SoundCloud as well? That would really help people who are on Android.

    Thanks

  20. Stef@n says:

    where can I find the
    Free Excel Dashboard Tools add-in
    ??

  21. Shanil says:

    This was a great podcast. Got learn a lot from 2 of the brilliant minds in Excel and it was really entertaining. Inspirational and Motivational. Looking forward for the release of Mike's new book on Microsoft BI tool.

  22. Roan says:

    Nice work guys.
    Power Map is certainly something I'll look into. I'm doing some work with a NPO (non-profit organisation) called Greenpop. They plant trees in impoverished areas for free, especially low income schools, here in Southern Africa and for them to get a visual representation of all the hard work they do will be amazing.
    Thanks for helping to broaden our minds.

  23. Martin says:

    Thanks for the podcast. I look forward to reading Microsoft Business Intelligence Tools for Excel Analysts

  24. Heather says:

    Just listened to my first episode of the podcast - loved it!
    I've enjoyed both DataPig and Chandoo.org for quite a while now, and it was fun to hear both of enjoying yourselves so much.

    I've been wanting to get into Power Pivot for some time - this podcast may end up getting me to make the jump into this powerful tool.

  25. Rudy says:

    Awesome Podcast!
    Exciting stuff. I've heard of Powerpivot before but was never in the KNOW. Understanding now of the paradigm shift and the Microsoft BI stack for Excel, I think it's really time to migrate from 2007.
    Chandoo - great idea starting up a podcast.
    Mike - I know MrExcel. I know Chandoo. and now I know BACON! You're awesome bro.
    #OpenXL
    #BaconBits
    #Kenmore (Lol)

  26. Aaron says:

    Thanks for (another!) great podcast, Chandoo! As someone new to the corporate BI/"big data" space, it was wonderful to hear your and Mike's thoughts on how Excel can be used instead of some of the clunky, complicated legacy systems that many companies seem to rely upon.

    Thanks!!!

  27. Mariusz says:

    I found Chandoo blog just a 2 weeks ago. It's great page and excellent podcast (I love this podcast idea very much). I expect to have a great fun with Excel Dashboard Tools add-in.

  28. Christy says:

    That was fun! thanks for putting it together... these tools all seem a bit more approachable now. You both are extremely awesome, I'm looking forward to future podcasts. 😀

  29. William says:

    Great episode! I'm on a steep learning curve with Microsoft Power BI and I owe much of my knowledge to Chandoo.org. I totally agree with the Power View comments regarding making one feel "Powerless". I hope it improves - there is great potential there. Thanks!

  30. G says:

    Fun conversation - Interested in testing out Mike's add-in.

  31. David says:

    Another enjoyable episode.

  32. Chris Krings says:

    Fantastic podcast. Thanks for connecting the dots on all the available BI tools for the Excel warriors out there.
    As always, it gets more complicated before it gets simpler. Fun to see Excel grow up into a relational structure.
    All the best, Chris

  33. Dileep says:

    Hi Chandoo,

    Excellent podcast..had lots of laugh in between..I would recommend this podcast to all my friends.

    and Mike waiting for your book to be released

  34. Salvador says:

    Great explanation of BI for the regular person. Chandoo, keep on with these great podcasts!! Loved the explaneation of PowerPivot and Power Query.

  35. Adi says:

    The best take-away of the podcast was that "No one advertises for excel gurus". So true... Good insights on PowerPivot; guess time to learn the "nth" thing in excel.
    Thanks Chandoo & Mike...

  36. Jimmy says:

    Very good podcast indeed. Hope Chandoo got his neighbour enrolled in the course 🙂

  37. Adi says:

    Chandoo, am getting an error msg on trying to install the add in... Does it work only on 2010 and above? I have 2007 installed...
    Pls help.

  38. krishna says:

    Thanks Chandoo and Mike
    I had a great time listening to this podcast. Loved it.
    I m looking to learn more on BI once I m done with certain classes at Chandoo

    And Mike you have earned a fan and Chandoo thanks for such a god podcast

    P.S. I have missed your archives. Can you kindly paste the link to all those

    Krishna

  39. Rob says:

    Hi Guys,

    This is my favourite of the three podcasts so far and covers interesting information in a way suited to a podcast (things like formula syntax is difficult to communicate without seeing it written down).

    Learning more about the Power BI tools is now definitely on my list, I just need to find a big project at work to sink my teeth into 🙂

  40. Bryon Smedley says:

    Great Podcast! I'm ashamed to admit, but I've always been intimidated by PowerPivot and PowerQuery, even though I'm considered the best at Excel in my company. This podcast has inspired me (by not wanting to be left behind in the new revolution of Excel) to learn these tools.

    Love the podcast. Keep up the good work.

  41. Damon Edmondson says:

    Great podcast, listened to it, and really helped me think about what excel BI is becoming and how its evolving

  42. Jay says:

    Hi Chandoo,

    As usual, lively and informative session. I never knew there was a data mining add-in for excel. This session really helps in understanding the BI potential in Excel, how things are evolving in this area etc. Great session overall. Thank you.

    Jay

  43. Jeff Weir says:

    Great post. Mike, good to see someone else has digged into the archives, with a view to writing them up. I'll send you my early attempt that Chandoo has completely ignored (in fact, he didn't even tell me he was ignoring it. I heard it here first. 🙂

    You're right...early on the site is part travelogue, part student diary, part marketing insight, part social commentary/satire, part advert critique.

    here's some of my favorite articles from Chandoo's archives:
    http://chandoo.org/wp/2004/11/04/smirnocked/
    http://chandoo.org/wp/2004/11/24/are-you-doing-blowjob/
    http://chandoo.org/wp/2004/12/02/i-stink-therefore-i-exist/
    http://chandoo.org/wp/2005/02/25/madhu/
    http://chandoo.org/wp/2005/08/29/recipe-of-my-lfe/

    ...but here's the funniest by far:
    http://chandoo.org/wp/2005/07/11/dude-where-is-my-fullstop/

    I love some of the inappropriateness of the early posts. But I see that that boundary-pushing was still in play in late 2008 with http://chandoo.org/wp/2008/09/26/visualizing-sex-love-10-must-see-infographics/ (although I can’t believe Chandoo did not replicate The Authentic Woman’s Penis Size Preference Chart in Excel.)

    What was also interesting was the post 500 days of PHD:
    Somewhere during the IRIS and loads of sleep and laziness, my blog has finished 500days of existence. Congratulations PHD

    Interesting, because the blog was 500 days old, and Chandoo had yet to actually post anything in regards to Excel on it.

    I miss those days. 🙂

  44. Micheal says:

    This podcast was very interesting. I have become a major proponent at work of changing how reporting is done. This podcast helped me to see more ways to improve or reporting

    I may pitch to them that we should dpsend people to Bentonville in April.

  45. Dileep says:

    Hi chandoo,

    how can i get my free dashboard tool add in.

  46. Donald Parish says:

    Mike, really enjoyed your point of view. I'm a VBA/Java/Ruby/Clojure programmer, but for ETL I'm using Power Query, especially since the underlying M language is powerful. Also a big fan of Q&A as feature of Power BI that the execs might use.

  47. Jack says:

    Still can't find the add in

  48. Paul Bishop says:

    Another fantastic episode Chandoo! Please keep them coming; they've all been really interesting and I've learnt a lot so far.

  49. Chandoo says:

    @all.. thanks for the lovely comments. I am really happy to feature Mike in our podcast.

    I will be sending you a link to download the add-in shortly (by Wednesday).

  50. TheQ47 says:

    Chandoo, I'm really loving this podcast. To be honest, I was concerned how it would work, because Excel is not really an auditory experience(!), but I'm finding it very interesting. Keep up the good work, Chandoo.

    And, by the way, despite what Mike might have said during the early part of the podcast, on my iPhone the Chandoo.org podcast does appear between some esoteric podcast subscriptions (in alphabetical ordrer):
    "The Bugle"
    "Chandoo.org"
    "Comedy of the Week from BBC Radio 4"
    "An Irishman Abroad"
    "The Smartest Man In the World"
    "NPR: Snap Judgement"
    "Stuff You Should Know" and
    "This American Life"

    These are among some of my favourite subscriptions, and that I look forward to downloading and listening to every week, but chandoo.org is the only business/excel related one.

  51. […] the newly prophesied ones (yea the power of PowerPivot compels you,according to that dark preacher Mike Alexander). So go and explore all those mysterious things on the ribbon. You don’t have to master all […]

  52. Dave says:

    Great 3rd show Chandoo! Loved the format and discussion, kept me listening happily on the way to and back from work. Please keep them coming as it was really good to hear about the Power BI suite rather than just read it, makes much more sense now. Cheers.

  53. John says:

    Mike was very informative and entertaining. I hope you can have him back as a guest to discuss specific applications of PowerPivot and PowerQuery.

    • John says:

      I may have input the wrong email address on my orginal post. Have you sent out the link to the Dashboard add-in? The one with this post is the correct address.

  54. Pablo says:

    Hi Chandoo,
    The best way to have a podcast is to have interviews, talk about broad subjects, discuss a new feature or technology. Think about it, we are just listening, we are not seing spreadsheets, and since most people are visual learners, trying to teach Excel via a podcast makes no sense, but it does for what you have done today.
    I hope you keep it up in this format, it awesome.
    Thanks,
    Pablo

  55. Stephen says:

    Hi Chandoo,

    This was the first podcast I listened to and I'm glad I did!

    Apart from being very informative its actually very entertaining. Mike is ridiculously funny and I love his analogies!

    This is my first visit to your site after listening to your podcast and it seems like an absolute gold mine for information and can see that it will be very beneficial for me, so thanks in advance for that.

    As there is so much information where would you recommend to start learning?

    Looking forward podcast 4 already, keep her lit buddy! Good luck

  56. David McElligott says:

    Excellent talk. I'm an enrollee of many of Chandoo's classes and love them all. I recommend the latest on Power Pivot to everyone. Can't wait to get the book Mike has coming out too. Keep up the great work and thanks for your help in making us all awesome in Excel.

  57. Alexis says:

    Fantastic podcast and a great episode, Mike is hilarious!

    I had heard of the new BI tools and looked into them a little bit but this has got me really excited about the potential of what I will be able to deliver at work. For me Power Maps will be awesome! Can't wait to get Mike's new book 🙂

  58. Tim says:

    Enjoyed session 3 and am looking forward to exploring Mike's dashboard. Thank you, Tim

  59. Nation says:

    Hi Chandoo,

    Received an email w/ a link to the add-in (Thank You & Mike!) - but so far no luck using it... Wanted to ask if you could please help me out w/ a new link, if it's not too much trouble? Following the link leads to an error page, as seen below (the "..." are just long strings that change w/ each attempt). Thanks again.

    "This XML file does not appear to have any style information associated with it. The document tree is shown below."


    -
    AccessDenied
    Access Denied
    ...............
    -
    ...............

  60. chrisham says:

    Not sure if I have made in the first 50, but loved the podcast, what can you say about Mike?? He'll do well as a scriptwriter too! Extremely funny guy! And thanks Chandoo & Mike for the episode, it was very informative

  61. G Rai says:

    Hi Chandoo

    You are awesome! I hope i am not to late to receive the excel add in.

    Thank you.

  62. OSt8Buckeye says:

    Chandoo,

    Love the podcasts! Have used your website for years, keep up the good work!

    Am hoping I am still in time to get a copy of Mike's add-in

    Thanks

  63. David Henderson says:

    Mike, Chandoo thanks a lot for the excellent podcast. Really keen on trying to learn about the new Power add-ins.

    Also, looking forward to when "101 really useful excel formulas" book come out. Loved the excel dashboards and reports book.

  64. Jdogzilla says:

    Great podcast chandoo. Many analyst now struggle with the decision of using excel for dashboards vs tools like Qlikview. Would love to hear where you see excel stand out against these.

  65. Eric says:

    Great podcast! You two had great chemistry!

    Is there a link to Power Maps?

  66. Sean Hyland says:

    Terrific podcast! Wish I had heard it sooner to be one of the first fifty to respond but regardless, I truly appreciate you making me awesome at Excel!

  67. Another fantastic episode Sir!

    Sir, i did MBA and right now pursuing PHD. i want to know which is better software for research work SPSS or Excel ??

  68. Kavita says:

    Dear Chandoo & Mike,

    I want Free Excel Dashboard Tools add-in......I hope I am in first 50 people who are commenting on your session.

    Definately it is helpfull.

    Thank you,
    Kavita

  69. Hi Chandoo & Mike,

    Great podcast, you guys are naturals.

    @Mike - You should think about getting your own podcast as you are a naturally funny guy. Excel is meant to be fun to us nerds 🙂

    @Chandoo - These podcasts are great and I learn something new every time I listen. Without your knowledge sharing I wouldnt be where i am today.

    Thanks guys and I cant wait for another one of your podcasts.

    John Michaloudis

  70. rgor says:

    Great podcast, love the style and really appreciate the learning - specially about the data-mining add-in and some of the other Power addins.
    Many thanks!

  71. Humberto Ruiz says:

    Really good interview. Excel is the future for business managers that can't receive the right and timely support it needs from IT.

  72. Alicia says:

    Thanks! Great podcast. Really appreciate you both sharing your knowledge with us.

  73. Ashish Mehra says:

    Thank you Chandoo and Mike, that was a great discussion.

    I want Free Excel Dashboard Tools add-in……I hope I am in first 50 people who are commenting on your session.

    Regards,
    Ashish Mehra

  74. Dom says:

    Looking forward to Mike's book. I also believe the world of Excel is changing, becoming even more sexy! If we are able to become proficient in Powerpivot we are going to look like super stars at work! You both have inspired me to finally start playing with Powerpivot this week. Loved the jokes.. makes it fun with is normally a pretty straight conversation!

  75. ashish mehra says:

    Free Excel Dashboard Tools add-in???

    Regards,
    Ashish Mehra

  76. Carlos Barboza says:

    Hello, if we are not able to get the add-in for free, it is possible to buy it? also, Chandoo! you rock!

    • SAUL ESPINOZA says:

      HI Carlos, it seems that you and I are probably the two first Peruvians listening to these awesome MVP's Chandoo and Mike Alex. Greetings

  77. Krishna says:

    Hi Chandoo,

    I had listen to this podcasts session 3 completely & i came to learn so many new things. Thanks for sharing such huge excel knowledge.

  78. Krishna says:

    I had listen to this podcasts session 3 completely & i came to learn so many new things. Thanks for sharing such huge excel knowledge.

  79. David says:

    Discovered the podcast recently and really enjoyed this episode. Really inspired me to start look in to the Power BI tools.

  80. mark says:

    interesting podcast. what would be the current books you would recommend for the beginner in power BI

Leave a Reply