Basic data analysis?

Hi, does anyone have instructions for basic data analysis? I’ve been told pivot tables would help me compare weekday and weekend data at a site, but I’m also interested in comparing two sites during the same time period. I’ve looked up how to perform pivot tables, but it’s not clear to me how this applies to AQ. Thanks.