3,113 questions
0
votes
1
answer
26
views
Getting same aggregation value for all category
I have three table named Content, Reaction and ReactionTypes, the Content and ReactionTypes tables are connected to Reaction table using One to Many relationship. Now, Category and Score are the the ...
- 21
0
votes
1
answer
61
views
Does duplicated data from denormalization affect the performance of vector searches?
In Cassandra, data are usually denormalized to match the query pattern. However, with vector columns, it means duplication of the same vectors. I know vector similarity search and index is very ...
- 2,777
-1
votes
2
answers
174
views
A schema with 10 Fact Tables and 1 Dimension Table
Is it normal / best practice to have multiple fact tables but only minimal dimension table(s).
I am new to data modelling and trying to create the best / most efficient data model and it always seems ...
- 11
1
vote
1
answer
126
views
Modeling Point Processes with Covariates: Use of quadscheme in R
I am currently attempting to model fire outbreaks using precipitation as a covariate. Upon reading various suggestions, I came across the quadscheme function in R. According to the documentation, the ...
2
votes
1
answer
808
views
Does unchecking enable load have impact on refresh?
I'm looking at an example where the enable load is unchecked. This automatically grays out the include in report refresh option.
So it neither loads into the model nor does it refresh this table.
...
- 9,886
1
vote
1
answer
31
views
How to handle specific required fields in a model depending on the value of another field in a database?
I am trying to build an Airbnb clone. Depending on whether your listing is an entire place, private room or shared room, it gives you different options to fill out about the bathrooms and locks ...
0
votes
1
answer
67
views
Creating a data model from scratch: Adding a Foreign Key in PostgreSQL
as personal project, I'm creating a small data model from a dataset.
Right now I'm facing issues in creating a foreign key between two tables.
CREATE TABLE IF NOT EXISTS public."Years"
(
...
- 5
0
votes
1
answer
68
views
Create measure in BI which include calculation between two related tables
As the model in the table, I have the bill of materials table as the fact table and the price and demand tables and dimensions,
I need to create 1- measure to calculate the total required quantity per ...
- 27
1
vote
1
answer
458
views
How to merge two different pbix files having different dataset in single file in power bi desktop
is it possible to merge two different pbix files in single pbix file like
customer.pbix and sales.pbix file can be merged and create single file in power bi desktop
- 111
0
votes
1
answer
627
views
How to get the second best model parameter using pycaret?
This is my code on google collab
# Import library
from pycaret.classification import *
exp_clf = setup(data, target='target', normalize=True)
best_model = compare_models()
And this is the result
...
- 21
-1
votes
2
answers
55
views
Table Restructuring Options in PowerBI
I was just given a PowerBI file that gets its data from some really messed up views in SQL Server. Basically, the database they're getting their data from is an OLTP database, and they don't seem to ...
- 724
1
vote
0
answers
52
views
Excel formula to change sum field depending on date
I have a data table in Excel in which each row corresponds to a specific deal event and has various different fields associated in the other columns. This data looks something like:
Deal ID Amount ...
- 439
1
vote
2
answers
146
views
What data type is appropriate for star schema keys (integer or text)?
I have inherited a star schema based report.
However the keys (links) are text fields. Not numeric ids.
For example:
The DimClient has values like:
Client Name
JLR
Mercedes
Audi
Volvo
And the ...
- 9,886
0
votes
0
answers
32
views
LSTM layer in Sequential model requires 3d input but only receives d2
Data is in 20 batches of 1000 characters with a vocab of 10510 words.
While trying to create an LSTM model to detect ai generated text, my model returns
`ValueError: Exception encountered when calling ...
0
votes
1
answer
49
views
Model the number of available spots in dimension or fact table?
We have a dimension table with day care facilities and a fact table where we receive the monthly number of taken spots per age category (3 cetagories).
Per facility we also have the number of ...
0
votes
1
answer
46
views
PowerBI: Many-to-many relationship with collection specified on the one side of the relationship
Scenario:
There is a many-to-many relationship between orders and widgets. I.e. an order contains several widgets, a widget can be contained in several orders
In the source data (two JSON documents ...
- 102k
1
vote
1
answer
426
views
How to model Header/Detail in Star Schema where there are measures at both granularities, whilst preserving drill-through?
My facts are Tickets (1m rows) and Ticket Actions (0.6m rows), with various dimensions (showing 2 here for simplicity) - some common to both, some unique, e.g. Action Type relates only to Ticket ...
- 137
1
vote
1
answer
41
views
Cassandra order issues
I encounter a problem sorting data on Cassandra using CLUSTERING ORDER BY.
The returned data is not sorted as expected with the following conf:
Any idea why the result is not sorted as expected ?
...
1
vote
0
answers
112
views
Power Query - Data model for multiple dimension tables with start and end dates
I am hoping for some assistance with data modelling. I have created a sample database to show my problem.
https://1drv.ms/u/s!Ap6q8W-mvm27hKRL1J85BopnnrfYRQ?e=tgASW4
Essentially I have a client and ...
- 11
0
votes
1
answer
92
views
Relationships from multiple non-unique data sources in Power BI
I have an interesting problem. I am trying to create a relationship from an Excel File containing 'Business Days' with only Dates/Month Name/Days/Year and connecting that to a SQL Database source in ...
- 21
-4
votes
1
answer
85
views
Transform View Table
I want to create a VIEW TABLE in my database based on a source table in SSMS (SQL Server).
But it's super hard to get the wanted view table format.
Here I present an example of the source table.
...
0
votes
2
answers
950
views
Primary and foreign keys dilemma in Snowflake Data Model
I am building a DQ testing application in Snowflake. Below is a simplified version of the data model (I renamed objects for the sake of clarity). I have multiple config tables for different tests (e.g....
- 157
1
vote
0
answers
22
views
Modelling location history in RavenDB (to get entities state at certain time)
We have a collection with ItemId/DateTime/Location fields.
We are tracking Items and their Locations (like, Storage1 or Building2 or City3. etc.) in time, Item might change its Location several times ...
- 6,119
0
votes
0
answers
59
views
Mongodb: Best way to model Many to Many relationship when references would be larger than 16MB
I currently have two resources in my application:
A File representation in the files collection:
_id: file1
fileGroups: ["group1"]
and a FileGroup in the file_groups collections
_id: group1
...
- 540
0
votes
0
answers
48
views
Data Modelling for Fact Table which refers to a same column for Revenue, Standard Cost
the fact table in my current model have a column called reporting_currency.
and there is an other column called rep_id
If the rep_id is 1,2,3,4 then reporting_currency is for Revenue.
If rep_id is 5,6,...
- 7