Edward Weber (edward@tortintakeprofessionals.com)
2025-01-14 15:37:22

Edward Weber accepted your invitation to join Slack — take a second to say hello.

Ahsan (ahsan@shield-legal.com)
2025-01-24 14:12:14

hey can you come into the integrations cave for a minute. Josh has a question for storing env variables into a jupyter notebook

Edward Weber (edward@tortintakeprofessionals.com)
2025-01-24 14:41:24

Hey @Ahsan sorry I went into lunch when you sent this. You good or still need help?

Ahsan (ahsan@shield-legal.com)
2025-01-24 14:42:02

Me and Dustin have a question for the current benchmark file. If you have a moment we would appreciate your help.

Edward Weber (edward@tortintakeprofessionals.com)
2025-01-24 14:42:15

kk i'll come thru

:cool_cool_cool: Ahsan, Edward Weber
Edward Weber (edward@tortintakeprofessionals.com)
2025-03-18 15:43:05

:rdj_hy:

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-03 15:22:14

Just for coding reference here is the bigquery table that my part of the code does:

image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-04-03 15:23:22

These are the two functions that runs the code: The bottom one adds the .xlsx files into storage and the top code will take that data and insert / update the bigquery tables

image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-04-03 15:24:15

Also these are the two pub/subs to run them too. They match the name of the cloud functions:

image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-04-03 15:25:24

The only part that isn't automated is I have to run your guy's code first and email it to myself which is the Flatirons Benchmark.xlsx From there storagebucket code knows to extra the latest ones and insert them into the cloud storage bucket and the BigQueryTables function will take those .csv and make it into a dataframe and insert it into BigQuery (the two tables). And that's it

Ahsan (ahsan@shield-legal.com)
2025-04-03 15:25:53

Yea we will fix that portion in the refactor to be automated, or should I say you will fix that hehe

🥹 Edward Weber
Edward Weber (edward@tortintakeprofessionals.com)
2025-04-03 15:26:15

That works haha

Ahsan (ahsan@shield-legal.com)
2025-04-15 17:22:12

Zach Wilson data engineer

:meow_attention: Edward Weber
Ahsan (ahsan@shield-legal.com)
2025-04-15 17:22:23

Data engineering up

:meow_attention: Edward Weber
Ahsan (ahsan@shield-legal.com)
2025-04-16 11:54:45

correction data engineering io

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-16 11:55:14

Thanks ! :catroombaexceptionally_fast:

Ahsan (ahsan@shield-legal.com)
2025-04-17 17:07:26

Also when you run the benchmark in the am, drop it in the main channel for all

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 18:16:17

Will do Ahsan 🙌

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 18:16:34

Appreciate the reminder

Ahsan (ahsan@shield-legal.com)
2025-04-17 20:25:49

Also probably don’t tell James you will start being pulled in for the work from engineering. Rather not tip off ward. Also told McFadden to pull you as my backfill.

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 20:26:50

That makes sense

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 20:27:08

I told them earlier ago that I will still be helping as I transfer it over to Dustin

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 20:27:12

So they should understand

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 20:27:50

So once it is fully built as one function then I wouldn't need to step in (unless needed)

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-17 20:27:53

If that makes sense

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-21 11:16:27

Morning @Ahsan

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-21 11:16:59

This weekend I was learning about power query, power pivot, dax, etc for BI skills and I can tell why you like excel compared to google sheets now lol.

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-21 11:17:13

Being doing sheets wrong all this time 🤣

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-21 11:17:23

Well not wrong but not to it's full protentional

Ahsan (ahsan@shield-legal.com)
2025-04-21 11:55:59

Sheets can do the same thing but you need to know the functions like the back of your hand, PQ is much more drag and drop so novice users become power users quickly

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-21 12:03:59

Yes that makes sense

Ahsan (ahsan@shield-legal.com)
2025-04-29 12:48:18

added your shield to the integrtions channel

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-29 13:32:16

Just seeing this now

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-29 13:32:23

Thanks for the add 🐐

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-29 17:17:06

Here is the powerquery for it just in case you want it as well

Flatirons config.json.zip
Ahsan (ahsan@shield-legal.com)
2025-04-30 13:28:45

in github do you have admin rights for the benchmark script repo?

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-30 13:33:21

My guess I do not but not 100% sure

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-30 13:33:30

I will make my way over to the cave

Ahsan (ahsan@shield-legal.com)
2025-04-30 13:33:42

grabbing some coffee, swing by whenever

Edward Weber (edward@tortintakeprofessionals.com)
2025-04-30 13:34:05

Okay let me know when you are available ^

👍:skin_tone_4: Ahsan
Ahsan (ahsan@shield-legal.com)
2025-04-30 13:50:36

onsite

Ahsan (ahsan@shield-legal.com)
2025-05-05 11:44:39

we have our huddle at 10 so we can meet after

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-05 11:44:58

That works with me :meow_party:

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-05 14:56:43
Flatirons Benchmark_Flatirons.csv
Ahsan (ahsan@shield-legal.com)
2025-05-05 15:05:10

here is the table SELECT ** FROM `shield-legal-bi.sl_dashboard.FlatIrons_Financials_AT`;

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-05 15:56:16

Thanks ! Okay I shall see if I can find that table and connect to it. If I can then I'll bring the laptop over so we can build the dashboard

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-05 16:00:50

Ah I looked it up. The reason we couldn't see any of the "bigquery tables" even though we got looker enterprise connected to bigquery database is since I need to look up how to write the LookML first. Then it will add it to a place called "explorer" which then we can use that to pull the data for our visuals.

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-05 16:01:07

