background preloader


Facebook Twitter

PowerBI with MySQL: Challenges and Alternatives. Microsoft PowerBI integrates with MySQL out of the box.

PowerBI with MySQL: Challenges and Alternatives

However, loading data into PowerBI to create MySQL visualizations is not straightforward—especially if MySQL is running in the cloud. Learn how the PowerBI integration works, including a quick guide to setting up MySQL as a data source, and a few alternative options to visualize MySQL data quickly and easily. What is PowerBI? PowerBI is Microsoft’s popular Business Intelligence platform, available both on-premise (PowerBI Desktop) and on the cloud (PowerBI Online). PowerBI’s capabilities include direct access to multiple data sources, real-time data updates, easy analysis with natural language queries, and ability to share reports and dashboards across the organization. Strategic & Tactical Dashboards: Best Practices, Examples. Geocoding System The FFIEC Geocoding/Mapping System (System) helps financial institutions meet their legal requirement to report information on mortgage, business, and farm loan applications.

Geocoding refers to the Metropolitan Statistical Area/Metropolitan Division (MSA/MD), State, County, Census Tract combination (address information) that must be provided for each reported loan application and the System allows institutions to enter a street address to determine the corresponding geocode. The System also provides Census demographic information about a particular census tract, including income, population, and housing data.

Please select the appropriate activity year for the address being geocoded. Faraday — data-driven marketing platform. Business rules: Informal predicates. A foundation. Business rules, also referred to as informal predicates, are the total collection of restrictions on, and meaning of, the data in your database model.

Business rules: Informal predicates. A foundation

It is important to understand the difference between the conceptual and the logical database model. It is also extremely important to understand the difference between a data model and a database model. When you know the difference, you will be laughing at many points said at different forums on the Net ;-) It is quite simply unbelievable to notice how many so-called "professionals" are not able to see the clear difference. Please study, read, and understand, in order not to become one of them... WpDataTables Review: Create Responsive Tables and Charts. WpDataTables is a plugin for WordPress that allows you to create tables, charts and graphs for your posts and pages either by uploading a file or querying a database.

wpDataTables Review: Create Responsive Tables and Charts

The tables have the option to be responsive for use on a range of devices, and there are a number of charts to choose from for creating a graphical representation of your data. Zip Code Shapefiles - US DataMart. Our ZIP Code boundary definitions are refreshed quarterly with current US Postal Service definitions and reflect current US Postal ZIP Code definitions.

Zip Code Shapefiles - US DataMart

You can also download a free ZIP Code sample Shapefile package covering the Chicago, IL market. Download Free Sample Data HereZIP Code Boundaries for the Chicago, IL region: Our ZIP Code Shapefile datasets are ready to be integrated with your own GIS tools. The download link to our Shapefile data will be immediately sent to your email address as provided during checkout. PolicyViz. I’m pleased to announce that I’ll be holding a special, two-day data visualization workshop on November 6th and 7th here in Washington, DC.


Over the past year or so, I have taught a number of public data visualization workshops. The workshops provide participants with an overview of the field, an introduction to best practices and strategies, and… Last week, I wrote a post on Visually about the conceptual and design process behind The Graphic Continuum. In this post, I want to share some of the sources of inspiration for the project. I developed The Graphic Continuum with two goals in mind. ZIP Code Database - ZIP Code List. Share: Home Printable Maps Shipping Calculator ZIP Code Database ZIP Code Database Our ZIP Code Database can be downloaded in both Microsoft Excel and CSV formats and easily opened in most spreadsheet applications or imported into the database software of your choosing.

ZIP Code Database - ZIP Code List

The data comes from authoritative sources such as the United States Postal Service (2011), US Census Bureau (2010), the Internal Revenue Service (2008), and Yahoo. - Open Science Data Cloud. Human sequence data from populations around the world with the goal of cataloging human genetic variation.

- Open Science Data Cloud

Total Size: 396.7TB Last Modified: June 4, 2013, 3:30 p.m. Bookworm. blog. Free Web Scraper and structured Data Collection Tool. The Upshot - Politics, Policy, Economics and Everyday Life From The New York Times. Local Area Unemployment Statistics Home Page. Datawrapper. Database. Tutorial from: Transactions allow multiple users to work concurrently with the same data without compromising the integrity and correctness of the data Atomicity, consistency, isolation, and durability are together known as the ACID criteria.


In an online application, database transactions must have extremely short lifespans. A database transaction should span a single batch of database operations, interleaved with business logic. Databases implement the notion of a unit of work as a database transaction. Big Data Analytics. Why no one uses your government data » Ben Balter. Publishing government information is about much more than simply throwing 0’s and 1’s over the firewall.

Why no one uses your government data » Ben Balter

It’s about building ecosystems and communities. It’s about solving shared challenges. Ben Balter » GitHubber, Gov 2.0 Evangelist, Aspiring Attorney. Cytoscape: An Open Source Platform for Complex Network Analysis and Visualization. Energy Maps. Mercaris. Quarterly Food-at-Home Price Database. The Quarterly Food-at-Home Price Database (QFAHPD) provides food price data to support research on the economic determinants of food consumption, diet quality, and health outcomes. Catalog. The Socrata Open Data API (SODA) allows software developers to access data hosted in Socrata data sites programmatically. Developers can create applications that use the SODA APIs to visualize and “mash-up” Socrata datasets in new and exciting ways.

Create an iPhone application that visualizes government spending in your area, a web application that allows citizens to look up potential government benefits they'd overlooked, or a service that automatically emails you when new earmarks are added to bills that you wish to track. To start accessing this dataset programmatically, use the API endpoint provided below. For more information and examples on how to use the Socrata Open Data API, reference our Developer Documentation. API Access Endpoint: Column IDs: Type type Domain domain. Open Energy Data. About. Zip Codes for the USA at GeoCommons.

GoMashUp. The one stop shop for mashup. JSON, XML, RSS feeds. Crowdsourced Architectural Salvage. Visualization Options. List of United States Utility Companies and Aliases. PVWatts Calculator. Federal Government Challenges Post-Safety Datapalooza. At last month’s White House Safety Datapalooza, several federal agencies issued challenges to civic minded developers to help the federal government solve real world problems ranging from health care, public safety, education, and more. Many of the previous winners of these challenges have been civic startups who have leveraged open data released on to help find creative ways to solve problems. Sketchnotes at the Public Data Safetypalooa, courtesy @anadiazhernandz Here’s a list of each challenge along with data resources and some examples of apps that work to solve similar problems.

Try to win! Consumer Product Safety Commission Challenge Goal: To develop ways to put recall information in front of consumers. The Consumer Product Safety Commission is responsible for making sure products used in the US are safe. Federal Government Challenges Post-Safety Datapalooza. U.S. Open Data Institute. U.S. Open Data Institute.