Tweet

Brian Graves

Oct 3 • 7 tweets • 4 min read

#DataAnalytics 101:

Start with the basics this month:
1. SQLBolt: practice #SQL
2. TableauPublic: data visualization
3. AutomateExcel: guided Excel practice
4. LearnPython: #Python tips for every level
5. Start Writing Online: the ultimate guide to writing

#DataFam

1. SQL Bolt:

SQL is king in the data analytics world. It's a critical skill.

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

Learn the basics or level up your skills today.

👉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.

Tableau is my absolute favorite data tool! Try it for free today.

👉twtr.to/tableaupublic

3. Automate Excel:

Excel is the "glue" for working with data in the business world.

This interactive tutorial will teach you how to use formulas in Excel. It covers the basics of creating formulas, formula shortcuts, named ranges, and more.

👉twtr.to/automateexcel

4. Learn Python:

Python is great for digging deeper into data analytics and automating your work.

Whether you are an experienced programmer or not, this website is intended for everyone who wishes to learn the Python programming language.

👉 twtr.to/learnpython

5. How To Start Writing Online:

If you've been thinking about improving your writing, I highly recommend How To Start Writing Online.

Everything you need to start writing, build an audience, and create new opportunities online.

👉 twtr.to/startwritingon…

TL;DR: Impress your boss with these 5 tools!
1. SQLBolt ⇢ twtr.to/sqlbolt
2. TableauPublic ⇢ twtr.to/tableaupublic
3. AutomateExcel ⇢ twtr.to/automateexcel
4. LearnPython ⇢ twtr.to/learnpython
5. StartWritingOnline ⇢ twtr.to/startwritingon…

• • •

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

This Thread may be Removed Anytime!

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

More from @NewPrediction

Brian Graves

@NewPrediction

Sep 29

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!

Read 9 tweets

Brian Graves

@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

Brian Graves

@NewPrediction

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

Brian Graves

@NewPrediction

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

Brian Graves

@NewPrediction

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

Brian Graves

@NewPrediction

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

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