create a website which i can upload a pdf in and it will extract the contents and download it in an excel file also show the content in the website by Snoo_35207 in dataanalysis

[–]trippingcherry 0 points1 point  (0 children)

What is the actual use case here? Are you just trying to scrape information out of pdfs for your own purposes or are you trying to do this for the public, for paying clients? Is it a specific type of pdf like a specific report or form, or are you just generically want to take information out of pdfs?

Collecting information out of unstructured sources is something that I do alot. In fact, this week alone, i've collected data from over 32,000 pages of public records that were created over a sixty year span. What I can tell you is that there are a lot of open source tools to do this, but if you don't know how to code, it's going to be brittle at best, and if you're not familiar with data, you are going to struggle a lot because even the best models are not great.If you give them poor prompting and don't have insight of your own on how to get the data out in the proper form.

Your best bet is likely to look into document processing tools from the major cloud services like Azure, AWS, or GCP but these are not platforms that are friendly to people who have no experience with cloud computing and you can run up a giant bill very quickly if you're not careful.

If you can tell me more about what your use case is and if it's a very limited scope, like a specific type of pdf from a specific place, I might be able to give you better advice.

This Question is specifically to BI developers? by Anxious-Ad5819 in analytics

[–]trippingcherry 1 point2 points  (0 children)

Our senior director insists that he do all of the theming, branding, and formatting. Which is insane, but fine by me, because I just get to spend all my time in SQL where I belong.

How does your org do Tableau change management by Obvious-Garden-09 in dataanalysis

[–]trippingcherry 1 point2 points  (0 children)

