Data Management for Finance with Power Query

Carl Seidman

FP&A Advisor | Microsoft MVP in Excel

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

In this intensive 12-hour Power Query program, you will embark on a step-by-step journey through data management, automation, and positioning. These skills are essential for constructing sophisticated financial models and data models, providing the foundation for accurate forecasting and strategic planning.

You'll learn how to connect various data sources, import data effectively, and reduce time spent on manual data entry. You'll build mastery around data cleansing and manipulation, filtering, sorting, and aggregate data.

By the end, you'll have gone from beginner/intermediate to an advanced Power Query user. And you will acquire a new perspective on data analysis. You'll be equipped with the skills to automate complex data preparation tasks, freeing yourself 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, a seasoned FP&A expert, or someone seeking to elevate in data analysis, this course is a catapult towards a more data-driven and insightful future in your career.

Contact:

info@seidmanfinancial.com

What you’ll learn

⚒️ Save time and minimize rework by effortlessly connecting, cleaning, and reshaping data with a most powerful tool for Excel and Power BI.

  • Confidently manage and transform connections to recurring data sources in seconds with the click of a button.

  • Connect to multiple data sources, review month-end trial balances, and run queries to centralize data in the exact format you want.

  • Import monthly sales, invoice data, accounts receivable aging, POs, and accounts payable to reconcile working capital and rolling forecasts.

  • Clean and transform data using Power Query Editor, utilizing no-code or low-code functions and expressions for modifications.

  • Handle missing values, duplicates, errors and divergent data types with recurring applied steps and no-code machine learning.

  • Write basic, put powerful, custom commands with m-code and DAX formulas.

  • Use Power Query to streamline annual budgeting and dynamic rolling forecasts.

  • Design financial models and KPI dashboards that automatically update in seconds with Power Query import refreshes.

  • Analyze trends, sales forecast, and variance analysis easily with dynamic arrays and Power Query-drive dynamic data tables.

  • Implement best practices for performance optimization, building parameterized queries and reusing queries across workbooks.

  • Import monthly sales data, actualize financials, and troubleshoot common issues and errors.

  • Learn the techniques, tips, and tricks for efficient Power Query use in various financial contexts.

Learn directly from Carl

Carl Seidman

Carl Seidman

The person Fortune 500s use for their financial leadership development programs

Companies hiring Carl for Data Management for Finance learning & development:
BDO
Verizon
Cigna Healthcare
Rice University
Cox Enterprises
See all products from Seidman

Who this course is for

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

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

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

Prerequisites

  • A working computer with a webcam, microphone, and reliable internet connection

    This is a highly-interactive course, not a lecture. You will engage in live discussions and Q&A with other attendees and the facilitator.

  • General business knowledge and a basic understanding of finance and Excel

    We apply data management techniques to financial modeling, forecasting, and analysis. A basic understanding of finance and Excel is helpful.

What's included

12 months access

Go back to course content and recordings whenever you need to.

Office hours and instructor access

Periodic office hours to interact with the instructor and other peers with questions as well as direct access to the instructor for course-specific inquiries/explanations.

Maven Guarantee

Your purchase is backed by the Maven Guarantee.

Course syllabus

Part 1 - Data Management for Finance with Power Query

    Part 1 - Welcome to the Course

    2 items

Part 2 - Data Management for Finance with Power Query

    Part 2 - Introduction to the Business Case

    3 items

Free resource

Advanced FP&A: Financial Modeling with Dynamic Excel cover image

Advanced FP&A: Financial Modeling with Dynamic Excel

Build Extremely Flexible Self-Updating Models

Create adaptable models that update instantly as assumptions shift and as new data is added. Stop wasting time w/updates

Automate with Dynamic Arrays

Replace manual formulas with powerful functions that scale by themselves. Learn the power of SEQUENCE, DROP, and TAKE

Strengthen FP&A Insights for Your Business Partners

Translate complex data into trend analysis, visualize the output and provide clear, actionable analysis for leaders.

By continuing, you agree to Maven's Terms and Privacy Policy.

Testimonials

  • Everything was explained great and motivated me to incorporate power query to my every day job. Demos were explained thorough.
    Testimonial author image

    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.
    Testimonial author image

    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.
    Testimonial author image

    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.
    Testimonial author image

    Dawn Harrison

    Forensic Technology Services Manager at BDO USA, LLP

What Carl has to say about Managing Data for Finance, in his own words

Data Management for Finance LinkedIn Testimonial

Frequently asked questions

Students receive a certificate of completion and up to 12.0 CPE credits.

Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA)

What Attendees Have Said

Maven for Teams

Reimbursement

Get your company to pay

Everything L&D needs: email template, receipts, and certificate of completion.

Get reimbursed

Private cohort

Run a cohort for your org

A dedicated cohort with a custom schedule and curriculum, tailored to your team.

Book a private cohort

$349

USD

·Self-paced
Enroll