Effective Finance Reconciliations With Power BI

Рет қаралды 11,356

Күн бұрын

Reconciliations are an important Finance control ensuring the completeness and accuracy of our Finance data. In this video we discuss the attributes of an effective reconciliation control and how Power BI can help us to achieve this. We work through a basic example comparing two datasets using a star schema structure and show how this enables us to drill down and identify differences. Finally we look at a more detailed example based on a Written Premium reconciliation for an insurance company. We review an example Power BI report that an company may use to perform their reconciliation.
Sections:
0:00 - Intro
2:49 - Simple comparison of two data sets
14:10 - Demo Written Premium Reconciliation
32:55 - Wrap up
Finance Re specialize in helping Finance teams improve their reporting and controls. Please see our website www.finance-re.com for more details. We would be happy to discuss your Finance process challenges and explain how we can help.

Пікірлер: 21

@colacoja Жыл бұрын

This tutorial is good, and practical. and valuable Please keep going. Thanks

@datatodividends Жыл бұрын

Thank you James. Really appreciate the feedback and yes, I've a couple of ideas for more videos.

@syedaneesdurez7197 Ай бұрын

Very useful video.. Gives more confidence how Power BI works so efficiently if we starts working on it.

@garrybye4415 Жыл бұрын

Really nice clean design - some of the clearest I’ve seen

@datatodividends Жыл бұрын

Thanks very much for your comment Garry.

@red2fourty650 Жыл бұрын

Great and simple way of teaching this subject… Luis from Mexico City. Great work and will be looking into more of your videos, thanks

@datatodividends Жыл бұрын

Thank you Luis.

@tienta4424 9 ай бұрын

I love your video. Can you share your dataset for practicing more? Once again I really appreciate your sharing.

@AnilKumar-vi8oe Жыл бұрын

Great work, kindly continue to bring these frequently.. Looking forward to see more

@datatodividends Жыл бұрын

Thanks for your encouraging comment Anil. I'm planning more videos, hopefully future videos won't need as many takes as it took me to complete this one!

@roberttyler2861 Жыл бұрын

nice video. Subscribed.

@datatodividends Жыл бұрын

Thanks for commenting and subscribing Robert.

@MahdFamilyChannelHeaven Жыл бұрын

This was what i am looking for from a long time. Still need to learn how you dashboard in bi services

@datatodividends Жыл бұрын

Thank you for your comment. Pleased that the video was helpful to you. If you are looking for some training to get started I highly recommend the free introductory courses from SQLBI www.sqlbi.com/training/

@tonye_jimgeorge Ай бұрын

Where can I get the dataset? Please can you make it available

@leonardocastro164 Жыл бұрын

The video was great, is there any chance you could share the PBX?

@datatodividends Жыл бұрын

Hi Leonardo, thank you, so pleased you enjoyed the video. I presume you mean the PBIX for the final demo of the reconciliation report? I'm not able to share that unfortunately. I do intend to do some more videos explaining some of the techniques used in that report - for example how to read the reconciling items from Excel (using Power Automate) which is not widely covered online. If there are other aspects of the report you would like me to cover then please do ask.

@dannybaeza6098 Жыл бұрын

Really nice clean design - could you do a tutorial of design? 🙏🏽 new suscriber

@datatodividends Жыл бұрын

Thanks for your comment Danny and for subscribing. A few people have asked me to do some design based videos - I've tended away from that as there are already several amazing people producing a lot of Power BI design content. There seems to be a demand for it though, I'll have to think how to structure it to make a good / useful video. Thanks for your input.