Microsoft Implementing Data Models and Reports with Microsoft SQL Server (70-466日本語版) - 70-466日本語 Exam Questions

Explanation:
Box 1:

Box 2:

Box 3:

Note:
* To create a new tabular model project from a PowerPivot for Excel file
* In SQL Server Data Tools, on theFilemenu, clickNew, and then clickProject.
(box 2)
* In theNew Projectdialog box, underInstalled Templates, clickBusiness Intelligence, and then clickImport from PowerPivot.(box 3)
* InName, type a name for the project, then specify a location and solution name, and then clickOK.
* In theOpendialog box, select the PowerPivot for Excel file that contains the model metadata and data you want to import, and then clickOpen.
Box 1:
* When creating a new tabular model project by importing from a PowerPivot workbook, the metadata that defines the structure of the workbook is used to create and define the structure of the tabular model project in SQL Server Data Tools. Objects such as tables, columns, measures, and relationships are retained and will appear in the tabular model project as they are in the PowerPivot workbook.
* Analysis Services provides three different approaches for creating a business intelligence semantic model: tabular, multidimensional, and PowerPivot. Tabular solutions use relational modeling constructs such as tables and relationships for modeling data, and the xVelocity in-memory analytics engine for storing and calculating data