This morning the PASS Summit 2014 started in Seattle and during the keynote there was several announcements from Microsoft. I’m considering here only the ones about Business Intelligence (you will find other blogs around about SQL Server). In the coming  Read more

Power BI offers many tools to explore a data model created in Power Pivot, such as Excel, Power View, and Q&A. You can improve the user experience and the accessibility of information by creating the data model in a proper…  Watch now

Today at TechEd Europe 2014 Miguel Llopis made the first public show of Power Query support for Analysis Services. This is still not available, but it should be released soon (hopefully it will be our Christmas gift!). Here is a list of features shown:  Read more

In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and…  Watch now

Power BI offers many tools to explore a data model created in Power Pivot, such as Excel, Power View and Q&A. You can improve the user experience and the accessibility of information by creating the data model in a proper…  Watch now

In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, and Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage…  Watch now

Just a few days before my session about Power Query at TechEd 2014 , Microsoft released a new update that enables the scheduled data refresh of a Power Pivot workbook containing Power Query transformations. This is a very good news, because it enables  Read more

Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap: PASS Business Analytics Conference 2014 – May 7-9, 2014 – San Jose, California Querying in DAX (Marco Russo)  Read more

The current version of Power Query does not have a user interface to create a Distinct Count calculation in a Group By operation. However, you can do this in “M” with a simple edit of the code generated by the Power Query window. Consider the following  Read more