Webcast: Accessing Your Company's Data With Power Query and Power BI
154 | Webcast | Intermediate | Scheduled
Description
Power Query and Power BI are genuinely incredible tools to revolutionize your workflow. They offer the promise of "write once, refresh many" reporting, where your reports can instantly update by clicking a button. While incredible tools, these features require additional training and experience to master. This course series will review the different methods of connecting to your data and have multiple hands-on activities to help you master these incredible tools. After completing this session, you will know how to turn your organization's data into repeatable, refreshable PivotTables, Power BI dashboards and more!
Credits
| Number of Credits | Type of Credits |
|---|---|
| 2.00 | Computer Software & Applications |
Designed For
Financial professionals who want to save time, improve accuracy and promote efficiency with their reporting projects
Prerequisites
Fundamental knowledge of Excel
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
Objectives
Upon completing this course, you should be able to:
- 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
Prices
- Member (Early Bird)
- $89.00
- Non-Member (Early Bird)
- $129.00
- Member
- $89.00
- Non-Member
- $129.00
Instructors
Thomas G. Stephens, CPA, CITP, CGMA
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.
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.
Back to Instructors