This video guides you on creating an AdWords dashboard. You can use the same logic for most of the supported data sources.