MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

Surgent's Clean, Transform, and Load Data in Power BI

 Currently available
 
2.0
26 / S-60364
Registration is Open
Member Price
$109.00 Regular Registration
Your Price
$114.00 Regular Registration
Designed For:

Accounting professionals, financial analysts, and anyone who regularly works with data and seeks to improve their skills in data management and analysis using Power Query

Prerequisite:

None

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel, and Power BI Desktop, known for its robust data processing capabilities. This course is designed to take participants from the basics of Power Query to exploring its more sophisticated features. It is an ideal blend of theoretical knowledge and practical application, centered around diverse data scenarios encountered in multiple industries. The aim is to ensure that the skills and techniques learned are universally applicable and beneficial in any professional context. Structured to be participant-focused, the course encourages active learning through a series of practical exercises, live demonstrations, and illustrative case studies. This approach not only deepens the understanding of Power Query's features but also demonstrates how to turn complex data sets into actionable insights. While the course is broad in its application, it remains detailed in its instruction, catering to both the novice and the seasoned professional. It is particularly beneficial for those who regularly interact with data, such as business analysts, project managers, and financial professionals, providing them with the tools to streamline data processes and enhance data analysis capabilities. Additionally, the course underscores best practices in data management. Participants will learn strategic approaches to data challenges, ensuring that their data processes are efficient, scalable, and sustainable. This course is not just about mastering a tool; it's about empowering professionals with the skills to transform data into a strategic business resource. By the end of the course, participants will be equipped to leverage Power Query in Excel or Power BI Desktop to its full potential, turning data into a powerful driver for business success and innovation.

Delivery Method: On-Demand Webcast
CPE Credit: Computer software & applications
Program Level: Basic

This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.

Objectives

  • Identify the key features and functionalities of Microsoft Power Query
  • Distinguish between different data transformation techniques in Power Query, including data cleaning, merging, and pivoting
  • Indicate the best practices for documenting each step in your data transformation process

Advanced Preparation

Download the handout and practice material prior to the course

Vendor

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.