Excel Dashboards
The following dashboards showcase my ability to rapidly conceptualize, build, and iterate on high-impact reporting tools using real-world data. Each was created independently from publicly available datasets and designed with the same principles I apply in a professional operations environment: clarity, utility, and actionable insight.
My background leading large-scale call center operations demanded tools that not only visualized performance but drove better decision-making. I’ve brought that same mindset here—distilling complex datasets into clean, interactive views that highlight key trends, flag outliers, and suggest next steps. These dashboards reflect my hands-on experience with Power Query, dynamic conditional formatting, and user-centric design—skills I've used to empower support staff for the entire project and help lead a top-performing technical support team for a global client.
Call Center Dashboard
🖱️ Drag the blue divider to toggle between dark and light mode.
All dashboards have both versions integrated into the file with the same data source.
- Dynamic – Utilizes formulas, slicers, and named ranges to automatically update visualizations and summaries as new data is entered or imported.
- Responsive – Adapts seamlessly to user interaction through pivot tables, slicers, and form controls, enabling real-time filtering and analysis.
- Fast – Optimized for performance using efficient formulas (
XLOOKUP,LET,FILTER) and structured data models to ensure minimal lag even with large datasets. - Engaging – Features visually compelling charts, conditional formatting, and interactive elements that draw the user in and make insights easy to digest.
- Efficient – Designed with a clean layout, reusable components, and minimal manual input, streamlining both development and daily use.
- Insightful – Highlights key metrics, trends, and variances using KPIs, sparkline charts, and dynamic text, helping users make informed decisions at a glance.
These animations highlight different elements of dashboard functionality, demonstrating both interactive data responsiveness and polished visual storytelling.
European Soccer Dashboard
US Rent Dashboard
Patents
Resume
Innovative leader with a proven record of optimizing processes, driving excellence, and developing top-performing teams. Skilled in enhancing team productivity through creating specialized and unique tools for organizational effectiveness, system development, and cultivating a culture of trust, execution, and continuous improvement.
Operations Manager
IMWIPA, LLC — May 2025 – Current
- Designed and maintained comprehensive buyer-seller matchmaking dashboards, identifying strategic merger and acquisition opportunities aligned with targeted revenue and growth criteria.
- Prepared recasts of corporate tax returns, P&Ls, and balance sheets to represent EBITDA, profit margins, and cash flow from normal operations, facilitating informed investment and acquisition decisions.
- Implemented and optimized deal management workflows within Streak CRM, increasing efficiency in tracking and progressing buyers and sellers through the sales pipeline.
- Developed a proprietary Python application to rapidly generate polished, persuasive investment teasers, standardizing format and messaging to enhance deal visibility and attractiveness.
- Established streamlined reporting processes, enabling real-time tracking of pipeline progress, deal valuation trends, and buyer-seller engagement metrics.
- Collaborated closely with senior executive to refine operational strategies, enhancing workflow automation and improving overall firm productivity and client satisfaction.
- Created standardized financial modeling templates, ensuring accuracy and consistency in presenting actionable insights for prospective investors and stakeholders.
Operations Manager
Conduent — June 2022 – May 2025
- Led a team of 10+ direct reports and 200+ indirect reports, consistently meeting and exceeding performance goals, along with active management of training, compliance, headcount, and timekeeping functions.
- Developed supervisors through one-on-ones, coaching observations, written communication reviews, team meetings, and daily stand-ups to ensure critical deliverables in a fast-paced and dynamic environment.
- Planned and presented actions and performance to client vendor managers in bi-weekly presentations.
- Created and ran a new line of business upskilling process, providing dependable and consistent candidates for client headcount needs. Met 100% of requirements across all training waves for nearly 1000 agents.
- Streamlined supervisor training program, rewriting course material, restructuring the syllabus, and taught classes. Reduced lecture time in favor of two-week structured co-management with a tenured supervisor.
- Led key components of a successful site-wide recertification project in 2025, refining coaching quality, feedback mechanisms, and performance documentation alongside senior management and auditors.
- Proactively conceived, created, and continuously improved/maintained a site-wide interactive call center dashboard which was adopted by all supervisors, managers, senior operations managers, and director.
- Created a novel security check report, for use with documenting monthly delivery of security investigations.
- Discovered and resolved errors in critical reporting, properly enforcing Results Based Compensation criteria.
- Analyzed rolling 13-week surveys to identify highly impact drivers as well as positive/negative outliers for root cause analysis. Create targeted training materials to address the most impactful needs.
- Quickly conceptualized and created numerous custom tools in Excel used by 80+ supervisors and 10+ managers daily. These are designed to reduce time and effort across all support staff levels and have been widely praised.
Resume - Previous Experience
Supervisor
Conduent — Apr 2021 – Jun 2022 (Remote)
- Led a team of 20+ direct reports consistently meeting and exceeding performance goals, along with active management of attendance, adherence, compliance, training, and timekeeping.
- Conducted in-depth performance reviews and coaching sessions to identify behavioral issues and their root causes, providing targeted and consistent coaching and follow-up to drive performance in critical metrics.
- Achieved top customer satisfaction and resolution scores for the Line of Business within the first 2 months of production. Accepted a mentoring supervisor role to support headcount ramp and was offered a permanent position in under 3 months, significantly ahead of standard timelines for supervisor-level roles.
- Reinvented mentoring recruitment while maintaining top team performance in critical metrics. Developed a master recruitment tool for headcount needs and developed top candidates to become impactful mentors.
- Created a Structured Support system, facilitating chat support to phone agents during periods of heavy volume.
Product Manager/Co-Founder
PAVE Medical — Jan 2015 – Dec 2022 (Zionsville IN)
Acquired by Mermaid Medical
- Designed, conducted, and analyzed “in vivo” and benchtop tests with prototype devices to finalize specifications.
- Collaborated with engineers and prototypers to improve tip geometries, throw speed, surfacing, and more.
- Invented biopsy technology: U.S. Patent No. US11045173B2, US11839364B2, US-12239299B2 with related European and Japanese patents. Worked directly with a patent attorney to secure valuable intellectual property.
- Create videos, diagrams, and materials demonstrating new biopsy technology to radiology professionals.
- Assisted in successful exit and transfer of technology to Mermaid Medical team.
Product Specialist
Argon Medical Devices — Sep 2014 – Jan 2015 (Franklin IN + Travel)
- Ensured successful transition of commercialized US Biopsy and Dextera product lines to Argon sales team.
- Directly supported sales reps nationwide, providing critical support before, during, and after procedures.
- Provided key advice during challenging biopsies resulting in successful procedures, closing new accounts.
- Conducted regional training for Argon sales representatives for all products acquired through US Biopsy.
- Developed strategy with regional managers and VP of Sales for product launch under new branding.
Product Manager
US Biopsy — Feb 2012 – Sep 2014 (Franklin IN + Travel)
Acquired by Argon Medical Devices
- Provided critical troubleshooting advice during complex transjugular liver biopsies, preventing procedures from being halted due to complications, resulting in closed client accounts and strengthened brand loyalty.
- Designed branding for, and ran, company booth at annual Society of Interventional Radiology trade shows.
- Trained and supported physicians and 50+ sales representatives in proper use of products in biopsy procedures.
- Invented biopsy technology: U.S. Patents US9463002B2, US10004483B2 with European and Japanese patents.
- Maintained expertise in, and strategic sales of, the complete US Biopsy and Dextera product lines.
Skills
- Advanced Excel & Power Query – Built complex dashboards integrating 20+ sources via Power Query, with conditional formatting, custom front ends, and operational logic
- Call Center Operations Strategy – Expertise in absenteeism tracking, supervisor coaching, team performance analysis, and process governance for 10+ direct supervisor reports and 200+ indirect reports
- Leadership & Team Development – Designed and delivered new supervisor onboarding, structured mentoring, and upskilling programs for 60+ supervisors and 1000+ agents
- Performance Management – Created custom reporting systems and dashboards to track KPIs across rolling 13-week windows and vendor-facing scorecards
- Process Improvement – Streamlined coaching, onboarding, training, and escalation workflows, reducing time-to-impact while improving audit and recertification readiness
- Cross-functional Collaboration – Partnered with senior ops leaders, supervisors, vendor managers, and auditors to drive performance improvements and site-wide adoption
- Data-Driven Decision Making – Built actionable insights into daily cadence tools, auto-flagged outliers, and provided interactive coaching recommendations
- Stakeholder Communication – Regularly presented performance trends and initiatives to client vendor managers, auditors, and senior leadership
- UX-Oriented Tool Development – Designed frictionless interfaces for non-technical users across Excel, browser styling, and internal web tools
- Technical Documentation & Enablement – Authored internal guides, training materials, and support processes to ensure consistency and adoption at scale
- Highly proficient in both Windows and macOS: Excel, Office 365 (All), Adobe Creative Cloud, HTML/CSS
- Technically minded with an eye for design, aesthetics, and frictionless UX. Hobbies include game modding, development through C++, Python, Assembly, Adobe Photoshop, Illustrator, and custom Excel/Python tools.
Education
- Bachelor’s – Graphic & Web Design | July 2016 | The Art Institute of Indianapolis
References available upon request.
Email: douglas.knoll@gmail.com