Dutch Data Dude

Data Nerdiness

Search
  • Blog
  • Shop
  • About
  • Disclaimer
  • Blog
  • Shop
  • About
  • Disclaimer
  • Master Data Services 2014 Add-in for Excel published

    / January 13, 2015

    Just a bit over a week ago a new version of the Master Data Services Add-in for Excel was released. It is the 2014 release, which will also work for SQL Server 2012. Main benefit is up to 4x…

    read more
  • Power BI Pro Tip: Dealing with errors when reading Excel files

    / October 7, 2014

    If you use Power Query to read an Excel file that has errors (such as #VALUE, #REF, #N/A, etc) the rows that contain the error will not be loaded into the data model but instead will be…

    read more
  • Combining text (csv) files using Power Query – follow-up

    / August 5, 2014

    I have been getting quite a few responses on my original post on how to combine text (csv) files using Power Query. One of the FAQs is how to keep the filename where the data came from…

    read more
  • Power BI Pro Tip: Name your linked tables

    / July 22, 2014

    Just a quick Power BI Pro Tip this time: if you use linked tables to add data to your data model in Excel, before you press the ‘Add To Data Model’ button be sure to go to…

    read more
  • Power BI Pro Tip: Show Top x results with RANKX() function

    / July 15, 2014

    One of the more frequent scenarios is listing the top X results, such as most profitable products, biggest customers, top 10 best selling stores, etc. Also doing a top X selection helps reduce clutter in charts: a…

    read more
  • Version compatibility between Power Pivot Data Models in Excel 2010 / 2013 and SharePoint 2010 / 2013

    / July 1, 2014

    I have been getting a lot of questions on compatibility around Excel 2010 / Excel 2013 / SharePoint 2010 / SharePoint 2013. To be honest, I have been confused myself. I encourage you to check out our Excel…

    read more
  • Power BI Pro Tip: Role playing dimensions with UseRelationship

    / March 25, 2014

    One frequent need in BI is something called a role playing dimension (see http://en.wikipedia.org/wiki/Dimension_(data_warehouse)#Role-playing_dimension for a definition). The classic example of this is a Date dimension that is related to a Sales fact table and used either…

    read more
  • Power BI Pro Tip: Sort By Column

    / March 18, 2014

    Here is an easy solution to a very common problem when making reports: how do I change the sort of some items from alphabetically to something else? The most apparent sample of this is Months. Let’s say…

    read more
  • CEO Announcement Twitter Analysis

    / February 11, 2014

    Last week Satya Nadella was announced as the new CEO of Microsoft (see http://www.microsoft.com/ceo). This was met with a lot of reaction in the world and also on the social networks. I decided to analyze the tweets…

    read more
  • Top 3 of what is new in Power Query for Excel

    / December 31, 2013

    Just recently the December update of Power Query for Excel has been published. See this blog post on the Power BI for the details: http://blogs.msdn.com/b/powerbi/archive/2013/12/13/one-step-closer-to-simplifying-data-analysis-and-visualization-new-features-added-to-power-bi-for-office-365-and-power-query-add-in-for-excel-preview.aspx. In this post I want to give you my personal top 3:…

    read more
 Older Posts

Shop (more available)

  • Data Miner (dark colors) $21.99
  • Power BIer (Yellow Logo) $17.95
  • Data Scientist (dark colors) $21.99
  • Data. sticker $7.99
  • Python Says Ni (light colors) $21.99
  • Shallow vs Deep Learning (dark colors) $21.99
  • Shallow vs Deep Learning (light colors) $21.99
  • SQL Super(wo)man sticker $7.99
  • It's not a logo, it's an icon $21.99
  • Data Wrangler (light colors) $21.99
2022 Dutch Data Dude | Bard Theme by WP Royal.
Back to top