After setting down the conceptual framework with the ERD model for the lunar migration dashboard, I moved into the space of data simulation. This blog describes the chapter where Mockaroo comes in to play, transforming the abstract model into a tangible dataset ready for the next layers of preparation and visualization.

Transitioning from ERD to Data with Mockaroo

Mockaroo’s role was pivotal, offering the tools to craft detailed, mock datasets that illustrate the complexity and diversity of the lunar migration story.

Here’s a concise look at how I approached this:
Focused Customization: Each entity—Crew, SpaceShips, Travelers, and Trips—received a tailored dataset, from personal details like DOB and nationality to technical specifics like spaceship capacity.Realistic Simulation: By leveraging Mockaroo’s formulas and custom lists, I ensured the generated data not only aligned with the ERD’s structure but also resembled reasonable lunar migration scenarios.

The power of Mockaroo lay in its precision and flexibility, allowing me to simulate a dataset that’s crucial for the next phase of the project.

Upcoming Challenge: Optimizing with Alteryx

The puzzle of aligning travelers with trips, constrained by the spaceship capacities, awaits. Alteryx will be the companion in this story, tasked with refining the Mockaroo data to fit the real-world logic.



Rodrigo Diaz
Author: Rodrigo Diaz

I'm Rodrigo from Mexico, and I am passionate about learning and career growth. I hold a law degree, a master's in business management, and a diploma in civil construction design. My expertise is in starting businesses and product design. I've worked in agriculture, IT, and the public sector, gaining insights into business operations. Outside work, I'm an avid golfer and enjoy spending time with my family, especially sharing experiences with my daughter.