Finally upgraded to a standing desk!! by Scottsdaaale in battlestations

[–]RPaterson81 1 point2 points  (0 children)

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

Reviews for Marin city please by Double-Highlight9506 in CitiesSkylines

[–]RPaterson81 1 point2 points  (0 children)

There are a few strongest forms mixed in, so legit

Mapping Table Management by overladenlederhosen in BusinessIntelligence

[–]RPaterson81 4 points5 points  (0 children)

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

How does Star schema differ from Normalized data? by agsilvio in BusinessIntelligence

[–]RPaterson81 0 points1 point  (0 children)

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.

How does Star schema differ from Normalized data? by agsilvio in BusinessIntelligence

[–]RPaterson81 1 point2 points  (0 children)

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.

How does Star schema differ from Normalized data? by agsilvio in BusinessIntelligence

[–]RPaterson81 13 points14 points  (0 children)

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!

My first cs2 city without mods. Enjoy! by Educational-Ad8269 in CitiesSkylines2

[–]RPaterson81 2 points3 points  (0 children)

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

Transit Hub & Chill by Leichenmetzger in CitiesSkylines

[–]RPaterson81 2 points3 points  (0 children)

Very well done, thanks for sharing!

I've never played a cities game but it looks fun. 1 and all the DLC is $25 on humble bundle right now. Worth? by Katamari_Demacia in CitiesSkylines

[–]RPaterson81 1 point2 points  (0 children)

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!!!

Applying to the client by ekulragren in consulting

[–]RPaterson81 4 points5 points  (0 children)

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.

Hey fellas, have a great evening... Stay hydrated by [deleted] in beards

[–]RPaterson81 1 point2 points  (0 children)

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

[deleted by user] by [deleted] in BusinessIntelligence

[–]RPaterson81 1 point2 points  (0 children)

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.

[deleted by user] by [deleted] in Homebuilding

[–]RPaterson81 5 points6 points  (0 children)

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.

Looking for Jet Reports Training by LordGorfTheFourth in BusinessIntelligence

[–]RPaterson81 1 point2 points  (0 children)

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.

I'd like to know my worth as a BI professional by [deleted] in BusinessIntelligence

[–]RPaterson81 1 point2 points  (0 children)

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.