Project briefs · Finance & Accounting

DICK'S Sporting Goods · Summer 2027 (May 17 to Jul 29, 2027)

Finance Corporate Intern: a project built for this posting

A summer finance internship at DICK'S headquarters near Pittsburgh, working on analysis that supports a large sporting goods retailer. It suits finance, accounting and economics students who like working with numbers.

Build this project for free →

Free, any major, no coding needed. Your project for this posting: Sporting Goods Retail Competitor Benchmarking Dashboard.

Company
DICK'S Sporting Goods
Posting title
Finance - Summer 2027 Corporate Internship
Location
Pittsburgh, PA (Customer Support Center)
Season
Summer 2027 (May 17 to Jul 29, 2027)
Majors named
Finance, Accounting, Economics, Mathematics, Statistics

Checked open on the employer's careers site on 2026-11-18. Read the full posting ↗

What this role is really testing

Financial analysis and modeling in ExcelCompetitor benchmarkingData-driven recommendationsRetail industry metrics interpretationClear written communication of financial findingsTrend identification and reporting

The project

Sporting Goods Retail Competitor Benchmarking Dashboard

A structured Excel workbook that benchmarks 4-5 major sporting goods retailers (e.g., Dick's Sporting Goods, Academy, REI, Big 5, Hibbett) across key financial and operational metrics such as revenue growth, gross margin, same-store sales, and inventory turnover, with a one-page executive summary tab presenting data-driven takeaways. This maps directly to the competitor benchmarking and senior management presentation responsibilities listed in the role, and proves Excel fluency and the ability to synthesize numbers into a clear business narrative.

  1. Pull the most recent annual report or 10-K data for 4-5 publicly traded sporting goods retailers and compile a raw data tab in Excel with metrics including total revenue, YoY revenue growth, gross margin %, operating margin %, and inventory turnover ratio for the last two fiscal years, label every source in a notes column.
  2. Build a formatted comparison table tab with conditional formatting (color scales or icon sets) to visually rank each retailer on each metric, and add two Excel charts, one clustered bar chart comparing gross margins across all companies and one line chart showing revenue growth trends, so a reader can spot the competitive landscape in seconds.
  3. Create a third tab titled 'Executive Summary' with a brief written analysis (5-7 bullet points) calling out who leads on profitability, who is gaining or losing share, and one data-backed strategic observation relevant to Dick's Sporting Goods specifically, formatted cleanly with a header, your name, and date so it reads like an internal report ready to hand to a manager.
Build this project for free →

Free account. Provieo walks you through it and turns it into a page with a link you can put on your application. This posting comes with you.

Questions

Do I need to know how to code?

No. For roles like this one, Provieo builds the project as a live case-study page: slides, tables and findings you fill in. You bring the thinking.

Where did this project come from?

Provieo read the DICK'S Sporting Goods posting and generated it on 2026-11-18. If you paste the same posting yourself you may get a different project, so two applicants don't show up with the same one.

Is Provieo connected to DICK'S Sporting Goods?

No. This is an independent project idea based on a public posting. It does not guarantee an interview.