AnalyticsCreator — Northwind setup record
Do not record passwords.

1. SQL Server and tools
Server address and instance (localhost only for this computer):

LAN hostname and actual TCP port, if used:

SQL Server engine version and edition:

Sign-in method and account name (no password):

OLE DB driver version and application architecture:

SSMS version; SSIS runtime version and full DTExec.exe path:

2. Northwind and database preparation
Source server and database (Northwind):

Northwind copy: already prepared or loaded from the supplied sample:

Source check date and result; sample revision:

Settings name reserved: NorthwindTutorial; repository: repo_NorthwindTutorial:

Design database reserved: dwh_NorthwindTutorial:

Separate warehouse destination: NorthwindWarehouse; actual server:

SQL Server database-file folder; creation and loading permissions:

3. AnalyticsCreator and saved settings
AnalyticsCreator release and 32-bit / 64-bit choice:

Actual saved warehouse name and repository database:

Actual design database and server:

4. Northwind model
Northwind connector name and successful connection test:

Selected source tables and packages:

Actual warehouse schema/table/column names for Customers, Products, Orders and Order Details:

Analytical table names, keys and relationships:

Sales calculation and rounding rule:

5. Generated files
Deployment name; SQL/SSIS generation target:

Destination server/database checked against NorthwindWarehouse:

Output folder and configuration folder:

Configuration connection checked; package source and destination checked:

Full main package path; configuration path; generated file hashes:

Generated .pbip file and associated .Report / .SemanticModel folders:

6. Load and result checks
Validation command, date, exit code and log path:

First load: date, exit code and log path; attempt marker:

Source and destination row counts: Customers / Products / Orders / Order Details:

Key, relationship and column comparison results:

Generated sales fact: complete line key, row count, units and net sales check:

Quantity and line-rounded sales total; first differing record if any:

Retry, if needed: preserved logs; new target and output paths:

7. Optional Power BI report
Desktop version and generated .pbip location:

Warehouse connection and refresh result:

Sales measure and report total compared with the warehouse: