Power Query Workshop

  • Power Query

  • What is Power Query?

    Power Query for Excel enhances self-service business intelligence (BI) for Excel with an intuitive and consistent experience for discovering, combining, and refining data across a wide variety of sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia.

    With Power Query 2.10 and above, you can share and manage queries as well as search data within your organization. Users in the enterprise can find and use these shared queries (if it is shared with them) to use the underlying data in the queries for their data analysis and reporting.

    More about Power Query        Course Outline

  • Some of the tricks you’ll learn

    • Consolidate multiple files (csv, txt or Excel files)

    • Get data from multiple sources and transform it as desired

    • Create an M function and invoke it

    • Debugging the M Code and how to understand it

  • Check some of our tricks on YouTube

Aimed towards

  • Excel Users

    Users that employ Excel on a daily basis and want to exploit the full power of the new Excel Business Intelligence tools to improve their reporting and data crunching capabilities.

    The potential participant has a good experience of Excel, some knowledge of relational database theory is recommended but not strictly required.

  • IT and BI People

    Professionals that are in charge of the data warehouse management of their company and need to understand how to provide support to analysts who need to extract data from different analytical and relational sources.

    Participants will learn how to adapt their existing data warehouse and other data sources so that the users will be able to find the data they need. They will also learn how to shape data correctly for the usage with the desired tool.

Formats of the Workshop

  • Online

    Attend one of our online seminars, workshops or recordings from anywhere around the globe with an internet connection.

  • Private

    If you are looking for something more tailored to your needs then a Private workshop, online or onsite, is the perfect choice for you.

  • OnSite

    Let’s bring the training to you! We can deliver all of our trainings anywhere in the American continent.

     

Versions of the workshop

Please visit http://powerquery.training/course/ for more information about the versions of the workshop

Need more information?

Why us? Contact Us