7 things you must absolutely avoid as a data analyst when creating a report for your boss or clients.

#DataFam #DataAnalytics #AllAboutTheData
1. Data confusion

There's nothing worse than looking at a dashboard or report and being confused:

• Where did the data come from?
• When was it last updated?
• Any additional context?

These questions will come up so include the answers directly in your analysis.
2. Not telling a story

Your analysis has to have a point.

Otherwise, it's a waste of time and money.

Instead, spell out exactly why your audience should care about the work you've done.

Don't make the mistake of "letting the work stand on its own". Nobody's got time for that!
3. Hiding the answers

A good analysis will prompt the end user to take some action.

Help your end users out by putting the recommendation or desired action right in the heading of the analysis or report.
4. Lack of organization

Nobody likes disorganization. Especially your boss or your clients.

Think about it: imagine if your bank statement was laid out with zero thought. You'd be furious.

Make sure your analysis and reports are broken into easily digestible sections.
5. GIANT WALL OF TEXT

You've heard it before:
• "Humans are visual creatures."
• "A picture says a thousand words."

And you get the point: include visuals, charts, and graphs to break up your work and strengthen your point.
6. Typos and bad grammar

Your analysis can be visually stunning and really get the point across.

However, you need to make sure you are using basic grammar rules.

A surefire way to turn people off from your hard work is leaving in easy-to-spot misspellings and mistakes.
7. Forgetting your audience

You have to keep your target audience in mind when writing a report or analysis:
• Managers vs. executives
• Decision support vs. trends
• Familiar with the problem or not

If you don't have a specific audience, hit pause until you can find out.
Recap on what to avoid:
👇
1. Data confusion
2. Not telling a story
3. Hiding the answers
4. Lack of organization
5. GIANT WALL OF TEXT
6. Typos and bad grammar
7. Forgetting your audience

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Brian Graves

Brian Graves Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @NewPrediction

Sep 23
Top resources to become better at #DataAnalytics in 2022:

1 SQLBolt: level up your SQL skills
2 TableauPublic: create & publish data viz
3 AutomateExcel: finally learn Excel
4 LearnPython: Python practice for every level
5 StartWritingOnline: improve your writing in 7 days
1. SQL Bolt:

SQLBolt is a series of interactive lessons and exercises designed to help you quickly learn SQL right in your browser.

It's great for beginners!

twtr.to/sqlbolt 👇
2. Tableau Public:

Tableau Public is a free version of Tableau that allows you to visualize data on the web or on your computer and upload it to a public Tableau profile.

It's a great way to get practice with Tableau!

twtr.to/tableaupublic 👇
Read 7 tweets
Sep 22
The #1 way to get noticed during the hiring process, is to have an awesome #DataAnalytics portfolio.

Unfortunately, most aspiring analysts don't know where to start.

Here are 10 data analytics portfolios that will inspire you to take the first step: ⤵
#DataFam #AllAboutTheData
1) Ger Inberg – Data Science Developer

Ger's portfolio showcases data viz, machine learning, and web dev projects. Each project includes a brief overview and link for details.

👉 gerinberg.com
2) James Le

James's portfolio focuses on data analyst projects, using Jupyter and R notebooks. Definitely check this out if you want to showcase your coding skills.

👉 jameskle.com/data-portfolio
Read 13 tweets
Sep 21
In #DataAnalytics, it's impossible to memorize everything you need to know about #Tableau.

Fortunately, there are amazing cheat sheets so that you don't have to memorize the basics.

Here are 7 Tableau Cheatsheets for you to download now:⤵
#DataFam #AllAboutTheData
1) DataCamp

In this Tableau Cheat Sheet, you'll learn how to create your first visualization, top visualizations in Tableau, creating dashboards, stories, and more.

Download now: twtr.to/r6am
2) Intellipaat

This cheat sheet will provide you with all the basics of the Tableau desktop that you need to know to get started with Tableau

Download now: twtr.to/xqR-
Read 10 tweets
Sep 19
Here's the step by step process I used to create and close a $36,000 "no-brainer" data consulting engagement with one client:
Step 1) I got to know business owners.

Through a friend that ran a solo agency, I was asked to bid on a small #Tableau job.

I got the bid just to get my foot in the door, and over delivered at every step.

I had no website, portfolio, or business cards.

Just relationships.
Step 2) I under-promised and over-delivered.

It's cliche, but powerful.

Example: applying branding colors to a Tableau dashboard takes about 15 minutes, but makes the final product 1000× better.

This gave the solo agency owner confidence that I knew what I was doing.
Read 7 tweets
Sep 10
Knowing #Excel is absolutely critical for anyone that works with data on a regular basis.

Fortunately, there are places online where you can learn these essential skills – without paying a penny.

Use these 7 websites to sharpen your Excel skills today.👇
#DataFam #DataAnalytics Collage showing screenshots of 7 free websites to learn Exce
1) SFiddle
The goal of SSFiddle is to make working with spreadsheets as fast and convenient as possible, similar to CodePen and DBFiddle.

Learn more: ssfiddle.com Screenshot of ssfiddle.com
2) FormulaBoost

Format and analyze Excel formulas to check for errors, validate results, and more.

Learn more: formulaboost.com Screenshot of FormulaBoost.com Online Excel Formula Beautifi
Read 10 tweets
Sep 7
When you're just starting with #DataAnalytics, it's impossible to remember everything you need to know about #SQL.

Fortunately, there are amazing #cheatsheets so that you don't have to memorize the basic syntax and commands

Here are 7 SQL cheatsheets for handy reference:👇
1) SQL Cheatsheet by @swapnakpanda

This cheat sheet covers the basics like querying and joins, but also includes some data modeling and data definition commands as well.

Definitely worth checking out: SQL Cheatsheet by @swapnakp...
2) MySQL JOIN Types by @SqlEmt

Trying to keep all of the different JOINs in mind, is pretty challenging. Especially after the coffee wears off for the day! ☕

Use Steve Stedman's MySQL JOIN Types cheat sheet to save time and avoid confusion on your next #MySQL project: Trying to keep all of the d...
Read 9 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(