Managing Data for Finance with Power Query

4.8

(11 ratings)

·

4 Days

·

Cohort-based Course

Save time and minimize rework by effortlessly connecting, cleaning, and reshaping your data for use in Excel and Power BI.

Partial List of Current & Former Clients

BDO
Verizon
Cigna Healthcare
United Technologies
Cox Enterprises

Course overview

Importing data into Excel + Power BI is easy when you know how to transform it.

------------------------------------------------

NEXT COHORT DATES AND TIMES

------------------------------------------------


MAY COHORT:


Day 1 (5/6): 2pm - 5:30pm CST

Day 2 (5/8): 2pm - 5:30pm CST



------------------------------------------------


In this intensive 2 half-day Power Query program, attendees will embark on a step-by-step journey through data management.


We'll begin by introducing core concepts and a fundamental understanding of Power Query, a tool that enables seamless extraction and transformation of raw data from back-end systems to Excel or Power BI.


The first phase of the course emphasizes understanding the Power Query interface and learning how to connect various data sources, including databases, spreadsheets, and online services. Attendees will discover how to import data effectively, reducing the time spent on manual data entry.


The next phase focuses on data cleansing and manipulation. You'll learn how to filter, sort, and aggregate data. You'll discover the different ribbons designed for intuitive user-interface and how to apply these techniques to real-world financial application. This will include handling missing or erroneous data, which is often a challenging task in financial analysis.


The final phase delves into data modeling. Attendees will explore how to create custom calculations, both through a clear user-interface and by using Power Query's formula language, M.


These skills are essential for constructing sophisticated financial models and data models, providing the foundation for accurate forecasting and strategic planning.


By the end of the training, participants will not only master Power Query's functionality but also acquire a new perspective on data analysis. They'll be equipped with the skills to automate complex data preparation tasks, freeing them to focus on insightful analysis and decision-making.


This transformative experience is tailored to financial professionals who seek to enhance their efficiency and analytical abilities.


Whether you're a new financial analyst, s seasoned FP&A expert, or someone seeking to elevate data analysis capabilities, this course is a basic step towards a more data-driven and insightful future in your finance career.


Seidman Financial 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: www.NASBARegistry.org.


Seidman Financial is a division of Seidman Global LLC.


Country cost--of-living adjustments and PPP (purchasing power parity) options available.

Who is this course for

01

Financial analysts and FP&As seeking to automate data formatting, preparation, and importing to enhance forecasting, planning, and analysis.

02

Accounting professionals wanting to elevate routine presentations to automated financial reporting.

03

Small business owners who want to adopt basic data cleaning processes to get the information they need.

04

Controllers who want to streamline their financial processes and save time when they import their data into files and reports.

What you’ll get out of this course

More than just content and training. It's about real financial processes
  • Review month-end close, adjusting entries, and recurring financial analysis
  • Connect to various data sources and run queries to centralize disparate data channels.
Introduction to Power Query
  • Overview of Power Query and its role in data analysis for finance.
  • Understanding how Power Query integrates with Excel and other Microsoft tools.
  • Setting up Power Query and exploring the user interface.


Data Import and Connections
  • Connecting to various data sources like databases, Excel files, web data.
  • Importing and refreshing data from different sources.
  • Managing and transforming connections.
Process flows to connect to back-end data and bring it into recurring financial analysis and reporting
  • Import invoice data, accounts receivable aging, POs, and accounts payable to reconcile working capital
  • Import monthly sales data to analyze routinely
  • Import finance actuals for rolling forecasts.
Data Transformation Techniques
  • Cleaning and transforming data using Power Query Editor.
  • Utilizing functions and expressions to modify data.
  • Handling missing values, duplicates, and data types.
Advanced Query Techniques
  • Writing and customizing M and DAX queries.
  • Building parameterized queries and reusing queries across workbooks.
  • Developing complex calculations and aggregations.
Integration with Financial Analysis
  • Using Power Query to streamline financial forecasting and budgeting.
  • Designing financial models and KPI dashboards.
  • Analyzing trends and performing variance analysis.
Best Practices and Troubleshooting
  • Implementing best practices for performance optimization.
  • Troubleshooting common issues and errors.
  • Tips and tricks for efficient Power Query use in a financial context.

This course includes

2 interactive live sessions

Lifetime access to course materials

33 in-depth lessons

Direct access to instructor

Projects to apply learnings

Guided feedback & reflection

Private community of peers

Course certificate upon completion

Maven Satisfaction Guarantee

This course is backed by Maven’s guarantee. You can receive a full refund within 14 days after the course ends, provided you meet the completion criteria in our refund policy.

Course syllabus

