{"id":14,"date":"2021-10-29T16:50:27","date_gmt":"2021-10-29T16:50:27","guid":{"rendered":"https:\/\/happydata.net\/?page_id=14"},"modified":"2025-12-21T05:43:04","modified_gmt":"2025-12-21T05:43:04","slug":"data-hungry","status":"publish","type":"page","link":"https:\/\/happydata.net\/","title":{"rendered":"Happy Data, LLC"},"content":{"rendered":"\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

what we offer<\/h2>\n\n\n\n
\n
\n

Every day we collect endless amounts of data, so much so that processing all of it can become overwhelming. Happy Data specializes in custom integrations, analysis, and visualizations that will help you make sense of your data.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n\n\n\n

<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div><\/div>\n\n\n\n

tableau visualisation example<\/h2>\n\n\n\n

This school district wanted to see which of their students fall into certain \u201cAt Risk\u201d categories. For this school district, a student who is at risk in two or more of five categories is considered an \u201cAt Risk\u201d Student. The categories are: Attendance, Behavior, Test Scores, Grades, Credits, and Mobility. In each category, the district has a specific set of criteria for which a student would qualify as at risk. For example, a student who has changed schools three times in one year or six times their entire career would be considered At Risk in the “Mobility” category. Two or more “Level 2” behavior referrals per month would earn a student an \u201cAt Risk\u201d mark in the “Behavior” category.
The first step of this project was to translate the district’s logic into a stored procedure that outputs the data required for this visualization. I then scheduled this stored procedure to run nightly after the district’s Data Warehouse Refresh process completes, creating the table on their Data Warehouse database. After these items were completed, I created the Tableau visualization, allowing the district to view their \u201cAt Risk\u201d students by school, gender, race\/ethnicity, and at risk category.<\/p>\n\n\n\n

<\/div>\n\n\n\n
\n
\"\"<\/a>
Click on the image for this sample, workable visualization<\/a><\/figcaption><\/figure>\n<\/div><\/div><\/div>\n\n\n\n
\n
\n
<\/div>\n\n\n\n
\"Sara
Sara Hefti<\/figcaption><\/figure>\n<\/div>\n\n\n\n
<\/div>\n\n\n\n
<\/div>\n\n\n\n
\n
\n
\n
\n

about me<\/h2>\n\n\n\n

Data specialist at your service with over fifteen years experience designing creative and useful solutions in various industries from museums to schools to hospitals<\/p>\n\n\n\n

Leveraging the power of Tableau & SSRS to give school districts a deeper knowledge of their staff and students from the forest on down to the trees. Answering questions such as the implications of re-zoning school boundaries and \u201chow many math teachers will we need next year\u201d helping teachers see trends in student attendance \/ behavior \/ grades so they can better serve the kiddos in their classroom<\/p>\n\n\n\n

Hospitals generate overwhelming amounts of data. Teaming up with the visionary hospital analytics gurus (CareSight), I help to extract and combine millions of data points from disparate sources into a cohesive platform; \u201ccleaning\u201d, analyzing and creating digestible stories for clients to better understand the movements of their nurses and the needs of their patients. <\/p>\n\n\n\n

Ultimately, questions are asked and answered leading to process adjustments which create leaner, more efficient workflows and better-performing hospitals.<\/p>\n\n\n\n

What stories does your data tell?<\/p>\n\n\n\n