Kategorie: Allgemein

Ursprünglich veröffentlicht auf Excel For You: The following technique is a modification to Chris Webb’s excellent Power Query article located at: http://cwebbbi.wordpress.com/2013/11/19/generating-a-date-dimension-table-in-power-query/ I hope that I am not stepping on something that Chris has already done but not published. Anyway, in order to understand what I am presenting here, you will have to read Chris’s…

Wie so oft heißt es also auch hier, dass ein überlegtes Design einem viel Arbeit ersparen kann: http://whitepages.unlimitedviz.com/2014/03/dont-update-your-power-query-after-building-a-model/

Chris Webb's BI Blog One of many cool things about Power Query is the way that it allows you to retrieve data from web services and load it into Excel. While this is a subject that lots of people (including me) have already blogged about, the Web.Contents() function – which is the M function that…

Ursprünglich veröffentlicht auf Marije…: Editors Note : This article was moved from my old bolg. The Excel Buffer table. Loved by many, unkown to most. Here is the description on MSDN. If you still don’t have a clue what I’m talking about, then allow me to explain. Else skip this paragraph and continue to the…

at Excel-Blog – Andreas Thehos Hier sind die vier Bilddateien:Bilder Die Excel-2013-Datei für Power View:PowerPivot 26 Kachelbilder Hier geht es zum Video: Videolink: http://youtu.be/1vKdmukUUiE Ursprünglichen Post anzeigen

Ursprünglich veröffentlicht auf business intelligist: Microsoft has released the latest update for my favorite Power BI tool. There are several cool albeit minor improvements to the functionality. The post at the link does a great job of describing the new changes, so I am not going to rehash them here. What I do find interesting,…

Ursprünglich veröffentlicht auf Intelligent SQL: We always hear about the power and compression ratio of tabular databases and Power Pivot, and how the Vertipaq compression engine can compress things up to 90% of what their source is. But, this opens up a lot of questions. For example, how can we properly size our tabular hardware…

Ursprünglich veröffentlicht auf Dick Moffat's Spreadsheet and BI Blog: My friend Simon Murphy noted yesterday that MS has decided to put InfoPath „down“: http://smurfonspreadsheets.wordpress.com/2014/02/06/infopap-re-envisioned/) … About time IMHO…. Not to take anything away from Simon’s post, I have to mention that he references an article in The Register (http://www.theregister.co.uk/2014/01/31/infopath_retired/) that includes the following quote from the…