Canadian Housing Analysis

 Introduction

This dashboard provides a comprehensive analysis of the Canadian housing market, focusing on various key metrics such as home ownership rates, vacancy rates by provinces, housing affordability, and the relationship between house prices and median family incomes. It offers a visual summary that helps to understand the current state of the housing market across different provinces and major cities in Canada.

Technologies Used and Chart Inferences

The dashboard was created using Tableau, a powerful data visualization tool that allows for the creation of interactive and insightful visualizations. The following charts and maps were utilized:

1. Bar Charts: Displaying home ownership rates across different provinces, allowing for a quick comparison of ownership percentages.

2. Filled Map: Showing vacancy rates by provinces, providing a geographical representation of housing vacancies and highlighting regions with higher or lower vacancy rates.

3. Pie Charts: Illustrating housing affordability in selected provinces (Alberta, British Columbia, Manitoba, Ontario, and Saskatchewan), categorizing the data into very affordable, affordable, moderate, and unaffordable housing.

4. Bar Charts: Comparing house prices to median family incomes in various cities, demonstrating the disparity between housing costs and family income.

Inferences

The visualizations reveal significant insights into the Canadian housing market:

• Home Ownership Rates: Newfoundland and Labrador have the highest home ownership rates, whereas Quebec has the lowest.

• Vacancy Rates: Saskatchewan shows the highest vacancy rate, which may indicate a surplus of housing or less demand.

• Housing Affordability: British Columbia exhibits a significant portion of unaffordable housing, while provinces like Manitoba have more balanced affordability categories.

• House Price vs. Median Income: Cities like Vancouver and Toronto show a stark contrast between high house prices and median family incomes, indicating a challenging affordability scenario in these urban areas.

Overall, the dashboard effectively highlights regional disparities and challenges in the Canadian housing market, providing valuable insights for policymakers, investors, and potential homeowners.

 Superstore Dataset Analysis

Introduction

This Tableau dashboard offers a detailed analysis of profit distribution across various product categories, sub-categories, states, and regions in the U.S. from 2014 to 2017.

Technologies Used and Chart Inferences

The dashboard leverages Tableau to create interactive visualizations, which include:

1. Bar Chart: Illustrating category-wise profit breakdowns by sub-categories, showing the profitability of each sub-category within Furniture, Office Supplies, and Technology.

2. Line Chart: Depicting year-wise profit trends across different categories, providing a temporal view of profitability changes from 2014 to 2017.

3. Filled Map: Highlighting profit distribution across different states, visually representing the geographical areas of higher and lower profitability.

4. Stacked Bar Chart: Comparing region-wise profit for different categories, showcasing the contribution of each category to the total profit in the Central, East, South, and West regions.

Inferences

The visualizations reveal significant insights into profit distribution:

• Category-wise Profit: Technology has the highest overall profit, with Phones being the most profitable sub-category, while Furniture shows some sub-categories with negative profits, such as Tables.

• Year-wise Profit Trends: Profits for Technology and Office Supplies have shown a consistent upward trend from 2014 to 2017, whereas Furniture's profits have remained relatively flat.

• Geographical Profit Distribution: States like California and New York show high profitability, indicating strong market performance in these areas.

• Regional Profit Comparison: The East region leads in overall profit, with significant contributions from Technology and Office Supplies, while the South region shows the least profit.

This dashboard effectively highlights the key areas of profitability and performance, providing valuable insights for business strategy and decision-making.