Welcome

  • 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.

Troubleshooting

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.

Proficiencies

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