How To Get A Job As A Data Analyst

Do you want to become a Data Analyst?



Overview of the steps and a brief explanation of each.


Content Topics


Methods to figuring out what that is.

Popular sites to research jobs that make people happiest that also pay well.

?Link to ebooks that have commissions. Free ebooks.



Education – links for educational resources to get said job.

What are online courses?

?Affiliate education signups?



Different methods for resumes.

Many different version of your resume. Targeted toward a job description.

Put yourself in the shoes of the hirer, what do you want to see? Certifications? Qualifications, experience. If you’re resume is over a page, don’t put things on there that aren’t directly relatable to the job.

?Services that will review your resume. Fiverr have an affiliate program? ODesk?


Your online presence

Google yourself, use public view (not personalized)

Log out of all your social accounts, browse in private mode to see what the public can see.



Step 4 APPLY


Your network. Tell all your friends. Hiding what you are doing from your boss? Tell only close friends


Find your dream company – find people that work there and contact them for advice and/or reference.

?Affiliate – LinkedIn PRO subscription? Benefits?


Where to look


Cover Letter


For certain roles: consider using a recruiter.

Pros: find jobs that aren’t listed

Doesn’t cost anything (finder’s fee charged to hiring company).

They ask the hard questions for you

They keep pushing, moving things along

They negotiate for you, they get paid more the more you get paid, to its also in their best interest to get you the highest paying job.


Cons: Not all companies with job postings will work with recruiters. Your dream company may not talk to any recruiters because they don’t want to pay the headhunter fee.

They’re annoying, they call and call and call. Some, good recruiting firms are smart and get it, but others push jobs on you you’ don’t want. Stick to your guns. Don’t

?Recruiter agencies with Affiliate links. Robert Half.


Where do I look??

Depends on the industry. IT – High paying, (affiliate?)

CareerBuilder, Monster, Indeed, Craigslist



Applying. Keeping track of everything.

Cover letters. What to have in cover letter that is not in the resume. Custom cover letters.


Step 5: Interviews:

Types of interviews and their purpose.

1st interview on phone – HR. HR is likely screening to make sure you’re a good culture fit and there aren’t any immediate disqualifiers such as difference in pay expectations, misfit

2nd interview with hiring manager, possible boss, bosses boss.

They’ll be asking specific quesitons relating to


Common questions and why they’re asked. How to answer them.

Common industry specific questions, why they’re asked, how to answer them.

How to bring your portfolio. Bring a laptop? What do I bring?
What do I wear?

Get their contact info.


Follow Up:
Thank you card

Handwritten email card Tip, have card ready to write on in the car after the interview. Pre stamped. Drop in mailbox near where you interviewed.


Phone interview, email follow up.

In person interview with important people, hand written follow up to everyone.

Call follow up (Don’t recommend). Hiring person is very busy. Can’t keep everyone straight, definitely won’t remember you via voice on the phone. Puts them in an awkward position on the phone, could actually turn them off. I actually had this happen with one candidate I was on the fence with. He emailed me several times and left me phone messages. I eventually asked the receptionist to send his calls to voicemail while the hiring process was still going.

Data Analyst Resources – Tools of the Trade

Free Tools and Resources for Data Analysts

3d Clipboard

Saves your past clipboard copies. This makes it easy to find and store text and images you will need to reference and paste later. Also allows for keyboard shortcut triggered pastes like email addresses you often have to type, formulas, datasets, header columns, etc.


Macros for all of windows. Allows you to build keyboard shortcuts to do any command. Commands can also be triggered by other things like time, opening a file, mouse clicks, or typing a series of keys. Fairly easy programming language to learn. Extremely flexible and powerful tool.

Excel Shortcuts

F9 – refresh

Ctrl+D – copies above cell down

Hold shift down to highlight ranges

Ctrl+end – move to last cell in row with a value

Ctrl+home – move to first cell in row with a value

Ctrl+pg up/down – move to first/last cell in a column with a value




Easy to use screenshot and screenshot editing tool. Makes it easy to snip pieces of your screen and has great tools to highlight, arrow point,


SQL Management Studio

Tips and Tricks… for writing sql queries

MS Outlook, email, calendar, etc.

GoDaddy hosting (affiliate)


Custom Ribbon

Shortcut keys

Tips and tricks..

Pulling data from SQL, OLAP, BI Cube, excel, etc.