Avoid unnatural hierarchies Use natural hierarchies Q 1

Avoid unnatural hierarchies Use natural hierarchies Q 1 January Q 1 2014 January 2014 February March Q 2 February 2014 March 2014 Q 2 2014 Q 1 January Q 1 2015 January 2015

PRODUCT Product. Category Product Category product. Category

http: //www. sqlbi. com/articles/prepare-data-for-power-view-forecasting-in-power-bi

Search for interpretations of question Score and select best interpretation Select best visual Q: Medal count by country for 2012 Score From Olympics. xlsxshowmedal[medalcount], medal[country] … … 0. 86 From Olympics. xlsxshowmedal[medalcount], Olympics[host country] … … 0. 72 From Sales. xlsxselectcustomer[country]……(no (nomedalcount) 0. 45

Search for interpretations of question Score and select best interpretation Content Display Show 1 measure, 1 member (geo) Map Show 2 measures, 1 member Scatter Show 1 measure, 1 member Bar Select best visual

Simple “objects” might be in a single column Attribute of entities, such as Color, Quantity, Price

Poor Better

Poor Better

Poor Better

Better Poor

Poor Better

Better Poor

Poor Better

http: //blogs. msdn. com/b/powerbi/archive/2014/03/12/demystifying-power-bi-q-amp-a-part-3. aspx

microsoft. com/sqlserver and Amazon Kindle Store microsoftvirtualacademy. com Azure Machine Learning, Document. DB, and Stream Analytics

http: //channel 9. msdn. com/Events/Tech. Ed www. microsoft. com/learning http: //microsoft. com/technet http: //developer. microsoft. com