5 things every accounting student needs to know about data analytics — and the one free tool to start with today
Accounting analytics is not data science. It's not programming. It's using modern tools to do the same accounting work faster, deeper, and more clearly — so your findings actually influence decisions.
When I was finishing my accounting degree at UMPI, nobody told me that the firms recruiting on campus were looking for accountants who could write a SQL query or build a Power BI dashboard. I was at Allied Universal writing SQL against access control databases before I even knew what to formally call it. That gap — between what school teaches and what firms actually use — almost cost me. This guide is the thing I needed and couldn't find.
| What People Think It Is | What It Actually Is |
|---|---|
| Data science for accountants | Excel used as an analysis engine, not a calculator |
| Learning to code from scratch | SQL to query financial databases — 10 queries to start |
| Replacing accounting jobs | Dashboards that tell the story behind the numbers |
| A whole separate career | Python to automate the repetitive month-end close work |
| Something you need years to learn | Skills learnable in 30–90 focused days with the right starting point |
A spreadsheet is a place to put data. An analysis engine is a place to ask questions of data. Same tool. Completely different mindset. That shift is the entire difference between a data entry accountant and a financial analyst.
You have more than you think. The question is what's missing — and whether it's the gap that's costing you interviews or career progress right now.
Want the full 15-question assessment with a personalized Skill Gap Report?
Take the free Accounting Analytics Skill Checker — 5 minutes, no signup, personalized results with specific product recommendations for your exact level.
Everything you need to begin already exists for free. Here's what to use and exactly what to do on day one with each tool.
You almost certainly have it. The question is whether you're using it as a calculator or an analysis engine. The difference is one mindset shift and three functions: pivot tables, SUMIFS, and structured tables.
Find any company's income statement on SEC EDGAR (free at sec.gov/edgar). Paste it into Excel. Press Ctrl+T to make it a structured table. Build a pivot table summarizing revenue by year. You have just done financial data analysis.
What blocks most people: not knowing which question to ask the data. → The Accountant's Excel Analytics Playbook ($19) at analyticsbyshanikwa.com solves that.
DBeaver is a free database tool — download it at dbeaver.io in 5 minutes. Connect it to the free sample accounting database at github.com/ShanikwaH/WGU_Portfolio.
Download DBeaver. Connect to the sample database. Type: SELECT * FROM general_ledger LIMIT 100; — hit run. You have just queried a financial database. That is SQL.
What blocks most people: they don't know what accounting questions to ask. → SQL Query Library ($9) has 50+ accounting-specific queries to copy and paste.
GitHub is where you store and show your work. Every recruiter who receives your resume and wants to verify your skills will look here. If there's nothing, it doesn't help you. If there's documented work, it changes everything.
Go to github.com. Create a free account. Create a repository called accounting-analytics-portfolio. Add a README that says who you are and what you're building. You now have a portfolio — empty, but it will not stay empty.
What blocks most people: not knowing what to put in it. → No-Internship Portfolio Builder ($27) gives you 5 complete projects with datasets, guides, and README templates.
Consistency beats perfection. 30 minutes a day compounds into something real in 90 days — here is exactly what to do with that time.