Hello
I’d like to get someone's opinion on whether the set up I have is most efficient or if there are any other recommendations.
I currently have 3 tables.:
1st table is named “stock” and has 1Million rows
2nd table is named “optimization” and has 400K rows
3rd table is named “fill rate” and has 100K rows
The “stock” table is downloaded via sql from our MRP system
The “optimization” table is also downloaded via sql from our MRP system
The “fill rate” table is downloaded from SAP via business warehouse.
Once all three are downloaded, I import all three via text files into Microsoft Access.
I then create a query to join the three tables and bring in the necessary columns and I also create calculated columns .I run the query and make it a new table in Access and I name the table ‘analysis’ in Access
After those steps I connect powerpivot to the table in Access named ‘anaylsis’ and begin to perform my analysis in Powerpivot.
Is this the most efficient method to use? If I were to use SQL Server Express instead of MS Access would it make this process easier and quicker to run? What are your thoughts?
I’d like to get someone's opinion on whether the set up I have is most efficient or if there are any other recommendations.
I currently have 3 tables.:
1st table is named “stock” and has 1Million rows
2nd table is named “optimization” and has 400K rows
3rd table is named “fill rate” and has 100K rows
The “stock” table is downloaded via sql from our MRP system
The “optimization” table is also downloaded via sql from our MRP system
The “fill rate” table is downloaded from SAP via business warehouse.
Once all three are downloaded, I import all three via text files into Microsoft Access.
I then create a query to join the three tables and bring in the necessary columns and I also create calculated columns .I run the query and make it a new table in Access and I name the table ‘analysis’ in Access
After those steps I connect powerpivot to the table in Access named ‘anaylsis’ and begin to perform my analysis in Powerpivot.
Is this the most efficient method to use? If I were to use SQL Server Express instead of MS Access would it make this process easier and quicker to run? What are your thoughts?
