Power BI - Upwork
Power BI Developer I'm seeking an expert in Power BI with experience integrating Power BI with SharePoint sources. My business generates Excel reports each week from each of the 40+ locations. These reports end up in a weekly folder, and each weekly folder ends up in the yearly folder in our SharePoint. I need an experienced Power BI expert who can set up the connection between Sharepoint and Power BI so that these individual weekly store reports are imported, cleaned , and combined together. I would like to be able to refresh the Power BI weekly with all the new data from all the stores added to the master sales table(s). The 40+ individual Excel files are all in the same format (across all the store locations), but several changes will be needed to be made – for example, each weekly report contains 7 columns for each of the days of the week, whereas in the final master file, those 7 dates will most likely need to become ROWS of dates (so perhaps the whole report needs to be transposed and cleaned up).Posted On: July 01, 2024 08:51 UTCCategory: Data EngineeringSkills:Microsoft Power BI, Data Modeling, Microsoft Power BI Development Skills: Microsoft Power BI, Data Modeling, Microsoft Power BI Development Location Requirement: Only freelancers located in the United States may apply. Country: United States click to apply
admin
0
0
Power BI Developer
I'm seeking an expert in Power BI with experience integrating Power BI with SharePoint sources. My business generates Excel reports each week from each of the 40+ locations. These reports end up in a weekly folder, and each weekly folder ends up in the yearly folder in our SharePoint.
I need an experienced Power BI expert who can set up the connection between Sharepoint and Power BI so that these individual weekly store reports are imported, cleaned , and combined together. I would like to be able to refresh the Power BI weekly with all the new data from all the stores added to the master sales table(s). The 40+ individual Excel files are all in the same format (across all the store locations), but several changes will be needed to be made – for example, each weekly report contains 7 columns for each of the days of the week, whereas in the final master file, those 7 dates will most likely need to become ROWS of dates (so perhaps the whole report needs to be transposed and cleaned up).
Posted On: July 01, 2024 08:51 UTC
Category: Data Engineering
Skills:Microsoft Power BI, Data Modeling, Microsoft Power BI Development
Skills: Microsoft Power BI, Data Modeling, Microsoft Power BI Development
Location Requirement: Only freelancers located in the United States may apply.
Country: United States
click to apply
I'm seeking an expert in Power BI with experience integrating Power BI with SharePoint sources. My business generates Excel reports each week from each of the 40+ locations. These reports end up in a weekly folder, and each weekly folder ends up in the yearly folder in our SharePoint.
I need an experienced Power BI expert who can set up the connection between Sharepoint and Power BI so that these individual weekly store reports are imported, cleaned , and combined together. I would like to be able to refresh the Power BI weekly with all the new data from all the stores added to the master sales table(s). The 40+ individual Excel files are all in the same format (across all the store locations), but several changes will be needed to be made – for example, each weekly report contains 7 columns for each of the days of the week, whereas in the final master file, those 7 dates will most likely need to become ROWS of dates (so perhaps the whole report needs to be transposed and cleaned up).
Posted On: July 01, 2024 08:51 UTC
Category: Data Engineering
Skills:Microsoft Power BI, Data Modeling, Microsoft Power BI Development
Skills: Microsoft Power BI, Data Modeling, Microsoft Power BI Development
Location Requirement: Only freelancers located in the United States may apply.
Country: United States
click to apply
