Posted on:

ETE had a little note in Jyske Vestkysten today

Posted on:

Just a quick note on Name Calculations in SSAS, they need to be written in whatever SQL dialect the underlying DB engine (probably MS-SQL) understands. I wanted to make a Sales Margin calculation, and to avoid a Divide by Zero where sale price was zero, my code for this was:
<br /> CASE<br /> WHEN Sale<>0 THEN (Sale-Cost)/Sale<br /> ELSE 0<br /> END<br />
Never before have I needed four lines to do a simple IF. ;-)

Posted on:

I'm not a frequent user of CoverFlow, but now that I wanted to use it on my shared iTunes library in my living room from the Windows iTunes client I noticed that I cannot select neither CoverFlow nor in an album list. I'm stunned and looking forward to trying it out on my MBP

Posted on:

While Googling I found Pentaho, an open source BI suite that uses the same stack that I used for my last job: MySQL/JBoss/Tomcat/Eclipse. Great seeing there are more out there, and if you're starting up with BI and prefer OSS, check them out!

Posted on:

Reading more in The Dashboard Spy I found this great table of questions users ask and how you should answer them when it comes to designing dashboard:

Questions Dashboard Users ask
Check out the reference whitepaper by PureShare on Best Practices in Dashboard Design. And for that next great UI design, check out 175+ Data and Information Visualization Examples and Resources

Image Image

Father, husband, software developer, musician and photographer.


Get to know what I'm up to

© 2020 Niklas Saers Contact Me