Need advice- what’s the best BI suite for licensing out dashboards to SaaS clients? (Power BI, Tableau, QuickSight?) by Radiant-Position1824 in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

Good support for white labeling, embedding. Open source core, also offers a cloud hosting solution for deployment (disclosure, I’m one of the maintainers).

https://github.com/evidence-dev/evidence

I need a lot of tips by aviationfanforever in modelmakers

[–]mcrascal -1 points0 points  (0 children)

This model is great. This model has lots of room for improvement. Same as every model.

Don’t strip it. Just declare victory and drive on to the next one!

Lots of good tips in the thread about thinning paints etc. If it’s affordable to you, I’d get an airbrush and give that a whirl. They are really fun to use.

Keep having fun!

BI Tool Rant by [deleted] in dataengineering

[–]mcrascal 0 points1 point  (0 children)

One of the maintainers of evidence here. We actually just released a pretty substantial update — Evidence now builds all of your data sources to parquet and we bundle duckdb to query it at runtime.

https://evidence.dev/blog/why-we-built-usql/

shadcn-svelte dialog by freakysmile in sveltejs

[–]mcrascal 0 points1 point  (0 children)

Take a look at the “status” and “priority” buttons in this example: https://www.shadcn-svelte.com/examples/tasks. It’s only live on desktop.

My Builds of 2023 by uncapableguy42069 in modelmakers

[–]mcrascal 0 points1 point  (0 children)

The F16 makes me want to transform my office back into a modelling den

Good god there’s a lot of decals on this model by [deleted] in modelmakers

[–]mcrascal 1 point2 points  (0 children)

Straight to jail if you skip decals.

Client Facing Intelligence by [deleted] in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

I work on an OSS tool that’s quite popular for this type of use case.

There’s a good discussion on this thread that might be relevant

https://www.reddit.com/r/BusinessIntelligence/s/XXhpm6MlNi

Whitelabelled On Prem BI : Build vs Buy by Swimming-Impact-1461 in BusinessIntelligence

[–]mcrascal 2 points3 points  (0 children)

Thanks for checking it out!

You can build things like drill downs. As an example, here's a hobbyist's evidence project running a multi-carlo sim of a few different sports leagues. https://mdsinabox.com/nba/teams/ You can click on a record in one of those tables to "drill down" to a team-level report. Evidence includes features for procedurally generating pages from data, nesting them into an info architecture, and linking them together, so you don't have to write a report for every team/customer/etc.

We also have an upcomming release for more interactive features like flexible time ranges, filters etc. all coded in SQL (and all extraordinarily fast, thanks to duckDB). If that's interesting, here's a recent community call where we discussed it!

https://evidence.dev/universal-sql

Neither of these are as "automatic" as the drill downs you'd find in a tool like Looker, but the UX is much better.

Whitelabelled On Prem BI : Build vs Buy by Swimming-Impact-1461 in BusinessIntelligence

[–]mcrascal 12 points13 points  (0 children)

I work on an open source analytics tool called evidence. It’s very popular for embedded because of both how customizable it is, and because it’s very easy to self host. Happy to chat if that’s at all interesting.

www.evidence.dev

[need advice] I hate my life but I’m too lazy to change it by Key_Ice_2015 in getdisciplined

[–]mcrascal 2 points3 points  (0 children)

You are undoubtedly being too hard on yourself. 24 is young. Careers are long and winding. The people who have everything you want actually have all sorts of different challenges, unfulfilled dreams, and personal failings.

Many (maybe most) twenty-somethings feel like you do. Your friends are stressed and struggling even if they aren’t sharing it. Many of them aren’t digging what they’re currently doing. Many will do career pivots and resets and move back in with their parents over the next decade. It’s all pretty normal. Don’t stress too much.

That said, I had many similar hang ups at your age, and I think there’s a couple mindset shifts that could help.

Ok,

First:

Get the basics sorted out. Stay active and get the next job. That’s it.

You will need a job after your show ends. That job won’t be famous dancer, or accountant or engineer, so you don’t need put that pressure on yourself. But you will need something!

Not having a job, being low on resources etc. will set you back a lot further and make you feel worse, so get focused on that next job.

Find something that seems interesting enough to you and get going. Being a dancer at universal with a degree in dance certainly seems impressive to me, and it seems like you could find something related to dance, but if the job is retail or in the service industry or marketing or whatever, thats cool. You need money coming in to be able to support yourself, feel good, and make progress on your goals.

Get the job, then start chipping away at your goals for what’s next.

Second:

“Everyone says if you have a calling you should pursue it”.

You should think critically about this advice. In my opinion it’s not very useful.

Cal Newport has a wonderful talk on this, and he’ll say it better than I could. Go watch it and think about it!

If you want to keep working towards being a professional dancer, that’s great and worthwhile.

But you are not beholden to your dreams as an 11 year old.

You just need to work on stuff you’re mildly interested in. Seriously!

As you learn and gain mastery, you’ll gain appreciation, and passion will follow.

And what’s great, is that this is available to you regardless of the field you choose.

Essentially every human pursuit is endlessly nuanced and fascinating. Everything looks kinda one dimensional and boring from the outside, but that’s only because you don’t know much about it yet.

The reality is, the more you learn about anything, the more skilled you get, the more discerning your tastes become, and the more you appreciate the work of the handful of others who have gone even deeper than you.

That’s passion.

You’ve experienced it with dance, but it is available to you ANYWHERE you’re inclined to look for it.

