r/datawarehouse • • Dec 22 '22

Do you think data-warehouse native apps are a new era for software?

1 Upvotes

The main advantage of warehouse native apps is that they do not own your data, as they are just an application layer on top of the data warehouse, kind of a software with no backend.

Today, most SaaS are record-based in terms of pricing but if you already have a data warehouse, it means you would pay multiple times for the same data.

Since Snowflake launched Unistore, a new wave has been created - Forward-thinking leaders are like "Why I would not build applications on top of the warehouse" to centralize my business on the same infrastructure - Finance, Go to market, operations - All the functions could be gathered in the same places.

What do you think about this trend of software applications that do not have their own data backend?


r/datawarehouse • • Jun 30 '25

HL7 vs Kimball Model

0 Upvotes

I recently started working for a hospital and they kept talking about this HL7 model like it was some monster. Eventually I started to see that it HIGHLY reflects a Kimball model. Can someone point me in the right direction as to how these are different? Can an HL7 standard be enforced through a Kimball model?

This was architected a long time before I got here and it sounds like the engineers took over and they didn't hire another architect. They still had a "designer" but she didn't mess with the star schema and just focused on where the data went after being processed by the HL7 model.


r/datawarehouse • • Jul 03 '24

What’s the absolute worst thing that you have done at your job that negatively affected you/ your team/ your deliverables?

0 Upvotes

Lately I have been thinking maybe data warehousing is not my cup of tea. I don’t even have the energy to do the absolute bare minimum some days. So, I just want to know what’s the worst thing I could possibly do at my job (pushing half-assed code to production, not applying correct logic for ETL transformations, etc.) that would have some repercussions?


r/datawarehouse • • Jul 02 '20

Datawarehouse dimensions help

2 Upvotes

Hello everyone,

I need to create a datawarehouse based on a transactional database. I'm using this one: https://www.oracletutorial.com/getting-started/oracle-sample-database/

Can you please help me identifying the dimensions?

I can see the DimTime, DimLocation, DimProduct, DimOrder, DimCustomer, DimEmployee, DimContact.

I need at least 10 Dimensions, let me know which tables I can add to create them as dimensions.


r/datawarehouse • • Jun 30 '20

Important Data Warehouse Elements For Business

Thumbnail
bestemsguide.com
2 Upvotes

r/datawarehouse • • Jul 13 '24

Convert rational model to dimensional model.

Post image
3 Upvotes

hi guys how are you I want a help to convert this Relational Model Schema into Dimensional Model and Gracias por sus grandes esfuerzos en ayudarme 😊😊


r/datawarehouse • • Sep 01 '24

Supercharge Your Snowflake Monitoring: Automated Alerts for Warehouse Changes!

0 Upvotes

r/datawarehouse • • Aug 12 '23

Python library for automating data normalisation, schema creation and loading to db

Thumbnail self.dataengineering
0 Upvotes

r/datawarehouse • • Jan 31 '20

Participate in Big Data Research ($200)

0 Upvotes

Hello,

I work for a market research company looking for individuals to participate in research about big data databases.

If you qualify for and participate, you would be compensated $200 for a 30 to 45 minute telephone interview. We will not ask anything confidential. We are looking for your opinions and insights on how our client can provide valuable solutions to IT professionals.

To participate in this research and/or future research, please click on the link below to complete an easy online survey to see if you qualify. Alternatively, you can contact us at 201 556 1188 x103.

https://www.research.net/r/dataingestionmai

Interviews are limited and available on a first come, first serve basis. If you don’t feel you are the appropriate person or are not able to participate, feel free to forward this to someone you believe would be interested in participating.


r/datawarehouse • • May 30 '24

How to know which Datawarehouse platforms a company uses.

0 Upvotes

Hi, I'm trying to find out which dataware house platform Omnicell uses. I've tried different websites but I want able to find it. And found the info on chatgbt to be unreliable. Is there anyway to know which one they use.

Sorry for this question. Just on a time crunch for a research.


r/datawarehouse • • Nov 28 '23

Best practices for working with dbt and BigQuery - A practitioner's guide

Thumbnail
y42.com
0 Upvotes

r/datawarehouse • • Mar 13 '23

Attention all aspiring ❄️ SnowPro Core certified professionals!

0 Upvotes

📢 I'm excited to announce FREE ($0.00) Kindle ebook is available for a limited time!

💯 "Snowflake SnowPro Core Certification Exam Guide and Practice Questions" is a perfect resource to help you ace the COF-C02 certification exam. With comprehensive coverage of the exam syllabus and practice questions, you'll be well-prepared to succeed.

👉 Get your free copy now and take the first step towards achieving your certification goals!

ebook - https://www.amazon.com/dp/B0BX7686JM

