Data Acquisition

1. Authenticate and manage data source settings.

2. Configure permissions and privacy levels.

3. Construct queries using custom SQL.

4. Differentiate between shared and local datasets.

Ensuring Data Quality

1. Utilize profiling tools for data assessment.

2. Address blank fields and errors.

3. Understand cardinality and its impact.

4. Define and correct data types.

Leveraging Applied Steps

1. Manage query steps and document actions.

2. Employ Advanced Editor for custom changes.

Extending Data Beyond Limits

1. Integrate and manipulate new data points.

2. Optimize data through column and row management.

Advanced Query Manipulation

1. Merge and append multiple queries.

2. Utilize helper and duplicated queries effectively.

Query Durability Practices

1. Troubleshoot and resolve query errors.

2. Reuse queries across different PBIX files.

Parameters and Functions Insights

1. Create and use parameters and functions effectively.

2. Explain the necessity of data models and star schemas.

Filtering and Relationship Management

1. Establish and leverage data relationships.

2. Implement complex filtering using CALCULATE.

Enhancing the Semantic Model

1. Integrate new DAX-based content.

2. Optimize model performance and manage field visibility.

Securing Data with Precision

1. Understand and apply row-level security.

2. Differentiate between static and dynamic security methods.