22. The future of the finance skills
- The global finance data lakes, the basic needs of our Global Finance work
- Even before getting the news that MAPS is gone, there were overwhelming voices from the analyst community that the Hyperion Essbase data template is not supporting the more advanced visual tools of such as Tableau, and we want the true source of the MAPS data (you can think of it as a financial actuals data lake). Just recently Lessbase has been enabled using a backdoor, so that analyst could use the flat files directly, eliminating the excel formatting efforts, and directly feed into the Tableau expense reporting
- This skill of data queries is becoming more important, as the choice of the front end has really proliferated, tableau designs, web-based forms, python models and etc. Each may have a unique data feed requirement, btw they are usually very flat file looking. The understanding of the underlying data and data extraction skills are critical as we design the FP&A products for our business customers
- Now let's talk about some of the more advanced work of an LoB finance analyst
- CAP is an internal and analytical system, is something we want to learn today. It's another data lake concept which has account level financial information, first started in both card and auto, as finance was looking for our own insights of vintage quality and segment quality of account performances, we debated heavily for the lack of an eighth dimension, the channel from a long time ago, an decided that the channel split will be addressed by the DID set-ups. It's a data link without the Hyperion Essbase front end, so both business analysts and financial analysts use SQL and now snowflakes to retrieve somewhat raw data out of it
- Pennywise should be coming online very soon. This is an internal and analytical system sponsored by the bank business
- The powerday is pointing to the creation of the global assumptions lake with much more contents, system storage, version control, and more frequent update
- Finally, peer pressure may be building up. I want to share the experience that I recently had at the Andrew director + innovation update. The question is, do you think the managers need to learn the data skills, pulling data from the source system? Shane/Steve had all gotten training on python
No comments:
Post a Comment