Web-interfacing Visualization
Case I: Exploring Multiple Dimensions of Survey Data
-
Part I: The Dirty Work - Reshaping Data for Visualization
(Reshaping data structures; Extracting strings; Automating for Shiny) -
Part II: The Jigsaw Puzzle Pieces - Creating Graphs with ggplot2
(Bars; Summary stats; Organizing data; Visually grouping data) -
Part III: Assembling the Pieces - Creating R Shiny App
(User interface layout; Widgets; Reactive expressions; Plot outputs; Table outputs; Style; Hosting app) -
Product: Shiny App
(Source: library user survey data)
Case II: Visualizing Times and Locations with Animation and Interactivity
-
Part I: Creating Animated Graphs with gganimate
(gganimate; Animated map; Animated line graph) -
Part II: The Shiny App
(Slider; Animation sequences) -
Product: Shiny App
(Source: user behavior logs / server events data)
Working with SQL in Shiny
Project I: Building a one-stop-shop web app for business intelligence
-
Connecting SQLite Database and Shiny App for Business Intelligence
(Compiling database queries with SQLite; Issuing queries with RSQLite; Embedding SQLite queries in Shiny components) - Product: Business Intelligence Dashboard
Case II: Building a prototype of a database management system
-
Creating a Shiny App for Database Management
(Dashboard layout; Authentication; Dynamic UI reacting to user inputs; Making sure the SQL parts work in Shiny; Web development in Shiny) - Product: Database Management Platform