Avoid unnatural hierarchies Use natural hierarchies Q 1

  • Slides: 47
Download presentation

Avoid unnatural hierarchies Use natural hierarchies Q 1 January Q 1 2014 January 2014

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

PRODUCT Product. Category Product Category product. Category

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

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:

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

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,

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

Poor Better

Poor Better

Poor Better

Poor Better

Poor Better

Poor Better

Better Poor

Better Poor

Poor Better

Poor Better

Better Poor

Better Poor

Poor Better

Poor Better

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

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

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.

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

Climate Change natural unnatural Past and Future RisksClimate Change natural unnatural Past and Future Risks
Unnatural L 0 Representation for Natural Image DeblurringUnnatural L 0 Representation for Natural Image Deblurring
Natural unnatural and D 2 labelled aminoacids byNatural unnatural and D 2 labelled aminoacids by
Markets Versus Hierarchies Hierarchies are for allocating resourcesMarkets Versus Hierarchies Hierarchies are for allocating resources
Lecture8 Inheritance Classification Hierarchies Inheritance Classification Hierarchies InheritanceLecture8 Inheritance Classification Hierarchies Inheritance Classification Hierarchies Inheritance
1 Avoid excessive temperatures 2 Avoid excessive cooking1 Avoid excessive temperatures 2 Avoid excessive cooking
Avoid Grammar that Confuses the Reader n AvoidAvoid Grammar that Confuses the Reader n Avoid
avoid difficult conversations not listening avoid your ownavoid difficult conversations not listening avoid your own
INTERVIEWING TIPS Avoid Interview Mistakes Avoid Interview MistakesINTERVIEWING TIPS Avoid Interview Mistakes Avoid Interview Mistakes
Title Avoid HighTech Time Wasters NOTES AVOID HIGHTECHTitle Avoid HighTech Time Wasters NOTES AVOID HIGHTECH
Avoid falling Avoid Column Femoras Fracture Age 65Avoid falling Avoid Column Femoras Fracture Age 65
Organizational Change An Unnatural Act Introductory CalculusBased PhysicsOrganizational Change An Unnatural Act Introductory CalculusBased Physics
Unnatural amino acid mutagenesis for sitespecific incorporation ofUnnatural amino acid mutagenesis for sitespecific incorporation of
How Unnatural Vocal Behaviors Can Make You MoreHow Unnatural Vocal Behaviors Can Make You More
Zombies An Unnatural History Monsters Cultural construction EmbodimentZombies An Unnatural History Monsters Cultural construction Embodiment
Unnatural Disaster How Politics Destroyed Canadas Atlantic GroundfisheriesUnnatural Disaster How Politics Destroyed Canadas Atlantic Groundfisheries
UnNatural Alliances Insurers Bankers Institutional Investors and EnvironmentalistsUnNatural Alliances Insurers Bankers Institutional Investors and Environmentalists
The Aral Sea An Unnatural Disaster Janet HallThe Aral Sea An Unnatural Disaster Janet Hall
Heartland Health 2020 Population Health Unnatural Causes VignetteHeartland Health 2020 Population Health Unnatural Causes Vignette
LIVING WITH RISK The Unnatural Geography of EnvironmentalLIVING WITH RISK The Unnatural Geography of Environmental
MAPP Unnatural Causes A Strategic Approach to TacklingMAPP Unnatural Causes A Strategic Approach to Tackling
Site Specific Introduction of Unnatural Amino Acids atSite Specific Introduction of Unnatural Amino Acids at
Unnatural Disaster How Politics Destroyed Canadas Atlantic GroundfisheriesUnnatural Disaster How Politics Destroyed Canadas Atlantic Groundfisheries
UnNatural Alliances Insurers Bankers Institutional Investors and EnvironmentalistsUnNatural Alliances Insurers Bankers Institutional Investors and Environmentalists