BalloutMoe
Board Regular
- Joined
- Jun 4, 2021
- Messages
- 137
- Office Version
- 365
- Platform
- Windows
Hello All,
I currently manage 10 Locations and for each location I have 6 different CSV files that contain anything from sales to employee ect... I have cleaned up the data using power query with conditional formatting as not every column is used and some calculations are being done along with lookups. I can create a pivot table however the data is so large (dating back to 2018) that it takes forever to update. And I need it to update daily as I get the csv file everyday at 6:00 pm. I have been thinking of using Access to build a database however I have no idea how to apply conditional formatting and the steps that were done with PowerQuery in Access to achieve the same results. Any ideas or tips how to handle such large data. The file names are always the same. But I have no idea how to go about it as I am trying to build monthly reports along with Daily Sales report. Any help or ideas would be greatly appreciated.
Thank you
I currently manage 10 Locations and for each location I have 6 different CSV files that contain anything from sales to employee ect... I have cleaned up the data using power query with conditional formatting as not every column is used and some calculations are being done along with lookups. I can create a pivot table however the data is so large (dating back to 2018) that it takes forever to update. And I need it to update daily as I get the csv file everyday at 6:00 pm. I have been thinking of using Access to build a database however I have no idea how to apply conditional formatting and the steps that were done with PowerQuery in Access to achieve the same results. Any ideas or tips how to handle such large data. The file names are always the same. But I have no idea how to go about it as I am trying to build monthly reports along with Daily Sales report. Any help or ideas would be greatly appreciated.
Thank you