Data Source – Accident Data from January 2017 through August 2022 Audience – Claims Group – Workers Compensation & Benefits Team Description – Our Claims Group wants to better monitor work-related accidents in working with customers. The types of things the team is interested in include: What volume of accidents do we have to manage? […]
Month: July 2022
Emergency Calls Requirements (#RWFD)
Dataset – 10 Months of 911 Calls (recently moved to a new call management system) Audience – General Public in the Atlanta Metro Area. DescriptionWe want to provide the citizens of Atlanta with a sense of transparency when it comes to emergency services in the metro area. Questions we ask internally and that we get frequently are: […]
Community Service Request (CSR) (#RWFD)
Dataset – Audience – Citizens on New York City Description Data Dictionary Basic NeedsUltimately we’d like to have an overview of all aspects of the financials, and then a deeper dive into the Balance Sheet and Income Statement. Accelerator –
Real World Fake Data – Season 2 – HR Attrition Recap
It’s good to be back! First, thanks to all the participants jumping into Real World Fake Data (RWFD) for Season 2! Hopefully, you find it a worthwhile endeavor for building your analytic skills! Session 1 was all about HR Attrition. For Season 2 I’ve introduced the idea of requirements, including a color palette and logo. […]
Financial Overview Requirements (#RWFD)
Dataset – 5 Full Years of Financials (7/1/2017 – 6/30/2022) Audience -FP&A Team DescriptionAfter years of excel files and formatted word documents, we are in need of a more visual approach to our Balance Sheet and Income Statements. Data DictionaryTotal Equity: Total Assets – Total LiabilitiesGross Margin: Sales – Operating CostsNet Income: Sales-(Operating Expenses+Taxes+Operating Costs)Operating […]