Alex Freberg

Ever seen a dashboard like this?

I've been a Data Analyst for almost 7 years. I don't think I ever made or created a dashboard that looked like this.

Almost all Dashboards I created had between 1-3 charts/graphs each. Anything above that and people would get overwhelmed and genuinely confused with so much going on.

Keeping things simple and straight forward for the people consuming the reports was always top priority.

You make enjoy creating the complicated, advanced dashboards, but if it doesn't help your end user it really isn't helpful.

Here are my upcoming series on YouTube:

1. Data Fundamentals (5-7 videos)
2. Git and Github (3-4 videos)
3. Everything you need to know about Healthcare Analytics (4 videos)
4. Full R series Beginner to Advanced (12-15 videos)
5. Statistics in Data Analysis (3-4 Videos)
 
This will fill in a lot of gaps that my YouTube channel currently has in Analytics and I hope will help a lot of Analysts out there!

If you have any other suggestions on videos or series let me know!

Year 1:
Coworker: “Do you know Excel?“
Me: “Yeah, absolutely! How can I help?“
Coworker: “I have these 10 projects I need help with. Really appreciate your help!“

Year 5:
Coworker: “Do you know Excel?“
Me: “I've never heard of it. Is that some kind of CRM?“
Coworker: “Oh, I'll go ask Bob. Thanks anyway.“

Life Lesson: Never tell your friends or coworkers you know Excel.

Most people think Analysts just build dashboards, but let's look at some other things Analysts do:

1. Data Collection (one of my previous jobs was 80% data collection)
2. Data Cleaning
3. Data Quality
4. Testing Code and Debugging (QA Analysts spend a lot of time doing this)
5. A/B Testing
6. Data Modeling
7. Exploratory Data Analysis

This covers a large portion of what an Analyst will do! I've worked in roles where it's 80% data collection + 20% data cleaning. Or 50% dashboards and 50% EDA. Every role is different and each wears many hats!

Power BI is like my therapist. Easy to talk to. Insightful. Says my best friend is a bad influence on me.

Qlik is like my personal trainer. I don’t really want to use them, but I will if I’m desperate.

Alteryx is like my lawyer. Expensive. I don’t fully understand what they do. But does the complex work me so I don’t have to do it myself.

Google sheets is like my barber. Useless.

What's the difference between a Business Analyst and a Data Analyst?

I've worked with both and even hired both. Here's my thoughts on the difference!

Someone said they finished my Data Analyst Bootcamp on YouTube, but were complaining they hadn't landed any interviews yet.

I asked if they had applied to jobs and they said no 😂 😂

Not everyone is cut out for the employed life...

I'm not one for conspiracy theories.....

but it looks LinkedIn doesn't want their employees to complain about their pizza party this year...

I don't know who needs to hear this, but that recruiter ain't calling you back.

Move on. Find a better recruiter.

Working from home has increased my quality of life substantially. I’ve been able to spend so much more time with my kids and my wife and honestly that makes me work harder when I do sit down to work!

What would you say is the biggest upside to working remote?