COMPLETE Github Project Portfolio ๐
Thank you!
I appreciate you taking the time to contact me. I will get back to you ASAP.
Recent Projects
Review Sentiment Analysis
Scraped data from two competing websites and analyzed their review scores using Natural Language Processing to understand the context of product reviews.
![](assets/images/image06.png?v=7792271c)
Tools Used:
Python
BS4
Sheets
NLP
Retail Price Comparison
Used Beautiful soup and selenium to pull data from two competing websites and analyzed their first product page to compare pricing strategies.
![](assets/images/image04.png?v=7792271c)
Tools Used:
Python
Selenium
SQL
Snowflake
8 Week SQL Challenge
Advanced SQL queries to help a restaurant understand their data.Dannyโs Diner is in need of your assistance to help the restaurant stay afloat - the restaurant has captured some very basic data from their few months of operation but have no idea how to use their data to help them run the business.
![](assets/images/image05.png?v=7792271c)
Tools Used:
SQL
Github
Customer Churn
I asked ChatGPT to act as a fake client and give me a question Data could answer. He asked me to explain our Customer Churn.Using Python and Excel I extracted insights for the most likely reasons Customers were canceling their service.
![](assets/images/image08.png?v=7792271c)
Tools Used:
Python
Excel
ChatGPT
COMPLETE Github Project Portfolio ๐
Tools
Dashboard Color Checker
I built a simple web tool that you can test different dashboard Color themes in both light and dark mode to see how they will look on a completed dashboard.
![](assets/images/image07.png?v=7792271c)
Tools Used:
Sheets
Squirrel365
Serial Number Processor
This was built for a specific use case.Example: Takes 'gh 7-7685' and 'bg-57688' then unifies formatting to 'GH77685' and 'BG57688' then exports into a clean PDF with all your processed serial #s.
![](assets/images/image03.png?v=7792271c)
Tools Used:
Python
Excel
Pandas
Data Articles
Take your Dashboard to the next level!!!
Data Analyst Tips - Written by Cameron Seamons
06/24/2023 * 3 Minute Read
![](assets/images/image09.jpg?v=7792271c)
![](assets/images/image17.jpg?v=7792271c)
T๐ฎ๐ธ๐ฒ ๐๐ผ๐๐ฟ ๐๐ฎ๐๐ต๐ฏ๐ผ๐ฎ๐ฟ๐ฑ ๐๐ผ ๐๐ต๐ฒ ๐ป๐ฒ๐ ๐ ๐น๐ฒ๐๐ฒ๐น!!
Cameron Seamons - Data Analyst Tips
06/24/2023 * 3 Minute Read
Color really can be the difference between a Great dashboard and an awful looking report that loses its message.๐ Think about it - you spend hours collecting and analyzing data, creating charts and graphs, and writing insightful findings, but if your report is presented in an unappealing and confusing way, all that hard work goes to waste.
START WITH YOUR BRAND COLOR PALETTEIf your company has a color palette, that should be your main colors for every report. A lof of organizations have a style guide you need to reference for examples and exact color codes.
Brand Colors
![](assets/images/image10.jpg?v=7792271c)
BAD COLOR HABITSToo many colors can hide your message and confuse the viewer. You should limit your color palette. You also want to focus on using colors that drive your message and highlight the important bits.
Bad Color Habits
![](assets/images/image11.jpg?v=7792271c)
BAD vs GOOD CONTRASTColors that don't have a high enough contrast can make your message hard to read, especially for those with any form of color blindness. Using colors that have a high enough contrast will help make your message clear to anyone that may be looking at your dashboard.
Bad Contrast
![](assets/images/image12.jpg?v=7792271c)
vs
Good Contrast
![](assets/images/image14.jpg?v=7792271c)
BLACK AND WHITEBlack and white are extremely harsh on the eyes, no matter what device the viewer may be using. They will always look slightly off and feel slightly out of place. By simply using off-hue white and black you can improve the readability and overall design of your dashboard.Most major brands do this already without you knowing. For example, Apple uses #F5F5F7 for off white and #212124 for off black.Try it in your next dashboard and see how much of a difference it can make.
PURE Black and White
![](assets/images/image13.jpg?v=7792271c)
vs
Off Black and Off White
![](assets/images/image15.jpg?v=7792271c)
BETTER COLOR SCHEMESMost BI tools (tableau, power bi, etc) come with their own default color schemes. These are often pretty boring and wont really help your work stand out.Some of the default themes also use way too many colors and end up confusing your message even more than if you just used a simple monochromatic color scheme.If you are unsure of what to use, follow your gut and use whatever looks nice when you step back and view your overall design.Also, if you need additional help selecting colors I have a Dashboard Color Checker tool that will show you what different color schemes look like on both light and dark backgrounds.
Monochromatic color scheme
![](assets/images/image16.jpg?v=7792271c)
THE GOLDEN RULE!Ok. So there are actually TWO golden rules.1. Keep it simple! Simple is always best. When you start getting complicated and adding way too many colors you will lose your overall message.2. If a color is not serving a purpose or part of your branding, then it shouldn't be there!
Remember,Keep your audience in mind. Who is viewing the Dashboard and what questions do they need answered? Try to theme your colors around this message.Until Next time.Never. Stop. Learning.
Contact me
Whether its questions about my work, or just to chat about data.
I look forward to hearing from you!