Construct an advanced SQL query using window functions to retrieve employee sales data, calculate rolling averages, and rank them by region. Ensure the query filters out any records with null values in it.