I will let you know once I got the LookML set up so that we can then create the visuals / tables, etc

Ahsan (ahsan@shield-legal.com)
2025-05-05 16:01:46

:copy_emoji:

:cool_cool_cool: Edward Weber
Ahsan (ahsan@shield-legal.com)
2025-05-06 11:59:05

Updates for huddle

Enroute, if I don’t make it there in time. Updates, Edward did financials for fl. Emailed nancy. Working on the fl financials dashboard for looker. Working on the modeling

Ahsan (ahsan@shield-legal.com)
2025-05-06 14:35:53

example of multiple case when statement ``-- Create the temporary table CREATE TEMP TABLE temp_standardized AS SELECT ColumnB, CASE WHEN ColumnB = 'toyota' OR ColumnB = 'Toyota' THEN 'Toyota' WHEN ColumnB = 'nissan' OR ColumnB = 'Nissan' THEN 'Nissan' ELSE 'Other' END AS Standardized_Make FROMyourdataset.yourtable`;

-- Use the temp table SELECT StandardizedMake, COUNT(**) AS Count FROM tempstandardized GROUP BY Standardized_Make;```

:eyes2: Edward Weber
Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:47:44

Hey you stated for me to not use the V1 however ther eis nothing populating for Flatirons CL Query

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:48:00
image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:48:07

Only V1 has the query for CL

Ahsan (ahsan@shield-legal.com)
2025-05-06 14:48:36

cl wont have anything populate because camp Lejeune is closed

Ahsan (ahsan@shield-legal.com)
2025-05-06 14:48:39

refresh your page

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:48:56

I mean there isn't a query for me to run

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:49:09

For FLatirons CL Query

Ahsan (ahsan@shield-legal.com)
2025-05-06 14:49:10
image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:49:38

It likes you since mine doesn't show anything

image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 14:55:10

I shall just type it in and resave it since my end doesn't display lol

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 16:42:51

Where did you get this file:

image.png
Edward Weber (edward@tortintakeprofessionals.com)
2025-05-06 16:43:22

You know what scratch that

Ahsan (ahsan@shield-legal.com)
2025-05-07 15:00:35

Conference room? Where are we doing this meeting

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-07 15:00:54

Meet is canceled but may you pop by at my desk for some flatirons stuff

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-07 15:01:08

Going to record some loom SOPs and kinda want to pick your brain again

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-07 15:54:37

@Ahsan Question for you. After running the rewrite.py file do you normally run the pivot table as a last step or is that before doing the financials. I only ask since I am looking at the SOP and it is in the middle so I wonder for your process if you do that pivot table in the middle or last step

Ahsan (ahsan@shield-legal.com)
2025-05-07 15:55:20

Benchmark -> financial injection -> rewrite.py file

Ahsan (ahsan@shield-legal.com)
2025-05-08 10:30:06

Financial run going ok?

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-08 10:32:32

Thanks for checking. I have been working on Ryan's financials stuff so far today sadly lol

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-08 10:32:48

Once I finish his stuff then I am going to jump back into flatirons financials

Ahsan (ahsan@shield-legal.com)
2025-05-08 11:03:18

Damn his shit must be a mess

Ahsan (ahsan@shield-legal.com)
2025-05-08 16:12:06

Everything was good?

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-08 17:55:28

Sadly I just did Ryan's financials today and tomorrow I have to continue doing it. So probably Monday will be my next run with flatirons financials

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-08 18:14:53

But how is it with you over there 👀

Ahsan (ahsan@shield-legal.com)
2025-05-08 18:28:55

Just setting up monthly reporting, once this clears I should be good for the rest of the month

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-08 18:29:19

Then you get to kick back and enjoy the rewards huh

Ahsan (ahsan@shield-legal.com)
2025-05-08 18:30:54

Yup

:cool_cool_cool: Edward Weber
Ahsan (ahsan@shield-legal.com)
2025-05-12 09:58:16

Have you run flatirons yet?

Ahsan (ahsan@shield-legal.com)
2025-05-12 10:22:48

You comfy running the financials today?

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:23:11

Good morning Ahsan. We shall see. I shall ping you if I have any questions but I think I should be good

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:23:22

I still have to finish Ryan's stuff today (Today is apparently last day)

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:23:30

Worked this weekend doing Flatirons stuff and his stuff

Ahsan (ahsan@shield-legal.com)
2025-05-12 10:23:37

Damn that shit is still going on

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:23:40

Good thing I am still hourly (for last weekend)

Ahsan (ahsan@shield-legal.com)
2025-05-12 10:23:51

Well let me know, should be in around 9:30ish

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:24:30

Yeah it is because James deleted the table I used to get my talk time so I had to rebuild the SQL code test things, then also work on Flatirons reconciliation and create a email report for cam, and then do another task for ryan, etc all in one day lol

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:24:35

Appreciate it bro

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:25:36

I am going to see if I can "train" someone to do Ryan's stuff because Ryan doesn't want to have to retrain someone to do his stuff but once James finishing building his new table I think that new person should do it or him since that means I will have to rebuild my code again / do different processes which I think he should do it since it is his table lol

Ahsan (ahsan@shield-legal.com)
2025-05-12 10:26:11

Yea mention that to McFadden

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:26:46

I will. Or me and James can take turns or something more fair. Since they didn't want to give him that task because "it will be too much for his plate" but at the same time is it not a lot of work for my plate too? lol

Edward Weber (edward@tortintakeprofessionals.com)
2025-05-12 10:27:09

That's why I am creating those SOP videos on how to do Ryan's stuff and from there James can just follow it to the T and if he needs help he can slack Ryan lol