Operational Financials in Microsoft Power BI Part 1

Academy Membership

This is for individual Membership: When you are registering for yourself. if you want to register for a group or team, check out the team membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial

Academy Membership - for Teams

This is for team Membership: When you have a group of team members registering. if you want to register for one person, check out the individual membership. Worth more than $10K! 48-hours free trial

  • Access to all video courses.
  • 200+ hours of video courses.
  • Instructed by RADACAD Coaches
  • Get certification for completed courses.
  • Member-only discount on upcoming in-person training sessions.
  • Yearly and Monthly plans. You can cancel anytime.

From: $49.00 / month with a 2-day free trial per member

Operational Financials in Microsoft Power BI Part 1

In this course, together we will build a new way to see and review Financial Statements, which we will call “Operational Financials.”  Operational Financials are not meant to replace Traditional Financials.

Length: 6 Hours

$259.00
Or log in to access your purchased courses

In this course, together we will build a new way to see and review Financial Statements, which we will call “Operational Financials.”  Operational Financials are not meant to replace Traditional Financials.  To define the difference, and why this course is important, I will quickly define both. 

Traditional Financial Statements are critical to review the financial performance of a company.  Government Agencies, Accountants, Investors, Banks, etc. require these formats to review and audit not only for/on financial performance but business activities as well.  Simply put, they show businesses how they did, in the past. 

Although Operational Financials, like Traditional Financials Statements, show how you did in the past, Operational Financials use both historical and current information to show you how you are doing now, present.  With Power BI we can add some Artificial Intelligence (AI) to help us predict how we will do, based on our past and current performance. 

Extending our reports to look at not only hindsight, including both insight and foresight would be reason enough on its own to entice every business to incorporate Operational Financials.  However, there is another and perhaps even more powerful reason to use these operational reports.  That reason is the ability for your team to understand the story your financial data tells without having to learn how to “read” financial statements.  Not only are these reports easier to digest information, but they also provide for incredible drilldown to detail.  This allows anyone with the need and security the ability to make informed business decisions, instead of guesses on hunches. 

In this course you will build 2 versions of the same report.  One version will be built using a non-calendar Fiscal Year and the other with a Calendar Year.  One will have beginning year balances and the other will create beginning balances from historical numbers.  The purpose of creating 2 reports is to allow users to experience data modeling and report designing as close to their environments as possible.  Each report will vary to continue the learning process rather than just repeating steps. 

In this course we’ll be covering data  modeling in the Query Editor, Query Relationships, DAX functions (columns, measures and tables), Time Intelligence functions, Drill-down reports, Bookmarks, Root Cause Analysis, Insights, Q&A options, syncing slicers and custom visuals.  

The final goal is that you can create your own Operational Statements that help everyone in your business make informed decisions, while improving your life and the success of your company. 

Modules

Module 2: Foundation Data Modeling in Power Query

Lessons

Module 3: Fact vs Dimensional Modeling in Power Query

Lessons