Yeah, there will be a lot of challenges that I have faced. One is performance. So one of the reports that I worked on was a BI report where the performance, so this was not performing well simply because the load on the data was quite huge. So we had to do a lot of merges. We had to do a lot of merges to get the data from different tables and the load on the report was quite high. So this was for one of the energy-based company that I worked for. So the reporting there was quite heavy. What we designed is, or what I designed is to gather the data, move to data flows and create quarter-based data. So now what is happening is that if right now we are in the first quarter, it will only take the data for the first quarter and then years before that. So like it will take the data from 2020, 2021, 2022, 2023, but only for Q1. However, it restricts to some amount and it will show the data for the others, but it will not be loading the data for the others. They just show the flat copy of the other data. However, the data for the Q1 will be loaded for others. So you can compare any kind of a matrix on that one. This is what was one of the examples I have to create because there was no, because try using the data was so huge that we couldn't use import. And we had to, even using that, we couldn't do it on import. So I have to use data query. And even with that query, the performance was low as compared to import, but we have to use data flow. So that's fun. And then second was when I was creating that user wanted to have a write-off capacity. So they wanted to insert comments from the live report. So we included PowerApps. So basically under a particular sales or under a year, they want to include sales target. So I connected my report to a SharePoint list and connected this SharePoint list back to Power BI. So what it does is it, and then created a PowerApp. So what it does when you enter a comment in this particular year, it gets saved into your SharePoint and then reverted back to the report. But it wasn't important. I have to use data query. So then I moved this Excel into a table, into a SQL server where I had a read and write capacity. I didn't have a read and write on the production. So I created, we had an access to another database in SQL server and where we had a read and write capacity, moved this table to there and created a read and write application. Now, customer can enter and modify the sales target according to a particular year.

