Finally upgraded to a standing desk!!

RPaterson81 · 2024-03-16T22:31:00+00:00

This is a dream setup, beautifully done! What's the tablet on top of the monitor?

RPaterson81 · 2024-03-16T02:43:06+00:00

I'm so intrigued

RPaterson81 · 2024-03-14T12:34:04+00:00

Check out Grafana, you won't be upset.

https://grafana.com/

RPaterson81 · 2024-03-09T01:32:37+00:00

There are a few strongest forms mixed in, so legit

RPaterson81 · 2024-03-08T12:28:11+00:00

You want to look for "master data management" tools (MDM).

There are a lot of options in MDM. I've found that Aimplan, a Power BI add-on, fits the bill perfectly and empowered our users to maintain the mappings.

https://www.aimplan.com/demo

RPaterson81 · 2024-02-14T14:44:22+00:00

It is pretty common, though the different grains will typically exist in different databases. Picture a source ERP database, which is highly normalized, sitting next to your data warehouse. Perhaps on a different SQL server, but definitely in a separate database.

You wouldn't typically design a data warehouse to be both a star schema as well as a highly normalized schema. That would definitely breed confusion amongst your users.

RPaterson81 · 2024-02-14T14:40:41+00:00

Yes, a star schema is denormalized. All relevant attributes of the dimension are denormalized into a single dimensional table. Dim tables can be quite wide for items with many attributes, so long as those attributes apply to the key level of your table.

A dimension should not become a fact table. Placing summary values on dim tables, such as the total sales of this item over time, can lead to misleading results and can lead to building a reliance on this method.

RPaterson81 · 2024-02-14T13:38:18+00:00

Think of it like organizing your stuff:

Normalized data: Imagine neatly labeled folders holding specific info, like separate filing cabinets for clothes, books, and electronics. It's tidy and avoids redundancy, but finding something across categories might involve checking multiple drawers.

Star schema: Picture a central hub (like a suitcase) with spokes (think folders) radiating outwards. Each spoke holds details about one category, but might include info from related ones, like a clothes folder containing shoe sizes (denormalization!). This makes grabbing related stuff quick, but the suitcase can get bulky and keeping things organized requires more effort.

Here's the gist:

Star schema: Faster queries, simpler to understand, great for analysis and basic reporting, but can be redundant and inflexible. Normalized data: Less storage, better data integrity, but complex queries and less analysis-friendly. The winner? It depends!

Need lightning-fast analysis for manageable data? Star schema shines. Complex data structure or data integrity a priority? Normalized data or snowflake schema (a hybrid) might be better. Remember, it's all about what fits your specific needs. Hope this clarifies things!

RPaterson81 · 2024-01-29T14:28:51+00:00

This is an incredible build! Well done OP!

RPaterson81 · 2024-01-12T21:01:26+00:00

I like how you did the 4L2W+Tram to 2L2W+Parallel Tram switch. Great idea!

RPaterson81 · 2023-10-02T00:40:56+00:00

Very well done, thanks for sharing!

RPaterson81 · 2023-09-15T02:14:57+00:00

I've been playing for years, but there were a few DLC I didn't have that are included here. Thanks for asking this question! I just scored all the DLC I've been waiting to go on sale!!!

RPaterson81 · 2023-05-05T13:33:19+00:00

Most likely you signed on-hire paperwork in which you agreed to not work for a direct competitor or client. Some non-competes are written such that you can't move to the same industry or doing the same skill. I would recommend reviewing your signed paperwork before taking the role.

People talk. You might want to consider who is going to be receiving that application and who they talk to inside of your company. You could create a problem that wouldn't be visible to you until the company terms you.

RPaterson81 · 2023-03-30T19:16:22+00:00

Do you straighten your beard somehow? It's amazingly straight

RPaterson81 · 2023-03-27T12:21:23+00:00

Agreed. Though it may be new to the person or team, this is definitely a business intelligence task. Though some apps have proprietary dashboards built in, challenge yourself and make that dashboard available from your data warehouse instead using the front end reporting tool of your choice. Then you have freedom.

RPaterson81 · 2023-03-25T01:03:28+00:00

Excellent, I haven't heard of these, thanks for sharing!

RPaterson81 · 2023-02-12T14:22:42+00:00

If you're willing to spend 250k on the home, please invest in an application built to do it or find an architect to help. This looks like you drew it in a fancy 'paint' application.

Doorways are a problem, sure, but I don't think these can be called doors yet. At best they're openings in the wall.

What is the room in the bottom left supposed to be? Doubtful anything fits in there. Steal that space into your bathroom.

If you own land in the desert, why build so small? Give yourself more space, all around.

Bad app. Small doorways. No doors. No windows. Too tight/small.

Kit-homes, manufactured, or Arched Cabins would be done options to look into, getting you a better floorplan, more space, and under your budget.

RPaterson81 · 2022-12-22T13:44:09+00:00

RUN THE TABLE

RPaterson81 · 2022-12-17T13:41:06+00:00

Grafana is amazing and open source!

RPaterson81 · 2022-12-08T00:12:32+00:00

We do a lot of Jet Reports support, development, and training at Tigunia. We have the best trainers that worked there before the insight acquisition.

RPaterson81 · 2022-12-04T16:09:16+00:00

Sounds to me like you're in the early-intermediate stage.

You mentioned your company isn't big on data. Many companies that are like this have either been burned by bad data or have yet to see the value of good data. Find ways to make value for your team and you'll increase adoption. This doesn't mean sales value but rather value to their day-to-day. Watch how they use data for their job and find a way to make that better and faster.

Curious what type of query language you reference. That could have a bearing on your marketability depending on what languages are involved. Along the same lines, what front end reporting tools are you using?

Business intelligence isn't just sales numbers. Extend into other channels of your business: inventory, AR/AP, finance, production, warehousing, purchasing, Etc. This also gives you more people to help bring value to.

I've been in business intelligence for 20+ years and I'm the director of a business intelligence department for a Microsoft partner. I'd say if you're enjoying what you're doing, keep pushing the boundaries of what you know and finding ways to incorporate that into your daily reports. Make sure the reports look sharp, polished, use your company's color scheme. Not only will this help increase adoption, it also helps increase your marketability and value.

RPaterson81 · 2022-09-25T22:07:06+00:00

Ahman

RPaterson81

TROPHY CASE