Forum Discussion
Someone To Chat With For A Few Minutes
So I have a lot of data to work with and I'm trying to figure out if I should do the gargantuan task of creating new tables in SQL using joins and merges, or if I should just write a lot of convolute...
Get this book from Marco Russo and Alberto Ferrari.
Do the modeling in SQL to end up with a star schema of 1 fact table and multiple dimension tables.
Complex DAX to make up for an unoptimized model will ALWAYS perform slower.
Remember, 95% of data models are star schemas. The other 5% just don't realize it yet.
So in other words, even though we're pulling all of the tables(100's of thousands of rows) from our vendor, we should manipulate it first on the SQL level? And then create our measures and stuff?
It's been very convoluted for me to try to make this data work when it's in such a disorganized fashion.