What is not a best practice for naming conventions in Power BI?

Which two field options are available when creating a waterfall chart?

Client provides you with SQL Server Analysis Service database connectivity with Multidimensional database structure. To import data use, Get Data -> SQL Server Analysis Service and data will be imported to Power BI. Is this statement correct?

You have a prospective customer list that contains 1,500 rows of data. The list contains the following fields:

- First name

- Last name

- Email address

- State/Region

- Phone number

You import the list into Power Query Editor.

You need to ensure that the list contains records for each State/Region to which you want to target a marketing campaign.

Which two actions should you perform?

What is the purpose of TRIM function?

You want to create a line chart showing Quantity by the invoice date. You notice that there is a relationship between the Date from the Date table and the Invoice Date Key from the Sale table, but the relationship is inactive. All other visuals in your report will be analyzing values by delivery date. How should you approach this problem?

The marketing team needs a new dashboard to show the uptake of social users on the company’s corporate forum. The dashboard will contain one particular report that shows the total number of users that registered for the site in each of the months of the year. For this report you want to create a dataset with a calculated column that displays the date with the abbreviated month name followed by the four-digit year e.g. Jan 2018. Which DAX expression should you use?

What is true about using variables in DAX?

How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created.

How do you connect to Excel files that contain target figures? The solution should involve minimum manual work when new Excel files are created.