290 likes | 442 Views
Overview. Finding and Using Population demographics and Commerce Data Files Comm. 352 – Marketing Strategy. Chipo Kangayi Harpreet Aulakh Data & GIS Library Services, U of S Library October 22, 2007. Ways to Find Data Files. Library Catalogue
E N D
Overview Finding and Using Population demographics and Commerce Data FilesComm. 352 – Marketing Strategy Chipo Kangayi Harpreet Aulakh Data & GIS Library Services, U of S Library October 22, 2007
Ways to Find Data Files • Library Catalogue • Data &GIS Library Services page: Data File by Topic • Statistics Canada Catalogue • Google Searches • Talk to the Data Library staff
Outline Purpose • Situational analysis • Develop a Marketing Strategy Overview • Find Population Demographics and Community Profiles • Use Commerce Data Files
Finding Population Demographics • CANSIM via E-STAT • Census of Population • Community Profiles
Connect to CANSIM from the Data and GIS Library Services • Library home page • Collections • Data and GIS Library Services https://library.usask.ca/data • CANSIM • CANSIM II – via CHASS • CANSIM II – via E-STAT CANSIM via Statistics Canada
ESTAT • English • Accept and Enter • Review license, click “Accept and Enter” button.
Demonstration: CANSIM II via ESTAT • CANSIM II via ESTAT http://tinyurl.com/2oafwu • People: Population and demography • CANSIM: Population Changes • Table: 051-0035; Components of population growth, census divisions and census metropolitan areas, 2001 Census boundaries, annual (persons), 1986/1987 to 2005/2006 • Select Geography: Saskatoon, Saskatchewan [47725] • Select Components of population growth • Select Reference Period: to from • Retrieve as a Table • Select Output format
Demonstration: Census via E-STAT • Census via ESTAT http://tinyurl.com/2oafwu • People: Population and demography • Census Database: Population Changes • 2006 Census of Population (Provinces, Census Divisions, Municipalities) • Table 2006 Population by age group and sex • Select Geography • Select Characteristic • Choose output format To download in Excel- Choose Comma Delimited File
Census of Population • Statistics Canada http://www.statcan.ca/menu-en.htm • Census (left hand menu) • Census of Population 2006; 2001; 1996 • Census 2001: Census of population • Search by topic, geography • Topic: Place of work • Electronic profiles: Cat. No. 95F0490XCB2001009 (#10) • Select geography; Download format Look for geographic index tab for Topic-based tabulations
Finding Community Profiles • Statistics Canada http://www.statcan.ca/menu-en.htm • Census (left hand menu) • Community Profiles • Search Saskatoon; Select city Don’t forget to read footnotes
Aboriginal People demographics • Statistics Canada, Community Profiles page http://tinyurl.com/2sd2ya • 2001 Census Aboriginal Population Profile (right hand menu)
Neighbourhood Profiles • Saskatoon • City of Saskatoon http://www.saskatoon.ca/org/city_planning/index.asp • Departments • Community Services • City Planning • Demographics • (drop down menu)
Other resources • Saskbiz: www.saskbiz.ca • Community Profiles • Select region • Select place from map • Analyze & Evaluate (right hand menu)
FINDING COMMERCE DATA FILES
1. The Library Catalogue • Know the name of the survey or the Key Words for your data needs Locate a survey by entering the survey name Keyword Search: Canadian Business Patterns
The Catalogue cont’ • Limit your search by “scoping” select Data & GIS files from the pull-down menu more manageable result list
2. DLS DATA FILES BY TOPIC https://library.usask.ca/data/ Small Area Retail and Trade Estimates
3. Statistics Canada Catalogue • Keywords: business
4. Google /General Internet Search • Industry Canada http://tinyurl.com/34j3aa • Saskatchewan Department of Industry and Commerce http://www.ir.gov.sk.ca/saskinfo • Canada Business http://www.canadabusiness.ca/gol/cbec/site.nsf/en/bg00328.html
5. Ask Data Library Staff Office: 2nd Floor, Main Library • Appointments recommended • Email us at refdata@library.usask.ca • Call us: 966-5987 Darlene Fichter (7209) Winnie Smit (7261) Rob Alary (5987) Elise Pietroniro (2677) Harpreet Aulakh (8841) Chipo Kangayi (8841)