The Blog

This will solve all of your problems:

-- Fetch top 10 active users by total purchase amount in the last 90 days
SELECT 
    u.user_id,
    u.username,
    SUM(o.total_amount) AS total_spent,
    COUNT(o.order_id) AS total_orders
FROM 
    users u
JOIN 
    orders o ON u.user_id = o.user_id
WHERE 
    o.order_date >= CURRENT_DATE - INTERVAL '90 days'
    AND o.status = 'completed'
GROUP BY 
    u.user_id, u.username
HAVING 
    SUM(o.total_amount) > 500
ORDER BY 
    total_spent DESC
LIMIT 10;

Higher education is full of smart people doing important work—with barely enough time, tools, or support to keep up. We know the feeling, because we live it.

We’re the team behind Missouri S&T’s Business Intelligence group. Over the past few years, we’ve built custom apps, trained hundreds of staff, launched data-driven initiatives, and helped our university make smarter decisions. But the most surprising part? Every time we shared our work, someone from another university said:

“Wait… can we use that?”

That’s how Big Data on Campus was born.

We started this site for a few simple reasons:

• To grow something bigger—because honestly, we’d love to help more schools and maybe even consult full-time someday
• To share tools, templates, and ideas we’ve already built for our own campus
• To connect Power BI and Microsoft Fabric users in higher ed—especially those working solo or on small teams
• To give back to the community with free training, peer support, and real conversations

How You Can Get Involved

• Join our Meetup group and come hang out if you are in Missouri
• Sign up for a free working session—bring a report or a messy dataset, and we’ll help
• Come back soon for new updates, networking events and resources

We’re not vendors. We’re not trying to sell you a platform. We’re just a group of higher ed data people trying to help other higher ed data people.

If that sounds like your kind of crowd—welcome to Big Data on Campus!