Opening up Python to the business
When was the last time you were on a plane? Probably a while back, right? When you got on the plane, did you turn right and take a seat, or were you told to turn left, and to fly the plane yourself? Sounds like a really silly question! Most people flying on a plane are not trained to fly a plane. We entrust that role to a professional pilot.
The pilot in turn entrusts the building of an aircraft to a firm like Boeing or Airbus, who have thousands of trained engineers. Every single flight is standing on many thousands of man hours of development, engineering and training. What is clear is that every part of this chain are important. The pilots are important, as is the flight crew who supports them, as are all the engineers who built the aircraft.
Let's think about doing analysis of financial markets. The end consumers of this analysis, the business, are usually investors and trading. Python is a great tool for doing financial analysis. However, for the output to be usable by the end consumer we need to have ways of publishing it in a user friendly way, preferably using some element of visualisation (a picture says a thousand words!). We don't want to make our analysis only accessible to folks who are familiar with Python! Using the analogy from above, what technology is going to be our "pilot"? Here are a few options that we can try, to make our analysis more accessible to end users, ranging from creating PDFs to creating web dashboards. We go through some of the Python tools we can use with all these cases:
Creating PDFs with analysis
This is probably the most obvious way to publish results and everyone is familiar with using PDFs. The downside is that any results are "static" and hence not interactive. Users have to consume the results in the way they are published, and can't customise the output. In my tcapy FX TCA library....
To read the rest of the article on the Cuemacro website, please click here!
Thanks for sharing Saeed Amen!
Entrepreneur
3 年I agree with you. The classic usage of Excel -> BI -> Python steps in every time you need heavy calculations where Excel struggles to propose a robust/efficient response. We built the tool to actually bridge this gap via APIs. I would be curious to get your feedback about https://www.xlbroadcaster.io/ Happy to talk about it and get your feelings about it.
Python is great to perform analysis and I genuinely like Dash. But people are so used to run their businesses on Excel spreadsheets that, at the end of the day, the easiest way to integrate Python in their mind and daily processes is Xlwings...