• My name is John Chopan, and I enjoy writing T-SQL and creating reports and dashboards.

    I'm currently a Senior Database Analyst at a local community college.
    My primary responsibilities are daily reporting, state/federal compliance reporting, benchmark reporting and dashboard design for data in the Colleague ERP system. I am also the administrator for the Image Now document imaging system.

    My personal short-term goal is to learn R scripting.

    Under the samples section you will find examples of dashboards I've created, and you can download the sample Power BI dashboard.

    Thanks for visiting.

  • Image

Customer Service

Over ten years experience working with customers and key stakeholders. Several letters of recognition for outstanding support.


Immense troubleshooting skill set. SQL Server & data processing, ERP software, and general desktop PC and server issues.

Data Analysis

Ad-hoc reporting, dashboard design in multiple tools (SSRS, Power BI, Tablaeu), and compliance reporting.


SQL server
Image Now
Power BI
Visual Studio
Visual Basic
Microsoft Office
Camtasia Studio