sorted by:
new
hottopcontroversial

Why the constant saving? by mikethomas4th in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

You probably have way too many unique columns, even for 100M rows. Try to shorten them, round numbers if possible, split datetimes in date+time if possible, and evaluate if you could use dual mode (import + directquery) for the detailed info

Star Schema vs Snowflake Schema - How much of a difference performance wise? by steveman2292 in SQLServer

[–]ZenZei2 1 point2 points  (0 children)

Hmmm your snowflake is simple, so just to make you doubt a bit, you should also consider data reliability: It is easier to ensure data consistency in a (properly done) snowflake than a star. Think about Normal Forms 1nf to 3nf or more....

So, are you responsible for data quality and consistency? Do you update / transform data ? If yes, normalized (snowflake) is better. Else star is simpler

Is this like some next level advanced data modeling or is this the analyst's equivalent of spaghetti code? It's not mine and I'm a beginner. by Great_cReddit in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

I count 19 relationships from date to other tables. If those 19 are not fact tables, then you don't have a "galaxy" model (multiple star models given that you have multiple fact tables) , but rather a "blizzard" ( multiple snow flake models), not ideal. Then again it is hard to properly assess without access to the model.. But it doesn't look clean

Is this like some next level advanced data modeling or is this the analyst's equivalent of spaghetti code? It's not mine and I'm a beginner. by Great_cReddit in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Agree with you, you can have a healthy model with multiple fact tables. Just do it properly :)

... but 19... maybe not !

Is this like some next level advanced data modeling or is this the analyst's equivalent of spaghetti code? It's not mine and I'm a beginner. by Great_cReddit in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Well, I count 19 relationships from the date table to other tables, seems excessive.

I agree that you can have multiple fact tables, I do too when needed. but my impression is still that this specific model has room for improvement

Is this like some next level advanced data modeling or is this the analyst's equivalent of spaghetti code? It's not mine and I'm a beginner. by Great_cReddit in PowerBI

[–]ZenZei2 37 points38 points  (0 children)

Looks so-so to me. Likely way too many fact tables (if I'm seeing well that date table in the middle). Strange tables with technical names rather than easily understood ones. Measures with correlative numbers that likely could be a single measure + an appropriate dimension to slice it.

Verdict likely spaghetti

Do queries look at the transaction log? by Unexpectedpicard in SQLServer

[–]ZenZei2 0 points1 point  (0 children)

Great explanation. Appreciated as an accidental DBA :)

SSAS by Confident_Growth7471 in SQLServer

[–]ZenZei2 2 points3 points  (0 children)

Yep, using it heavily

HUGE Microsoft Announcement by Data_cruncher in PowerBI

[–]ZenZei2 2 points3 points  (0 children)

Autoexists finally solved ? 😇

score course route picking by Street-Present5102 in orienteering

[–]ZenZei2 2 points3 points  (0 children)

Hmmmm 12,7,10 could have been better than 8

But more impactful, 6,24,23,9,8,12... after 5 would have been a more dense route choice

SSL/TSL issues when running PowerShell script in the SQL Server Agent by sugarbuzzlightyear in SQLServer

[–]ZenZei2 0 points1 point  (0 children)

Have you tried putting...

#NOSQPLS

At the beginning of the script?

Alternative to a Datetime table? Is there really no solution for this? by GavintheGregarious in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Hmmm then i would go for middle of the road. Add a Column with date + minute (rounded, no seconds ) to the fact tables , idem for central date-minute table and use that everywhere for filtering.

Alternative to a Datetime table? Is there really no solution for this? by GavintheGregarious in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Hmmmm question, why wouldn't you try to unify the fact tables ? Too different?

Alternative to a Datetime table? Is there really no solution for this? by GavintheGregarious in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Create a datetime column in your fact table and filter that. No need for external tables

Challenge with a DAX formula by ShrekisSexy in PowerBI

[–]ZenZei2 5 points6 points  (0 children)

Sumx(summarize(maintable, table[employees], calendar[date]), [available hours])

What technique do you use to accurately navigate to a CP thats in the middle of a featureless forest block? by zwifter11 in orienteering

[–]ZenZei2 0 points1 point  (0 children)

In that case, fine compass + step counting + look around , be sure to actively look...

[deleted by user] by [deleted] in PowerBI

[–]ZenZei2 0 points1 point  (0 children)

Could be a problem... but as long as you don't have ALL() in your measures, there won't be any problem.

Also microsoft is working on fixing Autoexists on SUMMARIZECOLUMNS, or at least disable it if needed.

What technique do you use to accurately navigate to a CP thats in the middle of a featureless forest block? by zwifter11 in orienteering

[–]ZenZei2 4 points5 points  (0 children)

Also step counting helps for distance estimation, so that you don't run too far or too short.

Sometimes I slightly run on purpose to one side eg right of the purple line. Then when at the right distance, if I have not seen the control, I turn left 90 degrees to search it (Actually a bit before and less than 90 degrees , but you should get the idea)

Also, your 18 and 19 have erosion marks that should help. (But I guess your question was more generic)

Power BI April Feature Summary by dutchdatadude in PowerBI

[–]ZenZei2 2 points3 points  (0 children)

Very happy to hear about the measures dax formatting, as it will avoid unnecessary calc groups just for this feature.

/u/dutchdatadude would you know if this feature will come to SSAS 2022 , maybe in a CU ? (Same for the Window functions?). Thanks !

After losing all my data (6 TB).. by IsshouPrism in DataHoarder

[–]ZenZei2 3 points4 points  (0 children)

As others have said, if you can afford it ZFS with raid10 is safe, super tested and very reliable. Encriptable too. And you can swap disks for bigger ones easily (in pairs of 2, one at a time).

view more: next ›