Welcome to my Data Portfolio

Hello, my name is Ayanna Smith

I am a recent graduate of the accelerated MBA program at Rochester Institute of Technology, where I obtained a B.S. in Print & Graphic Media Science and Technology. This data portfolio showcases the work I've completed in all data-related courses at RIT.

MGIS 650: Intro to Data Analytics and Business Intelligence:

This course reviewed statistics and introduced concepts and tools for making complex business decisions and interpreting, visualizing, and analyzing data. We worked in groups to create regression models, visualizations, and dashboards to help explain and interpret data. We harvested data from online sites or APIs for text and sentiment analysis.

Project 1: Analysis of the US Adult Obesity Rate

https://drive.google.com/drive/folders/1d5wP30H22zcRAaEb70DpEoZZctF1rr4X?usp=drive_link

Analyzed a USDA dataset on obesity rates and contributing factors across U.S. counties
involved reviewing the data, performing initial analyses, and deeloping regression models to identify key factors influencing obesity
Deliverables included an executive summary for non-statistical stakeholders, detailed reports on our analyses and model validations, and recommendations for effectively communicating our findings.

Additional Graphs

Project 2: Analysis of US Crime Rate

https://drive.google.com/drive/folders/1s3od9acHkE8mzAktzjHtOH1vlqO2117e?usp=drive_link

Analyzed historic crime data across the U.S. to establish baseline statistics and assess the impact of state laws on crime
Our work included examining crime trends, demographic factors, and the effectiveness of law enforcement groups
We delivered an executive summary, detailed report, and presentation summarizing our findings and recommendations.

Project 3: Text & Sentiment Analysis

https://drive.google.com/file/d/1qMfylkTQjnNDHum4EXodPwOXCDsFNc33/view?usp=sharing

Analyzed Microsoft stock by preprocessing text data, performing sentiment analysis using the NRC Sentiment Lexicon, and conducting time series analysis.
This approach allowed us to visualize common words and sentiments, track how public opinion evolved over time, and gain insights into the factors influencing Microsoft’s stock performance.

MAAT 301: Database Publishing:

This course is centered on personalized graphic communications: this entails customizing graphic messaging for individuals and specifically targeted audiences. The requisite competencies for database publishing, including managing and accessing databases and integrating digital assets for distribution using electronic and digitally printed methods, form the core of this course. Learners work with the fundamental design elements of databases constructed for activities that support graphic communication processes. Topics include best practices for building, optimizing, and maintaining databases comprising recipient information, as well as the merging of data with managed digital assets. Projects include composing publications and creating personalized documents for distribution online and in print.

Datamining

https://drive.google.com/drive/folders/1wBxqM5yX4r9eDDxAo_kMHpt-QGdXPFr5?usp=sharing

Collected information from the 2018 Winter Olympics
viewed original data source and eliminated irrelevant data

Performance Report

https://datastudio.google.com/reporting/b41ac978-781d-4e0f-a81e-1b993f16bb03

produced a goodle data studio dashboard from the giogle store 2018 data
created a website performance report
report included a traffic chart, E-commerce conversion rate chart, avergare ordervaule, traffic sources table, Decembeer 2018 vs. December 2017 scorecards, and an informative chart

OpenRefine

https://drive.google.com/drive/folders/1punOvRk5rQiHXZRL17fj7oqDzP0ywE0G?usp=sharing

used OpenRefine to clean and separate data
eliminated inconsistencies within the data

VDP Birthday Card

https://drive.google.com/drive/folders/1punOvRk5rQiHXZRL17fj7oqDzP0ywE0G?usp=sharing

Gathered names and birthdays and put them into an excel sheet
input various greetings or each person
used different images for each name

Automated Campaign Email

https://21060358.hubspotpreview-na1.com/_hcms/preview/content/71379800162?portalId=21060358&_preview=true&cacheBust=1651465209959&preview_key=ZjIxrXRH&from_buffer=false

Created a personalized email for different target personas
targeted older married couples and younger couples

Campaign Form

https://share.hsforms.com/1I401cGorQpu_50nOyOSLYAcje9y

Once viewers clicked the button on the initial email, it sent them to this form so I could get a better understanding of their travel interests
The information was then stored in an external excel sheet that was to be used for future marketing purposes

Campaign Landing Page

https://21060358.hubspotpreview-na1.com/_hcms/preview/content/71793496663?portalId=21060358&_preview=true&from_buffer=false&preview_key=lavnoFlh

Potential customers are sent this link once they fill out the form
it details personalized experiences for the specific target groups

Campaign Workflow

https://app.hubspot.com/workflows/21060358/platform/flow/195979920/edit

Details the order in which the customer is supposed to follow the campaign items
Starts with an initial email that sends customers to fill out a form
After the form is filled out, they are sent to a landing page that has another form that automatically triggers another email that customers will receive monthly

VDP Travel Postcard

https://drive.google.com/drive/folders/1SeIkahTak5-ArxWk4gLfDF2NahCpPycE?usp=sharing

Created a customized travel postcard that included various pictures and text
used FusionPro to differentiate which picture and text went on the postcard

Campaign VDP Postcard

https://drive.google.com/drive/folders/18H9dIuvfWvqSj5-oTTVOW4B0VWPrWwuT?usp=sharing

Created an initial postcard design in InDesign and chose which section I wanted to be variable data
Exported the variable data frames into Adobe Acrobat and switched out pictures and text according to each target persona

Brochure

https://drive.google.com/drive/folders/1tSsHJ4cPn5JxoHZfYbG3whgvTShi_5Zn?usp=sharing

created initial brochure design in InDesign and chose which section I wanted to be variable data
Similar to the postcard, I exported the variable data frames into adobe acrobat
Used FusionPro to insert images that would be more appealing to each target group

RIT Hockey Stats

https://drive.google.com/drive/folders/1bPXvoPk4m2DvWFIzx6asRQkgdYdiwYOa?usp=sharing

Gathered stats from the RIT Hockey Team's website
Added up totals and compared scores from previous years

Page updated

Report abuse