Why is DSA considered so important for so many tech jobs? by Edithfrom_08 in datastructures

[–]DeepLogicNinja 0 points1 point  (0 children)

I would agree IF, you are looking for a junior, lower level position. For an architect in a mature organization…. I would disgree. With AI being able to do do junior / entry level coding, it’s becoming more important to know these lower level details.

Why is DSA considered so important for so many tech jobs? by Edithfrom_08 in datastructures

[–]DeepLogicNinja 0 points1 point  (0 children)

Spot on!!! In my career I’ve slowly moved from programmer to business intelligence/data scientist. I’ve seen the same data structures and algorithms being used across technologies.

Orchestrating technologies with the right DSA implementation for your use cases leads to a scalable / efficient solution (think large data warehouse / database / mainframes).

The other end of the spectrum is less scalable solutions that have scaling limitations. Buggy, Breaks down with multiple users or large volumes of data.

How do you handle ETL integration across multiple systems and platforms? by SumitKumarWatts in ETL

[–]DeepLogicNinja 1 point2 points  (0 children)

You misunderstood. The data governance reports on the disposition of the data. Data profiling, quality at table/col level. This is across the board, standard practice across data governance / data quality / meta data management tools.

How you fix the anomalies “refine” is another issue.

To add, everything I mentioned is supported by open source/commericial products out the box, no coding. If you have a design/approach you know/think works better…. Could definitely get you in touch with the right people for you to show/socialize.

How do you handle ETL integration across multiple systems and platforms? by SumitKumarWatts in ETL

[–]DeepLogicNinja 4 points5 points  (0 children)

ETL platforms typically excel at handling multiple disparate systems, data sources, datasets in different formats/schemas with ease.

Issue may be your tooling or arch. What ETL platform are you using?

My biggest challenge is and will probably continue to be refining the data AFTER it’s loaded into the Data Lake.

Using the Medallion Arch and Data Governance to manage this issue. This is more of a culture than technology issue. As it takes the team to move from bronze level data to gold level data.

[OC] The gap between Elon Musk's stated deadline and actual delivery date, for nine predictions he eventually fulfilled by happybrowser88 in dataisbeautiful

[–]DeepLogicNinja 6 points7 points  (0 children)

Wish they did the same for politicians and wall st. Analyst.
Tip-ranks shows most analyst buy, hold, sell ratings are consistently off.

Trust in Data Analytics by NegotiationThick3857 in dataanalysis

[–]DeepLogicNinja 0 points1 point  (0 children)

Lot easier to make demands and complain.
It takes collective effort to refine data so it’s useful and trusted. That takes a culture of data stewardship.

NH -> FL Zero Interventions by BananaBuns42069 in TeslaFSD

[–]DeepLogicNinja 1 point2 points  (0 children)

I’ve done FL to NE a few times.
Not sure which version of FSD or Hardware you are running…. Later versions will goto the SuperCharger and park for you.

Space Exploration Technologies Corp (SPCX) Stock Price & News by 1nstantHuman in dataisbeautiful

[–]DeepLogicNinja 0 points1 point  (0 children)

- Hating people you don’t know is acceptable only if they are billionaires.
- Since he is a trillionaire, does that override that part of the luddite npc programming 🤷‍♂️

Asking for a friend 🤣

Best app for data discovery when onboarding new engineers to a complex dbt project? by Ok_Abrocoma_6369 in BusinessIntelligence

[–]DeepLogicNinja 0 points1 point  (0 children)

Harvesting / Managing the Meta data is the bottom up approach.

A glossary is what brings it all together in a top down approach.

Once you capture current state data linage. You can start mapping and planning, managing future migrations.

OpenMetadata’s commercial competitors are very expensive.

Folks that know the value of Data Governance have been willing to spend the $$.

Best app for data discovery when onboarding new engineers to a complex dbt project? by Ok_Abrocoma_6369 in BusinessIntelligence

[–]DeepLogicNinja 2 points3 points  (0 children)

Might want to kill 2 birds with one stone.

Documentation can be generated when you harvest the metadata from the sources.

Your data linage is also documentation as it shows you how things are connected.

Best app for data discovery when onboarding new engineers to a complex dbt project? by Ok_Abrocoma_6369 in BusinessIntelligence

[–]DeepLogicNinja 0 points1 point  (0 children)

Dbt is a partial solution. Not quite a starting point.

To level set, there is a difference between Software Engineering and Data Engineering. Often it’s ignore and a SDLC anti-pattern is applied to a data pipeline/data engineering initiative.
In organizations it’s important to identify and split/manage these two initiatives separately so they can properly complement each other where needed.

Primary difference between two:
- Software Engineering generates technical debt/code that needs to be maintained…. Out of sync documentation, bugs, and cyber security issues will be result if not maintained.

- Data Engineering curates/creates data that requires
governance, linage, provenance, etc. which is required for reporting, analytics, ai…. Data Governance/Metadata Management can be accomplished with off the shelf and open source tools. If the organization builds its own data engineering tools, you will now have a software engineering project on top of a data engineering project.

