In this project, we deal with sales data for Internet sales over the last 3 years
I have made some small transformations with SQL(SQL Server)on data such as:
-
select specific columns to use
-
transform some columns items to make it suitable to read
-
join some tables together
-
rename some columns
and create five tables: Internet Sales, Customers, Dates, Products.
after that we load data into power bi to create some visualizaions such as:
-
Sales Analysis Details
-
Customers Details
Into Power bi, I have made data transformation such as: transform some data, create measures, group measures into a table.