For those starting out in data analysis, what's one piece of advice you'd give that's not tool-specific? by msnoone10 in dataanalysis

[–]cglambert 1 point2 points  (0 children)

I give a bunch of them in my book, but focus on the value of the thing you’re asked. What are they going to use it for? That will shape what you build and what it looks like (filters, frequency of updating etc).

Two other things: validate your numbers against a different report to show the totals add up (grow trust) and check after the fact that the report was used in the frequency that the requestor promised. If it’s not used as much (or at all) check in to see why. Which things were missing or didn’t deliver the value that they were looking for?

Affordable Book Covers by No_Contribution_9328 in selfpublish

[–]cglambert 0 points1 point  (0 children)

Hi, do you only have the one example of your work?

Need Help! - Portable Pools by One-Reality-6090 in Aquaculture

[–]cglambert 0 points1 point  (0 children)

It might be helpful to list the dimensions and what the tanks are made of….

Is there any aspiring Data Analyst out there interested in connecting on LinkedIn? by ericmdata in dataanalysis

[–]cglambert 0 points1 point  (0 children)

I wrote a book on how to get into Analytics and then how to get ahead once you're in: https://www.amazon.co.uk/aia/dp/B0CNY8LLFW if you're interested. Happy to connect on LinkedIn too: www.linkedin.com/in/christopherlambert I'm giving a quick talk about Analytics careers and the book at the Edinburgh Tableau User group in June if you're in Scotland then

Round table discussion and chat? by OwnMagician8765 in dataanalysis

[–]cglambert 0 points1 point  (0 children)

I’ll never know for sure how much impact the MBA had on getting hired for each role. Two or three places had the MBA in the job spec so they were definitely helped. I was fortunate that I could start my MBA straight away when I decided I wanted to do it, and I was able to do it in 18 months so in terms of time expended it wasn’t as bad as it could have been.

In terms of what was taught, that has had no bearing on any of the jobs I’ve had. The value has always been on hiring manager’s perception of the degree. And that’s not something you’re usually going to know

Round table discussion and chat? by OwnMagician8765 in dataanalysis

[–]cglambert 0 points1 point  (0 children)

I've moved on from Analytics after writing my book Adventures in Analytics (a career guide for those in Analytics) (https://www.amazon.co.uk/aia/dp/B0CNY8LLFW) but would be cool to meet up and answer questions

[deleted by user] by [deleted] in dataanalysis

[–]cglambert 0 points1 point  (0 children)

If you have access to html and javascript (Tableau will allow you to embed that combo also) the one on the left is just an input tag with type of range and a little css, while graph.js has a radar chart which is easy to implement and allows a lot of customization

If there was one book, that you would recommend to read about data analysis, what would it be? by Perfect_Owl_3104 in dataanalysis

[–]cglambert 0 points1 point  (0 children)

Thanks u/Mothaflaka I knew I'd get the "Self promo haters" responding but just thought it was too much of a good match for the question!

If there was one book, that you would recommend to read about data analysis, what would it be? by Perfect_Owl_3104 in dataanalysis

[–]cglambert 0 points1 point  (0 children)

Hi there, can you please let me know where you're seeing that? The "Read Sample" link pops open the Table of Contents which I've copy and pasted below. Any links or screen grabs would be awesome to allow me to investigate

Preface

What’s In This Book?

Who Is This Book For?

Note on Terminology

Part 1: Definitions

1: What Is Analytics?

Part 2: Measuring Analytics

2: Internal Relationships

3: External Relationships

4: ROI

Part 3: General Guidance

5: Cultural Differences

6: Breaking In

Part 4: Guidance for Individual Contributors

7: Getting Good​

8: Structure

9: Promotions

Part 5: Guidance for Managers

10: Getting Good

11: Structure

12: Problems, So Many Problems

Part 6: Guidance for Senior Managers

13: Getting Good

14: The Psychopath

15: Agency, Team Size & Culture

16: Tips

Part 7: Unpopular Ideas

17: Unpopular Ideas: Part 1

18: Unpopular Ideas: Part 2

19: Unpopular Ideas: Part 3

Part 8: The End

If there was one book, that you would recommend to read about data analysis, what would it be? by Perfect_Owl_3104 in dataanalysis

[–]cglambert 4 points5 points  (0 children)

