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

Fabricio Laguna talks Business Analysis and AI
I recently connected with Fabricio Laguna, aka The Brazilian BA. Fabricio is a passionate and pioneering business analyst from Brazil. During our conversation, we had a thought-provoking discussion on how artificial intelligence stands to shape the field of business analysis in the years ahead. While AI promises to transform many aspects of busines...
Business Architecture, Ontology and More with Terry Roach
It's been a privilege meeting Terry Roach, a visionary in the field of enterprise architecture and business architecture. Terry's insights into the evolution of business models, the importance of ontology in architecture, and the potential of AI to shape our future were not only thought-provoking but also a reflection of his extensive exper...
Today I had the pleasure of chatting to Jignesh Jamnadas, Chief Operations Officer at Mosaic, about his Blueprints for Success. As a Senior Finance and Operations Executive, Jigs (as he is known to many) has a holistic understanding of all facets of business and a flair for managing both people and processes. Having worked with Jigs, I was struc...

 



Upcoming Live Webinars




 

Copyright 2006-2024 by Modern Analyst Media LLC