🚀 Don't forget to leave a review on Amazon to let other professionals know how it helped you in your journey towards becoming a SnowPro Core certified expert.

#KindleEbook #professionalcertification #ExamGuide #PracticeQuestions #SnowProCoreCertification #SnowflakeCertification #exampreparation #freeebook #SnowflakeTraining #snowflakemastery


r/datawarehouse • • 5d ago

Data Warehousing: Talking Book Spoiler

Thumbnail
gallery
0 Upvotes

A fresh off the presses piece from Good Strat. Hold on to them horses.


r/datawarehouse • • Feb 28 '23

DataWarehouse Maintenance

1 Upvotes

Hi,

I'm a BI Developer and have been tasked with adding a new column to an existing table in a database. The column that needs adding exists in one database and needs adding to a different database on the same sever.

We have SSIS packages set up with a staging and present area.

Could someone please help me figure out how to get the column into the staging area? Once in there adding it to the present area will be easy.

Thanks


r/datawarehouse • • Jan 08 '24

How to modelize a 1 to many in RAW with only one HUB ?

1 Upvotes

Let's say we have 2 tables in a source.

Example:

Project and Project Schedule

We can have many Schedule for a Project. But we don't consider a Schedule as a Business Object so it is should not be a HUB.

Schedule cannot be a SAT of Project because it is not a 1 - 1 relation.

How do I link the Schedule to Project ?

Should I change my mind and consider Schedule as Business Object and then create a LINK between Project and Schedule or create Schedule in a SAT of a link to the HUB_Project or is there another solution maybe ?


r/datawarehouse • • Dec 12 '24

MOLAP decision support system

1 Upvotes

Hello, this is datawarehouse star schema

Now we have to create a multidimensional cube to answer to 4 business queries. Shoul I be creating one cube or a cube per each query? Thank you!


r/datawarehouse • • Oct 24 '24

When Should You Invest In A Data Warehouse?

Thumbnail
data-sleek.com
1 Upvotes

r/datawarehouse • • May 10 '18

MDM is important peg in data warehouse projects and so is documenting the MDM change requests

Thumbnail
lightsondata.com
1 Upvotes

r/datawarehouse • • Nov 01 '23

PowerBI, Metabase and Gooddata capabilities: A comparison

0 Upvotes

Hello folks

For the ones of you who manage dashboards or semantic models in UI tools, here's an article describing 3 popular tools and their capabilities at doing this work

https://dlthub.com/docs/blog/semantic-modeling-tools-comparison

hope you enjoy the read and if you'd like to see more comparisons, other tools or verticals, or to focus on particular aspects, then let us know which!


r/datawarehouse • • Aug 30 '24

Snowflake Alternatives: 5 Cost-Effective Data Warehouse Solutions

Thumbnail
definite.app
1 Upvotes

r/datawarehouse • • Nov 07 '24

Agentic AI: Revolutionizing Autonomous Data Management

2 Upvotes

I recently came across an insightful article on Agentic AI and its transformative impact on data management. The piece delves into how autonomous AI systems are revolutionizing data analysis, quality management, and query optimization. If you're interested in the future of AI-driven data management, this is a must-read. https://www.dwagentai.com/blog/agentic-ai-data-management


r/datawarehouse • • Mar 19 '24

Data Warehouses vs Data Lakes

Thumbnail
youtu.be
2 Upvotes

r/datawarehouse • • Jul 13 '20

[Webinar] How 360 Degree Data Integration Enables the Customer-centric Business

2 Upvotes

Looking to build a customer-centric business strategy to create tailored marketing, efficient sales processes, and product offerings that serve your enterprise needs? Tune in to our free webinar to learn how you can create a 360-degree customer-view to improve your business processes.

Save Your Spot Now


r/datawarehouse • • Aug 11 '22

Data modeling

2 Upvotes

Does anyone have any info about data modeling or no a website that could help me without a lot of complexity


r/datawarehouse • • Sep 30 '25

What’s the biggest pain point you face working with data tools today?

3 Upvotes

I’m curious about your experiences with today’s data tools (things like Databricks, Snowflake, dbt, Airflow, spreadsheets, BI dashboards, etc.).

A few questions for you:

  • What’s the most frustrating or time-consuming part of working with data in your current setup?

  • For technical folks (engineers, data scientists): what do you find clunky or painful about platforms like Databricks (or similar)?

  • For non-technical folks (analysts, ops, finance, product, etc.): what makes it hard to get insights or use the data without depending on an engineer?

  • If you could magically fix or add one feature that would make working with data way easier, what would it be?

I’m just trying to get a real-world sense of where the pain is — beyond the sales pitches and shiny demos. Would love to hear any honest thoughts or stories!