Odin School PL300 Power BI Certification Course - hubs.la/Q02xXcNc0

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!

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")

Greetings from Nigeria. Your videos have helped me learn new stuff in data analysis. thank you for the effort,

Hello man, your content is awesome. Learned a ton of new stuff through your long video tutorials. Greetings from Spain. Keep it up!

This channel has many end to end projects across the domains that one can learn to become a Data Analyst. Really amazing stuff. Thanks and regards 🙏🙏

I Learned lot from your videos.Thanks Lot for you videos and Effort.

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 .

Where have you used MySQL? Please make a video how to get the MySQL table data into PowerBI. I've explored many videos in KZfaq. No one showed a proper tutorial.

This was very interesting and learned a lot of new stuff. Keep posting such new projects.

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

THIS IS AWESOM!! I leaned a lot from this tutorial. Good Job! Keep up the good work Friend !

Sir, Huge fan of you, you are the driving force behind my love to data analytics🤩🤩🤩🤩

Extremely useful tutorial. Thank you very much. I learned a lot 🙏🙏🙏

Great, Thanks for this project. Appreciate your efforts, hard work, patience and communication style. Keep it up bro!!

@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.

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)

Thankyou bro...its bit lengthy but covers all topics and concepts

Man, this content is very good, and I learnt a lot of new ideas on visualisation

Awesome 🤩 🙌🏻

thank you for the dashboard :)

Nice Dashboard..nice information you are giving

Nice video

thank you for powerful tutorials

I learned lot from your tutorial, keep it up mate!

Thank you for this great tutorial! I learnt a lot !

it is amusing course,i learnd a lot from your channel keep working,this is from Ethiopia . when will you start making tutorial on python

Awesome explanation💯 , cleared my doubts on DAX🙏

good job keep it up brother.😇

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

Thank you so much very useful..

1:19:00 I am getting this error(**Error ** Circular dependency detected: Date Table[Month No], Date Table[Month Year], Date Table[Month No].)

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.

Thank you

worth it 😍🙂 can you please share data modeling link

weekday/weekend = IF(Date_Table[Week Day Number]

2:07:20 ASSIGNMENT MoM Growth & Diff Sales = VAR month_diff = [1CM Sales] - [1PM Sales] VAR mom = IF(NOT(ISBLANK([1PM Sales]) && [1PM Sales] 0), month_diff / [1PM Sales], BLANK()) VAR _sign = IF(month_diff > 0, "+", "") VAR _sign_trend = IF(month_diff > 0, "▲", "▼") RETURN IF( ISBLANK([1PM Sales]) || [1PM Sales] = 0, "No Previous sales", _sign_trend & " " & _sign & FORMAT(mom, "#0.0%") & " | " & _sign & FORMAT(month_diff / 1000, "0.0K") & " vs LM" ) PS: change accordingly for Mom Orders and Quantities 😊

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] )

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 ?

Great video

Could you please add the SQL queries which you have shown in word document in here as well

please make a project on marketing domain and pharma/healthcare domian please

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 ?

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??????

Can you bring some Postgre SQL projects?

Whenever I am trying to import the data into MySQL only the columns are getting imported and not the rows kindly assist

Sir can you please provide link of 1st part ?

Why am i having issues with this colorsl for bars. All the bars keep having the same color

month wise total sales is not coming accurate how to solve it plz tell 😢

Is this all in one or part 3 will come as well?

Hello Sir, DSA padhna important hai data science ya Analyst field mein?

I have problem in my Power Bi some visual are not appearing can somebody tell me how to fix it

Starting with the video

1:33:18 it shows .. the syntax for ')' is incorrect

Facing issue in calendar

Can I get Requirement of document and Data sheet for practice

which PowerBI version are you using? I don't seem to have much of the formatting options in my version of PowerBI

2:38:31

Can anyone plzz tell me how we solve the error while data importing....Because it doesn't responded anything right now

sir the website to buy meterials realted to data analysis is not working is there any alternative way to get the materials

hey my tooltip not work while on tooltip but can't get page option to select i have only page auto wht i do?

Less is better but it’s cool though

🙏🙏🙏🙏

Not able to dowload the data

Can I direct start from part 2 ?

telegram link ....

❤

can someone please share me the Power BI dashboard. Please its needed. I can share my mail if anyone i willing to share it with me

Too much information makes it difficult

📌PLEASE PROVIDE HOW TO MENTION THIS PROJECT IN RESUME WITH DESCRIPTION AND BULLET POINTS. Please Reply

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.