Expand all modules

    4.8

    (11 ratings)

    What students are saying

    Meet your instructor

    Carl Seidman, CPA/CFF, CSP, CFE, CGMA, CIRA, AM, Certified Anaplan Model Builder

    Carl Seidman, CPA/CFF, CSP, CFE, CGMA, CIRA, AM, Certified Anaplan Model Builder

    Carl serves as a fractional CFO, FP&A advisor, and management consultant to entrepreneurial businesses throughout North America and Europe and assists them with strategic financial planning, value enhancement, and revitalization. 

     

    He's one of the preeminent trainers and facilitators in strategic finance and FP&A, with more than 13,000 participants attending his financial training programs, seminars, workshops, and masterminds. Notable clients include:


    ABM Industries, Accordion, AlixPartners, Allscripts, Broadridge, CHEP, Choice Hotels, CIBC, Cigna, Cox Enterprises, Crawford & Company, Deloitte, Dexcom, Discover Financial Services, Dominium, Express Scripts, EY, FS Investments, EVRAZ, Genentech, HCP, Inc., Heartland Financial, Hewlett Packard Enterprise, IGT, KPMG, Marsh & McClennan, Michelin, NerdWallet, Radisson, Rapid7, Sol Petroleum, Spotify, Triple-S, Telus, Santander, United Technologies, Universal Business Team, Verizon, and Walmart. 


    Carl is masterful at making the complex amazingly simple, engaging his audiences, building confidence, and facilitating a welcoming and transformative group experience. His content is rich and relatable, used in financial leadership development programs (FLDPs) at Fortune 500 companies, and is utilized or licensed by 6 of the top global financial training companies.


    Carl is a Certified Public Accountant (CPA) has earned other professional credentials including the CIRA, CFF, CFE, CGMA, AM (Accredited Member in Business Valuation), CSP (Certified Speaking Professional), Certified Anaplan Model Builder, and was a National Association of Certified Valuators and Analysts (NACVA) 40 Under Forty honoree. He holds a BA in finance and economics and an MS in managerial accounting.


    He's been where you want to be and does the work you want to do.

    What Other Attendees Have Said

            Everything was explained great and motivated me to incorporate power query to my every day job. Demos were explained thorough.
    Daniel Flores

    Daniel Flores

    Forensic Technology Services Manager at BDO USA, LLP
            Feel fully empowered to use Power Query. Made things simple. Everyone in group should take.
    John Thatcher

    John Thatcher

    Managing Director at BDO USA
            This was one of the better training classes: interesting subject matter, informative, and engaging. I enjoyed the class immensely, and would highly recommend it.
    James Mehlman

    James Mehlman

    Forensic Technology Services Senior Associate, BDO USA
            It was very engaging. Carl did a wonderful job presenting and making us feel heard with concerns.
    Dawn Harrison

    Dawn Harrison

    Forensic Technology Services Manager at BDO USA, LLP

    Learning is better with cohorts

    Learning is better with cohorts

    Active hands-on learning

    This course builds on live workshops and hands-on projects

    Interactive and project-based

    You’ll be interacting with other learners through breakout rooms and project teams

    Learn with a cohort of peers

    Join a community of like-minded people who want to learn and grow alongside you

    Frequently Asked Questions

    What happens if I can’t make a live session?
    I work full-time, what is the expected time commitment?
    What’s the refund policy?
    What is the difference between this Power Query program and all the other programs you offer?
    How will the classes work?
    What should I be expected to know coming into this course? How should I prepare in advance?
    Do you offer any guarantees for success, starting a business, or getting promoted.
    Does this course qualify for CPE (continuing professional education)?

    Students receive a certificate and 8.0 continuing professional education (CPE) credits for completing the course.

    Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA)
    Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA)
    A pattern of wavy dots
    Join an upcoming cohort

    Managing Data for Finance with Power Query

    Cohort 3

    $397 USD

    Dates

    May 6—9, 2024

    Payment Deadline

    May 5, 2024

    |

    Bulk purchases

    Explore Other Courses with Carl Seidman

    Explore Other Courses with Carl Seidman

    The Fractional CFO Power Skills Mastermind

    Dynamic Excel for Finance

    Advanced Financial and Business Modeling

    Cash Flow Forecasting and Modeling

    Managing Data for Finance with Power Query

    Financial Planning & Analysis (FP&A) Technical and Strategic Mastery - Driving Growth and Enhancing Value

    Delivering Financial Presentations with Executive Presence

    Forecasting and Valuing Major Capex Projects

    Coming soon

    Data Visualization and Power BI for Finance

    Coming soon

    What Attendees Have Said

    What Attendees Have Said
    A pattern of wavy dots
    Join an upcoming cohort

    Managing Data for Finance with Power Query

    Cohort 3

    $397 USD

    Dates

    May 6—9, 2024

    Payment Deadline

    May 5, 2024

    |

    Bulk purchases

    Want to stay connected? Receive resources, assets, and announcements about events and future course offerings.

    Submit your information and we'll be in touch.

    $397 USD

    4.8

    (11)

    ·

    4 Days