Book Image

Python Business Intelligence Cookbook

Book Image

Python Business Intelligence Cookbook

Overview of this book

The amount of data produced by businesses and devices is going nowhere but up. In this scenario, the major advantage of Python is that it's a general-purpose language and gives you a lot of flexibility in data structures. Python is an excellent tool for more specialized analysis tasks, and is powered with related libraries to process data streams, to visualize datasets, and to carry out scientific calculations. Using Python for business intelligence (BI) can help you solve tricky problems in one go. Rather than spending day after day scouring Internet forums for “how-to” information, here you’ll find more than 60 recipes that take you through the entire process of creating actionable intelligence from your raw data, no matter what shape or form it’s in. Within the first 30 minutes of opening this book, you’ll learn how to use the latest in Python and NoSQL databases to glean insights from data just waiting to be exploited. We’ll begin with a quick-fire introduction to Python for BI and show you what problems Python solves. From there, we move on to working with a predefined data set to extract data as per business requirements, using the Pandas library and MongoDB as our storage engine. Next, we will analyze data and perform transformations for BI with Python. Through this, you will gather insightful data that will help you make informed decisions for your business. The final part of the book will show you the most important task of BI—visualizing data by building stunning dashboards using Matplotlib, PyTables, and iPython Notebook.
Table of Contents (12 chapters)
Python Business Intelligence Cookbook
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Installing Robomongo


Robomongo is a GUI tool for managing MongoDB that runs on Mac OS X, Windows, and Linux. It allows you to create new databases and collections and to run queries. It gives you the full power of the MongoDB shell in a GUI application, and has features including multiple shells, multiple results, and autocompletion. And to top it all, it's free.

Getting ready

Open a web browser, and browse to http://robomongo.org/.

How to do it…

Mac OS X

The following steps explain how to install Robomongo on Mac OS X:

  1. Click on the Download for Mac OS X button.

  2. Click on the Mac OS X Installer (.dmg) link to download the file.

  3. Once downloaded, double-click on the installer file.

  4. Drag the Robomongo application to the Applications folder.

  5. Open the Applications folder, and double-click on Robomongo to start it up.

  6. In the MongoDB Connections window, create a new connection:

  7. Click on Save.

  8. Highlight your new connection and click on Connect.

  9. Assuming that you have MongoDB running, you should see the default system database.

Windows

The following steps explain how to install Robomongo on Windows:

  1. Click on the Download for Windows button.

  2. Click on the Windows Installer (.exe) link to download the file.

  3. Once downloaded, double-click on the installer file, and follow the install instructions, accepting all the defaults.

  4. Finally, run Robomongo.

  5. In the MongoDB Connections window, create a new connection:

  6. Click on Save.

  7. Highlight your new connection, and click on Connect.

  8. In the View menu, select Explorer to start browsing the existing MongoDB databases. As this is a brand new instance, you will only have the system collection.