Skip to main content

K2's 2024 Accessing Your Company's Data with Power Query and Power BI

Saturday, July 27
 10:00am - 12:00pm

(Check-In )

Add to Calendar

Online

2.00 Credits

Member Price $79.00

Non-Member Price $109.00

Overview

Power Query and Power BI offer great opportunities for accessing your data and making it more useful in reporting scenarios. Learn how to benefit from these tools in this session.

Objectives

  • Outline Power Query's noteworthy features and functions and how you can use them for reporting projects
  • Demonstrate how to connect Power Query to web resources, spreadsheets, and databases to extract, transform, and load data into your reports
  • List the various methods to transform your data using Power Query before importing it into a report
  • Demonstrate connecting Power Query and Power BI to a sample data server

Highlights

  • Utilizing Power Query to access data from the web, spreadsheets, folders, and databases
  • Using Power Query to perform various transformations to clean up data before importing it to Power BI or Excel
  • Producing various reporting documents from data delivered from Power Query

Designed For

Financial professionals who want to save time, improve accuracy, and promote efficiency with their reporting projects

Prerequisites

Fundamental knowledge of Excel

Preparation

None

Notice

Your webinar can be accessed via https://ctcpas.acpen.com/Account/loginhttps://ctcpas.acpen.com/. If you do not have an ACPEN account, please sign up for an account using the email address you have on file with CTCPA.

Leader(s):

Leader Bios

Thomas Stephens Jr., Shareholder, K2 Enterprises, LLC

Tommy Stephens received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. In 1992, he earned a Master of Science degree (Major in Finance) from Georgia State University in Atlanta. Presently, Tommy is a Certified Public Accountant, a Certified Information Technology Professional, and a Chartered Global Management Accountant. During his professional career, Tommy has gained valuable experience in a variety of positions, including: • Working as an auditor and technology consultant for an Atlanta-based public accounting firm; • Leading an Internal Audit staff and managing a Cost Accounting team for a Fortune 500 company; • Serving as a Chief Financial Officer for an international engineering organization; and • Founding and managing his public accounting firm that provides accounting, tax, and consulting services to individuals and a variety of small and emerging businesses. In 1995, Tommy began authoring and presenting continuing professional education courses to accounting and finance professionals. In 2003, he affiliated with K2 Enterprises, and in 2007, he joined the firm as a partner. Over the past twenty-seven years, Tommy has presented over 2,800 educational sessions to over 71,000 participants throughout the United States and Canada. Tommy maintains professional memberships with the American Institute of Certified Public Accountants and the Georgia Society of Certified Public Accountants. Additionally, he is a past member of the Institute of Internal Auditors.

Return to Top

Non-Member Price $109.00

Member Price $79.00