Category Archives: Analytics

Forecasting

Materials from my presentation Forecasting are now available: PDF

From the University of Michigan Business Intelligence Community of Experts site:

Forecasting

Presenter

Jeff Horon
Business Analyst
Medical School Grant Review & Analysis Office

Summary

Forecasting can enable better data-driven decisions. This presentation explores the spectrum of forecasting techniques, including scenario construction and powerful-yet-approachable quantitative methods. See how to match appropriate techniques to decision-support needs and then implement them in ubiquitous productivity software. Learn effective strategies for visualizing and communicating forecast outcomes, uncertainty, and sensitivity. Jeff details his forecasting experience at the Medical School. Examples include financial forecasts informed by operational data and scenario analysis.

Approachable Network Analysis

Materials from my presentation Approachable Network Analysis are now available: PDF

From the University of Michigan Business Intelligence Community of Experts site:

Approachable Network Analysis

Presenter

Jeff Horon
Business Analyst
Medical School Grant Review & Analysis Office

Summary

Unlock the power of network structures in your data. Learn how to build and analyze networks to gain insights through relationship analysis. Apply approachable techniques and free, user-friendly software. Transform the data you have into the data you need – from relational databases and unstructured text to common network structures.

Jeff detailed his work in the Medical School Grant Review & Analysis Office. Examples will include: Identifying networks of collaborators from eResearch Proposal Management [eRPM PAF] data, discovering networks of concepts in unstructured text, and use cases from other administrative data sets. Jeff’s presentation included:

-“Networks 101″ – The basic building blocks of networks
-How people in any campus unit can apply network analysis
-An emphasis on approachable techniques and free, user-friendly software
-Strategies for effectively visualizing and sharing network-driven insights
-Tools, tips, and tricks

Presented examples were produced with NodeXL, which is a product of Microsoft Research and university collaborators. NodeXL is very approachable — you can produce a network visualization by simply copying and pasting in two columns of properly-formatted data (i.e. an ‘edge list’). It computes a desirable set of network metrics, including eigenvector centrality. Layout, visual encoding, and aesthetics are top notch. It installs into Excel 2007+ as a template.