Finally, I am back to updating my beloved site.
For quite some time now, My team and I have been busy learning and integrating Python with our Inhouse BI tools. Mainly IBM Cognos Analytics(CA), Planning Analytics(PA), and Tableau..etc.
One of the main reasons, We have gone the Python route apart from it being uber-cool is to meet our ever-evolving business requirement.
When the budget is tight (i.e., no money to buy the shiny new software which makes our job more manageable). A little bit of Python magic usually saves the day.
Some of the areas where Python has helped are
- Performing Data Validation between the Source system, DataMart, and BI Reports for Financial Compliance and Auditing.
- Parsing the Log File to send alerts on Cube build failure and what caused the failure.
- Parsing the Log Files for finding who’s has logged in and how many times they are logging into Planning Analytics.
- Automating reports schedules and delivering the output to end-users( out of the box Cognos and Tableau scheduler did not work in this case, we needed something more flexible).
- Serving Performance metric Dashboards to a cloud server, so they can be displayed in monitors all over our organization ( i.e this is still in works).
- Analyzing and Visualizing Performance metrics.
- Too many to list and by now you get the idea.
And of course for doing some Data Science’ee stuff by building some Predictive models for predicting Plan and Forecast…more on that later.
While I feel like we have not even scratched the surface of what we can do with Python, the future looks promising!
So starting now, I will be sharing all the neat code ( IMO that is 🙂 ) which I find useful and which help us with day to day work and blogging them.
Drop me a note if you find it useful.
How Business Intelligence Works 