I'm Shanikwa — and before I tell you what's in this shop, I want to tell you where it came from.

I didn't start in data analytics or accounting. I started in public service. I spent years as a Practical Instructor II at the Georgia Department of Juvenile Justice, tracking academic performance for at-risk youth, identifying the barriers keeping students from passing, and presenting evidence-based findings to leadership that actually changed policy. I didn't call it data analysis at the time. But that's exactly what it was.

Then I worked in logistics at Amazon. Then in security at Allied Universal, where I was querying a SQL database tracking 500+ daily badge entries, finding patterns in incident data, and building automated compliance reports that cut manager review time by two-thirds. Again — data analytics work, without the title.

When I decided to formalize it, I chose WGU's MS in Data Analytics program. I finished in six months while working. The program covered Python, R, SQL, machine learning, MLOps, deep learning, Tableau, optimization, and a full capstone research study on state correctional spending and recidivism. Every single deliverable is published on my GitHub at github.com/ShanikwaH/WGU_Portfolio — because I believe in showing the work, not just claiming the credential.

At the same time, I went back for a BS in Accounting at the University of Maine at Presque Isle. Real coursework: Intermediate Accounting I and II, Federal Taxation I and II (with complete C-corp, S-corp, and partnership tax return preparation), Government and Nonprofit Accounting, and Cost Accounting. I became a certified VITA tax preparer through the IRS — preparing real tax returns for real taxpayers under real IRS guidelines. I joined the AICPA and GSCPA as a student member. And I'm on the CPA track in Georgia.

Every template in this shop was built because I needed it and it didn't exist the way I needed it.

The SQL cheat sheet came from realizing I was saving queries in scattered text files and wasting time hunting for the right syntax. The financial ratio calculator came from doing 10-K analysis assignments and calculating each ratio by hand — once. The CPA exam tracker came from watching other candidates struggle without a real system. The resume template came from understanding exactly what makes a data analyst resume pass ATS screening and what makes it fail.

These aren't generic templates dressed up with someone else's branding. They are the actual tools I use, rebuilt and documented so they work for you too.

If you're a data analytics student, a career changer, an accounting student, or a CPA candidate — these were made with your exact situation in mind.

All downloads are instant. Everything works in Microsoft Excel and Google Sheets. If you have any technical issue, message me and I will resolve it within 24 hours personally.

— Shanikwa

analyticsbyshanikwa.com · @AnalyticsByShanikwa on TikTok, YouTube, and Pinterest