Narayan jena

So thank you for giving me this opportunity. My full name is Narayan Jina. I have over eight and a half years of experience and four years into data analytics. The recent company I am working with is EyeLink Multitech, and the recent project I was involved in was AnyCura. That was a European-based client, and the domain was veterinary healthcare. My role in that project was to prepare, like, they have hospitals and clinics across Europe. They wanted to know which clinics are huge, which clinics are not huge, where maximum footfalls are happening, and where less footfalls are going on, as well as which assets are frequently in use and which assets are not in use frequently. I worked on all these KPIs. This is the overall introduction for me. Thank you.

So, for dealing with large datasets, I have to see the source, whether it's in import mode or it's in direct query mode. If it's in direct query mode, I will do all the transformations at the source only, and I will import the transformed data to Power BI so that the maximum load is given to the back-end side and Power BI is left as much as possible free. And after that, for calculation and modeling, I will go for the star schema because it's simple and joins are also simple. This will give a good performance result. And after that, instead of creating calculated columns, I will go for writing measures. And instead of writing many measures, I will go for variables. So I will try to write measures with variables. Okay. And after that, the performance analyzer is there. So, with that, I can see which formula or which measure is taking much time and which is not. I can manage that. And, also, I have to see if it's a big dataset. So, for my client's requirement, I will see whether I can fetch a particular amount of data to give the client's requirement or not. Maybe there is a mix of different kinds of data. Okay. But the client's requirement is specific to something only. For example, specific to a few categories only. So I can face that few data only. I mean, I can filter out that, and I can build the report on top of that. So like this, I can do with Power BI. Thank you.

Yeah, for this, I can go for the performance analyzer. There I can see, like, I can check which formula is taking much time. If I get any formula that's taking much time, then I can optimize that and rewrite that formula. So, the performance analyzer will be a great help for this issue. Thank you.

So, for this, if the Power BI report is not loading like this. In that case, I will check whether the connection is proper or not. 1st, I have to check that. Then, I have to check the connection, then the data source is proper or not. Then, after that, I have to check the gateway also. The gateway is a plugin available in Power BI, which is for transferring the data from on-prem to server-side. So, like this, a few steps I will consider, and I will check. Thank you.

I apologize, but I'm not sure I can answer that.

Yeah. So, in this case, I can go for, like, so I have already loaded the data to power BI. And, in any cases, if I need to change the model, I can go for some functions that are there in Power BI, like cross filter or a huge relationship function. So, with the help of these functions, I can test the required data. So, in that case, I think no need to change the model again. And I can, so and no need to do hard coding. By this, I can achieve this. Thank you.

Okay. So here in this deck's formula, it is written to calculate the sum of sales amount, then if you would filter all sales, again, it passes all sales, then sales year is equal to 2022. So here, what I see is we want a sale from 2022. And all sales I want with no filter should be impacted here. So here, I can write instead of using filter again, so no need to use that filter function again. It's I can write this expression without using filter also in a calculate expression, then filter whatever the number of filters I can implement. Okay. So in that after the sum of sales amount, I have written the expression. Then after, I can write directly all sales or else or else I can write sales is equal to 2022. So no need to use filter function again here. Without using filter function also, we can achieve this output. Thank you.

So, to design a Power BI report that accurately reflects complex business logic, I can write depth expressions. And while writing these expressions, I have to keep in mind that I should not repeat the same kind of depth formula or use unnecessary functions to get a particular output. I can use variables while writing text formulas. These are the few things I should keep in mind while writing DAX formulas. So, how to design a Power BI reporting solution that accurately reflects complex business logic? So, like this, I can achieve this requirement.

To maintain core quality in the development of decks, expressions, and SQL queries, we should have a reasoning skill, mathematical skill, as well as statistical knowledge. This will help us to write better code, and it will also improve our reasoning skill. With this, I suggest going for quantitative programming, which will definitely boost our logic. This will open a few other dimensions. By practicing quantitative programming regularly, it will definitely help us to write an enhanced form of decks, expressions, and SQL queries. We have to practice daily, choosing something for at least 10 minutes each day to write some decks, queries, or SQL queries. By doing this, we will stay in touch with this, and our knowledge will increase day by day. Regularly staying in touch with expressions and queries and keeping on practicing daily will be a good solution.

I'm sorry, I can't give you a correct answer for this.