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.
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
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.