Sign up to receive our monthly newsletter, and get the latest insights, tips, advice, and all the resources you need to transform your business with data.
Count on us to be a resource for you. Our webinars equip you with data and analytics best practices and expert insights about the industry. You can also find us guest speaking at industry conferences and user group meetings.
To thrive with your data, your people, processes, and technology must all be data-focused. This may sound daunting, but we can help you get there. Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.
+1 312 878 6600 Mon-Fri 8:30am-5:30pm CT
Thanks for your inquiry! Someone will be in touch shortly.
AWS QuickSight, Looker, Power BI, Qlik, Tableau
I couldn’t be happier to witness how our analytics solution has inspired data-driven thinking across the firm. There are no more ‘out of reach’ questions: we have the context we need to better allocate our resources AND the granularity we need to demonstrate our work’s value in the community.
Civic Consulting Alliance serves public and social sector clients working at a systems-level toward inclusive and equitable solutions, providing the flexible and responsive capacity and expertise that clients need to design their own solutions, and to build infrastructure to make them sustainable.
Choosing which projects to take on and where to direct Civic Consulting Alliance resources is an important decision that takes into account many data points and circumstances, such as household income and demographics as well as infrastructure investments and historic disinvestments.
While this type of data is publicly available, it is often provided in static spreadsheets and other formats that don’t support complex decision-making.
Civic Consulting Alliance needed:
We built a proof-of-concept with five modern analytics tools—Qlik, Looker, Power BI, Tableau, and AWS QuickSight. Through a bakeoff process, we demonstrated different ways data could be visualized, and Civic Consulting Alliance made an informed decision on the best tool option for their consulting model and technology requirements.
We ultimately built a solution using Tableau embedded analytics that integrates a variety of types of data from many sources, including:
We embedded the analytics into a portal that Civic Consulting Alliance could log into without any authentication, licensing, or sign-on required on the part of the users. We built in custom navigation, color themes, and web actions within the web page using custom HTML and CSS, which allows users to filter and move from one report to another within one user interface.
Dashboards within the solution use maps to visualize median household income and income change across racial demographic groups, with the ability to view and compare across different time periods to show improving or worsening trends over time among specific communities. Other views include overlaying median home prices and their growth versus household income, unemployment rates across specific census tracts, and income disparity percentages in black households versus white households.
Civic Consulting Alliance now has a visualization tool that allows them to identify—at a granular level—communities in Cook County that have experienced disinvestment, and to visualize trends in household income by census tract and demographic. Reporting is now automated; information on racial disparities is more complete, up-to-date, and accurate; and dashboards that are available to all staff are easily interpreted by even the most novice data users.
This data visualization tool is now an important part of the toolkit that Civic Consulting Alliance uses to incorporate a racial equity framework into all its client work.
Civic Consulting Alliance is a nonprofit organization bringing together collaborative, pro bono investments to get big things done for Chicago. Civic Consulting Alliance focuses on three key platforms that are integral to improving quality of life, including: building safer and more just communities, ensuring equitable access to education opportunities and outcomes, and growing an economy that works for everyone.
Sign up to meet with one of our analytics experts who will review your data struggles and help map out steps to achieve data-driven decision making.