SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Journey to SQL Authority with Pinal Dave

Yesterday I had discussed two analytical functions FIRST_VALUE and LAST_VALUE. After reading the blog post I received very interesting question. «Don’t you think there is bug in your first example where FIRST_VALUE is remain same but the LAST_VALUE is changing every line. I think the LAST_VALUE should be the highest value in the windows or…

Πηγή: SQL SERVER – OVER clause with FIRST _VALUE and LAST_VALUE – Analytic Functions Introduced in SQL Server 2012 – ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING | Journey to SQL Authority with Pinal Dave

KPI performance charts & dashboards – 43 alternatives (contest entries) | Chandoo.org – Learn Microsoft Excel Online

Hello all, prepare to be amazed! Here are 43 creative, fun & informative ways to visualize KPI data. About a month ago, I asked you to visualize KPI data. We received 65 entries for this con…

Πηγή: KPI performance charts & dashboards – 43 alternatives (contest entries) | Chandoo.org – Learn Microsoft Excel Online

Calculate previous month, quarter without using string gymnastics – Daniel Bowlin’s SQL Server BI Blog

This article outlines methods to calculate previous month, quarter, or previous period from a current period column in a date dimension or other table.

Πηγή: Calculate previous month, quarter without using string gymnastics – Daniel Bowlin’s SQL Server BI Blog

Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant

Excel users who start to learn Power Query will find learning R quite easy once they’ve started to play around with Power Queries M code. Smooth transition!

Πηγή: Power Query & Power BI are ideal learning paths from Excel to R – The BIccountant