ICAEW
  • Login
  • Event listing
  • How to Book
  • Contact Us
  • All Events
  • Virtual
  • In Person
  • On Demand
0
Basket

2023: Month-end in Power BI

Available

Virtual
All Locations
Data Analytics
Jan
1
Sun
-
Dec
31
Sun
09:30
-
PM
13:00GMT
Schedule Description: Increase the impact, efficiency and accuracy of your commercial month end reporting by learning how to build dynamic, real time close reports.
Description
Increase the impact, efficiency and accuracy of your commercial month end reporting by learning how to build dynamic, real time close reports in Microsoft Power BI
Please choose from the dates below to view more details.
2023 Month-end in Power BI
  • Overview
  • Agenda
  • Course level
  • Virtual classroom
  • Trainer
  • Price
  • Team training

Month-end in Power BI

Date and time

Location

Select a date in the drop-down menu above for details.

Select a date in the drop-down menu above for details.

Please note:

  • This course has 3-4 hours of self-led video on demand learning to complete before Day 1 and 1-2 hours before Day 2. Attendees will get the most from Day 1 and 2 by completing this self-led learning, but it is not compulsory in order to attend.
  • The entire course will be available on video on demand to attendees for 12 months.

Month-end performance reporting to business partners is a critical finance process, but in a world of increasing automation, for many it continues to be manual and repetitive. There are risks around data integrity and human error. Business partners are often left wanting more in terms of deeper understanding and action-orientated information. Follow up data requests add further burden to finance and are often ineffective in solving issues.

Month end reporting of the future will be fast and reliable, agile with easily implementable changes and high-quality data. Analysis will be quick to produce and evolve with business requirements. Most importantly, business partners will take actionable insights from the information, self-serving on detail and reducing data requests on finance teams by up to 80%.

This course will take finance professionals involved in the close process from zero to being able to produce a month end commercial reporting pack in Power BI. An upfront investment of time, learning and creating month end reporting in Power BI will save time in perpetuity by automating manual processes, reducing errors and removing unnecessary elements of business partnering.

Learning outcomes:

  • Produce revenue and opex reporting, profitability and customer analysis, dynamic commentaries and executive summaries that allow business partners to be increasingly effective
  • Prepare information for business partners which supports decisions on a course of action
  • Apply new ways of working with finance teams
  • Choose processes which save time, increase value and add output
  • Compare actuals to prior periods, budget and forecast within a model

Who should attend?

This course is aimed at anyone below top level senior positions (e.g. Analyst / Manager) who want to make significant improvement to their month end processes through investing in their own skills, and that of the team, in order to spend more time as an active business partner.

Attendees will need to be comfortable with excel and have had good experience of a month end process, so they can think through how the steps and benefits can apply to their unique issues.

Technical notes: Individual Power BI licenses are free to download and use to build reporting but sharing reporting with business partners will require a paid license as part of Microsoft 365 subscription. Power BI and Zoom are CPU/memory intensive. Power BI may be sluggish during the virtual parts of the course on older machines. Building reporting live is not compulsory, many attendees just watch and listen. Copies of the model at each stage of its build are provided for use in any exercises during Day 1 and 2.

Course enquiries?

Contact: Events information team

  • Webchat
  • Email
  • Telephone

 

FAQs

Should you experience any difficulties booking onto the event, please click here.

 

More from ICAEW Academy

  Search over 100 CPD virtual classrooms from a wide range of topics to advance your career.
  Partner with our team of experts to deliver bespoke in-house training to your team and organisation.
  View our in-depth leadership programmes and see how you can fulfill your career ambitions - whatever your career stage.
  Browse our specialist qualifications and programmes to enhance your knowledge and career opportunities.

 

The course will cover the core elements required to build commercial month end reporting, and each step focuses on the month end issue to be solved:

 

  • What is Power BI? Full context of what Power BI is, and how/when it can be used
  • Working with effective data: Connecting and transforming raw data from current source
  • Building useful analysis: Building a simple data model to give flexibility to reporting
  • Commercial KPIs: Creating calculations with Power BI to increase the usefulness of outputs
  • Bringing numbers to life: The types of charts and visuals that make a great month end
  • Influencing decisions: Utilising the month end report for analysis and with business partners
  • Month end options: exploring uses for different types of teams
  • Practical application: Exercises at each stage to become comfortable with Power BI and how to create month end reports

