Hi,
I am designing a report for the sales team and there could be 400k rows and about 20 columns (sales information like Qty, $, class, state etc by weeks), what they need is to compare X number of the weeks from year to year, What would be the best way to complete this?
The easiest i am thinking about using Pivot table with a timeline on the top to select the week numbers say (Week 1, 2,6 etc) and compare by different years
Just a bit to concern about the size of the file so is it better to prepare it in power BI or using access to hold the data?
Also for visualization should i use Power BI too?
Cheers,
Peter
I am designing a report for the sales team and there could be 400k rows and about 20 columns (sales information like Qty, $, class, state etc by weeks), what they need is to compare X number of the weeks from year to year, What would be the best way to complete this?
The easiest i am thinking about using Pivot table with a timeline on the top to select the week numbers say (Week 1, 2,6 etc) and compare by different years
Just a bit to concern about the size of the file so is it better to prepare it in power BI or using access to hold the data?
Also for visualization should i use Power BI too?
Cheers,
Peter