Chandoo.org Podcast - Become Awesome in Data Analytics cover art

Chandoo.org Podcast - Become Awesome in Data Analytics

Chandoo.org Podcast - Become Awesome in Data Analytics

Written by: Chandoo
Listen for free

About this listen

 Want to be an AWESOME DATA ANALYST? Chandoo.org Podcast is the place to go. Learn how to use popular Data Analytics software like Power BI, Excel, SQL and more with your host Chandoo – an award winning author, speaker and YouTuber.Copyright - Chandoo Careers Economics Personal Success
Episodes
  • CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)

    CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic)
    Dec 7 2023

    Bill Jelen is one of my most favorite people on earth. That is why I wanted to have him as my first guest when I restarted the podcast. Even though I recorded this few weeks ago, only now I got around to publishing it. Please enjoy the conversation with Bill.

    Listen to this episode Resources for this podcast episode

    More about Bill:

    • MrExcel.com (Bill’s website)
    • Bill Jelen on YouTube
    • Excel eSports

    The post CP05: Interview with MrExcel – Bill Jelen (on his incredible work ethic) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
    Show More Show Less
    38 mins
  • SQL vs. Power Query – The Ultimate Comparison

    SQL vs. Power Query – The Ultimate Comparison
    Oct 13 2023
    On the left side, we have a veteran warrior with 37 years of data battle scars and redundant six pack. They call him SQL. On the right side, there is a young challenger with transformative powers and “never say undo” attitude. He goes by the moniker Power Query. Who is going to win this battle?!? I have been using SQL for 25 years and Power Query since it came out in early 2012. And in this article, let me share my views on how SQL compares with Power Query. If you prefer to listen, check out the podcast episode – SQL vs. Power Query. Listen: SQL vs. Power Query Podcast Episode SQL vs. Power Query - The Comparison SQL Power Query What can you do? All CRUD operations (Create, Read, Update, Delete) Only Read the data What kind of data? Usually single source from a database or warehouse (ex: SQL Server) Can access data from anywhere and combine data from multiple sources too. How do you use it? You need to “WRITE” queries to use SQL. You “BUILD” Power Queries using the UI buttons and menu options. Where can you use it? Works almost universally. You can use SQL with most database systems and programming languages. Only with Microsoft stack of products, primarily with Power BI, Excel and Fabric. Who can use it? By default, you need permissions / special software to use SQL. Almost anyone can use Power Query as it comes packaged with Excel and Power BI. How fast is it? Built for performance and scalability. You can use SQL to access data quite efficiently. Can become slow and tedious as your data grows. Resources for Learning SQL SQL Basics 50 SQL examples for Excel folks Resources for Learning Power Query What is Power Query and how to use it? Learn Power Query in 15 minutes My Power Query Essentials Course What do you think? Have you used both or either of these technologies? What do you think? Leave a comment with your thoughts. The post SQL vs. Power Query – The Ultimate Comparison appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
    Show More Show Less
    28 mins
  • CP03: The Ugly Truth About Power BI (actually, 4 of them)

    CP03: The Ugly Truth About Power BI (actually, 4 of them)
    Aug 24 2023

    Power BI is one of the most prominent data analytics technology out there.

    Power BI is also one of the most marketed and hyped technology out there.

    Unfortunately, both of these statements are true.

    In a world where data is the buzz word, Power BI (or other similar platforms like Tableau) appeal to CXOs as panacea for all their data troubles.

    But, just as any technology, Power BI too has it’s own shortcomings. So in this episode of my podcast, let’s uncover 4 ugly truths of Power BI.

    I want to preface this discussion with a huge note of thanks & gratitude for what Power BI offers. It is a beautiful technology with a few patches of ugliness.

    Episode outline:
    • ONE: Power BI is not one technology, even though it is marketed as one.
    • TWO: Power BI changes frustratingly often. This makes it a hard technology to learn and use.
    • THREE: Power BI can get prohibitively expensive as your organization & data needs evolve.
    • FOUR: Power BI visuals / outputs are unimpressive.

    Listen to this episode Subscribe to the Show Resources for this podcast episode

    Learn more about Power BI:

    • The truth about Power BI and how to learn it properly (video)
    • Free vs. Pro vs. Premium Power BI – which one you should choose? (video)
    • Introduction to Power BI and full tutorial (article)
    • When & How to use various Power BI charts (guide)
    • Power BI Beginner to PRO – Full Course (paid class)

    The post CP03: The Ugly Truth About Power BI (actually, 4 of them) appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.
    Show More Show Less
    22 mins
No reviews yet