Data warehouse in your future? @nosleeps

Over ten years ago, I worked in a large urban school district that needed to disaggregate data, mix and match it, combining student data with assessment info from vendors. That need has only increased for all school districts! And, it isn’t just about assessment data. It is also about creating file uploads, automating data uploads to vendors, blending of data results, web based interface to the sea of data to allow easy access to data that would normally be difficult to get to.

Unfortunately, there weren’t many vendors who could get the job done then. And, for a school district to build its own data warehouse was cost prohibitive! The cost of hiring a database administrator (DBA) is around $85k…

Here is a diagram that tries to capture what a data warehouse might look like…what am I missing? What should be added?

By the way, I made this graphic organizer using Idea Sketch on my iPad…I am pretty picky about graphic organizer apps and I was pleased at how easy it was to use. By paying $3.99 for an in app purchase, lot more features opened up! 

Some of my favorites:

  • Export image, PDF, svg formatted files to Dropbox and other places (not googleDrive yet)
  • Import text copied from other apps
  • Switch to outline view

Some features I wish were available:

  • Export to google drive
  • Easy edit of idea sketch title (I couldn’t figure it out!)
  • Share to twitter (Facebook share is already available)

Kudos to the developers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: