How to analyze database

atcman

Board Regular
Joined
May 13, 2005
Messages
57
Hello, I have a database that has 92 rows and 365 columns. The first column is employees names and the other columns start with the date for each working day of the year. The data under the date in each column is alfa numeric work assignments. My question is how to best analyze the data and make it update to a dashboard.?
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

alansidman

Well-known Member
Joined
Feb 26, 2007
Messages
5,589
Office Version
2019
Platform
Windows
best analyze the data
What are you analyzing for? Tell us what you want as an end result. Your question is too vague for any type of solution.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,607
Messages
5,469,659
Members
406,665
Latest member
priyankape2005

This Week's Hot Topics

Top