overview
Designed and automated reporting systems that gave Civiconnect a centralized view of client activity, projects, resources, participant demographics, and program performance.
I transformed data from multiple internal platforms into interactive Power BI dashboards and analyzed participant feedback to identify trends, evaluate outcomes, and support program and marketing decisions.
role
Data Analyst
approach
Built the reporting foundation from raw data through dashboard development, automation, performance analysis, and stakeholder reporting.
*Note: dashboard data has been removed or modified for confidentiality.
1. building the data foundation
I collected, cleaned and combined data from several internal sources to create a more accurate and consistent reporting system.
Using Power Query, I standardized information, corrected errors and transformed the data into formats that could be used across the dashboard. I then created relationships between tables and developed calculated columns and measures using DAX.
This created one connected data model that could support company reporting, client tracking and program evaluation.
2. designing interactive dashboards
I designed the Power BI dashboard to reflect Civiconnect’s brand identity, using familiar colours, shapes and navigation so the system felt like an internal company platform rather than a generic report.
The introduction page gave users direct access to company performance, the client directory, web development and marketing data.
I added summary tiles, filters, slicers and drill-through functions so users could begin with a high-level view and move into more detailed information when needed.
3. tracking organziational performance
The company dashboard brought key operational metrics into one view, including:
Current client count
Completed projects
Project and employee work hours
Cohort and stream information
City and sales data
Resource allocation
Program performance
Users could filter the results by cohort, stream, city and sales information. The dashboard also included scheduled refreshes and current data connections.
4. building the client reporting system
I built an interactive client directory that gave the team a clearer view of every organization Civiconnect had worked with.
Each client profile included information such as project status, start and end dates, point of contact, completed projects, total project days and work hours.
I also added cohort and stream filters, a search function and drill-through navigation so team members could quickly locate a client and move from company-wide results into the details of an individual project.
5. evaluating participants outcomes
I collected and analyzed feedback from ConnectCamps participants to understand how their skills and confidence changed throughout the program.
The evaluation looked at areas such as web development, marketing, technical knowledge and soft-skill development. I compared responses across cohorts to identify patterns, strengths and areas where the program could be improved.
These insights helped Civiconnect understand the participant experience and make informed changes to future camp programming.
6. automating reporting workflows
I used Power Query and Power Automate to reduce repetitive data preparation and improve reporting accuracy.
I automated parts of the collection, transformation and reporting process, scheduled dashboard refreshes and created systems that were easier for the organization to update over time.
I also prepared government reports on program performance and participant outcomes, helping Civiconnect demonstrate its results and maintain funding eligibility.
outcome
Created a centralized reporting environment that allowed teams to move from high-level performance metrics into detailed client, cohort, resource, and program information from one platform.
The ConnectCamps evaluation also gave the organization a clearer understanding of participant growth and provided evidence that could be used to improve programming and support government reporting.
Capabilities Demonstrated
Data analytics
Identified the company, client and program information teams needed and created a connected reporting system around those priorities.
Performance Reporting
Created clear views of client counts, projects, employee hours, resources, cohorts and program metrics to support organizational decisions.
Power BI Development
Designed and published branded interactive dashboards with filters, slicers, summary tiles, search tools and drill-through navigation.
Program Evaluation
Collected and analyzed ConnectCamps participant feedback to measure growth in technical, marketing and soft skills across different cohorts.
Data Modeling
Connected and transformed data from Excel, Microsoft Project, Microsoft Dynamics, SharePoint and other internal sources using Power Query, DAX and relational data models.
Workflow Automation
Automated data preparation, dashboard refreshes and reporting processes to improve accuracy and reduce repetitive manual work.
*Confidentiality Note*
Some dashboard pages, company information and client details have been removed or modified to protect confidential organizational data.