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.