Hey everyone, brand new to using Power BI and analytics. Question; in terms of performance is it preferred to build more look up tables with 3-4 columns or to build a table with as much info on it?

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

For Power BI, until you get past a hundred million rows being aggregated performance should be fine unless you have to write complex DAX.
In terms of look up tables (sometimes called dimensions) you’re best off making the model look like a “star schema”, plenty of resources out there for that pattern.
You definitely don’t want only one table in your model, patterns good for Tableau in TDE mode are an anti pattern in Power BI. Assuming the data has dates, you’ll want a separate date table.
Enjoy the journey!

like

Related Posts

Hi,

Can anyone provide me any information about the "deals - mergers and acquisition" line of service. Like, the kind of work (analytical or qualitative) and WLB

FYI - I know About the M&A but need how it's done here in PwC IAC

like

I have offe3 from ibm and hcl in mainframe and automation testing, which one i should join?

like

Do you have a skills section on your resume? How high level (i.e. brand strategy, research) or granular (journey mapping) do you go?

Bonus points for examples that've wrangled the laundry list nicely

like

Any other mommas only get real supply from one side while pumping? Getting 0.5 Oz from left side after half hr pumping... Any problems if I just pump and feed from right side? (Baby is 11 months old and supplementing with formula anyway, likely weaning at a year)

like

Anyone looking to hire an entry level accountant position with no experience?

It’s been difficult to get a job around here.

What I have:
- Bachelors in Accounting
- Starting Masters in Accounting in January 2023

like

has anyone left their employer for another company and then come back ? how did your workplace take this ? and how did you negotiate terms to come back ?

like

Looking to move to NY. Have family in Staten Island and seems to be more affordable. Yes or no? I’ll be working in the city so the commute may be excessive. What should I know about Staten Island before seriously considering?? Only visited a few times. Thank you, all! Any insight would be appreciated 🙏🏻

like

Does anyone know what the salary range is for a Sr Advisor for someone with a Masters and over 10 years consulting experience and the subject matter expertise at Public Consulting Group?

like

Anyone here have a solution for working off of a master Sketch file with a large team? Committing and versioning similar to Github?

Hi all,

Im having 9.5yoe in java backend development( technical lead) and have not worked in devops till now. But recently i have started with a PG course in devops.
I am very much interested to move to devops. What kind of roles i can give interview for and what and all paths i can take forward.

like

Who wants to go out for valentines dinner 💞

like

Seeking advice for a friend. He called me this afternoon basically saying he was being put on a PIP, this is after the company had said a few times he was not learning the role fast enough, only executing duties at about a 20% accuracy week 1 of PIP, week 2 60%, now we are at week 3 back to 50% (UA role, has been there since June). Boss said significant improvement is needed by next Friday. Looking for tips, suggestions, should he already start looking elsewhere? He loves this new job.

like

