1 to 3 months –
30+ hrs/week –
We have a database in SQL Server with a table containing the raw flattened data of sales.
The columns contains such information:
1. Sales Date
2. Sales Receipt No
3. Item No
4. Item Attributes (Attributes1, Attributes2, Attributes3 … etc)
5. Membership details (Name, Gender, Date of Birth, Address, Country etc)
6. Sales location (Country, City, Outlet etc)
We want to use R to perform analysis.
1. Connect to JDBC (Setup the JDBC connection on the SQL server as well)