I'm a SharePoint newbie and I am wondering the best way to design SP web application. There are 2 departments- Dept A takes customer data, Dept B analyses customer data.
- Can I create 2 site collections like this-
company.com/sites/customerAnalyseaccess data from
company.com/sites/customerInfo? If so, how? (Data will be likely stored in list or document library.)
EDIT: There will be one document library which collects all customer transactions. The documents uploaded are for documentation only. But the doc properties like customer name, region, dollar amount etc will be used for customer analysis (Lets call this Company Customer Data). This 'Company Customer Data' will be compared against 'External Customer Data' that will come from an external data source (i.e. another database on same SQL server as that of SharePoint) and analysed. Will likely use Microsoft BI tools.