I've been asked to make a testing issue tracker. The challenge is that there's a many-to-many relationship between test cases & issues (i.e. a case would be impacted by multiple issues, & an issue can impact multiple cases).

I was planning to solve this with Excel's Power Pivot tool so I could put multiple tables into a single data model, but my company's on MacBooks (and won't allow Basecamp Windows OS) and Mac's Excel doesn't have this.

How can I solve? I'm open to any tools, not just Excel.

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

Jira. Don’t reinvent the wheel

like

Excel for test case and bug management. Red flag

like

Unless I completely misunderstood , you could probably make a private git repo to accomplish this, or use a ticketing solution like Jira or RT. Notion or Airtable may also be able to accomplish this. These are are all largely free(at some tier) and/or open source

I would not recommend attempting this in excel for the reasons you stated and this quickly can escalate into a technical mess.

like

Deloitte doesn’t have a test management tool? Come on.

I could make it for you, but I need to charge a consulting fee

Jira or HPALM

Use access

I should clarify I'm looking for something that would be relatively accessible to a client. The tracker of test cases is in Excel (on the client's SharePoint) because it's co-edited by us/client, and so looking for a tool that's either embedded in the same file, or one that can regularly pull the data from the Excel file and incorporate it into a data model with the issue info in order to create dashboards.

I'm not skilled with network databases, so any details are appreciated!

can be solved within excel without power pivot tool, using match function, and sorting.

Unfortunately, like I mentioned in the description, our MacOS version of Excel seem to only have Power Query, not Power Pivot

like

You say you have Power Query, so you can still read SharePoint files into a workbook and do full joins to preserve your many-to-many relationships. If you run into row count limits, you can take your PQ script and copy it to Power BI which is more scalable than Excel.

Related Posts

Any recommendations for learning Mulesoft? I used it a bit a few years ago, but I don't remember much. How much has it changed since being bought by SF?

like

Looking for a Legal Recruiter or Recruiting Firm. Young Associate with Healthcare/Health Law Experience.

like

Thank you and we’re done!

Post Photo
likeupliftingfunny

I'm currently in a consulting manager role internal to a well regarded pharma company. However, i have been contacted about a role at IQVIA for a new pure strategy internal group that they are standing up. It would be a 55% salary boost with director title and completely remote. Should I consider it? The salary increase and location flexibility are alluring.

like

What is the appetite for tax policies consultancy in North America?

Got offer and accepted but other firm that I applied ask for additional interview. Please advisd how to tell them "no" nicely ?

like

I need a referral for devops engineer role. 3.5 yoe
1 month remaining of notice period.
Location preference is delhi ncr.
Not getting calls these days

like

Did you use admissions consultants? Who was it and was he/she worth it? Advice on selecting one?

like

What should be the Salary ask be for Sr. Consultant @ EY India Tech Risk practise?
Relevant YOE - 5 years.

like

Switching to PWC. Is this a good move? 30% hike. Currently in tech consulting(big4) to Risk Consulting- DnA (PWC). Yoe-3yrs Cctc-10lpa Pwc EY KPMG Deloitte PwC How is risk consulting in Pwc

like

Could you please confirm if there is cab facility for Shollinganallur office,since I will have to WFO for 3 days in a week


Also,if cab is available,can you please share the charges for the same.

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

like

Does your firm regularly adjust rates? I read an article suggesting it should happen annually. Curious how regularly firms adjust attorney rates.

like

AITA? If my SO of 1 year wants to get a dog, do I get an opinion? We don’t live together

Can someone tell me what AI consultants are earning at Deloitte? I am interviewing for the same and wish to know a range?

Hi folks,


I have been assigned to one client project.... During a client interview they have asked qns in my relevant technology but after getting into the project they put me in different tech... Which I have never worked at before...
That project is short term and they are asking to complete the development within 2 weeks and I am the only one resource... I told my tech skills to my pm... He said no other resources is available to replace you.... What should I do now....

like

Any A&M folks here? Wondering how benefits / 401k compare to Big 4

like

Any referal for 2 year, security engineer in global logic??

Would like some opinions about how likely it is to make product analytics self serve by PMs? Anybody have success here? Or is it hopeless to think that product managers can pull their own data, look at their own dashboards, and do basic data tasks themselves?

like

Additional Posts in Excel Genius

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How do you fix microsoft excel cannot paste data error?

like

Still don't have xlookup. #fomo

like

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Would anyone be willing to teach me vlookup?

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

Anyone know what these badges are?

Post Photo
likefunny

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

likesmart

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

like

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

like

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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