I'm a new Clinical Quality Manager at @united healthcare. I have close to a decade experience in the industry. I have direct reports. It's a remote position. I have a doctorate degree in Business Administration. Certifications: Project Manager Professional (PMP, Certified Professional in Healthcare Quality (CPHQ), and Lean Black Belt in healthcare (LBBP). Base salary of $104,500. Any thoughts on the salary package? Optum.

like

26 year old prospect that just inherited a $20mm estate. He’s a country boy with limited financial knowledge. What direction would you go in order to land this prospect?

like

Is there any app for payroll to check salary slip. I am new joinee. My salary hasn't been credited in bank. Though I have received salary slip. When does the salary get credited? Any mobile app for hgsb?

like

I have a interview with Qualcomm for Embedded firmware development. Can someone suggest the interview rounds and expected areas for the interview. I am purely into automotive domain and the opportunity is totally new.

Also please leave a heart so that I can dm others for referrals

like

50k-ish budget for a new or CPO sedan or large coupe as a daily driver.

What would you get?

like

Can anyone recommend a black owned research company that specializes in qualitative research?

likeuplifting

Asalamualaikum and Happy Monday! Alhamdulillah for everything 🤲🏻. Hope you all have a great day iA 🤗!

Post Photo
likeuplifting

Additional Posts in Data & Analytics Consultants

I am hiring a few roles at CVS 5+ years experience. DM me if you want to jump into healthcare and I’ll share more details

like

I am looking for data scientist with strong NLP and Text Analytics experience to work part time, out of the US or India, for a startup in the US. Anyone interested, please DM.

like

What’s generally standard among FAANG companies for offer acceptance once one is extended? If anyone has experience with this, is it one week or is it more flexible? I am trying to schedule final onsite with two companies and hoping I can get timing to line up (in the event I am fortunate enough to have offers).

like

Has anyone here had any experience with Data Science bootcamp programs? I’m weighing some options and unsure if bootcamp or a certificate program would be worth the time/money.

like

Recs on getting comfortable with DL? Have built some stuff for work and even for classes, but for some reason nothing's really stuck well

like

Good Morning everyone, Can you recommend some reliable powerBI courses for someone who worked on different data analysis tools and looking to learn PowerBI and DAX?

like

I just transitioned a Research Analyst role a year ago. I want to develop more technical skills. I was accepted in a Data Analyst Bootcamp at University of south Florida..but would anyone recommend just getting a second bachelors (I currently hold a BA and MBA). Or should I just work my way through free courses that are out there?

like

I'm a civil engineer currently working with a cost consulting firm providing construction cost consulting to big tech. I wonder if it is worth taking a dual Master degree MBA and MS in Data Science? Would that make much of a difference in my career and compensation?
YEO 9
TC $116k

like

Do you guys think that with the current environment in Europe, data engineer jobs for consulting companies will safe? especially for smaller companies.

like

For those of you that have been in bi or data science consulting for a while, how many projects are actually smooth/not a complete clusterf*ck or sh*tshow? I’ve been in ERP consulting cont.

like

Hi all, I have 2 YOE with Intel clearances and background in SQL, tableau, Salesforce, and azure. In the pipeline for a job at Microsoft but wanted to know salary range and opps at other companies. Thanks in advance

like

Current project has me doing a bunch of PowerPoints. I'm skilled in SQL, Tableau, Python, and cloud. 2.5 yrs of exp at D. Anyone have any opportunities on their project?

like

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

I'm seeing a McKinsey Data Science job in DC that requires a TS, does this mean you have to have an active one at the exact level or above or just be eligible? Also, if I could network with some from that office, that would be fantastic.

Signed,

Humble and Hungry

like

MS Powerapps - Yay or Nay?

like

I moved jobs thinking that consulting would offer me new and interesting challenges that would grow me as a data Scientist only to find out how awful and non data science this industry really is. My current engagement has NO data pipeline and we are an afterthought in the grand scheme of things+ all the cool stuff is being given to specialists. My plan is to stay for a year and start looking elsewhere. But I’m wondering if its bad look to leave after 4ish months? Lmk

likefunny

Data and Analytics consultant - Masters + 4-5 years of work ex focused on AI/ML. Want to exit to industry. Which companies should I target for? I have FAANG/MSFT/Cap-one in mind. Any other recos?

like

Reading through some possible interview questions for FAANG. One of the ones I've seen on Glassdoor are to design a basic architecture structure for something like Netflix or Twitter or Spotify. I've been researching online using AWS or GCP (still learning all the moving parts of architecture). Any advice on how the setup would be? I'm assuming you'd start with some Load Balancers. For Netflix maybe have different different APIs for signing up vs scrolling through possible movies?

like

Has anyone reapplied to Georgia Tech to switch from OMSA to OMSCS? I’d like to know if some of the courses I’ve taken while doing the OMSA could transfer over.

like

How do people like working at Capgemini? I got an offer and I am curious about the WLB and how people working in the D&A space have liked working there.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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