Course ID: PBIMFR

Power BI: Monthly Financial Reporting – UK

About & Customize

Popular Options

  • In-Person
  • Live Webcast

• Identify how to produce revenue and opex reporting, profitability and customer analysis, and executive summaries that engage business partners and deliver massive value.

• Recall how to compare actuals to budget, forecast(s) and prior year and toggle reporting between Period, QTD and YTD views.

• Indicate how to integrate dynamic commentaries that instantly update as your time period selections change.

• Recognize how to upload your reports to the cloud for distribution around your business.

• Indicate how to connect to data and make transformations and edits that automatically reapply whenever the data is updated.

• Distinguish how to build a robust data model that leverages multiple fact and lookup tables.

• Identify how to create powerful Data Analysis Expressions (DAX) to produce a wide variety of financial measures.

• Recognize how to utilize a variety of best practices to keep your model organised, transparent and efficient.

Learning Context
• The course is based around a fictional wholesaler of gym equipment, Workout Warehouse. Data has been created to mimic monthly actual and forecast financial data to give a realistic experience to Accounting & Finance professionals.

• Challenges compliment practical work as participants utilise the reports they create to answer commercial questions on the business.

Import & Transform Data

• Utilise Power Query to connect to and make transformations to data.

• Produce a timeline table with a blank query.

• Add a new month of data to your model through a variety of methods.

Creating the Data Model

• Learn the theory behind relational data models, fact and lookup tables, and filter flow.

• Create a robust, comprehensive data model to underpin your reports.

Data Analysis Expressions (DAX)

• An introduction to the DAX formula language and a range of the most useful functions.

• Create calculated columns and measures to produce a wide-range of financial metrics.

• Improve your coding with variables and stay organised with useful best practice tips.

Creating Reporting & Visualisations

• Create revenue and opex reporting, profitability and customer analysis, and executive summaries that engage business partners and deliver massive value.

• Complete challenges for each of the six reports that require you to utilise the report to answer commercial questions.

Sharing Reports

• Introduction to Power BI Service – how to upload and share your reports with the wider business.

• Restrict confidential data by defining what reporting different users have access to.

Designed For
  • This course is aimed at Accounting & Finance professionals who want to make a significant improvement to their monthly financial reporting processes through investing in their own skills, and that of the team, in order to spend more time as an active business partner.
  • This course is just as relevant to someone with absolutely no experience of Power BI, who wants to learn from scratch, as it is to someone with prior experience who wants to learn new ideas and techniques.
Field of Study
Computer Software & Applications
Prerequisites
  • This is a Beginners course – no prior knowledge of Power BI is required.
  • Power BI Desktop application (this can be downloaded and installed from https://powerbi.microsoft.com/)
Course Producer
Business Learning Institute
CPE Credits
10
Level
Basic
Available Formats
In-Person, Live Webcast
Types
Seminars

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org