The sequel of this playlist is available in form of a video course here codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project If you like this playlist you would absolutely love the course as it is 50X better in terms of quality and content.
While I add the year and date and then i tried to click on the block to get the quantity and revenue i was getting the blank as output in the screen, can you help me on this!
i think this is the right place for every beginner who have became a data anyalyst..I'm one of them.....last 3 days i have working on this project,,eairlier get some issues regarding power bi ,because when i watch this videos it is a 2 yrs later and now power bi is updated so some little issues i have get but now after some time i resolve it successfully.and finally i have make a sales insights dashboard ..thank u so much sir you have done a great job for us..💯💯
Hi Pravin. Could you help me with one issue? At 28:30 when Dhawal sir is updating the first bar chart's y-axis from "customer_name" to "market_name", it is showing the same values for all the bars of the chart in my case. I have recently started this project and also have the updated version of Power BI like you. So, did you face the same issue? Please help me out here
Sir we generated a new column from sales_amount which is norm_sales_amount because it was having 2 entries in USD and rest in INR and we created a measure "Revenue" if we have used norm_sales_amount column in calculating the revenue measure then we would obtained some different value and what I think would have been correct one although it will not make a huge difference in the revenue. On an end note the power bi series was fabulous
While using norm_sales_amount, I have noticed it throws the error in the measure column. After small R&D found error is coming due to the data type of this column. We need to change the data type to decimal by clicking 1.2 in the column header in Transform Data window.
Great video, I think the reason why the top product says 'Blank' is because of a decrepancy in the star schema. I tried pulling the product_code column from the sales transactions table (instead of the sales products table) and it works just fine. Also, wanted to point out that you did not used the normalized sales amount and used the sales amount, which takes in USD.
in top 5 product matrix , you have selected wrong filed . Instead of selecting from sales products we should select it from transaction table . Becuase if we search in SQL , their are 279 distinct product code in sales products table where in transaction table 339. So , if we drag product code from products tables (339-279 = 57) 57 rows will be considered as blank while adding total revenue.
Hi Dawal, After setting 'set as default schema' , SELECT count(*) FROM transactions WHERE transaction.currency = 'INR ' ; can also be written as SELECT count(*) FROM transactions WHERE currency = 'INR ' ; give the same output.
Pandas is very powerful when it comes to data cleaning so I would love to clean my data in pandas rather than screwed up your head in powerBI. It is better to clean your data in pandas and import each and everything in your PowerBI that will save you lot of time
If you are using pandas without PBI, there is one disadvantage in this case you need to connect to Database using some connector, Extract the data perform transformations and load the files into PBI, But look at the complexity in this case there are 5 tables, moreover this database may update, So power Query Will automate this but with pandas its Kinda difficult.
Yeah, indeed pandas is powerful. I have intermediate level proficiency with pandas, but there you can manipulate data so well and easily. Plus, I think with Python the process can be automated and can be connected with PBI
Hey Dhawal!! This type of issue we face in every day work because sometimes data gets punched in system wrongly and this issue occurs. We need to check the same for other important attributes such as product category and product details. Its great learning from you!!!
it's so fun to see you in your own element. :D Also thank you for teaching this project. I had query in the third video about but now it got solved. Thank you for that
thank you for great knowledge, only thing I wanted to add is instead of filtering out data with INR and USD we would have simply used if else to convert USD#(cr) to USD and INR#(cr) to INR. please correct me if I am wrong
To remove duplicated currencies due to extra characters, just right click select transform and click on clean, it'll automatically remove extra characters.
In the matrix of top 5 products we have to consider the product code field from sales_transactions table instead of Product table.Its showing blank because we have filtered some data to adjust the duplicate currencies.If we cross verify with query in the database it can be seen that the database has no missing values so its clear that some thing is wrong from the dashboard end.
Your videos are very helpful. Thank you for the roadmap. I am following it and able to perform all the tasks as per your instructions...!! Thanks a ton...!! 🙏🙏
You did a great job we need to make special procedure how to find blank,how to find duplicate in sql and remove the value in sql itself by data engineer then only we got good insights
Very helpful video. Loved your content. Just one question .. Why is the top 5 products initial product code is blank. I could not find any transaction in SQL workbench which does not have a product code
Excellent learning so far, It would be great if you could do couple of more complex power BI enlightening session, loads of thank & greatly appreciate your efforts & time.
You're doing such a good things sir than you for your tutorial it helped me to understand more about power bi Keep doing more useful videos sir Thanks from the bottom of heart ❣️❣️
The issue of 2 seperate entries of INR and USD could be resolved in the power editor of PowerBI as well : (If we want to merge and have single entries for INR and USD then follow the below steps) The respective steps are : 1. Extract text before delimiter - Input R for INR and D for USD After the first step all the entries would be either IN or US 2. Replace values - Replace IN with INR and US with USD
HI Dhawal, Thanks for your efforts. Also we can create view to sort the issue concerning currency. Bellow is my approach towards it. create view vw_transactions as select product_code,customer_code,market_code,order_date,sales_qty,sales_amount, case when currency='INR' then 'INR' when currency='INR ' then 'INR' when currency='USD' then 'USD' when currency='USD ' then 'USD' end currency from transactions where sales_amount >0
Hello Brother, You are doing great job. I really loved your Power BI series. Can we write simple SQL query to check revenue in 2020? I have one suggestion and it gives me same answer. The query is 'SELECT SUM(sales_amount) FROM transactions WHERE EXTRACT(YEAR FROM order_date) = 2020 and currency = 'INR ' or currency = 'USD ';' Welcome for suggestions and also let me know if I am making any mistake here.
The REVENUE measure should be SUM(norm_sales_amount) and not SUM(sales_amount). We made a new column (norm_sales_amount) to convert the USD values to INR, why aren't we using it? Using just the sales_amount will give wrong results. Please check and confirm.
Hello Sir, we are filtering INR and INR/r. INR/r is having maximum observations hence keeping those rows and filtering out the INR header which are having 279 rows. cannot we change INR into INR/r because there is no error in the amount and filtering out those values may lead to fewer revenue numbers?
A big fan of you and this channel, really helps alot. Just a request, can I have the excel format for all these tables so I can import them in PowerBI and Tableau and play around. Thanks. More power to you.
hi there, Thanks for sharing this amazing series where we can learn professional practices as well. Always looking for something like that. I want to ask something. While building the dashboard I am trying to show the total revenue by product type through a donut chart. we have two distinct values in product type. one is Distribution and one is Own brand. Now the thing is when I put product type in the chart it shows two distinct values but when I drag the total revenue in it. it shows the third option which is blank and it covers the 47percent of the revenue. Is it that the transaction table has the sales of products that are not in the products tables? Can someone help me out with this?
Hello sir, There is mistake in your revenue calculation. You have used sales_amount column from transactions table for revenue calculation but it contains currency in USD. We have made norm_sales_amount column for revenue calculation in INR, but by mistake you taken wrong column in this whole dashboard and for verify with SQL query we have to also convert those USD into INR there. ❤️
Sir as we have done the analysis for certain number of years can we forecast the future of the sales and revenue like in tableau it has an option for forecast So, similarly do we have any option or method for forecast result in power bi...? and sir thank you for sharing the DAX course.
Thank you very much Dhawal.. !! I've some points in my mind, As we've not used norm_sales_amount anywhere while building the dashboard, then what is the point of creating it; And I've tried to use that column in place of sales_amount in revenue formula, It didn't work as expected, can you please check.... Second thing is that we can't say the sales are declining from 2019 to 2020; as we're not having complete 2020 data..
sir for the sum of total sales amount we have to use new_sales_amount column because you had converted USD values into INR but you had used old sales_amount column which has USD values
@@bxcks6220 bro watch the next video you will get to know and for new_sales_amount you have to change column type (like text, decimal, whole number) by default it is text so we have to change it as a decimal number
I think, In top 5 products, highest revenue product is blank because there are missing products_code in product table. And those products are contributing to Total revenue of 984.81M. So, those are shown as (blank) as there is no information about those in product table.
just establish relationship between Order_date from sales transactions and date in sales date in Model view and everything will be fine. For better understanding please watch previous lecture of Dhaval sir on 5.30
It took me half day to figure out that tables should have relations for slicer to work. missed this point in part 4. now learned it after wasting half of my day. 😂🤭
Hello Sir, Such a nice informative lecture. I am facing problem in BI Dashboard when I click on the month or year , value of revenue or sales does not change as shown in your video at 25:44 time. Can you please help
Whenever i add year to the dashboard , along with years i get blank button also just like years. when ever i click on any year my revenue and sales shows blank instead of showing the value.
Sir, my power bi is giving error for the first measure . Revenue. It says there is string type in the column new_ sales_amount. That's why can't Sum . ...!! By the way we have to use normalised sales amount right? Why are we using old sales_amount..??
Sir, can I do the same Data analysis part using Python library pandas? I am not comfortable with SQL. I am just asking. Is it possible to do the database analysis part using pandas? I love your all the tutorial.
@@codebasics Thanks for replying..The previous videos on Interviewing real time analyst & sharing their experience was really awesomeeee... please make some more videos like that...
I have a question, since we created a new col which contains currency amount converted to INR ,then why we did not use the new col for calculation of sales_amount?
Hi, currently I am working on this project now but I am facing an issue while creating a drop down for year column which is in sales date table. The year column is not mapping with the data in report view.
Hello all I am following this playlist and doing this project along I am struck in a place....and need help when I use slicer for year and when i click on a particular year the values are remaining unchanged....Tried my best and cannot figure it out
can we convert INR to USD then finally USD to INR to avoid the old rate of usd to inr conversion thing like in 2017 we may have different conversion rate
yes so ideally instead of using fixed rate you will call some api that can give you latest exchange rate. Or better is to retrieve exchange rate at the time when transaction happened. That will give you most accurate result
When I'm dragging out the year from sales date and applying the slicer it shows blank on the list and when I'm clicking on the year it's not showing the corossponding revenue and sales qty what should I do???
have also faced same problem .but i resolved it. Just watch previous tutorial carefully that how dhawal sir made relationship with different table while building a model @ time stamp 5:30
Hey Hi ..When I am selecting any of the Year from slicer like 2017,2018,..Its showing the "Blank " in the rest of the visuals ... same thing is happening with Cy_Date
The sequel of this playlist is available in form of a video course here codebasics.io/courses/power-bi-data-analysis-with-end-to-end-project If you like this playlist you would absolutely love the course as it is 50X better in terms of quality and content.
While I add the year and date and then i tried to click on the block to get the quantity and revenue i was getting the blank as output in the screen, can you help me on this!
bcoz your model is wrongly mapped. connect date with order date. it will resolve the issue
@@vinayakh3264
I have same issue and not resolved by your solutions.
@@vinayakh3264 thanks correct solution
@@vinayakh3264 market_name by revenue is not working. its blank even after building relationships
i think this is the right place for every beginner who have became a data anyalyst..I'm one of them.....last 3 days i have working on this project,,eairlier get some issues regarding power bi ,because when i watch this videos it is a 2 yrs later and now power bi is updated so some little issues i have get but now after some time i resolve it successfully.and finally i have make a sales insights dashboard ..thank u so much sir you have done a great job for us..💯💯
Hi Pravin. Could you help me with one issue? At 28:30 when Dhawal sir is updating the first bar chart's y-axis from "customer_name" to "market_name", it is showing the same values for all the bars of the chart in my case. I have recently started this project and also have the updated version of Power BI like you. So, did you face the same issue? Please help me out here
I never understood Power BI better than this. Thank you so much. My only regret is not starting with this playlist first.
yep me too
Sir we generated a new column from sales_amount which is norm_sales_amount because it was having 2 entries in USD and rest in INR and we created a measure "Revenue" if we have used norm_sales_amount column in calculating the revenue measure then we would obtained some different value and what I think would have been correct one although it will not make a huge difference in the revenue.
On an end note
the power bi series was fabulous
Sure I am going incorporate this feedback in upcoming video
While using norm_sales_amount, I have noticed it throws the error in the measure column. After small R&D found error is coming due to the data type of this column. We need to change the data type to decimal by clicking 1.2 in the column header in Transform Data window.
@@RajaKumar-hg9wl thanks budd
Great video, I think the reason why the top product says 'Blank' is because of a decrepancy in the star schema. I tried pulling the product_code column from the sales transactions table (instead of the sales products table) and it works just fine. Also, wanted to point out that you did not used the normalized sales amount and used the sales amount, which takes in USD.
in top 5 product matrix , you have selected wrong filed . Instead of selecting from sales products we should select it from transaction table . Becuase if we search in SQL , their are 279 distinct product code in sales products table where in transaction table 339. So , if we drag product code from products tables (339-279 = 57) 57 rows will be considered as blank while adding total revenue.
Thank You very much for the comment. It was very helpful.
best teacher on youtube which avail every thing for analysis the data well done sir
Hi Dawal,
After setting 'set as default schema' , SELECT count(*) FROM transactions WHERE transaction.currency = 'INR
' ;
can also be written as SELECT count(*) FROM transactions WHERE currency = 'INR
' ;
give the same output.
Pandas is very powerful when it comes to data cleaning so I would love to clean my data in pandas rather than screwed up your head in powerBI. It is better to clean your data in pandas and import each and everything in your PowerBI that will save you lot of time
If you are using pandas without PBI, there is one disadvantage in this case you need to connect to Database using some connector, Extract the data perform transformations and load the files into PBI, But look at the complexity in this case there are 5 tables, moreover this database may update, So power Query Will automate this but with pandas its Kinda difficult.
Yeah, indeed pandas is powerful. I have intermediate level proficiency with pandas, but there you can manipulate data so well and easily. Plus, I think with Python the process can be automated and can be connected with PBI
💯 Exactly!!! CLEAN USING PANDAS AND IMPORT TO POWER BI 🔥
@@harshpriyam7280 what if I clean all this by using mysql? Is it possible
it is becoming more interesting to learn powerbi after seeing your videos
Thank you very much sir. Sir we need more this kind of businesses analysis video. Thank you again. From Bangladesh
Will try to upload more. Thanks. 😊
Hey Dhawal!! This type of issue we face in every day work because sometimes data gets punched in system wrongly and this issue occurs. We need to check the same for other important attributes such as product category and product details.
Its great learning from you!!!
0:30 #1
5:25 #2
9:50 #3
10:55 completing data cleaning & ETL
11:25 - 37:25 building dashboard
38:00 - 40:00 interaction with dashboard
it's so fun to see you in your own element. :D
Also thank you for teaching this project.
I had query in the third video about
but now it got solved. Thank you for that
☺️👍
loved this project series so far and your teaching sir..
This is really very well explained. Each step in detailed without a hurry. I enjoyed creating this dashboard alongside you. Thank you so much, Sir!
thank you for great knowledge, only thing I wanted to add is instead of filtering out data with INR and USD we would have simply used if else to convert USD#(cr) to USD and INR#(cr) to INR. please correct me if I am wrong
To remove duplicated currencies due to extra characters, just right click select transform and click on clean, it'll automatically remove extra characters.
yeah, a lot simpler, dont know why he took the long route here specially since this is a beginner project.
Well Explained!! Love this project series and learnt many new things from this series. Thank you.
Feel like everything gonaa smooth like amul butter.
U've unique ability to connect like this much.
Ha ha.. i love amul butter. Thanks for the comment Sumit :)
In the matrix of top 5 products we have to consider the product code field from sales_transactions table instead of Product table.Its showing blank because we have filtered some data to adjust the duplicate currencies.If we cross verify with query in the database it can be seen that the database has no missing values so its clear that some thing is wrong from the dashboard end.
Thank you arijeet, even I too also wondered about the same issue. your comment helped to clarify my doubt.
thanku arijeet. i also dont like this blank
Your videos are very helpful. Thank you for the roadmap. I am following it and able to perform all the tasks as per your instructions...!!
Thanks a ton...!! 🙏🙏
Thank you for your video. this is my first time in power bi.
You did a great job we need to make special procedure how to find blank,how to find duplicate in sql and remove the value in sql itself by data engineer then only we got good insights
Hi @codebasics for calculating revenue at 12:41 should we use the normalized amount instead of sale amount as it has all the amounts in INR?
I too agree, because norm sale amount is the amount that has amount covered from the USD to inr.
Thanks, you provided a real case, and showed how to solve the problems.
Very helpful video. Loved your content.
Just one question .. Why is the top 5 products initial product code is blank.
I could not find any transaction in SQL workbench which does not have a product code
Really love your projects series.
Nice explain sir . one should watch this series to understand actual work of data analyst 😊
I am enjoying this video so much because you are so natural and real and no this is not making me sleepy at all , thank you so much
Excellent learning so far, It would be great if you could do couple of more complex power BI enlightening session, loads of thank & greatly appreciate your efforts & time.
This is a piece of art
Learning like a night owl 🦉 Thank you.
Loved this Project Series
Thank you for this series from India
One correction for Revenue we have to take norm_sales_amount instead of sales amount
hey i have done that but it's not showing the results. Can you please help?
You're doing such a good things sir than you for your tutorial it helped me to understand more about power bi
Keep doing more useful videos sir
Thanks from the bottom of heart ❣️❣️
👍😊
Just completed up to this .I love it ❤️..U r doing a great job🙌.and Btw tell bhavin patel not to watch the reports in mobile while driving 😅...
ha ha.. good tip. sure I will inform him :)
This is the most fun I've had on any tutorial🤣😂
The issue of 2 seperate entries of INR and USD could be resolved in the power editor of PowerBI as well :
(If we want to merge and have single entries for INR and USD then follow the below steps)
The respective steps are :
1. Extract text before delimiter - Input R for INR and D for USD
After the first step all the entries would be either IN or US
2. Replace values - Replace IN with INR and US with USD
I m binge-watching this playlist, just awesome knowledge
Glad you enjoy it Haroon!
Just a simple suggestion, we can also fix the base data once we get to know these are the errors.
what's the harm in that.
HI Dhawal,
Thanks for your efforts.
Also we can create view to sort the issue concerning currency.
Bellow is my approach towards it.
create view vw_transactions as
select product_code,customer_code,market_code,order_date,sales_qty,sales_amount,
case
when currency='INR' then 'INR'
when currency='INR
' then 'INR'
when currency='USD' then 'USD'
when currency='USD
' then 'USD'
end currency
from transactions
where sales_amount >0
Hello Brother, You are doing great job. I really loved your Power BI series. Can we write simple SQL query to check revenue in 2020? I have one suggestion and it gives me same answer. The query is 'SELECT SUM(sales_amount) FROM transactions WHERE EXTRACT(YEAR FROM order_date) = 2020 and currency = 'INR
' or currency = 'USD
';' Welcome for suggestions and also let me know if I am making any mistake here.
I runned your qwery and it worked pretty fine and also checked the value in the dashboard it matches the same
Thankyou!! I didn't make as many best friends in my life as I made in this video haha
¨Dear friends, remember, data will never lie!¨ 😂 thanks man for all this knowledge!
Wonderful teaching and project. keep it up
Huge thanks...love your all series of videos...
@12:12 🤔 revenue is the sum(norm_sales_amount), isn't it?
The REVENUE measure should be SUM(norm_sales_amount) and not SUM(sales_amount). We made a new column (norm_sales_amount) to convert the USD values to INR, why aren't we using it? Using just the sales_amount will give wrong results. Please check and confirm.
Yes. I agree.
Sir, there has to be a query to extract unique data type so that we can quickly figure out the odd man out...
Right??
at 35:30 i was literally sleeping when you said i hope you guys are not sleeping xD
To avoid any future problems with currency amount we could use
CURRENCY_AMOUNT>0
instead of filter 0 and -1 or in future any other negative value
Sometime we record sales amount Zero, when we give items as giveaway or sales Promotion, but inventory should be out. so we need to keep this record.
Loving it so far.
Glad you liked it mallu
@@codebasics Hope you would add more videos on sql and powerbi
Thanks a lot. Awesome learning and very nicely explained.
Hello Sir,
we are filtering INR and INR/r. INR/r is having maximum observations hence keeping those rows and filtering out the INR header which are having 279 rows.
cannot we change INR into INR/r because there is no error in the amount and filtering out those values may lead to fewer revenue numbers?
A big fan of you and this channel, really helps alot. Just a request, can I have the excel format for all these tables so I can import them in PowerBI and Tableau and play around. Thanks. More power to you.
hi there, Thanks for sharing this amazing series where we can learn professional practices as well. Always looking for something like that.
I want to ask something. While building the dashboard I am trying to show the total revenue by product type through a donut chart. we have two distinct values in product type. one is Distribution and one is Own brand. Now the thing is when I put product type in the chart it shows two distinct values but when I drag the total revenue in it. it shows the third option which is blank and it covers the 47percent of the revenue. Is it that the transaction table has the sales of products that are not in the products tables?
Can someone help me out with this?
Great Explanation sir
Hello @codebasics , is there any way to fix the blank in top 5 markets dashboard ?
Power BI is Interesting. 😍
Hello sir,
There is mistake in your revenue calculation. You have used sales_amount column from transactions table for revenue calculation but it contains currency in USD. We have made norm_sales_amount column for revenue calculation in INR, but by mistake you taken wrong column in this whole dashboard and for verify with SQL query we have to also convert those USD into INR there. ❤️
Agreed
Why did you use the sales amount and not the revised sales amount where we converted the currency into INR?
@dhaval sir. we can rename 'INR' to 'INR
'. doing this we will not lose any data
Sir as we have done the analysis for certain number of years can we forecast the future of the sales and revenue
like in tableau it has an option for forecast
So, similarly do we have any option or method for forecast result in power bi...?
and sir thank you for sharing the DAX course.
Thank you very much Dhawal.. !!
I've some points in my mind,
As we've not used norm_sales_amount anywhere while building the dashboard, then what is the point of creating it;
And I've tried to use that column in place of sales_amount in revenue formula, It didn't work as expected, can you please check....
Second thing is that we can't say the sales are declining from 2019 to 2020; as we're not having complete 2020 data..
Awsome project..........THanks a ton brother........
sir for the sum of total sales amount we have to use new_sales_amount column because you had converted USD values into INR but you had used old sales_amount column which has USD values
Exaclty. Also. I find my revenue as 11M idk why
@@bxcks6220 bro watch the next video you will get to know and for new_sales_amount you have to change column type (like text, decimal, whole number) by default it is text so we have to change it as a decimal number
I think,
In top 5 products, highest revenue product is blank because there are missing products_code in product table. And those products are contributing to Total revenue of 984.81M. So, those are shown as (blank) as there is no information about those in product table.
Hi Dhawal, After adding slicer in the report when I select any year data in other reports isn't changing. Do you know why?
You first need to relate [order_date] from sales_transactions table to [date] in sales_date in the model schema.
@@Tiago092 how to do that
just establish relationship between Order_date from sales transactions and date in sales date in Model view and everything will be fine. For better understanding please watch previous lecture of Dhaval sir on 5.30
It took me half day to figure out that tables should have relations for slicer to work. missed this point in part 4. now learned it after wasting half of my day. 😂🤭
In 5th part, when I add a slicer it gives me a blank value. Why it is giving blank??
Uh got a solution ?
Great video man...highly appreciate it
Glad it helped
Hello Sir,
Such a nice informative lecture. I am facing problem in BI Dashboard when I click on the month or year , value of revenue or sales does not change as shown in your video at 25:44 time. Can you please help
I'm facing the same problem. I don't understand why that is happening
@@shaswatichakraborty1006 Same here
awesome 👍👍 please bring more learning projects like this
I am happy this was helpful to you.
Very good sir please can you make projects on power bi
I also build my dashboard with few more modification it's great
yours videos really helpfull
Can you provide us also the data set for this project? I would like to test it by myself. Thanks you so much.
You are the BEST!!
Glad it was helpful!
thank you sir.....i practiced.....it, its cooll.......when i got some order will let you know.....:)
Whenever i add year to the dashboard , along with years i get blank button also just like years. when ever i click on any year my revenue and sales shows blank instead of showing the value.
Sir, my power bi is giving error for the first measure . Revenue. It says there is string type in the column new_ sales_amount. That's why can't Sum . ...!!
By the way we have to use normalised sales amount right? Why are we using old sales_amount..??
Sir, can I do the same Data analysis part using Python library pandas? I am not comfortable with SQL. I am just asking. Is it possible to do the database analysis part using pandas? I love your all the tutorial.
Thank you sir. it is very helpful
Keep it up
sir, i am getting 533m as revenue plzz tell me..and btw ur teaching style im superb sir
Is this a part of a series? Can we start directly from this project or any previous lectures need follow first ?
Simanchal, You can find the Playlist on video description
@@codebasics Thanks for replying..The previous videos on Interviewing real time analyst & sharing their experience was really awesomeeee... please make some more videos like that...
thank you so much sirji......................................
Hi Sir
for revenue you did not use "norm_amount" and did not apply data type on same field.
thanks
I have a question, since we created a new col which contains currency amount converted to INR ,then why we did not use the new col for calculation of sales_amount?
great teaching sir !
Glad it was helpful!
very interactive ❤
Hi, currently I am working on this project now but I am facing an issue while creating a drop down for year column which is in sales date table. The year column is not mapping with the data in report view.
Hello all I am following this playlist and doing this project along I am struck in a place....and need help
when I use slicer for year and when i click on a particular year the values are remaining unchanged....Tried my best and cannot figure it out
Bro, same error.... Did you find any solution?
can we convert INR to USD then finally USD to INR to avoid the old rate of usd to inr conversion thing like in 2017 we may have different conversion rate
yes so ideally instead of using fixed rate you will call some api that can give you latest exchange rate. Or better is to retrieve exchange rate at the time when transaction happened. That will give you most accurate result
Sir, My value is totally different in revenue from yours. Kinldy suggest on this
When I'm dragging out the year from sales date and applying the slicer it shows blank on the list and when I'm clicking on the year it's not showing the corossponding revenue and sales qty what should I do???
have also faced same problem .but i resolved it. Just watch previous tutorial carefully that how dhawal sir made relationship with different table while building a model @ time stamp 5:30
very helpful @codebasics
Hey Hi ..When I am selecting any of the Year from slicer like 2017,2018,..Its showing the "Blank " in the rest of the visuals ... same thing is happening with Cy_Date
When I select the year on the slicer, the revenue and quatity cards are showing (blank). Any reason why this is happening?
awesome so i will subscribe!!!!