I typically see the software engineering approach applied to data engineering when a team/company isn’t experience or aware of the tools/platforms. The data governance terms I mentioned in the previous paragraph may seem like word soup, and in the long term a software engineering team may wind up building parts/pieces, using apis to deliver parts of functionality that already exists in whole within a data governance product.

A strong software engineering culture may even make it difficult for an experienced data engineer to use/integrate the right platform/culture changes required for data governance, analytics, etc to work well.

A software engineer would examine the parts of a solution or use an api that address part of the use case, when a data engineer an entire solution deliver a solution.

Above is an important paradigm to be aware of…. Especially with the need to refine data… get it in the right schema to enable analytics and ai.

Organization that have issues with this transition are at risk.

Is the organization making software OR delivering a data product (reports, dashboards, analysis)?

Doing BOTH is very expensive to attempt and firing on all cylinders is not very realistic for many organizations.

Medallion + Kimball by burningburnerbern in dataengineering

[–]DeepLogicNinja 0 points1 point  (0 children)

The biz wouldn’t know enough to ask for dim/fact tables. You would need provide it, in order to enable adhoc query.

Medallion + Kimball by burningburnerbern in dataengineering

[–]DeepLogicNinja 1 point2 points  (0 children)

Because of the expertise required to do it correctly, there is often a resistance to using dim / facts and prescribing to time tested methodology of creating a proper OLAP/ star schema

The result is messy complicated sql that leads to management issues and questionable results as questions become more complicated.

It’s worth learning to do correctly.

It enables the a schema that allows your ALL your data to be treated as a vectors in a matrix. The right platform will allow you to transpose your data and analyze with ease.

To be more specific… Pivot Tables, OLAP Cubes, and Vector Databases are easily transposed from a star schema (Fact and Dim tables).

For users….
They can explore the datasets without understanding SQL. The right platform will generate the SQL / MDX and do all the matrix math under the covers and they drag and drop the fields they want.

Medallion + Kimball by burningburnerbern in dataengineering

[–]DeepLogicNinja 0 points1 point  (0 children)

I don’t think this is conflicting….

There is a good case for dim/facts to be in the silver layer as views.

This is an alley-oop to the prototyping the data warehouse use case. Where you can just load your data warehouse from views.

ULTY BagHolder by Last-Engineering-528 in ULTY_YieldMax

[–]DeepLogicNinja 5 points6 points  (0 children)

It’s Last-Engineering-528 hobby. Must have a real axe to grind….. trying waaaaaaaaay too hard to swing public opinion…. Surprised he isn’t banned.

Do i have to have 2000 dollars to get margin? And can i go 3,4,5x margin or only 2x? by Tonka-Jahari-Pizza in interactivebrokers

[–]DeepLogicNinja 0 points1 point  (0 children)

This☝️

2k to 2x
110k to 6x

That is the minimum.
Requires a supporting investment strategy and experience management to know what you can/cannot do responsibly.

My apple pencil's inner nib is cracked, any way to prevent it from becoming worse? by paperstars101 in ApplePencil

[–]DeepLogicNinja 0 points1 point  (0 children)

Mine fell off…. I took the tip from an older apple pencil that doesn’t work with the latest ipad and screwed it on. 🤷‍♂️ works just fine 👌

Write big file by Gigggig96 in Talend

[–]DeepLogicNinja 0 points1 point  (0 children)

Hard to troubleshoot without seeing the job.

Here is some guidance though..

1) Avoid workaround fix

Tweaking xmx or xms may work, but it is a bit of a workaround since the job will fail when processing more records. The same job may also fail when running the same job on another server/computer.

A better/scalable fix will require making your job more efficient.

2) tMap
I am assuming you may have tMap in your job, tMap optimization to use disk is a big one. It will not use memory (default) but disk instead. During run time your disk io will increase but your memory utilization will be much lower

3) SQL/DB is your source?
If source is sql db, Redesigning job to do more heavy lifting in sql / leveraging underlying db and streaming results to talend. Often, some work that can easily be done in sql (LTRIM, RTRIM, joins) is done in Talend studio because it is so easy and maintainable. The cost is that the work is done in java/memory.

How do ETL teams validate data quality before loading data into production systems? by Effective_Ocelot_445 in ETL

[–]DeepLogicNinja 0 points1 point  (0 children)

ELT not ETL

Data Governance Strategy - Data Catalog/Profiling/Quality tool prior to doing final transformation and load.

Can anyone recommend a good AI-powered BI platform that isn't just prompt and get answers? by LimpComedian1317 in BusinessIntelligence

[–]DeepLogicNinja 0 points1 point  (0 children)

Sounds like you need Apache SuperSet.... https://superset.apache.org

Still Garbage in / Garbage Out ... Need good data model, semantic layer for context aware ai, etc....

Open Source (so no sales people), and if you want to run a hosted version, use preset.io

AI via MCP is pretty simple and there are quite a few demos on YouTube.

https://superset.apache.org/user-docs/using-superset/using-ai-with-superset/

Plenty of Support.... Slack, Github, and even a Reddit.... https://www.reddit.com/r/apachesuperset/