Power BI Global Summit - My 8 steps for Accounting & Finance
Originally published: 03/06/2023 02:10
Publication number: ELQ-95709-1
View all versions & Certificate
certified

Power BI Global Summit - My 8 steps for Accounting & Finance

8 Steps to Your First Finance and Accounting PowerBI Report. Use a star schema, and some dashboards and uncover the game-changing business intelligence tool,

Description
8 Steps to your first Finance and Accounting PowerBI Report


There could not be a bigger or more in-demand tool for finance and accounting professionals to learn today other than Power BI.

Excel will always be there to solve different problems, but PowerBI is fast gaining momentum across the accounting and finance community yet many are still slow to adopt it given it's more of an "advanced" tool for "developers".

Lance will debunk this barrier and show how in 8 easy steps almost any finance or accounting professional can develop a data model using multiple time dimensions (actual, budgets, forecasts) and deal with the financial constructs of profit and income statements.

What you will get from attending?

My personal secrets where I learnt Power BI to get me and my team started and how you can follow a similar path we all took (everyone's is slightly different).

- A highly structured approach to getting started for accounting and finance professionals but also others looking to enter into the Power BI world with a finance and accounting lens.

- Learning how to handle finance and accounting multi-time dimensions (actuals, budgets, forecasts) etc over the calendar and financial years contexts as well without having to write a single line of code or use any custom visuals.

- Access to dummy financial data with product and location dimensions across actuals, budget and forecast data.

- Downloadable and completed PowerBI report to explore

- Downloadable PDF report
 

This Best Practice includes
1. PDF slides 2. PBIX file 3. Images 4. Video recording of the session

Acquire business license for $299.00

Add to cart

Add to bookmarks

Discuss

Further information

Assist those in understanding the 8 Steps to build their first Finance and Accounting PowerBI Report. Included is the outline of the video along with the data and the completed PBIX file.
This is intended to assist in the overall high-level steps required to build and become familiar with Power BI.
All the transformation steps can be seen inside Power Query
All the measures used in the form of DAX can be seen within the underlying PBIX file
Most importantly the style and creation of the report and its interactive focus for accounting and finance across actual, budget and forecasting with accuracy.
Watch the video and become familiar with these steps, attempt them and then check yourself against the built solution

To enable accounting and finance professionals to get familiar with the process and possibilities of automating traditional reporting steps particularly when comparing actuals vs budget and forecast.

This has been built to connect to Xero as the underlying accounting system and whilst it is possible to use for other cloud or on premise accounting packages, there would be additional data transformation required which is not included in this.

If you are looking to use this pre-built report and assistance in integrating it to your accounting system, do not hesitate to call us or visit www.modelcitizn.com


0.0 / 5 (0 votes)

please wait...