Generated by All in One SEO v5.0.1.1, this is an llms.txt file, used by LLMs to index the site. # Clair Wyant BI & Data Consultant in San Diego ## Sitemaps - [XML Sitemap](https://clairwyant.com/sitemap.xml): Contains all public & indexable URLs for this website. ## Pages - [Marketing Consultant Home](https://clairwyant.com/) - Clair Wyant, a San Diego BI and data consultant. I build the reporting systems and dashboards mid-market and $800M+ orgs trust. Book a free intro call. - [Data Architecture Consultant](https://clairwyant.com/services/data-architecture-consultant/) - Data architecture and data warehouse consulting for mid-market teams: warehouse audits, KPI design & reporting built from the foundation up. US-based. - [Marketing Analytics Consultant](https://clairwyant.com/services/marketing-analytics-consultant/) - Marketing analytics consultant for paid campaigns across Google Ads, Meta, GA4 & CRM. Unified dashboards that prove ROI, not just report it. US-based. - [Looker Studio Consultant](https://clairwyant.com/services/looker-studio-consultant/) - Work directly with a US-based Looker Studio consultant, not an agency. 7+ years turning GA4, Google Ads & BigQuery into live dashboards. Book a free intro call. - [San Diego Tableau Consultant](https://clairwyant.com/services/tableau-consultant/san-diego-tableau-consultant/) - San Diego-based Tableau consultant: custom dashboards, SQL & BigQuery reporting. 7+ yrs, remote across the US. Contact for a project or retainer. - [Tableau Consultant](https://clairwyant.com/services/tableau-consultant/) - Tableau consultant for mid-market teams. I start with the data & warehouse, not just the dashboard. Desktop, Server & Cloud. Project or retainer. - [Data Visualization Consultant](https://clairwyant.com/services/data-visualization-consultant/) - Data visualization services and consulting for Tableau & Looker Studio. Dashboards that unify siloed data into one view. 7+ years, $800M+ orgs. San Diego. - [Business Intelligence (BI) Consultant](https://clairwyant.com/services/bi-consultant/) - Hire a dashboard consultant who builds the KPI system behind your dashboards, not just the visuals. Tableau, SQL, and BigQuery. US-based BI reporting. - [Data & Analytics Consulting Services](https://clairwyant.com/services/) - Tableau, BI, Looker Studio, data architecture & marketing analytics consulting for mid-market teams. San Diego, US-based. Book a free intro call. - [What Sports Are On TV Today? Live Games Schedule (Updated Daily)](https://clairwyant.com/portfolio/live-games-on-tv-today-sports-tv-schedule-dashboard/) - Find what sports are on TV today. Interactive dashboard showing live games, channels, and start times across ESPN, Fox Sports, CBS, NBC, and more. - [Clair Wyant's Interactive Tableau Resume](https://clairwyant.com/resume/clair-wyants-interactive-tableau-resume/) - An interactive Tableau visualization of Clair Wyant's resume: past employers, skills, and software expertise, built as a live dashboard. - [Let's turn your data into a dashboard you'll actually use.](https://clairwyant.com/contact-clair-wyant/) - Contact Clair Wyant, a San Diego BI & data consultant. Tell me about your reporting project and I’ll reply within one business day. No commitment. - [Tableau Workout Wednesday #WOW](https://clairwyant.com/portfolio/workout-wednesday-wow/) - A compilation of my Tableau dashboards from Workout Wednesday, the popular weekly data visualization challenge in the BI community. Built by Clair Wyant. - [Digital Marketing Analytics & Visualizations Portfolio](https://clairwyant.com/portfolio/digital-marketing/) - Clair Wyant's digital marketing data visualization & analytics portfolio, utilizing Google Data Studio (now Looker Studio) & Tableau. - [NCAA Men’s Basketball Tournament History](https://clairwyant.com/portfolio/ncaa-mens-tournament-history/) - Interactive Tableau dashboard of every NCAA Division I men’s tournament team, 1939 to 2025: appearances, deepest round, streaks, and droughts by team. - [Premier League Clubs in the Champions League](https://clairwyant.com/portfolio/champions-league-english-clubs-qualification/) - Tableau dashboard of every Premier League club to reach the UEFA Champions League, 1992-93 to 2025-26, how often each made it, and the 7 English winners. - [U.S. Domestic Nonstop Flights by City and Airline](https://clairwyant.com/portfolio/us-non-stop-flights/) - Which US cities lead in domestic nonstop and direct flights, and where do Southwest, Delta, American, and United compete on the same routes? 2,789 unique routes. U.S. DOT BTS data. - [Data Visualization Projects](https://clairwyant.com/portfolio/) - Data visualization dashboards & reporting projects built with Looker Studio & Tableau by Clair Wyant. - [San Diego Surf Report: Surf, Water Temperature & UV Index](https://clairwyant.com/portfolio/san-diego-beach-conditions/) - Daily surf, water temp, UV & bacteria status for 24 San Diego County beaches. Updated each morning from CDIP, Open-Meteo & the County of San Diego. - [EU & G7 Nations: Economic Indicators Since 2020](https://clairwyant.com/portfolio/eu-g7-uk-economic-figures/) - GDP, CPI, wages, and business investment across all 27 EU member states and G7 nations, indexed before and after 2020. See where the UK and G7 members diverge. Tableau dashboard. - [Phoenix Weather History (2000–2025): Is It Getting Hotter?](https://clairwyant.com/portfolio/history-phoenix-weather/) - 25 years of Phoenix weather history: temperature records, days above 100°F, heat season length, and shoulder season warming. 2024 saw 188 days above 100°F, the hottest year on record. NOAA data, Tableau dashboard. - [EU Internet Access by Country: Household Connectivity Rates](https://clairwyant.com/portfolio/eu-home-internet-access-usage/) - Tableau visualization of European Union internet access statistics. Analyze connectivity by country, urban vs rural areas, and device usage trends since 2015. - [US Military Bases Worldwide](https://clairwyant.com/portfolio/tableau-dashboard-us-military-bases-outside-the-us/) - Interactive Tableau map of 110 US military bases across 43 countries. Filter by branch (Army, Navy, Air Force, Marine Corps, Space Force), by continent, or by country. 85% in Asia and Europe. - [EU Migration Data: Where Immigrants Move in Europe](https://clairwyant.com/portfolio/migration-european-union-countries/) - EU migration data (EuroStat): which countries receive the most immigrants, where non-EU immigrants come from, and how internal EU migration shifted after 2020. Tableau dashboard. - [EU Citizenship by Country: Who Becomes a European Citizen?](https://clairwyant.com/portfolio/new-citizens-european-union-countries/) - 10 years of EuroStat data on European citizenship by country. Italian citizenship leads by volume; Morocco is the top non-EU source. Albania declining, Syria accelerating, Venezuela spiked in 2023. Tableau dashboard. - [Ham Radio Contact Log: HF DX Map & Statistics | KG7MAJ](https://clairwyant.com/portfolio/tableau-ham-radio-contacts/) - Interactive log of amateur radio HF contacts worldwide. DX map showing contacts by band, country, and time. Built by KG7MAJ, licensed since 2013. - [Clair Wyant Resume](https://clairwyant.com/resume/) - Resume of Clair Wyant, BI Architect. Seven-plus years building data infrastructure, Tableau dashboards, and reporting systems for mid-market companies. San Diego. - [U.S. City Open Data Portals: 250 Cities by State](https://clairwyant.com/municipalities-public-datasets/) - A directory of official open-data portals for 250 of the largest U.S. cities, organized by state, with direct links to each city's public datasets and GIS hubs. ## Portfolio - [How Spaces attracted five million visitors by improving the content](https://clairwyant.com/case-study/how-spaces-attracted-five-million-visitors-by-improving-the-content/) - [Creativity helped Hemisferio to increase their brand reach vertically](https://clairwyant.com/case-study/creativity-helped-hemisferio-to-increase-their-brand-reach-vertically/) - [How DigitalBox used AI-powered data insight to boost sales](https://clairwyant.com/case-study/how-digitalbox-used-ai-powered-data-insight-to-boost-sales/) - [How CGlobal is using social media as a tool for commercialization](https://clairwyant.com/case-study/how-cglobal-is-using-social-media-as-a-tool-for-commercialization/) - [How Next used social media to turn haters into loyal fans and ambassadors](https://clairwyant.com/case-study/how-next-used-social-media-to-turn-haters-into-loyal-fans-and-ambassadors/) - [How Abstract reached a global audience with a minuscule budget](https://clairwyant.com/case-study/how-abstract-reached-a-global-audience-with-a-minuscule-budget/) ## FAQs - [Vivamus id ante vel purus commodo cursus? Nunc sit amet cursus massa?](https://clairwyant.com/faq-items/vivamus-id-ante-vel-purus-commodo-cursus-nunc-sit-amet-cursus-massa/) - [Quisque aliquet, libero consequat elementum convallis, erat risus imperdiet?](https://clairwyant.com/faq-items/quisque-aliquet-libero-consequat-elementum-convallis-erat-risus-imperdiet/) - [Duis vel risus egestas, viverra enim sed, pretium velit?](https://clairwyant.com/faq-items/duis-vel-risus-egestas-viverra-enim-sed-pretium-velit/) - [Mauris porta interdum risus, at scelerisque ante faucibus porttitor erat sit?](https://clairwyant.com/faq-items/mauris-porta-interdum-risus-at-scelerisque-ante-faucibus-porttitor-erat-sit/) - [Suspendisse sed ligula sed est ornare gravida varius natoque magnis?](https://clairwyant.com/faq-items/suspendisse-sed-ligula-sed-est-ornare-gravida-varius-natoque-magnis/) - [Curabitur ornare felis sit amet neque volutpat, porta lobortis elit rutrum?](https://clairwyant.com/faq-items/curabitur-ornare-felis-sit-amet-neque-volutpat-porta-lobortis-elit-rutrum/) - [Praesent posuere nisi risus auctor posuere? Etiam auctor laoreet magna?](https://clairwyant.com/faq-items/praesent-posuere-nisi-risus-auctor-posuere-etiam-auctor-laoreet-magna/) ## Portfolio Categories - [Content Strategy](https://clairwyant.com/portfolio_category/content-strategy/) - [Customer Experience](https://clairwyant.com/portfolio_category/customer-experience/) - [Digital Strategy](https://clairwyant.com/portfolio_category/digital-strategy/) - [Local Marketing](https://clairwyant.com/portfolio_category/local-marketing/)