I have a decent understand of Drupal and how to administer it, but I am not very good with anything custom so I am looking for a module or a set of modules to help me.

I have a external database that I would like to connect to. (Already have a DSN configured.) How to I:
1. Connect Drupal to that external database?
2. Create some charts with that data?
3. Display those Charts and Data in a dashboard?

I would assume I would need to create a widget in the dashboard module, but as for the rest I am not sure.

Thank you for any help or guidance you can provide.