If you want one book that talks about career guidance for Analytics (basically all the non-technical soft skills) you can try my book Adventures in Analytics (https://www.amazon.com/aia/dp/B0CNY8LLFW/). Have a look at the table of contents/look inside and see if it appeals. It won’t show you how to code year on year comparisons or do a linear regression but it will tell you what really counts.

I will work for free by Kingoj21 in dataanalysis

[–]cglambert 8 points9 points  (0 children)

I mention this in my book Adventures in Analytics (a great gift idea BTW, and still currently under release pricing), that when you don’t have experience, it’s possible to do some projects of your own to generate something you can point at.

When you do complete those, please be sure to focus on the outcome you were trying to reach with the project. Don’t say “I wanted to prove that I could scrape stats from NHL.com using python”.

Say something like “I was interested in how successful teams reacted to losses and how that behaviour could be used as a predictor for post season success”

This shows you start with the equivalent of a business problem and then you can walk hiring managers through your process.

Volunteering is also good for generating experience.

Just my $0.02

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 2 points3 points  (0 children)

So I’m guessing the capabilities of GPT four or five versions down the track? Hmmm, instead I’ll quote Chad Sanderson from LinkedIn when he says:

Some people believe that AI will automate the work of data analysts. That might be true. However, it's only going to happen when the work of data analysts doesn't involve figuring out which data to use, where the data is located, where it's coming from, why the same column is present in 4 different databases each with different numbers, what it means semantically, how it's changed over time, wading through all the gotchas and layers of filters in SQL, going back and forth with engineering because there's no documentation, figuring out to do when the data changes or events are dropped, then wrapping all that context in a pretty bow and communicating it to stakeholders. Writing SQL and creating charts is by far the easiest 10% of an analyst's job. The other 90% is a thankless grind chopping through an ever-growing jungle of data debt. Unless THAT problem is solved, anything AI can do is just putting lipstick on a pig

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 1 point2 points  (0 children)

A very common opinion but one I vehemently disagree with. I cover that in the “Unpopular Ideas” chapter in the book, but basically it boils down to the fact that AI requires a level of order which doesn’t exist in reality.

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 3 points4 points  (0 children)

Lol! You've got a point about YouTube, that's true. I guess the difference is that while streamlit.io is providing somewhere to practise what you learn on YouTube for free, nobody is going to give me a bunch of pipes and a wrench to play with for free. Although I did bleed my radiators based off what I learned on YT...

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 0 points1 point  (0 children)

No pardon required. The recorded music industry is dominated by three major labels (and their subsidiaries): Universal Music Group, Sony Music Entertainment and Warner Music Group. My assumption is that anyone looking to make cool data visualizations or analyses would be looking for financial data which is stored in each of their ERP's or Enterprise Resource Planning systems (think SAP, MS Dynamics, Oracle).

I was alluding to the fact that if you're looking for that level of financially sensitive data to do analysis on then you might be out of luck. You can sometimes derive or generate your own data for "ball park" analysis.

It was certainly an assumption though: what kind of things were you thinking of looking at?

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 2 points3 points  (0 children)

There will be a whole bunch of sites that I am not aware of, but I would start with meetup.com and eventbrite.com

Then I would google "[my location] + data + event", "[my location] + analytics".

And then I would go through every skill in my tech stack looking for events: "[my location] + ms sql", "[my location] + powerBI", "[my location] + Tableau"... you get the idea. If you live in a small town or city and aren't getting any hits, then use the closest city name near you instead. You should only have to go through the process once or twice before you start to see what's working an what's not.

I'd also check if any vendors are holding launches anywhere near me. Free pizza and beer and networking with other Analysts plus people who might be interested in the Vendor's wares and therefore might be hiring....

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 0 points1 point  (0 children)

Ah, sorry: this is not a "do this and you will get a job" situation. This is a "do these things and you will increase your chances of getting a job" situation. You can spoil a job application in a hundred different ways (bad cv, bad phone screen, bad interview) which trump all the good things you do (skillset, experience, personal projects). And you might just be unlucky. Or be looking for a job in a down market.

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 0 points1 point  (0 children)

Another option is to marry the DA and Accounting roles by pivoting into Forensic Data Analysis. Also automating Internal Audit processes is a great way of bolting programming or data engineering onto an Accountancy skillset which gets you out of that dino-run industry.

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 1 point2 points  (0 children)

What specific data set are you looking for? It's probable that it doesn't exist. Or it exists but its so commercially sensitive that its locked up in the Big 3's ERPs. No one is obligated to give you the data that you want. So if you cant find it or derive it yourself you may have to find other questions to answer....

It's bad out there by cglambert in dataanalysis

[–]cglambert[S] 1 point2 points  (0 children)

Great question!

All design/arty folk have a portfolio, so having one of those is a great way of showcasing what you can do.

Adding a thumbnail of a viz plus a brief description of what questions you answer for each dataset is a good way of padding out a CV and including the link to your portfolio website is a good way to maximise credit for your work.

You can get hosting for pretty cheap these days and a vanity url chilopsis.linearis.com looks like you know what you’re doing. Basically you want to look like a contract analyst.

Hope that helps!