Mark Craig
Data Analyst

Discover my data analysis journey, highlighting my skills in Excel, SQL, Tableau, and Power BI through real-world projects.

Behind the Data

Get To Know Me

Hello! I'm Mark Craig, and as a data analyst, I love the idea of turning data into insights that empower and assist people. I get a lot of fulfillment from helping people reach their goals. This trait, along with my analytical mindset, has led me to data analytics. I see data as a great tool for any business, and I know that many people lack the knowledge to use it effectively. I hope that with my skills and desire to help others achieve their goals and make data-driven decisions.

Outside of my professional life, I enjoy engaging in activities that balance my analytical work. I am a travel enthusiast who loves to explore different countries and learn about everything they have to offer. Being active and spending time outdoors is something I enjoy to clear my mind and energize myself.

Featured Projects

Crossfit Games

Data from the CrossFit Games 2019, featuring two interactive dashboards. The first dashboard focuses on selected athlete information and results, allowing users to filter and view detailed performance data, trends, and event outcomes. The second dashboard provides performance statistics by country and affiliated gym, utilizing bar charts to offer insights into gym affiliations of top-performing athletes. This project showcases my ability to leverage Excel for data analysis and visualization, enabling users to explore and derive insights from complex data sets.

Nashville Housing

This SQL project focuses on cleaning a Nashville housing dataset, involving tasks such as standardizing date formats, populating missing property addresses, splitting address and owner address fields, identifying and removing duplicates, and dropping unnecessary columns. The project demonstrates proficiency in data cleaning techniques, SQL queries, and string manipulation, preparing the dataset for in-depth analysis, reporting, model building, and integration with other datasets in real estate-related domains.

Travel Data (Part 1)

Data from travel in Brazil was analyzed using SQL to explore and prepare user data, flight information, and hotel information. By utilizing SQL queries such as joins, subqueries, and aggregate functions, crucial information was extracted for interested parties. This project showcases my ability to handle complex data, perform detailed exploratory analysis, and extract meaningful insights, demonstrating proficiency in SQL and data analysis techniques.

Travel Data (Part 2)

In addition to exploring and preparing the data from the Brazil travel dataset using SQL queries, I utilized the insights gained to create three comprehensive dashboards highlighting key metrics and trends for users, flights, and hotels. These dashboards showcase statistics and trends over time, offering valuable insights into user behavior, flight patterns, and hotel bookings. I provided a comprehensive overview of the travel landscape in Brazil, enabling stakeholders to make informed decisions based on the presented metrics and trends.

Tableau Dashboards

With Tableau, I can analyze data trends, identify patterns, and communicate key findings effectively to stakeholders. This ability to translate data into actionable insights can greatly benefit businesses by enabling informed decision-making processes. Through interactive dashboards, executives and stakeholders gain a deeper understanding of their data, allowing them to identify opportunities, mitigate risks, and optimize strategies. By harnessing Tableau's powerful features, I can help businesses unlock the full potential of their data, driving innovation, efficiency, and growth.