2:47:38 IN FUture if there are too many things to consider for certain condition to be met thne we can just use IN operator instead of || operators DAX: Weekday / Weekend = IF( 'Date Table'[Day] IN {"Sat", "Sun"}, "Weekend", "Weekday")
I can’t believe you had done it in 4 hours only. It’s so tiring, but I’m glad I could complete my first own sales dashboard. OMG Thank you so much! God bless u!
It’s great to learn from your video. Clear and easy to understand. Highly recommend for newbie. Please create more begin to end projects in the future. Thanks ❤❤❤
Good afternoon, i learn so many things in this dashboard and enhanced my knowledge on DAX and insights and also the interactions between all charts and KPIs, and hope that you are going to make some more Dashboards with new ideas .
1. Shouldn't we create dim_Product and dim_Store tables to make a star schema? 2. What is your opinion on creating a design by inserting shapes, which makes refresh slower, instead of using PowerPoint? 3. 1:09:00 Why calculated column instead of a measure? Performance will definitely suffer 4. What's the point in creating CM Sales? It is exactly the same as Total Sales 5. 1:45:53 Why did you create month-diff variable and then did not use it in mom? 6. 2:36:40 This pie chart doesn't make any sense. How can you compare Total Sales in $ with Total Orders? These are different units
Where have you used MySQL? Please make a video how to get the MySQL table data into PowerBI. I've explored many videos in RU-vid. No one showed a proper tutorial.
The project is superb and very helpful.. Thank you for taking the initiative .. Just one suggestion .. I think if you make the project in Hindi ... it would be more impactful and easy to understand (especially the DAX functions and the exact purposes for making the DAX function)
@DataTutorials, thank you so much for this highly insightful and well curated teachings. Your magnificent dexterity is highly commendable. I have decided to add this project to my portfolio and I am almost completing it. However, I figured that each time I format the constant line section to select the new measure calculated(Daily Avg Sales), as soon as I click ok, the bars(columns) in the stacked column chat, disappears. I tried to increase the value to 1, the column then re-appeared but as soon as I proceed to select the new measure calculated, it vanishes again. I have tried to unselect and re-select to troubleshoot the error, still proved futile. I will appreciate your assistance. Thank you in anticipation.
Thank you so much for the great lesson sir , indeed learned a lot & boosted one confidence with all the DAX manipulation shown in this video . i just have a question regards the last visual Sales by Hours | Days whenever you use any of the filters of other visuals the stacked column chart above the [Day Names] will be filtered but not synched with the heat map , i wonder if you can tell me how to synch them together.
Hello Data Tutorials, I wanted to know why you wrote that cm_sales. Isn't this also the right DAX formula? DAX Cm_sales = CALCULATE(TOTALMTD([Total Sales], Date_table[Date])) It is providing the same results.And as i know that every thing which is in dashboard is interlinked so why the cm_sales ?
Hello , as given assignment in project is this correct way or any changes needed MOM Change = IF ( ISBLANK ( [Previous Month Sales] ), "No sales in previous month", [Total Sales] - [Previous Month Sales] )
MoM_Growth & Difference_Sales = VAR month_difference=[Current_Month_Sales]-[Previous_Month_Sales] VAR mom=([Current_Month_Sales]-[Previous_Month_Sales])/[Previous_Month_Sales] VAR _sign=IF(month_difference > 0,"+", "") VAR _signtrend=IF(month_difference > 0,"▲","▼") RETURN IF(ISBLANK([Previous_Month_Sales])||[Previous_Month_Sales]=0,"No Previous Sales", _signtrend & " " & _sign & FORMAT(mom,"#0.0%" & " | " &_sign & FORMAT(month_difference/1000, "0.0K")) & " " & "vs LM") I tried this one and this is working
I don't understand this: Why we did these SQL queries in previous video? Because there is no use for them, or am I wrong ? Everything for dashboard is done in PowerQuery and DAX. Or can I somehow use these queries ?
Please someone reply this : In my bar chart, When i place Label for Store Location above each bars , at placeholders, I can not see it , it doesn't appear above each bars , what i can do here??????
great explanation but my doubt is what is the reason to use SQL in this project since everything depends on DAX queries to make different metrics like total orders , total sales etc in power BI
@@datatutorials1 brother there is last question can u make Microsoft SQL basic to advanced because there is no such good video on yotube for Microsoft SQL server and your all videos in mostly use tool is Microsoft SQL ??
My friend, explain me something. i'm learning from your channel, but how a begginers can create by himself this dax formula? MoM Growth & Difference Sales = VAR month_diff = [CM Sales] - [PM Sales] VAR mom = DIVIDE([CM Sales] - [PM Sales], [PM Sales]) VAR _sign = IF(month_diff > 0, "+", " ") VAR _sign_trend = IF(month_diff > 0, "▲", "▼") RETURN _sign_trend & " " & _sign & FORMAT(mom, "#0.0%") & " | " & _sign & FORMAT(month_diff / 1000, "0.0K") & " vs LM" 1) Just explain me how, because it's very hard to understand. are you using chatgpt? for example if a company asks you for this specific measure, you take in advange usign chatgpt or you create this formula by yourself without help?? 2) all the case study that you're publishing in your channel they could be considerated as real case or not? Thanks for your work.
First of all these are projects with data available on kaggle or any other website. The requirements are created by myself based on my 10+ years of experience in this field. When you create requirements and based on that you create these logic, and I have not used chat gpt. I have gained enough experience in DAX that I can create these set of logics by myself. In realtime requirements and data come from clients, which are somewhat similar as these.
@@datatutorials1 I KNOW, but i don't have your experience, how can i work for a company if i don't have this padronance with dax?? i do practice every day, but i don't have much confidence with dax, you know what i mean? i can use chat gpt for learning fast? whatsapp the big advice for a begginners like me? thanks a lot, you're the best.
@s.s616 you have to work on such projects, create your own reports. Practice will only make u perfect. Even I didn’t had much knowledge when I started to work in this field. You have to work on multiple scenarios. Building and practising 2 or 3 projects won’t get u to this level of understanding. Work as much as you can on such projects, then and then u will gain knowledge and confidence.
@@datatutorials1 if I follow all your project's tutorial, I will able in some moth to understand a lot? Just to have the necessary skills to send a CV to some companies. What do you think?