30-days Money-Back Guarantee
Data modelling using get & transform for business intelligence and data analytics in Excel 2010 -2016 using Power Query
Updated on Sep, 2026
Office Productivity, Microsoft, Excel
Duration - 4.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
What is POWER QUERY (PQ)?
It's a FREE tool provided by Microsoft for Excel users.
Yes, you read it correctly. This tool is FREE !!!
And Power Query can make novice Excel user to PRO-Excel user very quickly, & this training will make your journey easy and memorable.
Power Query is available for ALL users of Excel 2010 / 2013 / 2016 and Power BI. In Excel 2016, it has been renamed as "Get & Transform".
These course topics can be applied to all versions of Power Query - Excel 2010 / 2013 / 2016 & Power BI.
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, Salesforce, Azure and many other sources of data.
You can perform and automate all the Extract > Transform > Load (ETL) tasks required to clean the data and make it usable for further analysis in Tableau, Power BI, Excel, Access, etc.
Check out the detailed breakdown of what’s inside the course
Abhay Gadiya is an experienced trainer with a strong passion for teaching and practical learning. He focuses on explaining concepts in a clear and simple way, helping learners build real-world skills and confidence through hands-on examples.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.