Hey James, what languages do you know, or what should I learn to help get me into Dev Ops basically? I know Python and SQL, but I have some downtime and I wanted to learn a bit more on Udemy while I can.
Hey there' So honestly I mostly just know Python and SQL myself, but a lot of devops is the surrounding technologies depending on what it is that you end up working on. If you aren't familiar, I recommend building out a little project in python or something, and learning Git if you don't know it already
Gotcha, yeah, I know Git too, and okay! I'll try and do a couple projects, I'm trying to do a couple projects here so that'd hopefully help. Thank you! π
Sounds like you have a pretty good starting base! If you're decent with code and know git, I would recommend starting to look into different cloud stacks. We (shield and tort) are moving to Google Cloud Platform so that would be a good place to get a lay of the land
Big asterisk on the next part, but I would also recommend trying to learn Docker. We use that within the company and I'm attempting to wrap my head around it now.
okay, thank you so much, I'll keep working on that stuff while doing my little project
That's awesome! Keep me up to date with your progress
Hey there' Off the wall but how busy are you??
Generally but also like this next few days/week
Not super busy honestly, we're kind of slow currently, I'm working on the Benchmark Dashboard here and there, but other than that, I'm pretty free, why whats up?
I think integrations is going to need some help with some stuff in the future, and I brought up your skill set to Dustin, but I also wouldn't want to volunteer you or anything, especially before speaking to your leadership lol
I will absolutely love to volunteer for things lol but I will talk to brittany about it later today about it, just to see if she's okay with it
Hey @James Turner so what exactly was the point of that meeting? No one told me anything about it and I just got sent the invite, and other than 'upload your code to github' I don't really understand why I was there tbh. I don't like deploy software or anything, most of the code I do is local now since ward and dustin comes screaming bloody murder whenever someone touches lawruler via API so I mostly just manipulate excels and google sheets. So I'm just slightly confused and I know Brittany doesn't know anything code-related basically so i'm asking you lol
Honestly I learned about the meeting 5 minutes before the meeting, I'll head over later
@James Turner do you use looker studio or looker to make your dashboards?
I originally used Studio, but was requested to move to Looker Enterprise so I've been building on that lately
SORT of, i'm trying to build something similar to Ryans dashboard (just the look of it) specifically for our monday reports , but I don't think i'm able to with looker studio. Trying to get into that table format with text values - I'm used to PowerBI or Tableau so i'm still learning looker honestly, but i'm starting to think it's a handicap from me using looker studio but idk for sure honestly
Sorry at the dentist rn- thus delayed responses
oh omg, no worries at all! I thoought you were here i'm so sorry! Whenever you get a chance, can you just swing by my desk, no rush! π i wanna pick your brain
sorry! I was in a meeting, whenever you have time again, I'm back here again π
You're all good- I'm bouncing between like 4 unrelated popup projects right now for Carter, Cam, and Ryan otherwise I would be more readily available lol
I leave at 2:30 today, but no rush at all! we can meet at any time this week or next week whenever you have time π
@James Turner! I have to cancel the meeting today - my dr had a cancellation and im leaving early to goto the dr
honestly, I was just wondering if Looker Studio vs Looker Enterprise is better, but I did some research and I'll probably have to use looker enterprise for what we wanna do, and I THINK Brittany has an account already
What time are we meeting today? @James Turner 11 I believe? right?
Yes 11- Thank you!
do you want me to come to you or you coming over here? i'm running to the bathroom real quick
Hey sorry- In with Carter and Ward for a few minutes, but I'll head over to you. Do you have the whole hour available?
no rush! i'm free for the rest of the day, so any time works π:skintone3:
only looking at it from a money aspect as it's 24/month and viewers can view reports for free whereas we believe viewers with looker have to have an account and pay 30/month we believe
It's the dashboarding tool I learned on- It's good, we toyed with the idea of using it here but Ryan pushed really hard to do everything in Looker enterprise
the entire integrations team wanted it lol
LOL i'm not shocked, that's a trend - the whole company wants 1 software, and then some balding white man ruins it for everyone lol
but ok, so do any of your guys looker dashboards go to the firms for them to view? that's all we're worried about, cuz our dash's would be external for the firms to look at - so if the firms already have a viewer account for looker, then we should already be good but we don't know. I should probably ask ryan huh? edward said he'd have to ask ryan since he does all of that
Not at the moment no, I brought that up before because right now we don't even have looker enterprise accounts for all the supervisors
gotcha, so i'll look into powerbi then just for cost savings for a little. We'll see lol but okay, have a good night i'm outta here!
I know youβre super busy - but whenever you get the chance (whether it's today tuesday wednesday) just swing by - it's not super high priority but eventually, no rush tho! π
Heyo- I'm getting that code fixed now, with hourly scheduled updates for questions
Next is to just make you an editor on looker
Gotcha, thank you! β€οΈ sorry for bugging you about this, we just want to get it done honestly and make these dashboards so that it'll reduce our manual re-work - but I'll probably be bugging you more about this stuff going forward a little cuz i'll probably be the main person doing this on brittanys team
Genuinely you're all good, you're not bugging me!
I have long term goals of being a leader in tech, so this is really good practice for me to be balancing multiple projects where I have a foot in, but I'm not the primary engineer doing the ground work.
I sent the invite to aidan@tortintakeprofessionals.com
I'm still working out the bugs in RBAC so please be respectful about keeping to just the Q&A and TIP Operations boards that I set you up with as your homepage
I just would rather get into doing dashboards and more analytics (which is what I thought this dept was that I'm in was going to be) so I'm trying to get my feet wet with looker cuz i'm more proficient in like powerbi and tableau lol but of course! thank you!
I'm confused though, isn't looker pulling from BigQuery? so anything i have access to in bigquery i would have access to in looker? I have some financial data access in bigquery but i obviously don't use or look at it, but that's why i'm confused why you had to make a specific board that I can use
for each table in Bigquery, I have to set up a connection from Bigquery to Looker which is called an "explore".
Multiple "Explores" live in a data "Model"
and roles and permissions for what data you can access are are given on a "Model" level.
I gave you access to the "tip_datawarehouse" Model, and the specific explores that will be helpful for you are:
12 - Law Ruler Question And Answer Data 10 - Five9 and Lawruler Data Joined 8 - All Law Ruler Leads With Enrichment
I recommend starting with making a personal folder, building your dashboards there, playing, learning, ect. We can always move the dashboards to a shared folder later
The connection is there, but it's two seperate accounts and systems
ohhhh, gotcha gotcha, cuz I remember you showing me the explore and all that, are you able to specifically give me access to the tables in 'lrdata' and 'reportingmonday' and 'reportingsandbox' and 'reportingworkspace' ? idk if it works like that, but those tables in bigquery don't have any financial data in them whatsoever, it's strictly lawruler data but data I might need at some point (this can be done later, doesn't have to be now i know you're kinda swamped)
Sry for delayed response- had to run home rq to swap out my partners ice pack and do meds and stuff. She just got the first half of her ACL surgery on Tuesday so were finding the flow lol
I gotta get a thing for ryan and brittany rq, but i'll look into it