Skill 2.1: Create and optimize data modelsManage relationshipsOptimize models for reportingManually type in dataUse Power QuerySkill 2.2: Create calculated columns, calculated tables, and measuresCreate DAX formulas for calculated columnsCalculated tablesMeasuresUse What-if parametersSkill 2.3: Measure performance by using KPIs, gauges, and cardsCalculate the actualCalculate the targetCalculate actual to targetConfigure values for gaugesUse the format settings to manually set valuesSkill 2.4: Create hierarchiesCreate date hierarchiesCreate hierarchies based on business needsAdd columns to tables to support desired hierarchySkill 2.5: Create and format interactive visualizationsSelect a visualization typeConfigure page layout and formattingConfigure interactions between visualsConfigure duplicate pagesHandle categories that have no dataConfigure default summarization and data category of columnsPosition, align, and sort visualsEnable and integrate R visualsFormat measuresUse bookmarks and themes for reportsSkill 2.6: Manage custom reporting solutionsConfigure and access Microsoft Power BI EmbeddedEnable developers to create and edit reports through custom applicationsEnable developers to embed reports in applicationsUse the Power BI API to push data into a Power BI datasetEnable developers to create custom visualsThought experimentThought experiment answersChapter summary