Disclaimer

All of the topics discussed here in this blog comes from my real life encounters. They serve as references for future research. All of the data, contents and information presented in my entries have been altered and edited to protect the confidentiality and privacy of the clients.

Thursday, February 26, 2015

Learning python for BI

Hello All

What does Python have to do with BI report? Well maybe no much directly in enterprise environment, but python can be very useful for my garage project. I want to build a Data visualization product that shows real time update of certain market driven products and get users to subscribe to it for a monthly fee, that's what python can be handy for my ETL process.

Just to give an idea, I may choose to store my data in one of these open source DBs like Hadoop Hive, Cassandra or Mongo DB, and I can use python to pull data from whatever source that i want, for example zillow.com, if i want to analyze all of the real estate properties in America. For visualization, i can use Tableau to display the market trend and my analysis..

Now you may think that my idea sucks and there are so many real estate websites out there already. Well of course the idea sucks because this is not what I am really trying to explain you here, if i had a great idea, I wouldn't be letting it out until i secure my billion dollar patent first. Duh..

Anyways, Python can be a very powerful yet quite sample programming languages that supports various DB commends (of course, much more than just doing things with DB), so it's worth your time to look into it if you are a techy guy.

Get good at it and you can write your own ETL tool.

A good place to start if you have very little experience is here:
http://learnpythonthehardway.org/book/

Thanks

Until next time

4 comments:

human resources degree online said...

this is really nice post to read

professional resume writing service said...

good one. you mentioned some helpful tips.Thank you for posting this.

Venkat M said...

Very Useful Information
Best Informatica Online Training INDIA, USA, CANADA, AUSTRALIA...
Visit Best Informatica Online Training

punyavathi siva said...

Thank You for your great information on Obiee online training.
Obiee Training in UK Canada Singapore

Online Obiee Training in Hyderabad india

Related Posts Plugin for WordPress, Blogger...