What are some basic or best practices to find gaps in data consistency for a big excel file? Any advice on the conceptual or tactical approach would be really appreciated

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

Load it up with R, make histograms, crosstab counts, and ratios to check for odd values and typing errors. Once you've defined some rules for what's reasonable, you can add checks for specifics straight into Excel.

likehelpful

Load it up into Dataprep

You're trying to do data quality analysis. There's much information via Google to search for dq issues.
Make sure you understand the business rules regarding the data capture and curation to know if the data is bad or acceptable. Heuristics and data profiling is what you're looking at.

Related Posts

Opportunities available for freshers and experienced CA/CPA/ACCA in EY GDS.

Experience requirements : 0 till 20 years relevant. If interested send your CV at -
manalrehtal1986@gmail.com

Location: Multiple locations across India
Like, comment, share and spread the word to those in need!

#cafreshers #experienced #cpajobs #accajobs #statutoryaudit #panindia

Can someone please explain how rolling (sold) puts to following week works?

like

Do you believe the plot leak on Reddit?

8/25 Thread (General):

like

What's the most expensive frivolous item you've spent your hard-earned $$$ on?

like

Team, need reference in IBM. I have a referal code.

like

I recently joined Deloitte, with an approved 140 from my previous firm. I don’t expect my date to be current any time soon. Can I just keep extending my visa at Deloitte based on my approved 140 until my priority date becomes current?

Dear Connections, Hope you all are doing well! I am actively seeking a job change in Customer Service for pune/remote location with experience of 2 years into customer centric environment in Ecommerce and Banking and Edtech industry. location- Pune Kindly like and comment and share relevant opportunities.

like

Hey! I've always wanted to get into IB (prestige, money, you name it), however now that I'm in a more laid back environment (better WLB, "easier work") it doesn't seem as attractive as before and the pay is quite good for an analyst level (I think the pay is competitive even comparing with IB's pay in my country) . I wanted to know if anyone had the same experience and what were your thoughts (pursue an MBA and leave your comfort zone and "good pay" or just stick with it). TIA!

like

I applied for another position within my company. I wanted to reach out to the hiring manager just to formally introduce myself and share my interest. Would this be a good idea?

smartlike

I am looking for a career change in designing. Need guidance in designing.

like

What are the best beyond-the-pill programs you’ve seen?

like

Any other departing GSAP scholars get lower AIP than peers with the same rating?

like
like

And the rest is history 😅

Post Photo
funnylike

I am an SAP CPI Consultant with CCTC of 12LPA fix & 21% variable pay. My YOE is 4 years. What else should I learn so that I can increase my package to 20LPA plus while switching job. Do you recommend reskilling to some other tech/ domain?

like

Any recs on resources to learn / brush up modeling skills? College senior joining a banking group next summer. Thanks

like

Can anyone share any experiences with the tax team at CFGI/Carlyle? Thanks :-)

like

My parents are coming to the U.S. to visit for a month. What activities should I plan for them? We will travel for a couple of weeks but I want to find something for them to enjoy (instead of just moving around the house) while they are local.

like

Additional Posts in Data & Analytics Consultants

Interviewing for a data scientist role. They gave me a week for a case study where I’m asked to clean data and then derive data insights (python), and then make a PowerPoint to present my process and results. Any case study samples out there I can reference to? Much thanks!

like

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

Would working with a data lake be valuable experience? Was offered that as my next project.

like

I interviewed for a product analytics DS role at Fb/Meta last week and haven't heard back since. Not sure if I event want to take up the role but nevertheless wondering if I am already rejected? Been about a week.

like

Looking to move from consulting to chill DS/analytics role. Don’t care too much about TC ($150k is fine), but WLB is paramount for me. Anyone have any thoughts as to where I can get this?

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

Looking to switch into Big4 and consulting industry, anyone willing to refer? Big thanks.

Vibe check - do you also feel often times that you are a wizard who pulls a rabbit out of his hat on each project, with unrealistic timelines, no data, understaffing and lack of clear requirements?

like

Anybody have any luck using virtual box to load a VM on windows 10? Throwing an error saying:

“The hardware virtualization is enabled in the Acceleration section of the system page”

like
like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

What’s the coolest data solution you have delivered? The industry is getting a little predictable and some inspiration is always welcome.

like

I am a beginner DA user and trying to gain experience. I am trying to do a project on ESG for fun, and having some difficulty coming up with a hypothesis. Want to pick your brains and see if I can get started. I have data about CO2 emisiones, electricity usage, air quality, and that’s pretty much it. Using alteryx and powerbi (to visualize results) as I don’t have any other programs. Thanks so much!

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

Analytics 💵 transparency thread!


Format:
Title level (standardized title/job level)
Economic area (Bay Area, Midwest, etc)
Salary + bonus + liquid equity
Anything else you think would help

likesmarthelpful

Data engineering or data science as your starting career for job security and ease of moving around to different jobs?

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

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

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