-
IntroductionWelcome to the Bootcamp
-
Our approach
-
Why Hackathons?
-
What is Data Engineering & DevelopmentUnderstanding Data Engineering
-
Problem-Solving for Developers – A Beginner’s Guide
-
Understanding Business & Client NeedsRunning hypothesis-driven experiments using the MVP
-
The Hackathon Problem Brief
-
Task: Identify the MVP1 Quiz
-
From MVP to “MLP” (Minimum Lovable Product)— Building What Your Customers Care About
-
User and Player Types in Gamified Systems
-
The Octalysis Framework for Gamification & Behavioral Design
-
The Strategy Dashboard for Gamification Design
-
Task: Evaluate client needs & wants1 Quiz
-
10 tips for writing good user stories
-
A Complete Guide to Data-Driven Customer Acquisition
-
Design & DevelopmentDesigning Enterprise Level End to End Systems from Idea to Product1 Quiz
-
Database design
-
Classifying data models
-
Deciding fact and dimension tables
-
Entity Relationship Diagram (ERD) Tutorial – Part 1
-
Entity Relationship Diagram (ERD) Tutorial – Part 2
-
Querying the dimensional model
-
Conceptual, Logical and Physical Data Models
-
Test Your Knowledge on Database Design1 Quiz
-
Task: Create ERDs for Your Client1 Quiz
-
Intro to Programming
Create a conceptual, logical and physical ERD for the data mart that tracks and reports on sales volume and value for LotsOfStuff. The ERD should include information about the various products that LotsOfStuff sells, as well as details about the company’s clients, including their loyalty points, segmentation level, and contact and address information.
You can use any tool to create the diagrams, as long as the final output is a .pdf file.
Two (completely free to use) recommended tools are draw.io and dbdiagram.io.
Responses