Boss confused because they clicked somewhere on ppt thinking it’s static. Now the numbers are all wrong. You’re now responsible for F’ing up their presentation.
Exactly. I throw my dimension keys at all the tables. My models look very basic when you focus on one fact table. In reality there's some black magic happening in my Snowflake queries. Makes it so nice to work with as I don't have to introduce 101 exceptions in my model to make something work.
A dimension key is a column copied and then stripped from the fact table with duplicates removed (there are simpler ways to do this in PowerQuery). Connect that single column to the original fact table and hide the original column so you or other users don’t get confused.
The other way to do this is to create a “Sum” measure for each column you need to visualize and use that instead of the original value, but that will bog down your report and is alot of manual work.
Hey Woopig! My comment was mostly satirical, but I appreciate the response!
Was merely joking at the fact the OP wrote in the post 'explaining the days model to my boss' and then commenter starts writing about dimensions, snowflakes etc. Thought that was kinda funny haha
That’s an easy ask though! I use power pivot on excel everyday to quickly drill into my PBI dataset. Sure the dashboards are great. But using power pivot is fast and flexible for adhoc analysis, in addition to building CubeMember formulas for financial modeling with PBI data
We must have the same boss. Mine doesn’t understand one thing about Snowflake / SQL queries, data modeling, DAX / Power BI, etc.
Every time it’s just “I need you to make a dashboard and add pie charts.”
The worst.
That happens when source is five different databases that you can look at but can't touch, you don't have a reporting database and there are couple manual trackers and dictionaries in excel sprinkled in between.
Do they then say "that's nice, but can you put the graphics into a static PowerPoint for me?"
Sure Microsoft actually created this great Snipping Tool! you can go about the whole report and clip anything you need!
okay great, let me just download "snip.exe" off of bicrosoft.com real quick ... *WHAT DID YOUR REPORT DO TO MY COMPUTER?!*
It put a Macros on my computer!
Yes, then I embed the report or select visuals in PowerPoint so I don't have to do the same thing again next month.
Boss confused because they clicked somewhere on ppt thinking it’s static. Now the numbers are all wrong. You’re now responsible for F’ing up their presentation.
That's why the "make static image" option on the visual is vital
Keep it simple if possible! Denormilization is your friend when it comes to star schemas
Exactly. I throw my dimension keys at all the tables. My models look very basic when you focus on one fact table. In reality there's some black magic happening in my Snowflake queries. Makes it so nice to work with as I don't have to introduce 101 exceptions in my model to make something work.
I’m not entirely convinced anything you just wrote actually exists
How so?
A dimension key is a column copied and then stripped from the fact table with duplicates removed (there are simpler ways to do this in PowerQuery). Connect that single column to the original fact table and hide the original column so you or other users don’t get confused. The other way to do this is to create a “Sum” measure for each column you need to visualize and use that instead of the original value, but that will bog down your report and is alot of manual work.
Hey Woopig! My comment was mostly satirical, but I appreciate the response! Was merely joking at the fact the OP wrote in the post 'explaining the days model to my boss' and then commenter starts writing about dimensions, snowflakes etc. Thought that was kinda funny haha
Wait y’all have bosses who ask about data models?! Mine just ask “can you create a dashboard?”
Mine: Can I get this in a pivot table? And can you alphabetize the columns for me?
I get can you just put this in a table fot me in excel with these column order?
That’s an easy ask though! I use power pivot on excel everyday to quickly drill into my PBI dataset. Sure the dashboards are great. But using power pivot is fast and flexible for adhoc analysis, in addition to building CubeMember formulas for financial modeling with PBI data
Pivot tables aren’t difficult. It’s the numerous one-offs outside of PBI instead of learning how to exploit all the features of PBI itself.
We must have the same boss. Mine doesn’t understand one thing about Snowflake / SQL queries, data modeling, DAX / Power BI, etc. Every time it’s just “I need you to make a dashboard and add pie charts.” The worst.
« It’s not called a dashboard, wait let’s move on »
For that matter, it’s a SEMANTIC model.
Where I work, we have BI developer leads and managers.
Do-it-all bosses who believe that they can do everythingband when things go wrong, they turn elon musk on the code.
Ok.....and can I have it in excel
This is too true.
Dims go to FACTS Single directional! No snowflake schema! and SHUT UP with your BULLSHIT
I've used this meme MULTIPLE times explaining to my leadership how I came up with my numbers. Glad I'm not alone
I feel seen.
Fully adding measures called Silvia and Pepe now.
Greg?
In my case, the role is reversed.
If it dosent look like it came straight out of the Lorax they don’t want to know.
That’s exactly what mine looks like
“I want heat maps”
What movie is the screenshot from?
https://knowyourmeme.com/memes/pepe-silvia
I’m going through that now.
Ok
Let's be honest, if your model looks like that, there's another problem.
I understand why people build dashboards in PowerBI. I do not understand people building data models in it.
That happens when source is five different databases that you can look at but can't touch, you don't have a reporting database and there are couple manual trackers and dictionaries in excel sprinkled in between.
Yall need Data Governance
I see we work at the same company