This portfolio project showcases my ability to design and implement a Customer Relationship Management (CRM) system using SQL and Google BigQuery. It simulates a real-world business environment by modeling core CRM entities—Customers, Leads, Contacts, and Opportunities—and establishes relationships between them using a normalized relational schema.
The project emphasizes data modeling, SQL schema creation, and cloud-based data warehousing skills, with reusable components suitable for future CRM data analysis projects.
- Relational schema with primary and foreign key constraints
- Google BigQuery as the cloud data warehouse environment
- CSV data ingestion through the BigQuery interface (free-tier compatible)
- Modular SQL scripts for schema setup and querying
- Analysis-ready structure for deriving business insights
- Clean and organized folder structure to mirror professional standards
| File / Folder | Description |
|---|---|
schema_setup.sql |
SQL script to create all CRM tables and define relationships |
data/ |
Folder containing CSVs for Customers, Contacts, Leads, and Opportunities |
sql/ |
Includes working SQL files like exploratory_queries.sql, business_insights.sql, etc. |
README.md |
This project overview and usage guide |
- Clone this repository
git clone https://github.com/nicolepcollins/sql-crm-portfolio.git
- Open the schema_setup.sql file in BigQuery and run the statements to create all tables.
- Upload data from the data/ folder into the corresponding tables using BigQuery's CSV upload functionality.
- Explore and analyze the CRM system using the queries provided in the sql/ folder—or write your own!
Skills Demonstrated ✅ SQL schema design & normalization ✅ Data modeling with primary/foreign keys ✅ Cloud-based data warehousing (BigQuery) ✅ Loading & transforming data from CSV ✅ Business logic modeling for CRM systems ✅ Git/GitHub version control & project documentation
About Me
Nicole P. Collins
Aspiring data analyst passionate about building scalable data solutions and uncovering actionable business insights. This project showcases my hands-on experience with SQL and cloud tools, simulating real-world data challenges.
🔗 Connect with me on LinkedIn 📫 GitHub: @nicolepcollins
📌 Tags #SQL #BigQuery #CRM #DataModeling #RelationalDatabase #DataAnalytics #PortfolioProject