Berube Practical Reporting with Ruby and Rails

1. ed
ISBN: 978-1-4302-0532-6
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 312 Seiten

Business intelligence and real-time reporting mechanisms play a major role in any of today's forward-looking business plans. With many of these solutions being moved to the Web, the popular Rails framework and its underlying Ruby language are playing a major role alongside web services in building the reporting solutions of tomorrow. This book offers a comprehensive introduction to this popular framework. It shows you how the Ruby language and Rails framework can create truly compelling reporting services by plugging into popular third-party applications and services such as Google AdWords, UPS.com, iTunes, and SalesForce.com.

David Berube is a Ruby developer, trainer, author, and speaker. He's used both Ruby and Ruby on Rails for several years, starting in 2003 when he became a Ruby advocate after he wrote about the language for Dr Dobb's Journal. Prior to this, he worked professionally with PHP, Perl, C++, and Visual Basic. His professional accomplishments include creating the Ruby on Rails engine for CoolRuby.com, a site that tracks the latest Ruby developments, and working with ThoughtBot.com on the Rails engine that powers Sermo America's Top Doctor contest. Additionally, he has worked on several other Ruby projects, including the engine powering CyberKnowHow's BirdFluBreakingNews search engine, and he also created the Slueshi text adventure game system, a multiplayer text game engine written in Ruby. David's journalism has been in print in over 65 countries, in magazines such as Linux Magazine, Dr Dobb's Journal, and PHP International Magazine. He's also taught college courses and spoken publicly on topics such as 'MySQL and You' and 'Making Money with Open Source Software.' He lives in New Hampshire and his hobbies include basketball, yo-yos, and sleep.

Autoren/Hrsg.

Berube, David

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Author;10
4;About the Technical Reviewer;11
5;Acknowledgments;12
6;Introduction;13
7;Introducing Reporting with Ruby;14
7.1;Data Access Fundamentals;15
7.1.1;Choosing a Database;15
7.1.2;Using Active Record As a Database Access Library;17
7.1.3;Summary;29
7.2;Calculating Statistics with Active Record;30
7.2.1;Grouping and Aggregation;30
7.2.2;Analyzing Data with Grouping and Aggregates;33
7.2.3;Summary;42
7.3;Creating Graphs with Ruby;44
7.3.1;Choosing a Graphing Utility;44
7.3.2;Graphing Data;48
7.3.3;Summary;60
7.4;Creating Reports on the Desktop;61
7.4.1;Choosing a Desktop Format;61
7.4.2;Exporting Data to Spreadsheets;62
7.4.3;Creating GUIs with Ruby;70
7.4.4;Summary;83
7.5;Connecting Your Reports to the World;84
7.5.1;Choosing a Web Framework;84
7.5.2;Live Intranet Web Reporting with Rails;85
7.5.3;Graphical Reporting with Rails;100
7.5.4;Summary;116
8;Examples of Reporting with Ruby;118
8.1;Tracking Auctions with eBay;119
8.1.1;Using eBay APIs;119
8.1.2;Obtaining Competitive Intelligence via eBay Web Services;121
8.1.3;Summary;139
8.2;Tracking Expenditures with PayPal;140
8.2.1;Gathering Data from PayPal;140
8.2.2;Reporting PayPal Expenses;143
8.2.3;Summary;160
8.3;Creating Sales Performance Reports with SugarCRM;161
8.3.1;Installing SugarCRM;161
8.3.2;Sales Force Reporting;162
8.3.3;Summary;175
8.4;Investment Tracking with Fidelity;176
8.4.1;Writing a Small Server to Get Report Data;176
8.4.2;Tracking a Stock Portfolio;178
8.4.3;Summary;192
8.5;Calculating Costs by Analyzing Apache Web Logs;193
8.5.1;Speeding Up Insertions with ActiveRecord:: Extensions;194
8.5.2;Creating PDFs with PDF:: Writer;195
8.5.3;Cost- Per- Sale Reporting;196
8.5.4;Summary;216
8.6;Tracking the News with Google News;218
8.6.1;Using FeedTools to Parse RSS;219
8.6.2;Company News Coverage Reporting;220
8.6.3;Summary;235
8.7;Creating Reports with Ruby and Microsoft Office;236
8.7.1;Interacting with Microsoft Office;236
8.7.2;Importing Web- Form Data into an Access Database;239
8.7.3;Summary;263
8.8;Tracking Your Ads with Google AdWords;264
8.8.1;Obtaining Google AdWords Reports;265
8.8.2;Planning an AdWords Campaign;270
8.8.3;Summary;287
9;Index;288