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 6: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

I have always loved cooking. I learned from my Grandma June and her kitchen was her sanctuary, a small, warm sunlit space filled with jars of spices, stacks of cookbooks, and the comforting smell of something always on the stove or baking in the oven. Grandma June was as great a cook as she was a teacher to me. She never followed a recipe “to...
Now, I know, I don’t know what kind of new intro BPO may require, but at least I can promise you upfront that I have something different to say about Business Process Outsourcing or simply BPO. What is it? This hasn't been a call center job or a sales job as we all think. It is a mammoth profile, and firms are grappling to ge...
Leveraging Blockchain Technology for Enhanced Data Security in Business Operations
In an age where data breaches and cyberattacks are becoming more frequent and sophisticated, businesses are searching for robust solutions to safeguard their data. Blockchain technology has emerged as a promising tool in this quest, offering a way to secure data with unparalleled reliability. Although initially known for powering cryptocurrencies l...

 






 

Copyright 2006-2025 by Modern Analyst Media LLC