How common is it for IT/ DE to give people reporting tables with 100s of columns?

I come from an org that we focused on having a reporting data warehouse with tall narrow tables, and it made for great performance at the cost of small complexity in queries.

Now, I am in a company where IT wastes an inordinate amount of time, normalizing data into one massive table with terrible performance.

How common is this? Is there any advantage to big 100s of columns tables?

like
Posting as :
works at
You are currently posting as works at

Sounds like yall need a digital transformation of some sort over there

Nah we just need to redesign our data warehouses

Related Posts

Not related to consulting but anyone has experience with ratehub / canwise financial as lender for the house mortgage? They seem to offer better discount on Prime rate compared to the big 5 banks.

helpful

Does a 20 year long career at Deloitte hold much value in the marketplace in light of the current economic situation? Started as a change leadership Consultant, but ultimately spent majority of my career in Resource Management and Global Mobility.

At any level above Senior, how do u manage the relationship between utilization and realization, which is an inverse relationship. Seems to be either blow the budget (and write it off), or eat a lot of time.

like

MBB folks, I’m a Product Manager (non-tech company) and interested in working at MBB.

Which level/role does MBB can offer me ?

like

How do y'all manage passwords ?? Esp absolutely critical ones e.g. coin markets etc..
Is anyone else paranoid about all this ?

like

Any books suggestions?

like

Currently being recruited for Alvarez & Marsal (Dubai or Riyadh). I’ve checked with my irl network and no one has worked with them before. Anyone here working with or for them who wouldn’t mind answering a few questions related to my proposed function; Strategy & Implementation?

like

In order to DM i need 11 likes. Please help me guys

like

When you keep delaying that deliverable you promised last week......

Post Photo
likefunny

So how much money did Jim Carey get for his Super Bowl spot? Guesses?

like
like

Hi people actually i got a call on 30th april that you have been selected to Barclays but still on the career portal it's showing completed. But the hr has told me the joining date but i didn't received anything

like

Anyone working in synechron for DKP group? How is the WLB and job security there?

Anyone with November PERM approval?

like

Still don't have xlookup. #fomo

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How much is the average Emergency Medicine physician making out of residency? (Name your city)

like

Please help me to get 11 likes.

like

I have been an assistant manager at a retail store for a year and a half. This chain has about 60 stores. I get paid hourly. What is a fair hourly wage for an assistant manager position ima store of this caliber?

like

Additional Posts in Data & Analytics Consultants

What are some interesting non-tech/insurance/advertising/consulting careers where data science is applied? Thinking of epidemiology and economics

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

Coming to the realization that consulting is not for me (tech person) feeling angry that salaries at D will never be on pair with FANG and that leadership is not tech focused. For example you could be a soul contributor at fang making 240k and people at Deloitte wait 10+ years to earn that as Senior Managers because they need to climb the corporate ladder. It seems super clear cut to me now, if you want to make money in tech don’t join consulting firms. Am I wrong?

like

What is a data lake in basic terms?

like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

like
like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

I am currently working mostly in Data Analytics, but I want to transition into Data Engineering. I've applied to a couple Data engineer positions but it seems I don't have the qualifications for them. Should I maybe look for Jr. Data Engineer positions to get experience and try to move up from there? If so anybody know of any Jr. Data Engineer positions available?

like

What’s the best/simplest way to understand Sets vs Groups in tableau?

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

Anyone in the KPMG Lighthouse practice that would be willing to take a look at my husband’s resume and put in a referral? He’s interested in the Associate, Data Scientist position.

Noob question - I want to consolidate the dates into a single dates column. Would numpy or pandas help me reorganize this dataset effectively or should I do it within excel?

Post Photo
like

Is anyone working with Elastic at DoD?

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Currently in consulting where I get to do data visualizations sometimes but not always, have an opportunity to shift to a data analytics focused role. Struggling to decide as I am not fully sure if I would be competent in/happy with daily data work. Advice, thoughts? 😣 I just never find what I like…

like

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

What is it about D&A that most clients (or even partners) don't appreciate? Thinking about the painpoints or opportunities that are unseen at the top or require lateral thinking

like

In the most unnecessarily complicated phrasing worthy a dissertation, what are you working on this week?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal