Subversion Architecture/ Repository Structure for BI
Page 1 of 1
Subversion Architecture/ Repository Structure for BI
Hi Everyone,
We are just getting started with Microsoft's stack of tools as our BI solution.
We will be creating/using SSRS Reports, SSAS Tabular Models, Excel Services.PowerPivot models and PowerView reports for each functional area within our company.
For each functional area say ("Human Resources") we will be having a set of Reports, Data models, Dashboards etc
I was wondering if anyone of you could point me in the right direction for maintaining all the projects under Version control ( We will be using SVN ). Is there a standard way of maintaining all these diverse kinds of files/folders under SVN ?
Or in simple terms could you point me the benefits of using one over other in the following.
1) Create separate folders for each Functional Area such as "Human Resources", "Sales" etc and house all the reports, models related to that functional area within their respective folders
The folder structure would look something like this
Human Resources - > HR Models -> HRDataModelProject1 ( This level will be the root for svn - And developers will checkout projects from this level )
Human Resources - > HR Reports -> ReportProject1
Sales- > Sales Models -> SalesModelProject1,
Sales- > Sales Reports -> SalesReportProject1,
Or
2) Create separate folders for each content type such as Data Models, Reports etc as separate folders and house reports or models for each functional area
Models - > HumanResources - > HRDataModelProject1 ( This level will be the root for svn - And developers will checkout projects from this level )
Models - > Sales - > SalesModelProject1
Reports - > HumanResources - > HRReportProject1
Reports - > Sales - > Sales ReportProject1
Are there any pros and cons of the above methods? Or is there any other way to do it more efficiently ? Your advice is very much appreciated !
Many Thanks
BiDev
We are just getting started with Microsoft's stack of tools as our BI solution.
We will be creating/using SSRS Reports, SSAS Tabular Models, Excel Services.PowerPivot models and PowerView reports for each functional area within our company.
For each functional area say ("Human Resources") we will be having a set of Reports, Data models, Dashboards etc
I was wondering if anyone of you could point me in the right direction for maintaining all the projects under Version control ( We will be using SVN ). Is there a standard way of maintaining all these diverse kinds of files/folders under SVN ?
Or in simple terms could you point me the benefits of using one over other in the following.
1) Create separate folders for each Functional Area such as "Human Resources", "Sales" etc and house all the reports, models related to that functional area within their respective folders
The folder structure would look something like this
Human Resources - > HR Models -> HRDataModelProject1 ( This level will be the root for svn - And developers will checkout projects from this level )
Human Resources - > HR Reports -> ReportProject1
Sales- > Sales Models -> SalesModelProject1,
Sales- > Sales Reports -> SalesReportProject1,
Or
2) Create separate folders for each content type such as Data Models, Reports etc as separate folders and house reports or models for each functional area
Models - > HumanResources - > HRDataModelProject1 ( This level will be the root for svn - And developers will checkout projects from this level )
Models - > Sales - > SalesModelProject1
Reports - > HumanResources - > HRReportProject1
Reports - > Sales - > Sales ReportProject1
Are there any pros and cons of the above methods? Or is there any other way to do it more efficiently ? Your advice is very much appreciated !
Many Thanks
BiDev
BIDev- Posts : 2
Join date : 2013-10-30
Similar topics
» Data Vault v's Dimensional Model
» Warehouse Structure
» How to Structure Information
» Reporting table data repository vs. Dimensional data store
» Fact table structure
» Warehouse Structure
» How to Structure Information
» Reporting table data repository vs. Dimensional data store
» Fact table structure
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|