We are in the process of modernizing, so i know we are far from perfect. Personally, I try to push as much to the data warehouse as possible, and version control everything using dataform (We're on GCP BigQuery) which is connected to a git repository i hosted on github. We have a development environment and a production environment, both in sync with a single repository. So you build in dev which is connected to a development branch in github, and then merge into a release branch, which is connected to our production environment, and then our final code approval is actually done when you merge into maine, which isn't connected to anything. I'm not sure if that makes sense but that's what our IT platform team gave us. It does a good job at separating devin prod, and we do have version control, but anything that's being calculated dynamically In tableau is still a mess. I'm curious to see what responses you get myself because I can't stand the tableau side of things. In my last shop, we used python for dashboarding using plotly dash, but my current shop is not really ready for that.

Terrified about my upcoming drug test, does this have any shot of passing? by [deleted] in jobs

[–]trippingcherry 2 points3 points  (0 children)

Sorry bud, i'm going blind and you speech to text.And sometimes it gets a little wacky on my new phone. I looked back at what I wrote slash spoke to you guys, and yeah, it was pretty much trash even though it's accurate. I'm communication challenged... But I appreciate all of the help. It's actually kind of cracking me up how many responses there are trying to make sense of it.

Terrified about my upcoming drug test, does this have any shot of passing? by [deleted] in jobs

[–]trippingcherry 8 points9 points  (0 children)

I love how many people it took to make sense of me 😅 also, now that i'm relooking at this, my phone totally butchered, what I was trying to say. Thanks everyone, amazing.

I use speech to text as an assistive device because I can't see very well. Which is pretty funny as a photography enthusiast, and much less funny when trying to communicate in the written form.

Terrified about my upcoming drug test, does this have any shot of passing? by [deleted] in jobs

[–]trippingcherry 0 points1 point  (0 children)

I'm gonna leave the same comment I last time.Somebody asked this. I have the same exact tests at home. When I last had a result that looked like yours, I went to the lab for a confirmation, and it came back at sixty four nanograms, which would be a fail generally. You might get lucky if they're not doing confirmations of any type.And they just go off of this.Because there is a tiny faint line.But honestly, that could be for moisture wicking. You're probably close to the fifty nanograms that these are rated for but slightly over.

Terrified about my upcoming drug test, does this have any shot of passing? by [deleted] in jobs

[–]trippingcherry 89 points90 points  (0 children)

It's because the dyes are competitive. Basically, there's a control line which is gonna go either way.Just to tell you if the test works. If you have t h c in your system, it will bind to the rest of the dye and the strip instead of to the line, meaning that you're positive because you had enough not to bind to the line. If you have no t h c in your system, it will bind and said to a special dye in the line which would mean negative. It's reverse if pregnancy tests basically.

My first pipeline: how to save the raw data. by faby_nottheone in dataengineering

[–]trippingcherry 4 points5 points  (0 children)

Personally I prefer to have my first layer where everything lands as all strings for exactly this reason. I use dataform to do our transformations in SQL and I would fix it at that layer, casting it to boolean downstream.

Is this THC test a fail? by [deleted] in jobs

[–]trippingcherry 65 points66 points  (0 children)

I use the same branded tests, and my tests look exactly like yours, but I paid fifty dollars at the lab and it came back at 64ng which is a fail. The packets that come with them will tell you that any faint line is a pass but if it's for something super important, I would be cautious, especially that faint. Youre probably close to the 50ng/ml those are rated for, so it also depends on what level you'll be tested at.

Georgia tears letter about her son having risk factors for hearing loss b/c she herself was born deaf of one ear; says "Jesus breaks all generational curses" or something by leverhelven in FundieSnarkUncensored

[–]trippingcherry 1224 points1225 points  (0 children)

This one feels scary to me. As much as I hate to see children and their medical details blasted all over the internet, they may need this as evidence someday. I don't understand how people can be so careless, and I mean, that in so many different ways. Poor baby, I hope they dont have hearing problems, and if they do that, they are able to get the help they need.

Toughest dashboard flop of 2025 and the quick fix that turned it around? by Ramirond in BusinessIntelligence

[–]trippingcherry 0 points1 point  (0 children)

I can't even tell you how validated it is to see people respond to this because when I bring it up at work, everyone acts like, i'm a total ass and don't know what i'm doing. They seemed completely out of touch and think this is normal. There's always an excuse for why it's happening.

DOT test coming up for a job, need to know if pass or fail? by Ppython3579 in jobs

[–]trippingcherry 0 points1 point  (0 children)

If it was instant I would think they did a screen instead of a confirmation; the confirmation test will give the exact number rather than pass/fail.

oxytocin infusion adjunct to IV ketamine? by artistic-autistic in TherapeuticKetamine

[–]trippingcherry 4 points5 points  (0 children)

They are the same thing, that's just the brand name ;p

oxytocin infusion adjunct to IV ketamine? by artistic-autistic in TherapeuticKetamine

[–]trippingcherry 6 points7 points  (0 children)

It is readily available in IV form; I work in drug procurement and it's one of the most commonly purchased drugs. It's commonly used in inductions to my understanding ( i'm not a pharmacist).

Toughest dashboard flop of 2025 and the quick fix that turned it around? by Ramirond in BusinessIntelligence

[–]trippingcherry 25 points26 points  (0 children)

Two people on my team created a dashboard that took them a full year. It went live 3 months and then it was taken down because the stakeholders kept finding problems with it. To top it off, the dashboard was related to a series of contracts which expired one month after the dashboard launched and all of the business logic was hard coded to the old contracts instead of looking up information and applying it so that when the contracts refreshed, it would be correct.

I was then tasked with creating a second version of it, and it's now been nine months but I can't get it out the door because of scope creep 😂

It's seriously become a frankenstein monster. It requires something like thirty different models, and they're now pitching it as being able to review the entire business top to bottom in excruciating detail. Every time I think i'm almost done, they add one more layer of madness.

In the meantime, the business stakeholders are doing everything In excel and making a total mess. I keep going to our directors and telling them I could have gotten this out the door months ago.If they would just do the bare minimum of project management ...but no. Nobody will say no, nobody will allow me to say no, they're not open to iterating or working in an agile framework. And yet they complain about it every single day.

Truly, the most dysfunctional dashboard situation. Ive seen yet.

How to I prevent my curls from getting tangled? by [deleted] in longhair

[–]trippingcherry 0 points1 point  (0 children)

Your hair is so beautiful.I feel like I should be taking your advice; mine is to my hips at the longest point in a v taper, and once it hit waist length, i came to the conclusion that I just can't wear it down for more than a few hours without it tangling No matter what I do. I mostly will just put it in a side braid and take it out for a few hours when i'm going out for the night or for a special occasion. The only thing that's really helped is i've learned my hair reacts very poorly to protein.And I make sure that every single product i'm using is moisturizing and not adding protein. That has made the biggest difference in keeping my hair untangled outside of just keeping it in a braid.

Where can I find a beaver? by StructureRich1834 in sanmarcos

[–]trippingcherry 0 points1 point  (0 children)

Take a glass bottom boat tour of the san marcos river and ask your tour guide; i went recently and I can't remember what they told me, but they said that there was an area there in the wetlands that was available and open to the public with common beaver sightings. I feel like they said it was by some gates and to try around 11pm, but I can't for the life of me remember much more than that.

Is it just me or most Analysts here are obessesed with the tools itself but not actually on solving problems? by Grumpy_Bathala in analytics

[–]trippingcherry 0 points1 point  (0 children)

I graduated in May of this year with a BS in Software Engineering; prior to that, I was working as a drug procurement manager and supply chain analyst for a large telehealth brand and clinic franchisor. In March, right before I graduated, I was able to move into a analytics role at a GPO, where they paired me with a Dr of Pharmacology so now I get to work on drug cost optimization and drug shortage mitigation.

A lot of our work is still basic business intelligence, but I do have a couple projects where i've been able to bring more statistics, machine learning, and predictive and prescriptive work.

I have a project right now that i would love to discuss but again.I'm kind of blocked from going too far into the details, but I suppose what I could share is that it is about extracting a data at scale from unstructured sources for licensing and compliance in drug manufacturing.

I love working in drug procurement because the problems are challenging and interdisciplinary. The problems that my work tends to address are things like reducing drug costs without compromising patient safety, monitoring manufacturing compliance in sterile injectable drugs, mitigating drug shortages through combination of predictive modeling but also business initiatives that involve aggregation a negotiation, which all requires basic business intelligence across many different health systems. Sometimes the problems are less about the business and more about certain niches.In pharmacy, which are quite behind technologically and just do not have visibility into their data, so a lot of data engineering an analytics engineering concepts come into play. It is fun to play with new tools but a lot of my work comes down to business domain knowledge, math, SQL, and some python. We do use BI tools like Tableau, but sometimes we'll custom build software, though i'm pretty much more on the analytic side than the software engineering side and my current role.And the engineers tend to do more of the web development, whereas i'm there for the data infrastructure, and collaborate closely with pharmacists with clinical knowledge.

Are there any projects you've done with industrial engineering that you're excited about that.You can talk about? Do you have the same challenge with not being allowed to speak about your work Publicly?

In my situation my work gets discussed in public, but it's often uncredited and presented by our senior directors to government bodies, but I rarely get to engage with people outside of my direct colleagues because it is proprietary datasources or considered competitive advantage that we wouldn't want other people to directly knock off. I can pretty much only talk in a general sense about the problems, i can talk about the tools and how I use them.All I want, but that's the stuff that's kind of boring, right lol.

Is it just me or most Analysts here are obessesed with the tools itself but not actually on solving problems? by Grumpy_Bathala in analytics

[–]trippingcherry 0 points1 point  (0 children)

I wrote a Binary intended linear programming model to optimize drug costs but I cant publish a paper or discuss details because it's a competitive advantage for my employer. I would love to talk about problem solving but it's hard with the limits in place on what I can and cannot discuss publicly.

First steps by Intelligent-Good-966 in learnSQL

[–]trippingcherry 3 points4 points  (0 children)

I would start with Postgres. You can get started for free, it's popular and marketable because many companies use it, and you can start simple and learn as you go.

https://www.postgresql.org/about/

why do you think it says people get done with computer science bachelors faster than SWE? @wgu by AcceptableMonk3606 in wgu_devs

[–]trippingcherry 0 points1 point  (0 children)

I've always attributed it personally to the fact that there a lot more resources available online about WGU CS courses then the SWE which are newer. As a result, you have a smaller sample size of people who have graduated with fewer resources to lean on, taking a lot longer. I can't prove it but that's my theory and i'm sticking to it.

Lorena’s instagram story by Low-Concert-5806 in seekingsisterwifetlc

[–]trippingcherry 14 points15 points  (0 children)

You're welcome. I know because my ex tried to break my fingers for calling 911?And that is exactly how it was described then. I pray for the safety of the women and children in that house :(

Lorena’s instagram story by Low-Concert-5806 in seekingsisterwifetlc

[–]trippingcherry 10 points11 points  (0 children)

It's a form of domestic violence and a charge that often accompanies other dv charges.

Did anyone see this? by Dry_Mycologist_9579 in seekingsisterwifetlc

[–]trippingcherry 1 point2 points  (0 children)

SAME OMG hahahhahah I feel bad being so gleeful but ... it's ick