22 free tools for data visualization and analysis Review April 20, 2011 06:00 AM ET Computerworld - You may not think you've got much in common with an investigative journalist or an academic medical researcher. Want to see all the tools at once? For quick reference, check out our chart listing all the tools profiled here. There are many tools around to help turn data into graphics, but they can carry hefty price tags. Related Blog Here's a rundown of some of the better-known options, many of which were demonstrated at the Computer-Assisted Reporting (CAR) conference last month. Data cleaning Before you can analyze and visualize data, it often needs to be "cleaned." DataWrangler What it does: This Web-based service from Stanford University's Visualization Group is designed for cleaning and rearranging data so it's in a form that other tools such as a spreadsheet app can use. Click on a row or column, and DataWrangler will suggest changes. What's cool: Text editing is especially easy. Skill level: Advanced beginner. Runs on: Any Web browser.
Reinventing business research | timetric.com wfb2sql MySQL Database Articles & Tutorials - Database Journal In the Importing XML Data into MySQL Tables Using a Stored Procedure article, Rob Gravelle outlined some ways to work around MySQL's restrictions on stored procedures to import XML data into your MySQL database tables. Today's article covers how to use a Prepared Statement, including error handling and validation, as well as handling additional XML formats. In theory, it would seem that a stored procedure would be the perfect vehicle for importing XML data from a file, and yet, the LOAD XML INFILE statement cannot be run within a Stored Procedure. Ever since Oracle became the owner of MySQL when it acquired Sun Microsystems in 2010, improvements to the software haven’t been as forthcoming as one might hope. There are a lot of occasions for converting one data type to another in MySQL. Over time, applying the same rounding algorithm to many numbers can lead to a condition known as rounding bias. Robert Gravelle explores the use of cursors and their role in stored procedure programming.
Fusion Tables (Beta) Bust your data out of its silo! Get more from data with Fusion Tables. Fusion Tables is an experimental data visualization web application to gather, visualize, and share data tables. Visualize bigger table data online Filter and summarize across hundreds of thousands of rows. Two tables are better than one! Merge two or three tables to generate a single visualization that includes both sets of data. Make a map in minutes Host data online - and stay in control Viewers located anywhere can produce charts or maps from it. Visualize bigger table data online Import your own data Upload data tables from spreadsheets or CSV files, even KML. Visualize it instantly See the data on a map or as a chart immediately. Publish your visualization on other web properties Now that you've got that nice map or chart of your data, you can embed it in a web page or blog post. See how journalists and nonprofits around the world use Fusion Tables Two tables are better than one! Make a map in minutes Share that map!
FlowingData | Data Visualization, Infographics, and Statistics iOS 5 iPad Database Implementation using SQLite From Techotopia Whilst the preceding chapters of this book have looked at data storage within the context of iOS 5 iPad based applications, this coverage has been limited to using basic file and directory handling and object archiving. In many instances, by far the most effective data storage and retrieval strategy requires the use of some form of database management system. In order to address this need, the iOS 5 SDK includes everything necessary to integrate SQLite based databases into iPad applications. The goal of this chapter, therefore, is to provide an overview of how to use SQLite to perform basic database operations within your iPad application. Once the basics have been covered, the next chapter (entitled An Example SQLite based iOS 5 iPad Application) will work through the creation of an actual application that uses a SQLite database to store and retrieve data. [edit] What is SQLite? SQLite is an embedded, relational database management system (RDBMS). sqlite3 . sqlite> .exit
d3.js