We're proud to provide Data Visualization services.

Expand
Healthy U Portal app.

Processes
  • Continuous Delivery
Team Leadership
  • Senior Producer
    Kelly Albrecht
  • Senior Architect
    Rob Bayliss
  • Senior Development
    Rob Bayliss
  • Art Director
    Colin Panetta

Cooley-Dickinson Hospital offers an incentive-based healthy lifestyle program to their employees. As employees participate in exercise activities, healthier eating habits, and education classes to learn life-enhancing techniques, they gain points— which translate to greater discounts to their benefits contributions. CDH was tracking this participation program on paper and in Excel for over 1000 employees. Last Call was hired to transform the program into an interactive digital experience to increase participation and automate much of the workflow of managing the program.

We provided an easy-to-use interface to minimize the barrier of entry for users. Maximized by a Mobile First approach, we condensed how much information was presented to allow users to quickly access the main features of the program, which included entering exercise activity. While also accessible through desktop and laptop computers, the primary use case for the app was on the go, from a mobile device, for a user to track their progress. LCM went further, implementing QR Code functionality, allowing CDH to post flyers notifying staff of special activities. Scanning the QR Codes on those notices would transition the user’s experience to the relevant area of the app.

Things went really well with the program, it met all of our needs really well and the employees loved it.

Sam Blasiak, Cooley Dickinson Hospital

The program has been met with amazing reception both from administration, and employee participation. The program is being further expanded and developed to be modular and rapidly deployed at partner healthcare facility partners.

Expand
Rainforest Alliance's Global Impact Map.

Processes
  • Agile/Kanban
  • XP
Team Leadership
  • Senior Producer
    Kelly Albrecht
  • Senior Architect
    Rob Bayliss

Rainforest Alliance needed an effective way to illustrate their global efforts to preserve one of the earth’s most valuable resources: the environment.

Most recently impressive is the mapping project that we unexpectedly threw on Rob and Tom’s lap, and which they handled quickly and expertly. 

Melissa Normann, Senior Manager, Web Strategy and Development

Knowing that a simple page with paragraphs wouldn’t suffice, we built a map that allows the Rainforest Alliance to display data from a specific region. The user can then zoom in on those regions or look at specific data points to learn more. The map takes a large spreadsheet of geodata, created based on information from the Rainforest Alliance’s CRM, and creates an interactive map powered by CartoDB that allows users to see RA-certified organizations, and what they do.

The project took less than a month to complete, using a combination of Kanban and XP management processes.

Expand
Labor Rights Portal.

Processes
  • Continuous Delivery
Team Leadership
  • Senior Producer
    Kelly Albrecht
  • Senior Architect
    Rob Bayliss
  • Senior Development
    Rob Bayliss

Verité has an immense amount of data that has been collected over the last 30 years regarding labor worldwide. Internal efforts are ongoing to collect all of the hand-written and paper reports into a centralized database that can be queried and sorted. For the lay-person the data was still just numbers and figures. They needed a way to visualize the data for use by researchers, academics, and the general public.

We wanted to ensure the data was exciting to work with. Far too often, data is presented as merely tables and numbers. From the start we wanted to tell a story about the data, so together with Verité, LCM crafted a question-and-answer-based approach to displaying the data with creative charting and mapping elements built to place emphasis on the results of the data.

The site’s functionality continues to be expanded as data is collected with additional visualizations and database connectors to provide real-time data for global results. 

Expand
National Census of Writing.

Processes
  • Agile/Scrum
Team Leadership
  • Senior Producer
    Sean Eddings
  • Senior Architect
    Jeff Landfried
  • Senior Development
    Jeff Landfried

In the midst of sorting massive amounts of data for the National Census of Writing, Jill Gladstein of the Swarthmore College English Department called on Last Call Media to create a usable web data explorer for use by the general public and qualified researchers alike. Survey data was collected from respondents from over 900 higher education institutions. Census questions gathered data about curricular, administrative, and support structures of writing programs in the United States from March 2013 to October 2014.

Census data is extremely important for the Higher Ed community, but the information is only as good as it is accessible. Working closely with the Swarthmore staff, LCM pinpointed what information was the most critical and sought after by administrators and researchers viewing the data. Graphs were designed to optimally visualize survey question responses and search functionality created to easily explore by survey question, institution type and related filters.

Tablet showing graphs from the National Census of Writing website.

The first iteration of the site launched in time for Swarthmore to unveil its functionality at the Council of Writing Program Administrators 2015 Conference to great praise. The site, in addition to the program’s work, has gone on to be featured in Inside Higher Ed being utilized by the general public, researchers and higher education institutions all over the country and is 508 compliant.

The Census is being utilized in ways we never expected.

Jill Gladstein, Swarthmore College English Department
Expand
Upgrading the CAIA Association.

Processes
  • Agile/Scrum
Team Leadership
  • Senior Architect
    Jeff Landfried
  • Senior Development
    Jeff Landfried

Time-sensitive reporting was challenged by a lack of exporting and reporting capabilities of the previous web platform, so CAIA was looking at upgrading their existing infrastructure from an outdated, highly customized and modified eCommerce website, to a more robust solution upgraded to the newest version of Drupal.

How we did it

Profile picture for user Jeff

We joined the project to get it across the finish line. We refined the existing agile approach for a better-organized project backlog and a more deliberate iteration strategy.

Our solution included working with in-house developers to migrate and upgrade numerous features and systems to work with the most current major Drupal version. Tailored reporting capabilities were developed, giving real-time statistical and sales figures for their support team and company executives.

 

Expand
Helping patients learn more about their options for medical professionals.

Processes
  • Continuous Delivery
Team Leadership
  • Senior Producer
    Sean Eddings
  • Senior Architect
    Abby Kingman

Helping patients identify and connect with a medical professional best suited for their needs.

A key component of the web presence for Columbia Medical School is their faculty profiles. In keeping with their tripartite mission of teaching, research, and clinical work, the University displays two distinctly different types of profiles. Department web site profiles focus on the individual’s scholarly work and administrative positions. The ColumbiaDoctors website displays information about the physician’s clinical work including specialties, practice locations, and insurance. It is also just as important for new medical professionals to store and access their profile information in one place as it is for the departments and practices they are a part of. 

Maintaining a complex system with many data feeds and manual verification of information was becoming a burden for the University’s support staff, and the complexity of the process to create or update a profile was vexing to faculty and their support staff. Columbia University Medical Center looked to LCM to help them find a new solution. There was a preference for moving to an existing solution available in the marketplace rather than building a new custom solution. 

We embarked on an intensive information gathering phase, to better understand the existing technology, data inputs and outputs, and nature of the support queue. Through preparing user stories, we worked with the University to identify stakeholders groups, and we conducted detailed interviews with individuals in each group to understand their pain points within the existing system.

Finally, we conducted extensive research to identify potential solutions. We identified a number of peer institutions and investigated the faculty and physician profiles, and - to the extent possible - the technologies and workflows employed to create them. We contacted a number of vendors to gather more detailed information and winnowed the list of candidates to those that presented the best possible fit. We summarized our findings recommendations in our final meeting with the team.

By working closely with the team and developing a strong rapport with them, as well as the stakeholders, we were able to gain a clear understanding of their goals and deliver actionable recommendations   

By working closely with the team and developing a strong rapport with them, as well as the stakeholders, we were able to gain a clear understanding of their goals and deliver actionable recommendations to support CUMC’s business goals.