Categories
podcast

Test Posting One

Wide Mouth Frog

That would be a file.

 

Categories
Data Warehouse

Design Tip #169 New Directions for ETL

This Design Tip reflects on the remarkable durability of the basic Extract-Transform-Load paradigm, while at the same time recognizing some profound changes that must be addressed. These changes are due to new data demands, new classes of users, and new technology opportunities.

via Design Tip #169 New Directions for ETL | Kimball Group.

Categories
Practice

This is why you never end up hiring good developers

You are bad at giving technical interviews. Yes, you. You’re looking for the wrong skills, hiring the wrong people, and actively screwing yourself and your company.

via This is why you never end up hiring good developers – Quartz.

This doesn’t just apply to developers, it should apply to anyone working in a “must know how to think and ask questions” position.

Categories
Uncategorized

Placeholders in Form Fields Are Harmful

Summary: Placeholder text within a form field makes it difficult for people to remember what information belongs in a field, and to check for and fix errors. It also poses additional burdens for users with visual and cognitive impairments.

via Placeholders in Form Fields Are Harmful.

I do so dislike placeholder as label. Begone!

Categories
Practice

Writing Hyperlinks: Salient, Descriptive, Start with Keyword

To help users quickly find what they need, anchor text should stand out from the body content and accurately describe the page that it refers to.

via Writing Hyperlinks: Salient, Descriptive, Start with Keyword.

Categories
Data Warehouse

Have You Built Your Audit Dimension Yet?

One of the most effective tools for managing data quality and data governance, as well as giving business users confidence in the data warehouse results, is the audit dimension. We often attach an audit dimension to every fact table so that business users can choose to illuminate the provenance and confidence in their queries and reports. Simply put, the audit dimension elevates metadata to the status of ordinary data and makes this metadata available at the top level of any BI tool user interface.

via Design Tip #164 Have You Built Your Audit Dimension Yet? – Kimball Group.

Categories
Practice

Software in 2014

We’re at an in­flec­tion point in the prac­tice of con­struct­ing soft­ware. Our tools are good, our server de­vel­op­ers are happy, but when it comes to build­ing client-side soft­ware, we re­ally don’t know where we’re going or how to get there.

via ongoing by Tim Bray · Software in 2014.

Categories
Uncategorized

BayesDB

INFER salary FROM mytable WHERE age > 30;

Fill in missing data with the INFER command. Unlike a traditional regression model, where you need to separately train a supervised model for each column you’re interested in predicting, INFER statements are flexible and work with any set of columns to predict.

via BayesDB.

Categories
General

New MIT Media Lab Tool Lets Anyone Visualize Unwieldy Government Data

DATAVIVA, A PROJECT DEVELOPED IN PART BY MEDIA LAB PROFESSOR CÉSAR HIDALGO, AIMS TO MAKE A WIDE SWATH OF GOVERNMENT ECONOMIC DATA USABLE WITH A SERIES OF VISUALIZATION APPS.

via New MIT Media Lab Tool Lets Anyone Visualize Unwieldy Government Data | Co.Design | business + design.

Categories
Data Warehouse

Dimensional Modeling Techniques – Kimball Group

Ralph Kimball introduced the data warehouse/business intelligence industry to dimensional modeling in 1996 with his seminal book, The Data Warehouse Toolkit.  Since then, the Kimball Group has extended the portfolio of best practices.Drawn from The Data Warehouse Toolkit, Third Edition, the “official” Kimball dimensional modeling techniques are described on the following links and attached .pdf:

via Dimensional Modeling Techniques – Kimball Group.