Rachel Smith

View Portfolio

Data Analytics Portfolio

Welcome to my professional data analytics portfolio. This website showcases a collection of projects that demonstrate my ability to transform complex data into meaningful business insights through thoughtful analysis, visualization, and strategic decision-making. Each portfolio project is presented as a comprehensive case study, outlining the business challenge, project objectives, analytical methodology, tools and technologies utilized, key findings, and measurable outcomes. Rather than simply displaying dashboards or code, these projects illustrate my complete analytical process—from understanding the business problem and preparing reliable data to developing actionable recommendations that support organizational goals. Throughout this portfolio, you will find examples of work involving Python, SQL, Tableau, Power BI, financial analysis, machine learning, and business intelligence, all grounded in a commitment to data integrity, continuous learning, and evidence-based decision-making. Whether you are a recruiter, hiring manager, or fellow analytics professional, I invite you to explore these projects and see how I combine technical expertise, business acumen, and a passion for solving real-world problems through data.

Dashboard showing enrollment, retention rates, and department statistics for SNHU and Ohio State

Technical skills

My technical and analytical skill set combines business knowledge with modern data analytics tools to transform complex information into actionable insights. I am proficient in Python, SQL, Microsoft Excel, Tableau, and Power BI for data extraction, cleaning, analysis, automation, and interactive dashboard development. My experience includes working with large datasets, performing statistical analysis, creating data visualizations, developing financial models, and applying machine learning techniques to identify trends, patterns, and opportunities for process improvement. I have a strong understanding of data integrity, database management, business intelligence, and performance measurement, with the ability to communicate technical findings through clear visualizations and executive-level reporting. Complementing my technical expertise are strengths in critical thinking, problem-solving, project management, collaboration, and continuous learning, allowing me to approach complex business challenges with a strategic, data-driven mindset and deliver solutions that support informed decision-making and operational excellence.

See project

Testimonials

An elegant flat-lay composition of a silver laptop partially open, its screen filled with a complex yet clean data model diagram and interconnected flow arrows. Beside it lie a tablet showing a time-series forecast chart and a smartphone with a compact dashboard of key performance indicators. On the desk, a small acrylic stand displays an abstract business card layout with simple iconography hinting at email, phone, and web contact info, without legible text. Soft morning window light from the right creates gentle highlights and long, calm shadows across the wooden surface. Photographic realism, top-down perspective, minimalistic, conveying organized, accessible business intelligence.

Hope D.

Rachel turned scattered financial data into clear dashboards that finally aligned our operations, finance, and executive teams.

A modern, glass-topped conference table covered with printed analytics reports: heat maps, bar charts, and forecasting graphs spread in an organized pattern. At the center, a slim tablet displays an interactive dashboard with glowing data visualizations. Two minimalist metal-and-acrylic nameplates on the table subtly include placeholder elements that imply “Rachel Smith” and “contact details” through icons and layout, without legible text. Overhead, cool white office lighting casts even illumination, creating crisp highlights on the glass and polished metal. Shot from a slightly elevated angle, photographic realism, with a professional, results-driven atmosphere suitable for a portfolio homepage hero image about transforming data into insights.

Hope D.

Her Python automations cut manual reporting time by 60 percent and reduced data errors, giving leadership confidence in weekly metrics.

A modern, glass-topped conference table covered with printed analytics reports: heat maps, bar charts, and forecasting graphs spread in an organized pattern. At the center, a slim tablet displays an interactive dashboard with glowing data visualizations. Two minimalist metal-and-acrylic nameplates on the table subtly include placeholder elements that imply “Rachel Smith” and “contact details” through icons and layout, without legible text. Overhead, cool white office lighting casts even illumination, creating crisp highlights on the glass and polished metal. Shot from a slightly elevated angle, photographic realism, with a professional, results-driven atmosphere suitable for a portfolio homepage hero image about transforming data into insights.

Hope D.

Rachel quickly understood our business model, asked smart questions, and delivered insights we used directly in our board presentation.

A dark, sophisticated dual-monitor setup in a dimly lit office, with one screen showing clean Python code for data automation and the other a polished dashboard of sales and operations metrics. The matte-black keyboard and mouse rest on a wooden desktop with a faint grain texture. Discreet badges on the monitor base use abstract shield and beaver-like silhouettes to allude to Southern New Hampshire University and Oregon State University, rendered as non-text, non-branded shapes. A cool blue backlight glows behind the screens, creating a focused, high-tech ambiance. Photographic realism, three-quarter angle shot, strong contrast between screens and dark surroundings to emphasize automation and analytics expertise.

Hope D.

The Tableau and Power BI dashboards she built make complex operations data approachable for non-technical stakeholders across our organization.