Forum Discussion
Org Template from Excel Sheet converted into extractable data - Need Help
Hello Everyone,
I have a template I need to re-configure to get extractable and legible data into PowerBI. The template currently is set up for end users to have to modify columns and rows that would not work for my BI import to manipulate. Or at least not to my knowledge.
My goal is to collect the total hours per discipline. Currently the excel template is set up as a sheet, not a table. How can I easily convert this template that could be used company wide as a standard asset, very easy for data entry as well as import into power BI.
Any suggestions would be greatly appreciated. Please see table below.
https://docs.google.com/spreadsheets/d/1WEKhbzaEe4vaewCUTikVV6KMKXyD2Xr36Xojbzde_Xw/edit?usp=sharing
Hi nicoleclancy91 ,
The Excel file appears to have a non-tabular structure, with a lot of empty or merged cells. To make it extractable and suitable for Power BI, we need to:- Identify relevant data (e.g., total hours per discipline).
- Unpivot (reshape) the data into a structured table format.
- Remove unnecessary empty rows and columns.
I'd clean and restructure the data into a tabular format.
Best regards,
1 Reply
Hi nicoleclancy91 ,
The Excel file appears to have a non-tabular structure, with a lot of empty or merged cells. To make it extractable and suitable for Power BI, we need to:- Identify relevant data (e.g., total hours per discipline).
- Unpivot (reshape) the data into a structured table format.
- Remove unnecessary empty rows and columns.
I'd clean and restructure the data into a tabular format.
Best regards,