(1 of 3) Excel Power Query & Dashboards: Import and Refine Your Data Fast

Event Description:

Excel’s dashboarding capabilities empower users to transform raw data into meaningful insights. Suitable for business reporting, financial analysis, or project management, Excel dashboards offer a user-friendly and visually impactful means to analyze, interpret, and communicate data effectively.

Building a dashboard requires data that can be sourced from various locations such as databases, CSV files, and web pages. Often, this raw data isn’t immediately suitable for use, necessitating cleaning, merging, and combining processes.

Do you often find yourself saying, “It’s taking too long” when referring to the time spent formatting your data for reports?

Are you regularly tasked with repetitive and time-consuming data cleaning and transformation activities? These might include removing unnecessary rows and columns, filtering out irrelevant data, converting text to numbers or dates, splitting or merging columns, removing unexpected characters, or combining files together.

Would you appreciate a solution that can perform all of these tasks with the click of a button? If your answer is yes, then Power Query (also known as Get and Transform in Excel 2016 and later) is what you need.

Learning Objectives:

  • Import data into Excel from sources such as text files, web pages and databases
  • Keep the imported data in sync with the source data using just two clicks
  • The Power Query Editor – the key to data cleaning and transformation
  • Save a ton of time – automate the cleaning and transformation process

Webinar Documentation:

PMI PDUs:  0 Ways of Working, 0 Power Skills,  1 Business Acumen

Written by TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Share This Post
Have your say!

Leave a Reply