Identify and connect to a data source
Change data source settings, including credentials, privacy levels, and data source locations
Select a shared dataset, or create a local dataset
Choose between DirectQuery, Import, and Dual mode
Change the value in a parameter
Evaluate data, including data statistics and column properties
Resolve inconsistencies, unexpected or null values, and data quality issues
Resolve data import errors
Select appropriate column data types
Create and transform columns
Design a star schema that contains facts and dimensions
Identify when to use reference or duplicate queries and the resulting impact
Identify and create appropriate keys for relationships
Configure data loading for queries