How can modern data management approaches and technology be used to empower workers, raise awareness and ensure that decisions align with both the strategic objectives and obligations of organizations?  

In this course, students will learn to develop Excel-based analytical tools, informational frameworks and visual interfaces for improving resource-usage and process effectiveness in support of these issues.  They will become acquainted with data acquisition, cleaning, filtering, structuring (in the form of optimization and simulation modeling) as well as prescription and practical conveyance. In doing so, students will gain the technical skills and integrated multi-application competency needed to lead cutting edge analytical projects.
The key deliverable of the DAV course is a group-developed stand-alone application catered to the on-going decision support needs of an organization (public or private) or section of the population. 

These take on a range of forms, pulling in the capabilities of multiple tools with design for use in mind.  Below are a few examples of pitches, walk-throughs and live-presentations of tools developed (also see 

Foundational Framework of Data Analytics


 For a more complete set of video examples see the side-bar options, where you will also find links to the text book, associated add-ins, 3rd party software information and access to a 25,000+ strong LinkedIn group of professionals working in this area.  

Try the Blackbelt Ribbon Add-in (beta) - A collaboration with my former students:

Using PowerMap to Visualize Growth in Demand and a Supply Chain

YouTube Video

Try my Pleuroku game on Excel (a mix of Minesweeper and Sudoku), built a few years back:

'Standard Convention' Iconography of Data Visualization Attributes

Subpages (1): Gallery