Until now, building Business Intelligence solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used. And updates have been tedious and error prone.

Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities.

Power Query is a tool that can be used for data discovery, reshaping the data and combining data ( Merge / Blend / Consolidate, etc.) coming from different sources. Power Query can connect directly to Excel, Access, Text, CSV, Hadoop, Sales Force, Azure and many other different sources of data.

Learning to use Power Query means less time spent manipulating data and more time analyzing it to gain powerful insights and make better decisions.

Power Query will save you hours of time gathering and preparing your data before loading it into your data model.

The British Academy for Training and Development offers this course to the following categories:

• Novice Excel user to advanced Excel users.
• People performing Data Analytics.
• Business Intelligence Specialists.
• Data Analysts / Financial Analysts.
• Excel users who want to learn advanced data modeling & business intelligence tools.
• Students looking for a comprehensive, engaging, and highly interactive approach to Excel training.
• Anyone looking to become an Excel Power user and supercharge their analytics skillset.
• Students looking to pursue a career in data analysis or business intelligence.
• IT specialists who performs Extract Transform & Load (ETL) activities for business.

After completing the program, participants will be able to master the following topics:

• Understand the features available in Power Query.
• Use Power Query tools.
• Connect Excel to multiple workbooks.
• Get data from the web and other sources.
• Prepares data accurately for reporting and analysis.
• Automates data updating, consolidating, cleaning, and shaping processes extensively.
• Connect to multiple data sources for easy refresh.
• Merge and append queries using Power Query.
• Use all of features introduced in Excel which will help in business processing, data analysis, financial reporting.
• Automate various task which would have taken long hours of work.
• Perform various complex data cleansing activities using Power Query.
• Master unique tips, tools and case studies.
• Learn how to use Power Query to absolutely revolutionize workflow in Excel.
• Build pro-quality business intelligence solutions to blend and analyze data from multiple sources.
• Create report dashboards using slicers, timelines and KPIs.

• Introduction to Power Query.
• Power Query essentials.
• The power of Power Query.
• Power Query data sources.
• Import data into Power Query.
• Load data and refresh query.
• Transforming data with Power Query.
• In built transformation in Power Query.
• Consolidate and append data.
• Merge queries/multiple joins in Power Query.
• Date and Time techniques.
• Allocating values to periods.
• Query optimization.
• Case studies.