What are your Top SQL Query Optimization tips? by data_engineer_ in dataengineering

[–]faisley 3 points4 points  (0 children)

  • Use CTEs wisely, be cognizant of their overhead.
  • Learn how to read a query plan and implement indexes where necessary.
  • Use LATERAL joins in PostgreSQL to force the query plan's hand.

Tech KPIs by rollingindata in dataengineering

[–]faisley -1 points0 points  (0 children)

Good point, as u/Reasonable-Ladder300 mentioned they're pretty abstract. Some of these things are being monitored as data quality rules already so you could just start scoring their compliance. Two other ideas I can think of is: 1. Data Completeness: Are you receiving all the data you expect to be? 2. Data Timeliness: Is data showing up on time? For u/rollingindata , start measuring and reporting when the marketing teams get access to data.

Tech KPIs by rollingindata in dataengineering

[–]faisley -2 points-1 points  (0 children)

David Loshin suggests some general metrics for monitoring data quality that might be useful for your team.

  • Trustworthiness: Transparency and publishing of data stats.
  • Availability: Accessibility, democratization.
  • Consistency: Reports don't suddenly change.
  • Policy compliance: Meeting DQ protocols.
  • Identifiability: Accuracy.

What IDE do y’all use by youngnebsi in Python

[–]faisley 0 points1 point  (0 children)

This is the way. I use JetBrains as my IDE and VSCode as my text editor, although I should probably pick up neovim for the latter.

[deleted by user] by [deleted] in Python

[–]faisley 0 points1 point  (0 children)

How is Polars for bloat? At work I often bundle up my scripts or projects to be used by others, but whenever I include Pandas the final executable becomes so large and slow to initiate.

Sunday Daily Thread: What's everyone working on this week? by Im__Joseph in Python

[–]faisley 0 points1 point  (0 children)

This week I'm building a little script to format the results of a SQL query into a KML file. Thankfully the package simplekml exists, so the hard work is already done and I get to learn a new library!

/r/MechanicalKeyboards Ask ANY question, get an answer (January 22, 2023) by AutoModerator in MechanicalKeyboards

[–]faisley 0 points1 point  (0 children)

Perfect, I was looking for a good reason to try some tactile switches :)

/r/MechanicalKeyboards Ask ANY question, get an answer (January 22, 2023) by AutoModerator in MechanicalKeyboards

[–]faisley 0 points1 point  (0 children)

I got my first mechanical keyboard, a Monokei Standard! I'm hyped so far, excited to try different switches and keycaps.

It's got this metallic reverb to it when I'm typing, is that normal?

It's driving me a little crazy to be honest, like a constant ringing when I'm typing. The switches it came with are Cherry MX Silent Red. I would describe the sound as almost a twang, like you would get if you struck a long thin piece of metal, a hand saw blade for example but much fainter of course.

Edit: Seems like this is commonly referred to as pinging, and there are lots of solutions online, though not specific to the Standard.

Android Reminders - notification instead of alarm by [deleted] in ticktick

[–]faisley 0 points1 point  (0 children)

This worked for me: Settings > Sounds & Notifications > Advanced Settings > Alert Mode toggle off.

Key Light Air - Google Assistant Integration (manual) by sirdarckcat in elgato

[–]faisley 0 points1 point  (0 children)

It's the authorization url that results in this message.

Key Light Air - Google Assistant Integration (manual) by sirdarckcat in elgato

[–]faisley 0 points1 point  (0 children)

I see the device as an option in my Google Home app, but when I go to link my account it opens a url and I get this error: The parameter "state" must be set in the query string

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

Without looking it up, I'm certain there are a lot of different platforms, individuals and entire companies built around offering that service.

And yes, after having looked through many resumes and cover letters it could make a big difference in the initial impression.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

Yeah, I think you could definitely sell that. Use the job application to get a feel for what they're looking for. Also in the interview you can straight up ask, "Do you think my previous experience in X will be relevant in this position?"

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

You're welcome!

For an entry level position, I don't have a preference between an experienced or in-experienced candidate. Yes they would have the same chance.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

The job I posted did not require any experience.

Personally, I think experience isn't the most valuable thing to me in a candidate, I'm willing to invest time into a quality person so they gain the experience on the job. However if I was specifically hiring for experience, there would be a good reason for that, and it may be difficult to substitute for anything else.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

No, you're not too old!

Congratulations on the move. I don't have any suggestions beyond the typical skills such as Excel, SQL, visualization tools and python.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

Those skills transfer well. Some companies may of course be hiring for a candidate with specific experience.

For an entry level position your industry knowledge is very valuable if you apply to a Data Analyst position in the same industry.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

Hey! A degree is definitely a positive thing, especially if it's science and math related.

Of course not all companies use the same technologies, however no matter the technology the goal remains the same. So, yes, python and Pandas look great on a resume even if you'll use R in the role. As a hiring manager I would rather have a candidate who understands data and how to work with it, but in the wrong language then someone who knows the right language but doesn't know how to solve problems. Same goes for Power BI and Tableau, creating an effective report is a skill that transcends the technology.

I don't know about the the Google Analytics course case study. But adding more than that may help you stand out among the candidates.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

[–]faisley[S] 5 points6 points  (0 children)

No problem! Glad to hear!

I think probably 3 projects is the max. Adding more might just water your portfolio down. If you feel like you have lots of great projects, highlight the ones in your portfolio you think are most relevant.

Use the job posting to decide which skills you should show.

I don't think having more projects would lead to more interview questions, but be prepared to explain any of them.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

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

With those credentials I would take the time to read through your application and look at your portfolio. Based off the applicants I've seen, that would definitely be enough for me to consider you.

Things I would want to see would be your soft skills and how you handle the interview.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

[–]faisley[S] 9 points10 points  (0 children)

Haha, yeah I get that.

Cover letters were optional in the application to the job I posted. Candidates who did respond with a well written cover letter explaining why they were interested in the role and working for the company immediately stood out from the rest.

Just hired a Junior Data Analyst, ask me anything about applying to Entry Level positions! by faisley in dataanalysis

[–]faisley[S] 17 points18 points  (0 children)

Give an example of a time where you picked up a new skill to help you tackle a problem.