Power Bi Series_ Go Beyond Pivot Tables With Power Pivot

Passed with 70% 1. What is a benefit of Power Pivot versus standard Pivot Tables? a. Power Pivot has no data limit, where PivotTables are limited to just over 1 million records . b. Power Pivot can be used without Excel, where PivotTables requires Excel. c. Power Pivot works with ALL versions of Excel, where PivotTables only works with certain versions of Excel. d. Power Pivot uses ALL the same functions as Excel so there is no learning curve. 2. What is a feature of Power Pivot? a. Excel Functions. b. DAX Calculations. c. Charting. d. PivotTables. 3. What is the BEST way to learn Power Pivot? a. Ask someone else to create your Power Pivot data model. b. Learn to create macros in Excel as that knowledge will help you with Power Pivot. c. Learn to program in SQL as that is the programing language used by Power Pivot. d. Same way you learned Excel...Start simple and grow into advanced features. 4. How many data sources can you connect to using Power Pivot? a. One and it has to be Excel. b. Many but they have to be the same file type. c. Many different types (Excel, text, CSV, Database, web, etc.). d. Two but they have to be the same time. 5. What Power Pivot view allows you to drag & drop fields in order to create relationships between tables? a. Table View. b. Data View. c. Diagram View. d. Calculation View. 6. What is one of the advantages of adding data to the Power Pivot data model versus adding it to an Excel worksheet? a. Data in the data model can be changed. b. Data in the data model cannot be changed. c. Data changed in the data model also changes it in the source data. d. It is the only way to create PivotTables to analyze data. 7. What can be changed in the Power Pivot Data Model? a. Source data. b. Text entries. c. Numeric entries. d. Column names. 8. When you add multiple tables to a data model, what feature provides the ability to access data from all the tables in one PivotTable?

Passed with 70% a. Building relationships. b. Calculated columns. c. Measures. d. Hierarchies. 9. Where can a calculated column be used? a. Excel calculation. b. PivotTable Field List. c. PivotTable Calculated Item. d. PivotTable Calculated Field. 10. What happens when you use an aggregation function (i.e., SUM) in a calculated column? a. It calculates a value based on the values in the row. b. You receive an error. c. It calculates a value based upon the entire column. d. It turns the calculated column into a measure. 11. What is one of the Rules of a Measure? a. Redefine the measure, don't reuse it. b. Never use a measure within another measure. c. Only use calculated columns in a measure. d. Reuse the measure, don't redefine it. 12. What type of measure is created within the Power Pivot data model? a. Implicit. b. Exact. c. Explicit. d. Calculated Field. 13. How do you know a field is a measure when selecting from the Field List of a PivotTable? a. Measures are listed all together in the Field List. b. They are listed in bold in the field list. c. The are not listed in the field list. d. They are preceded by an "fx" in the field list. 14. What is the syntax for creating a measure in the Power Pivot data model? a. Name:=formula/function/expression. b. =function(argument,argument,etc.). c. Name=formula/function/expression. d. [Name]:=formula/function/expression. 15. When creating a measure, what formula language do you use? a. DAX (Data Analysis Expressions). b. Excel Functions. c. SQL (Sequential Query Language). d. M Query Language. 16. When creating a measure that calculates Sales Per "X", which DAX function should you use? a. AVERAGE.