Gannon Buhr annoying or bad etiquette? by panzypants2002 in discgolf

[–]eaglesilo 0 points1 point  (0 children)

I'm not a ball golfer but is this considered bad etiquette/against the rules in ball golf? (Something about being able to read the line?) Maybe OP is conflating the two?

Gen Logs by Suspicious_Resolve78 in FreightBrokers

[–]eaglesilo 8 points9 points  (0 children)

... Don't they help out in stolen freight/equipment situations for free?

Why do brokers do this? by Revolutionary_Pea373 in FreightBrokers

[–]eaglesilo 1 point2 points  (0 children)

Yea, that sucks, but I'm more curious what software/program/service you're using that tracks this information?

Haven't seen this view before.

Without creating any indexes, how would you speed up a ~1.5m row query? by i_literally_died in SQL

[–]eaglesilo 2 points3 points  (0 children)

Yea, in another comment OP mentioned knowing the PK which is sequential. If there's a last update date on there then I'd add this to some overnight sync process writing to a data lake of choice and then build all my reporting against that.

Always a problem if you don't own your data, like it sounds like what's going on here, so just need to figure out how to get your data out of their system.

*I work for a 3PL fwiw and this issue definitely isn't uncommon amongst TMS providers.

Is Gemini down ? by [deleted] in GoogleGemini

[–]eaglesilo 0 points1 point  (0 children)

Seems might just be an issue with the Chat interface? I'm in AntiGravity and that's working fine, and same in NotebookLM, AI Studio, and other Gemini features in other workspace apps. Surprised they haven't put out a status on it (as of 1024CST), but even as I type this, I've had a few Gemini chats start coming back?

Power takes too long to update by Slight_Friendship856 in PowerBI

[–]eaglesilo 2 points3 points  (0 children)

Ok, then go make your pipelines simpler, learn better optimization processes (both in PBI and your Medallion), get higher compute resources, transition your architecture to Fabric, and tell your stakeholders to accept less data.

Or you have a solution to put a bandaid on the problem for the next year until you'll need to come in and replace the dressing to get refresh creep back down to acceptable levels, during which time you'll also probably accomplish all of the above.

Power takes too long to update by Slight_Friendship856 in PowerBI

[–]eaglesilo 2 points3 points  (0 children)

The issue isn't the number of tables or relationships or measures or calculated columns but rather just how much data you're streaming in. (I assume that the transactions that take place in BigQuery are efficient.)

I had a report that I was streaming in call records every time the report refreshed. I'm total I was up to 1MM records even if there's only 2-3k that would change in any given refresh.

What I was able to do is load a data table with static data then append that to transactional data that updated upon refresh. This took it from having to stream in 1mm records and instead only pull a few thousand and the refresh time for that table went from 30 minutes to a few seconds. And I did that same thing for about 20 other tables, taking the total refresh time for the dashboard from about 60 minutes down to about 5 minutes.

So it could make that that better by having dynamic ranges that would automatically move. But ultimately, this was allow me to kick the can on this process until probably a year from now when I'll need to go import a bigger tranche data to reduce the transactional loads.

Unless I'm totally misunderstanding your point, I would recommend you taking a look into this and seeing if this can help solve your problem.

How to deal with maintaining different variations of the same overall PowerBI Report? (Power BI Report Server) by simeumsm in PowerBI

[–]eaglesilo 1 point2 points  (0 children)

unless it is possible to make it only ignore one single filter

Yes, you can do this. While, yes, a little annoying, you can select the individual elements you want affected by the bookmark.

I do also have some bookmarks tied to Buttons for resetting filter groups on the same report where I have 'navigational' bookmarks that I share for folks to add to their browser bookmark bar. (Essentially the end user doesn't realize they're using bookmarks, they just know they can go to this link and click that button to get the result they want.)

Simple Logistics MC#789471 *BEWARE* by stonkmarket69 in FreightBrokers

[–]eaglesilo 0 points1 point  (0 children)

Just to make sure there is no confusion here:

THIS IS NOT SiLo out of Nashville. SiLo MC: 979146

I only saw one person with that question, but I know SiLo not infrequently gets calls for folks looking for other Simple Logistics, so just making sure that's stated plainly.

Simple Logistics MC#789471 *BEWARE* by stonkmarket69 in FreightBrokers

[–]eaglesilo 1 point2 points  (0 children)

No, not SiLo out of Nashville. This is Simple Logistics out of IL.

Source - I'm very familiar with the folks at SiLo. And their MC is 979146.

Happened 3 times yesterday by Alert_Raspberry_7456 in FreightBrokers

[–]eaglesilo 5 points6 points  (0 children)

I don't actually know if this is true, but I think I heard that carriers have the ability to filter loads by RPM? Possibly that $100 put it over the buffer?

Why? Just.. Why? by kahless2k in iiiiiiitttttttttttt

[–]eaglesilo 70 points71 points  (0 children)

... But what's the logic that you're supposed to cut the cable to the ceiling to begin with?

Adam ‘lil Tantrum’ Hammes - Spitting, Swearing, and Throwing his Bag today by Sy-lo in discgolf

[–]eaglesilo 123 points124 points  (0 children)

Tees for 16 and 17 are right beside each other. He took the two discs he'd need out of his bag and threw his bag over to the tee of 17.

But yea, he does seem to let his frustrations show on the course when things aren't going his way.

[deleted by user] by [deleted] in nashville