This course is for:

Capability Framework

What is a virtual classroom?

A virtual classroom provides the same great learning experience as other ICAEW training, except one difference, you can learn from your desk.

Being delivered online makes it so much easier to access in a busy working week and would definitively recommend this type of training. The breakout rooms work really well to allow you to get to know the other participants and share experiences.

Virtual classroom delegate

The focus is on the learner and creating an enriching classroom experience that connects participants globally. Using video, learners can converse and interact with the trainer and other learners in real-time. Whiteboards, break-out sessions, polls, screen-sharing, and interactive Q&A create an immersive learning experience.

I think the virtual training format using Zoom, and the survey features, and break out rooms, really works great. I had no problems engaging with the facilitator and felt he listened to what we said, and kept the pace of the content moving steadily.

Virtual classroom delegate

Secure your place now and keep your skills and knowledge up-to-date.

How do I attend a virtual classroom?

Once you've booked your session, you will receive an email with your booking confirmation. The steps you will need to follow to attend your virtual classroom will arrive in a separate email closer to the date of your course.

Oliver Deacon FCA

"Great to hear from someone with several years' practical experience rather than standard 'common sense' stuff."

Delegate feedback

Oliver is a former Finance Director at Microsoft, an ICAEW member and a PCC Executive Coach through the ICF. He brings a refreshing and inspiring perspective to modern finance. His last team at Microsoft cut 2 days from their month end reporting work by using Power BI. He relocated back to the UK from Seattle in September 2019.

Dan Stockdale

Dan is a financial modeller and online course creator, producing content aimed at accounting & finance professionals, analysts and consultants. He is a CIMA member who has worked as a strategy modelling consultant and internal trainer at PwC, and has extensive industry experience engaging with CFOs and Strategy, both in London and Sydney. His aim is to create remote learning that is challenging, realistic, fun and high quality.

 

 

Rate Price
ICAEW Member £999 + VAT
Non-Member £1,350 + VAT

 

Our public course programme is deliberately structured to encourage delegates from different organisations to participate. However, if you have six or more delegates who require development in the same area, we are able to run a more cost-effective and much wider range of courses tailored specifically to your organisation.

Organisations will have the choice to run our in-house courses online or in-person. 

These are ideal for organisations seeking hassle-free, flexible and cost-effective training delivered to multiple delegates at your location of choice. Whether we use our existing materials or develop new content for your business, our expertise lies in translating your requirements into a pragmatic, interactive training programme highly relevant to your people and organisation.

To discuss in-house training for your business please email academy@icaew.com or contact us through our enquiry form

 

 

Basket
Item(s) £0.00
Grand Total £0.00

Contact us

  • Helplines and support
  • How to make a complaint
  • International offices
  • UK offices

Events

  • All events
  • Continuing professional development (CPD) courses

Information services

  • Library
  • Guide to services
  • Company research
  • Historical resources
  • Library collection
  • Library search

Legal

  • ICAEW policies
  • Cookies
  • Privacy policy
  • Reproducing ICAEW content
  • Copyright notice and disclaimer
  • Data protection policy
  • ICAEW website links policy
  • +44 (0)1908 248 250
© ICAEW 2017

This screen shows you the details for the selected product.

Click the "Add to Cart" button to add this product to your shopping cart. You can enter a quantity larger then 1 to add multiples of this product to your shopping cart.

If the product is full you will see a "Wait List" button. Click this button if you would like to be notified if/when capacity is added. If capacity is increased we will email you.  Upon receipt of the increased capacity notification, registration will be on a first-come, first-served basis.

If the product is not ready for purchase you will see a "Notify Me" button. You can click this button if you would like to be notified when this product is ready for purchase.

Some products can only be purchased through our partner. In this case you will see an "External Register" button. Click this button to purchase through our partner's website.

Powered by Configio