Sharad Anand's Data Automation Hour cover art

Sharad Anand's Data Automation Hour

Sharad Anand's Data Automation Hour

By: Sharad Anand
Listen for free

About this listen

 Stop working harder and start automating your data life! Host Sharad Anand delivers expert strategies for mastering the full Microsoft data stack. Learn how to connect, transform, and visualize data using Excel, Power BI, Power Query, and DAX. This is the show for analysts and professionals ready to save hours every week by building brilliant, automated reporting solutions.Sharad Anand
Episodes
  • Power Query Masterclass: The Complete Guide to Data Automation in Excel & Power BI

    Power Query Masterclass: The Complete Guide to Data Automation in Excel & Power BI
    Sep 29 2025

    This masterclass is your comprehensive, zero-to-hero guide to mastering Power Query within the Microsoft data stack.

    Host Sharad Anand breaks down the powerful automation engine that saves analysts hours every single week.

    In this lesson, you will learn the fundamentals and advanced techniques for automating your data analysis, including:

    • Connecting to Any Data Source: Setting up your initial Connectors to pull raw data into Power Query.

    • Deep Data Transformation: Starting with basic cleaning (copying, pasting, deleting) and moving to advanced techniques.

    • Automation via M-Language: Understanding and leveraging the powerful M-Code for building custom, non-repeating steps.

    • Advanced Techniques: Mastering complex tasks like Merging & Appending Queries and connecting to Web Data Sources.

    Whether you use Excel for reporting or Power BI for visualization, this episode is the critical foundation you need to stop cleaning data manually and finally embrace automation.


    #Powerquery #powerbi #excel #dataautomation #datacleaning #datatransformation #sharadanand
    Show More Show Less
    1 hr and 59 mins
No reviews yet
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.