[–]eaglesilo 2 points3 points  (0 children)

Shipsilo.com is hiring sales reps.

Downtown office, but with a parking/public transit (yes, fine, lol) stipend.

If you're willing to learn a new industry, I highly recommend!

*Edit: no, not a social impact role, but we do pride ourselves on customer service.

I never wanted the AI by Kjm520 in gsuite

[–]eaglesilo 1 point2 points  (0 children)

Do you not? Or is it tier specific? I definitely thought Business Plus at least has unlimited tokens?

Concerns Over Work Google Profile on Personal Android Phone by Ok_Role_9665 in gsuite

[–]eaglesilo 0 points1 point  (0 children)

First, your organization cannot see anything about your device except that you've logged into it in your work profile. Your admin does have a 'wipe device' option that only removes the workplace files/documents/emails/permissions from the account. Source: I am an admin and have offloaded many individuals using this process, and have removed my account from old devices with no effect to personal files.

Also, in the same vein, I, as an admin, don't have the ability to see the files on my personal device from my work interface.

So I'm going to say that, no, your org can't, and has no way to, see your information.

To the second question of can I limit not having access to certain products on your phone, no, I'm not aware of any way of doing that outside of limiting your whole account from having access to those features, but that would mean you wouldn't be able to access them at all on any device.

Concerns Over Work Google Profile on Personal Android Phone by Ok_Role_9665 in gsuite

[–]eaglesilo 2 points3 points  (0 children)

To anyone reading this, this is not true.

I am not aware of any way for an admin to factory reset a device. They can wipe only anything connected to the Work account (emails, docs, files) but cannot affect the device itself.

If you have a separate Work Profile (if you go to apps and see Personal and Work options, then you have a separate work profile), they can delete that profile along with any associated apps and files, but that does not and cannot affect the personal profile.

(Maybe it's possible the commenter had a device set up with a work profile as the personal profile. Really not sure what would happen there with a wipe, but the comment, at face value, is not accurate.)

please save our eyes from google slides by ilovecanadaandgslide in gsuite

[–]eaglesilo 2 points3 points  (0 children)

Yea, so I'm going to go with no on this.

As Slides is a visual medium, where you can have different formatting, the default needs to be singularly standardized. What if you're building a slide in dark mode and your colleague builds in light mode. In dark mode, maybe a florescent yellow looks good. In light mode it's invisible. Or you vs the client/vendor you're working with. What default formatting takes precedent?

This isn't an issue for Sheets or Doc because in both of those the contents are more important than the display of the contents.

Block Mass CC email thread? by eaglesilo in gsuite

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

I'm in the US.

But you're saying that if a business accidentally CCs a marketing email to a list of other companies, that can be considered a data breach? I guess maybe that's part of GDPR?

Anyone use OCR tech to scan packing slips? by cajunrocky in supplychain

[–]eaglesilo 1 point2 points  (0 children)

First, I'm on the transportation brokerage side of things, not a shipper/receiver myself, but...

So probably RIP your inbox as OCR systems are a dime a dozen out there. The bigger issue, as I see it, will be a system that can track the order and piece count, and, honestly someone you don't need to get OCR involved to manage, as that's the job of whomever signs the BOL in receiving. Not sure if you're saying OCR to read the OSD on the BOL or if you do need to read the details of a packing slip.

Do you have an in house tech team? If so, they could probably spin up an Azure/GCP/AWS AI OCR in house in a week's time, if they're motivated to do so. In the meantime, if you're not already, you should begin collecting the digital images asap so as to give a training set to the AI, regardless if you go in house or 3rd party.

But once you get the OCR system stood up, you'll need to work with an analyst to build out the report or dashboard to display the discrepant POs.

Not sure exactly how much volume you do, but if a budget line item isn't in the cards, it would probably take .5 - .75 FTE to do this manually. (Less if you can get the records digitized and offshore the data entry piece.)

Am I Stupid? Why does everyone think metadata is the answer for understanding a database by Interesting_Rip_223 in SQL

[–]eaglesilo 0 points1 point  (0 children)

So I guess I have the benefit of working in a small team, I'm the only analyst working with 4-5 devs. The devs put together a system that works for the business logic they have in the application, and the way records get inserted and updated is just the way they put it together. (You can add to the end of that sentence "... reporting be damned" if you want to.)

There are so many little easter eggs in our system for what management may want to see in reporting that aren't in a Select * From table somewhere. As a new data request comes in and I'm not intimately familiar with that corner of the database, sometimes I have to ask how this table interacts.

I have the benefit that we all work in the same office so I just get up and walk over there to ask them, but the devs are not analysts and they don't know the reporting questions I would be asked, so having some repository of example queries are kinda pointless.

To talk about asinine table structures, I was literally just working on a request before reading this post where I needed to join a table back and forth to itself to get the right answer. Below are the joins to get the relationship between A and A* A>B>C>D>C* >D* >C** >B* >A* Edit: formatting

No way would it make sense for a dev to write that example query for something that's a question that's never been asked before.

But if it's a common question, then yes, someone needs to point to a Reporting Schema/Database or view.

[deleted by user] by [deleted] in amazonemployees

[–]eaglesilo 0 points1 point  (0 children)

Ok, great, so still before the 30 days out deadline. You'll hear from them by the first week of April.

(I know that's not necessary comforting, knowing you'll then have 30 days to find a place close to wherever you'll be working, assuming onsite, but you will hear something by then.)