How to fit a separate table in data warehouse model?
I have a table named AWARENESS_MEETINGS with name and date of the meeting as an attributes, it's not related to any other table in the database. I am designing a data warehouse model, I can't fit it into the model its only related to the date dimension, and I can't determine if it's a fact or dimension table, the only business question related to the table is the count of the AWARENESS_MEETINGS by time.
EDITE:
EDITE 2:
Solution
If you have a business requirement to count the number of awareness meetings then you would need:
- a fact table to hold the counts
- a meetings dimension to hold the meeting name
- a date dimension
- any other dimensions needed to slice/dice/aggregate the fact table
- How to Create a Generic Semantic Data Model in Tabular Editor for Power BI Reports with Separate Datasets?
- Optimizing low-level structure for CPU memory performance in my game simulator
- Power BI - Tree chart out of only numerical data
- Get latest values from a SCD dimension table
- Crow's Feet - One vs One And Only One
- DynamoDB Hot Paritions Key Prefix and Overloading GSIs
- What is a good way to determine if all fields on a record except one are empty?
- the right way to model the data in collection and documents
- Fragmentation in MongoDB when growing documents
- A relationship is not working when using a measure
- How to handle multiple dimension records having the same name even though they have unique key/relation with the fact table (1:M)?
- Modifying column values in Pandas?
- Is there a way to relate a Calendar lookup table and a 24hr Time lookup table to 2 different tables on more than 1 column in PowerBI?
- Dredge MuMIn: when using a dredge on a GLMM, does the null model include random effects?
- Does unchecking enable load have impact on refresh?
- How to map OO inheritence to a relational database scheme?
- Why many refer to Cassandra as a Column oriented database?
- Show items with no data is not giving expected result
- MongoDB: upsert with different values for update and insert
- Unpivot columns with multiple relevant rows with headers. PowerQuery M language | Multiple Unpivot simultaneously
- Creating a data model from scratch: Adding a Foreign Key in PostgreSQL
- What is the difference between Max Cardinality and Min Cardinality?
- How to model when header table has values?
- Typescript union type of functions weirdly becomes an intersection type of the arguments
- How to merge two different pbix files having different dataset in single file in power bi desktop
- Unsure whether to use One-to-One Relationship or Factless Fact Table
- What is best practice to deal with missing data according to Kimball?
- Power Bi Data Transform - Returning only currently active records
- What's the best way to model recurring events in a calendar application?
- How to *really* write UML cardinalities?