Welcome to your free Power BI Desktop & PowerBI.com test 1. To join tables together: Drag the matching field from one table to the other in Power Pivot Drag the matching field from one table to the other in Power Query Use the Power Query JOIN function Use the Power Pivot CROSS-JOIN button 2. Which of the following is NOT a valid data source for Power BI to open automatically: XLSM Macro-enabled Excel Workbook PDF document A table on an HTML web page Microsoft Exchange 3. Which of the following statements about Power BI Desktop is FALSE? Query Editor & the Relationships view in Power BI Desktop are based on the same technology as Power Query and Power Pivot in Excel Power BI Desktop can handle larger volumes of data than the Excel (64 bit) data model Power Pivot DAX expressions in Power BI Desktop are called Measures Data tables can be manually entered in Power BI Desktop 4. To create drill down reports in Power BI Desktop: The data needs to be exported to Excel Click the “Add Drilldown” function for each measure Add more than one field to the Axis section of a chart Right-click on one part of a chart then choose the desired drilldown 5. To calculate the percentage of total sales that each product’s sales comprises, you could use the following 2 DAX expressions: (i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) / [Sales All Products] ) * 100 (i) Sales All Products = CALCULATE( SUM( [Sales] ), ALLEXCEPT( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , [Sales All Products] ) (i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , [Sales All Products] ) (i) Sales All Products = CALCULATE( SUM( [Sales] ), ALL( tblProducts[Products] ) ) (ii) Pct of Total = DIVIDE( SUM( [Sales] ) , HASONEVALUE( [Sales All Products] ) ) 6. Dashboards published to PowerBI.com: Can only be shared with users who share the same domain Can be shared with anyone by copying the page’s URL Can be shared with anyone by clicking the Share button Can be shared with anyone by going to File > Publish to Web 7. Which of the following statements is FALSE regarding publishing data on PowerBI.com: Data can be refreshed at any time via a manual refresh Data can be refreshed at scheduled times via a data gateway Data can be refreshed via Power Update Data can be refreshed via Power Query 8. To re-use a custom function in another Power Query custom function: Invoke the function from the Advanced Editor Copy and Paste the function from one Advanced Editor pane to the other Advanced Editor pane Invoke the function from Power Pivot Call the function via a macro 9. Which of the following statements is FALSE regarding maps: Maps are only available in Power BI Desktop Custom maps can be created e.g. to show a shopping mall floor plan Maps can be used to show a concentration of data Power BI Desktop can calculate map locations using latitude and longitude 10. Which of the following statements is TRUE regarding Power BI Desktop drilldowns? Measures can be used as drilldown categories There is a maximum of 10 levels of drilldown available Drilldown layers must be defined at the time of designing the report Tooltips can only be displayed at the top drilldown level Be sure to click the button below to check your answers! By checking your answers, you agree to receive communications from Access Analytic. You can unsubscribe at any time. Click here to review our Privacy Policy. First Name Email Time's up Related Posts:How to Get your Free Power BI AccountWordle for Power BI FansSquareWars – A Fun Way to Learn Excel 365Navigating the New Normal: Why CFOs are embracing Data…Build Wordle using Dynamic Array FunctionsPower Query Challenge Jackie Meddows-Taylor2023-11-01T17:27:37+08:00 Share This Story, Choose Your Platform! FacebookTwitterLinkedInEmail