Perform the Extraction Transformation and Loading (ETL)

Practical 2: Perform the Extraction Transformation and Loading (ETL)

process to construct the database in the Sqlserver / Power BI.

Step1:

Home- OData Feed

http://services.odata.org/V3/Northwind/Northwind.svc/

Select Orders and Products and click transform data

Step2:

Remove all the columns and keep Productid, productname, quantityperunit, unitinstock

Step3:

Change the data type of unitsinstock column to whole number

Step4:

Select order_details column

Click on the right icon

Click on expand

Step5:

Add column – Custom column - give column name (linetotal) – enter formula

[Order_Details.UnitPrice]*[Order_Details.Quantity]

Step6:

Rename the column name as Total

Step7:

Left click and drag the Total column beside the shipcountry column

Step8:

Close and apply

Step9:

Select data, the tables will be displayed

Step10:

Click manage relationships

Step11:

Click edit and click ok

Step12:

Click model and the ER diagram will be displayed

BSCITprojects