Data Analytics & Viz Course
Data Analytics & Viz Course
In this course, students learn to develop desktop analytical tools, informational frameworks and visual interfaces for improving resource-usage and process effectiveness in support of these issues. They become acquainted with data acquisition, cleaning, filtering, structuring (in the form of optimization and simulation modeling) as well as prescription and practical conveyance. They become familiar with complex spreadsheet modeling, VBA coding, integration of Microsoft Power BI tools, the Palisades @RISK suite and application mobility. Students emerge with 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. On the left are a few examples of pitches, walk-throughs and live-presentations of tools developed (also see Student Project Gallery).
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. On the left are a few examples of pitches, walk-throughs and live-presentations of tools developed (also see Student Project Gallery).
Two reference texts are central to the discussions of interactive analytical and visual application development.
BLACKBELT RIBBON add-in
BLACKBELT RIBBON add-in
A host of data acquisition, visualization and analysis tools, packaged for simple access and use, see the Blackbelt Ribbon Add-in - A collaboration with my former students who are now Blackbelts themselves.
ExtraLite Version now available for user until May 2022
Full version with use cases and function directory, found in 3rd Edition Excel Basics to Blackbelt text (forthcoming May 2020).
BLACKBELT RIBBON add-in download:
ExtraLite Version now available for user until May 2022BLACKBELT RIBBON add-in download:
Full version with use cases and function directory, found in 3rd Edition Excel Basics to Blackbelt text (forthcoming May 2020).
Current Heat Mapper image-set library:http://www.experimental-instruments.com/HeatMapCatalog.pdf
Guide to the original 2013 Blackbelt Ribbon: http://www.experimental-instruments.com/BlackBelts/RibbonManual.pdf
Guide to the original 2013 Blackbelt Ribbon: http://www.experimental-instruments.com/BlackBelts/RibbonManual.pdf
Mobile App Projects
Mobile App Projects
These apps are designed for the support of classroom discussions of descriptive, predictive and prescriptive analytics. For support in the use of these apps, please contact Dr. Bendoly @ bendoly.2@osu.edu
MazeCrunch
MazeCrunch
TrendEst
TrendEst
Enterprise Applications
Enterprise Applications
Reference Guides
Reference Guides
Foundations of Data Analytics
'Standard Convention' Iconography of Data Visualization
Decision tree for Descriptive, Predictive, Predictive Analytics
Other Examples
Other Examples
