I have a requirement for a sales report to be written against data in a database table that contains order information. The table has a field which stores serialized json. That json has a complex structure to include records and nesting.
I’d like to use Power Bi to do the report however it’s unclear whether Power BI can handle reporting against this datasource.
If it cannot I need to devop an SSIS script to etl the data to a table structure that I can report on and then write the report.
I’d like to hire someone to work with me over skype to understand the issue and make recommendations, help with prototyping etc..
This person should enjoy a challenge and be well versed in SSIS and Powershell.
11 freelancers are bidding on average $140 for this job
HI i glad to say that i have worked for our dashboard to process data from ssis . I am not familiar with power shell or power bi , if you would like to work together ,I am always ready to take challenges