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

@sathyamanikantabk4483

2 ай бұрын

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

@sathyamanikantabk4483

2 ай бұрын

what is the solution for this

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!

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

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

Where have you used MySQL? Please make a video how to get the MySQL table data into PowerBI. I've explored many videos in KZread. 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

@VINODkumar-gz8tt

2 ай бұрын

Interesting Questions waiting for answers 😊

@mrbartuss1

2 ай бұрын

@@VINODkumar-gz8tt It seems we won’t get them

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

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 .

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

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

Thank you so much very useful..

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

Nice Dashboard..nice information you are giving

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

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

@datatutorials1

2 ай бұрын

Thanks bro, glad you liked it 😃

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

thank you for powerful tutorials

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

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

Thank you

Great video

good job keep it up brother.😇

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

@datatutorials1

2 ай бұрын

Glad to hear that

Awesome explanation💯 , cleared my doubts on DAX🙏

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)

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

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

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

@datatutorials1

2 ай бұрын

Glad to hear that

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

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

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

5 күн бұрын

It’s mentioned in part one

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.

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

Can you bring some Postgre SQL projects?

🙏🙏🙏🙏

worth it 😍🙂 can you please share data modeling link

@datatutorials1

2 ай бұрын

Check description

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

Sir can you please provide link of 1st part ?

Can I get Requirement of document and Data sheet for practice

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

@lokeshmoolya5569

22 күн бұрын

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

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 😊

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 ?

@datatutorials1

2 ай бұрын

You did not watch the complete part 1 , i have answered this in part 1 video. Please watch again to know.

@kishan0705

Ай бұрын

It was just for cross checking with real SQL data with power bi findings

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

❤

Not able to dowload the data

Less is better but it’s cool though

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

2:38:31

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

@datatutorials1

2 ай бұрын

This is last bro

@beingrishi6450

2 ай бұрын

@@datatutorials1 Ok

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

@Sumankumari-hw9qb

25 күн бұрын

same here if you get the solution please reply

@datatutorials1

25 күн бұрын

@Sumankumari-hw9qb latest version June 2024

@Sumankumari-hw9qb

25 күн бұрын

@@datatutorials1 Thank you for your project video

@faisalirshad9403

23 күн бұрын

@@Sumankumari-hw9qb i dont think it is due to just the latest version but perhaps the difference is due to free and purchased version

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

@datatutorials1

6 күн бұрын

For you or in video?

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

@datatutorials1

4 күн бұрын

Its under maintenance, please try in morning

telegram link ....

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

@datatutorials1

6 күн бұрын

Thats not possible, if you are using updated version it should be there.

@SanketWade-z5s

2 күн бұрын

@@datatutorials1 i made a mistake while creating the tooltip it's my fault thanks for the content

Can I direct start from part 2 ?

@datatutorials1

2 ай бұрын

Yes you can

@mdwamik409

2 ай бұрын

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

Too much information makes it difficult

Starting with the video

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

@revalladhanunjay8690

Ай бұрын

I am also waiting for that only....if U know any method....please share me

@MadVocalVibes

19 күн бұрын

Did you get something to write? Help..

@mohammadfurquan241

18 күн бұрын

@@MadVocalVibes no, not yet

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.

@datatutorials1

27 күн бұрын

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.

@s.s616

26 күн бұрын

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

@datatutorials1

26 күн бұрын

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

@s.s616

26 күн бұрын

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