--- title: "Tutorial Plan" slug: "tutorial-plan-1" updated: 2023-11-23T19:29:30Z published: 2023-11-23T19:29:30Z canonical: "docs.datajet.app/tutorial-plan-1" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.datajet.app/llms.txt > Use this file to discover all available pages before exploring further. # Tutorial - Create DJDemo2023 Project ## Introduction To begin working in DataJet, you will first need some data to work with, and that data will need to be on the DataJet server. This tutorial will take you through the process of downloading the DataJet demo data files, adding them to the server where DataJet is running and then using those files to create a sample project. NOTE - If working on the "**dj-demo**" realm, the DJDemo2023 project will be on the server already. - Your organisation may not allow you to upload data to the server in which case you will only be able to create the Demo project if the data has already been added to the server - Speak to a database administrator if the demo data is not already on the system you are working on and you do not have the ability to upload data ## Objective This Tutorial shows how to: - **Download** the DataJet Small Demo Database from the DataJet Download server (note - other data can be used in place of the DataJet demo data if you have it) - **Upload** the demo data files to the active DataJet realm - **Extract** the data, script and definition files - **Run** the script and **create** a demo project and reports ## Key Techniques that will be covered - Accessing the download server - Uploading data to the DataJet server - Decompressing data files - Downloading from the DataJet Server - Using [Script Editor](/v1/docs/script-editor) to run a complete script - Opening and viewing a project ## Step 1 - Download Demo Data Go to DataJet download server and download djdemo2023.rar: [https://download.datajet.app/data/djdemo2023](https://download.datajet.app/data/djdemo2023 ) ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700571300472.png) (store in the usual downloads location) ## Step 2 - Login to DataJet Run **DataJetExplorer.exe** to bring up the login screen. Enter or select a realm name, enter username, and provide password. Login CredentialsThe example shown here uses the **dj-demo** realm, but your organisation will provide you with the correct login credentials. You will require the following: - DataJet **realm** **name** - **Username** - **Password** Installing DataJet DesktopIf DataJet Desktop is not already installed on your client machine, it can be downloaded from: - https://download.datajet.app/desktop See [Installing DataJet Desktop](/v1/docs/datajet-desktop-client-for-windows-installation-instructions-v41) for further details ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700571967257.png) Click **Sign In** to connect to the selected DataJet realm. The DataJet Desktop Application will be opened: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700572266448.png) (For more details on logging in to DataJet, see [Logging in to DataJet Desktop](/v1/docs/logging-in-to-datajet-desktop)) ## Step 3 - Uploading and Extracting data Upload TimeIt will take approximately 5 mins to upload the full demo database to the server - this step is not necessary if working on dj-demo or if the demo data is already on your realm #### Open Remote File Manager Go to **Admin | Remote Files** and select the **Data Source** Folder:![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700563180818.png) #### Go to Data Source Folder Check for existence of sub-folder **DJDemo2023**![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700564381239.png) #### Verify Files are on the Server If the **DJDemo2023** folder already exists, go to [Step 4](/v1/docs/tutorial-plan-1#step-4-check-data-files-are-on-the-server). If file **djdemo2023.rar** already exists in the Data Source folder, go to [Step 4](/v1/docs/tutorial-plan-1#step-4-check-data-files-are-on-the-server). If the DJDemo2023 folder **does not** already exist, and the file djdemo2023.rar is not in the Data Source folder, upload the **djdemo2023.rar** file by selecting the **Data Source** folder and choosing "Upload":![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700572480395.png) #### Refresh Remote File manager Once the upload is complete (when the status in the popup Job Window changes from "**Running**" to "**Complete**"), close the Job Window and press Refresh:![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700766422479.png) #### Unpack the Demo Data Files Decompress the file djdemo2023.rar into folder DJDemo2023. To do this: 1. Select the **checkbox** next to the file djdemo2023.rar 2. Click the "**Decompress**" icon 3. When the "**over-write existing files?**" message is displayed, click **yes**. Contents of djdemo2023.rar**djdemo2023.rar** contains a sub-folder called **DJDemo2023** - if this folder already exists, any existing files in that folder that have the same name as files in the *.rar will be overwritten.  It is safe to overwrite these  ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700565448061.png) ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700565599882.png) ## Step 4 - Check Data Files are on the Server #### Verify Demo package contents Go to **Admin | Remote Files | Data Source** ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700563180818.png) Go to sub-folder **DJDemo2023** and verify it contains the following files: - sales.dat - customer.dat - product.dat - CategoryDecodes.xlsx - 12 month sales template.xlsx - djdemo2023 load script.json - djdemo2023 - injected.json - RFM Groups.xlsx ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700565756972.png) ## Step 5 - Download and Run Demo Script This step shows how to download the demo script shipped as part of the DjDemo2023 project from where it has been unpacked on the DataJet server. Once this script file has been downloaded to the local machine, we will then use **Script Editor** to open it and run it. Script Editor[Script Editor](/v1/docs/script-editor) is a part of DataJet Desktop and runs on the local client machine.  In general scripts are stored and edited on the local machine, at least until they are ready to be published and shared with others #### Download the script Download the script by 1. going to **Admin | Remote Files | Data Source | DJDemo2023**, 2. selecting/checking **djdemo2023 load script.json** 3. selecting "**download**" 4. download the file to wherever local scripts will be stored. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700573408971.png) #### Open Script Editor Open Script Editor by going to **Script | Editor:** ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700572880573.png) The Script Editor Workspace will open: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700573523633.png) #### Open Script Open the demo script file by going to **File | Open** and browsing to wherever the script file **djdemo2023 load script.json** was just downloaded. ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700573769927.png) The file will be displayed in the Script Editor window. #### Run the Script Verify that the project name is correct (it is possible to choose a name other than DJDemo2023 if required) and click Run:![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700574043377.png) When the script executes, it will verify that project "DJDemo2023" (or whichever project name has been selected) should be dropped. Click Drop Project: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700574383876.png) CAUTION!If another user has been working in an existing project called DJDemo2023, selecting Drop Project will delete that version of the project and over-write it with a new one. If this happens in error, speak to a system adminstrator for details of how to retrieve the original project As the script executes, the Method Window will update with progress:![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700574564936.png) When the script has completed, the final execution time will be displayed in the Output Window: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700575833290.png) ## Step 6 - Accessing the Demo Project To access the project that has been created by the script, go to **Projects | Open** and select the project **DJDemo2023**: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700576127857.png) DJDemo2023 will load into the project workspace: ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1700576188985.png) The project is now ready for exploration. See [Instant Insights](/v1/docs/instant-insights) for tips on how to begin exploring and analyzing data. A collection of data (consisting of projects, metadata and data objects) and users that together provide a functional and siloed domain of operation. Each realm belongs to a single DataJet server, and must have a unique name. The realm must be specified when logging in to DataJet.