Instiq

1Prepare the data

Practice questions →Glossary →
  • 1.1Get and connect to data

    Understand connecting to data sources and shared semantic models, choosing storage mode (Import / DirectQuery / DirectLake), credentials/privacy levels, and using parameters.

  • 1.2Profile and clean the data

    Understand evaluating data with data profiling (column quality/distribution/statistics) and resolving inconsistencies, nulls, error values, and import errors in Power Query.

  • 1.3Transform and load the data

    Understand column types/creation, grouping/aggregation, pivot/unpivot, building fact/dimension tables, reference vs duplicate, merge vs append, relationship keys, and query load configuration.