Demand is how popular a niche might be compared to others. Opportunity is how good a niche might be and if it might be worth trying out mixed with also having better chances to be on page 1.