Forums for the Business Analyst

  Modern Analyst Forums  Business and Sy...  Data Analysis f...  How to represent and visualize and present data table relationships
Previous Previous
Next Next
New Post 12/3/2021 7:25 AM
User is offline Mythbusternz
1 posts
No Ranking

How to represent and visualize and present data table relationships 

Hi Experts,

I am working on 100+ reports and used Power Query to create a table that shows each header in the spread sheet is used as data. Here is a sample problem health report say Covid reports. There are 6 spreadsheets with data on Covid, so I got a table which report uses what header (Table) likewise there are other health reports having common headers. I need an idea of what tool and how to co-relate 

Each of these spreadsheets are output from various systems and databases. Once I get the common links between each of the headers in the spread sheet, I will map them to the systems and create matrix.

Further details on Covid spreadsheets Repart 1

1.ID, 2. Place 3. vaccine status 4. Partial flag 

Report 2: 1. ID 2. Name 3. GP/ Nurse name 4. ID of the GP/Nurse 5. Batch No

Repoert 3: 1. ID, 2. Name, 3. Address 1, 4. Address 2, Region, State. etc

Now I have a matrix of all the above spreadsheets and who is using what headers,, using power query. I need your help to visualize this into a meaningful story so I can use it for 100s of spreadsheets I need to analyze.

Previous Previous
Next Next
  Modern Analyst Forums  Business and Sy...  Data Analysis f...  How to represent and visualize and present data table relationships

Community Blog - Latest Posts

There are big differences between data exploration versus data presentation. And you need to be aware of these differences as you're creating data stories and data presentations. Let’s start by defining our terms: Data exploration means the deep-dive analysis of data in search of new insights. Data presentation means...
Is Agile a reason to avoid documentation? I bet this question shows up again and again while working with product requirements. On one side, we have got long specifications, complicated diagrams, mystical technical design, too many prototypes and pretty obvious for engineers user guides (do we really need so much?). On the other side, can we actual...
The cloud-native application development has helped enterprises all around the globe reduce time-to-market, enhance performance, and develop agility and flexibility. Several enterprises are achieving these results by migrating their systems or traditional monolithic applications to the cloud. But to gain from the real benefits of cloud technology, ...



Copyright 2006-2022 by Modern Analyst Media LLC