Creating an interactive reporting hub

Bernadett Remenyfy-Kiser

Data Visualizer
Google BigQuery
Redshift
Tableau
1) Project overview
The company faced issues with report management and data accessibility, slowing down effective decision-making. The dashboards they had were not interactive, slow to load and it was a very long process to build something new. There was no core framework, which caused inconsistencies in how certain KPI-s very calculated. The new comprehensive dashboards needed to incorporate sales, marketing, transaction, and traffic data.
2) Actions
Collaborated with stakeholders to create the unified meaning of each KPI
Built the SQL queries for the underlying data layer
Ensured that the new dashboards are interactive with differerent splits, drilldowns and easily switchable between different level of aggregations
Created the core visualization framework and design style for the company
Designed a centralized reporting hub, which provides a user friendly interface and makes all related dashboards easily accessible
Tools: Google BigQuery, Amazon Redshift, Tableau
3) Result
Streamlined Reporting: The centralized reporting hub improved the efficiency of report distribution and access, enhancing daily operations.
User-Friendly Interface: Stakeholders found it easier to navigate and interact with the dashboards, leading to better decision-making.
Enhanced Data Understanding: The interactive features, such as drill-downs and splits, empowered users to explore data relationships, resulting in improved insights and data-driven actions.
Easily downloadable data: Users can now conveniently download the data they need for further analysis.
Partner With Bernadett
View Services

More Projects by Bernadett