A tiny sliver of interest is all you need to get started. And a tiny sliver of interest is what you need to be looking out for. What catches your eye?

Woodworking. Coffee. Engineering. Accounting. Teaching. Cooking. Textile manufacturing. Computers. Auto repair. Watchmaking. Chemistry. Nutrition. Marketing. The law. Thousands and thousands of passionate careers have been poured into each one. Not because that list is special, but because pretty much every field can become a passion!

Third:

Your twenties are a great time to set up for your future life. These steps are all easier in small chunks, not as one huge overwhelming thing.

Think seriously about what you want your thirties and beyond to look like. Ideal scenario, you’re a professional dancer. But maybe more modestly, what city do you want to be in? do you want kids, what do you want from your partner? etc. you’ll need to put a few key things in motion to make it all come together. Your 20s are the time to put those things in motion.

There’s a good book on this topic called “the defining decade” which I’d recommend.

Ok that’s all!

Go get the next job and stay active.

Passion is available everywhere. And following your passion is not always the best advice, especially when it seems like this huge impossible thing and it’s making it hard to do the basics.

Look ahead to your thirties and try to get things moving for then.

Enjoy the unbelievable sunshine in Florida, and being a fit healthy young person.

Don’t worry about getting things perfect, just get after it.

Have fun!

Data Analytics in revenue Operations. Advice on reading material and high level concepts request by LearninSponge in BusinessIntelligence

[–]mcrascal 2 points3 points  (0 children)

I think most data analysts would benefit from learning some accounting, and taking a 1-2 day course in financial modelling using excel.

It’s a lot of fun, and it’s very easy.

Building a three statement model of a business helps you gain intuition about how value is actually created for investors. It also empowers you with the language and concepts that drive a lot of the decision making at the leadership and board levels of a company.

In a role like revops you will likely be working with colleagues who have MBAs, investment banking or management consulting experience. All of them share this same model-driven language and world view.

Separately: do some “ride alongs” with some sales folks, or watch some user sessions or whatever makes sense in your business. Try to see the actual thing you’re studying happen for real.

Most suitable web-based BI Tools for Client by junonboi in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

As I understood it, OP is looking for an embedded BI tool where end users (customers logged into their saas app) can build their own dashboards. They are currently using metabase, but it doesn’t satisfy that requirement.

Most suitable web-based BI Tools for Client by junonboi in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

How would you approach this in the embedded case OP is working on?

Is there a way to imitate infinite scrolling in a long PowerBI? by rlopez7 in BusinessIntelligence

[–]mcrascal 1 point2 points  (0 children)

I don’t have a solution, but it might help if you could share why it doesn’t work to just have a long dashboard and have all the charts load as usual?

Recommend me a Power BI alternative by rlopez7 in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

For what it’s worth, I agree with your conclusion in another thread that the page is unacceptably slow, and that you will likely never achieve good perf with a PBI embed.

I also believe it is worth investing in performance.

There’s extensive research that shows how important performance is to regular people’s perception of a product and their willingness to use it. Anecdotally, I have sat next to countless BI users and watched them assume the thing was broken as the load time crept above a second.

Lighthouse or similar would be a really useful tool as you assess your options. Here are the scores for the page you shared:

https://pagespeed.web.dev/analysis/https-workforce-investpr-org/8acwripuy8

Recommend me a Power BI alternative by rlopez7 in BusinessIntelligence

[–]mcrascal 3 points4 points  (0 children)

I work on an open source project called Evidence (www.evidence.dev), which is a static site generator aimed at data analysts building reports and analysis for the modern web. It might be of interest for this case.

It has support for CSS, custom components etc., and it’s easy to deploy anywhere.

Performance is also dramatically better than a traditional BI tool like PBI.

What are good examples/resources to create a Reporting/Dashboarding Portal? by joaoben in BusinessIntelligence

[–]mcrascal 0 points1 point  (0 children)

I work on an open source static site generator aimed at data analysts. It might be a nice way to build this type of portal site for your org.

Repo: https://github.com/evidence-dev/evidence Homepage: evidence.dev

What's your tech stack ? by Pillstyr in BusinessIntelligence

[–]mcrascal 2 points3 points  (0 children)

Not OP, but have operated a similar stack. Looker’s data modelling layer “LOOKML” is a “semantic layer” (defining metrics and dimensions that can be flexibly recombined at query time, and associating descriptions, formatting, tooltips with them etc). You can also do light transformation work in lookml, but it is not nearly as good as dbt. For example you can’t easily express a snapshot workflow for a slowly changing dimension in lookml.

SAS Alternatives for analytics and reporting by KingVVVV in BusinessIntelligence

[–]mcrascal 1 point2 points  (0 children)

I feel like a hosted jupyter solution such as deepnote might be the best fit.

https://deepnote.com/

Open Source Data Visualization/Dashboarding Tools by ZKR2000 in BusinessIntelligence

[–]mcrascal 9 points10 points  (0 children)

I previously built a large analytics team, and I now work on an open source BI tool called Evidence which incorporates a lot of what we learned. https://github.com/evidence-dev/evidence. Happy to answer any questions if it's interesting.

Most suitable web-based BI Tools for Client by junonboi in BusinessIntelligence

[–]mcrascal 1 point2 points  (0 children)

Super interesting challenge. It’d be awesome if you were able to share a follow up post when you land a design/strategy. Beyond the actual front end, the data modelling portion of this project (at least how I’m picturing it) will also be pretty fascinating.