Would be great if you did a video looking at subscription product renewals where the renewal might be a year later but they were a customer throughout the period.
I plan to do a reporting dashboard on a subscription dataset in the future. I haven't found one that gives me enough data points for what I need, most are cleaned up for ML projects, but am on the look out 🙂
Hey Dean, I tried your way of doing but the data modeling is taking a lot of time. My Data has more than 10 Million Rows, Is there any other way to load the data faster?
That will be the table buffer. The only workaround that might work is to order the table then create a reference table and see if it keeps the sort order, as that's the only reason to use table buffer. I know this works when doing it in dataflows but not tried in desktop before. When detailing with that much data it will be slow but if you can break it up it will be quicker. Reason I did it in dataflows as it took so long to load preview when working with millions of rows.
@@DeanChereden I'm trying to create a reference table on Dataflows but its still messing around the order sequence. When do you create a reference table? I did it after the step where you added a custom column for 'Previous Order Sequence'.
Hmm I wonder if the desktop version doesn't store the sort like dataflows do. I don't understand why Microsoft make it different between the 2. I'll have a try with so testing to see if there is another way to sort it.
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Would be great if you did a video looking at subscription product renewals where the renewal might be a year later but they were a customer throughout the period.
I plan to do a reporting dashboard on a subscription dataset in the future. I haven't found one that gives me enough data points for what I need, most are cleaned up for ML projects, but am on the look out 🙂
Hey Dean, I tried your way of doing but the data modeling is taking a lot of time. My Data has more than 10 Million Rows, Is there any other way to load the data faster?
That will be the table buffer. The only workaround that might work is to order the table then create a reference table and see if it keeps the sort order, as that's the only reason to use table buffer.
I know this works when doing it in dataflows but not tried in desktop before.
When detailing with that much data it will be slow but if you can break it up it will be quicker. Reason I did it in dataflows as it took so long to load preview when working with millions of rows.
@@DeanChereden Thank You For Replying, Dean. I Shall Try This Workaround And Would Let You Know.
@@DeanChereden I'm trying to create a reference table on Dataflows but its still messing around the order sequence. When do you create a reference table? I did it after the step where you added a custom column for 'Previous Order Sequence'.
Hmm I wonder if the desktop version doesn't store the sort like dataflows do. I don't understand why Microsoft make it different between the 2. I'll have a try with so testing to see if there is another way to sort it.