business intelligence

I get a daily report which has data with some variability in terms of what column any given header may arrive in (i.e. column AAC today is column something else tomorrow). The report comes with six rows of header details so already requires a transpose/merge/transpose activity ... Is there a...

I have Table A and Table B Table A has the unique personnel ID Table B has the the field "Category" where personnel ID can have multiple categories selected, e.g., Table A: Key Name 1 John 2 Jacob 3 Jane Table B: Key Category Sub Category 1 Personnel Type...

I'm running analysis on an Audit that has been distributed over the course of a year. There are currently about 40 or so different audits. Each audit contains 90 questions. When the audit was first published, the results we were getting were skewed. For instance, many of the answers came back at...

I need to build a report for my work that tracks the trends of a weekly questionnaire that gets sent out, but I am really struggling trying to develop a way too set this up. Should I use Access? Queries? I don't know!! I know I've probably been overthinking this and there is likely a simple...

Hello, Excel world! I've managed to go through basic books about creating charts in Excel. I can say, I even learned some tricks to make reports/dashboards nicer. But browsing though web, I found some really amazing reports done in Excel. Reality-check: need to learn A LOT more to get to that...