Видео

Hi, I am trying to this, but I am facing a problem. The column name shows an error. -- = Table.AddColumn(#"Filtered Rows", "IncidentdateNew", each try Date.FromText(Text.Start([incident date],2) & Text.Middle(incident [incident date],3,2) & "-" & Text.End([incident date],4)) otherwise Date.FromText(Text.Middle([incident date],3,2) & Text.Start([incident date],2) & "-" & Text.End([incident date],4))) Expression.Error: The name 'incident' wasn't recognized. Make sure it's spelled correctly. Could you please explain why this error??

Isn't removing duplicates from single column (as we did in mapping) will affect the analysis outcome since their corresponding values in other columns are there in the data?

Superb Explanation .

Thanks man this was a savior...I have a project today and since last two days I watched multiple videos unable to understand sh*tz...but I understood everything that u explained. Excellent stuff for beginners like me.

Masterpiece!Thank you so much for this detailed project.. Quick question ,under relationship's view we have two speciality_name columns under all data table but when we move onto building visuals,I see only one just below specialty HIPE...please let me know on what transformation you undertook...did you merge or discard the other and if so on what basis? Your response will be highly appreciated!

Thank you for the SQl beginners Bootcamp.. It is very helpful and well explained!! can you also create some videos on advanced SQL functionalities please?

A new direction of power bi

I installed the SSMS and after opening the server name is not showing. Its empty

TIP Merge the Sem1 Table and Sem2 Table on both Name and Subject, I wasted my time on this, so sharing.

I have never ever commented on any of the RUclips videos but this video made me. Thank you so much for this apt knowledge share!

It's so awesome! Thanks

This is the best DAX tutorial I've watched in youtube! amazing job!

just amazing!! you got new subscriber today

Thanks so much for this content. I hope there more on to come. You have boosted my self-learning Data science journey . I really appreciate ❤️❤️. Please drop more and details ones as this.

whats ur linkedin ?

Hi , I can't connect to your server in Microsoft SQL Studio. Is it still possible to connect? I like this project and would to train on it also. why does this error appear?

@Pivotalstats, where are you most available to pick 1-1 queries?

I just found your channel today and sir you are absolutely doing a fantastic job. I am planning to make a switch into data analysis role and I had faced this date conversion error. Will surely try if these steps helps! Subscribed ❤

Is big query free or should pay?

awesome

Can anyone provide the link of mapping data

thank you very much, this helped my project a lot.

Thanks! For this tutorial. I Requested to you pls bring more videos like this dashboard.

Nice

SUM is syntax sugar for SUMX.

#1 Best Content on DAX over RUclips @Pivotalstats

Hi, the dashboard and the entire video was excellent. I learned a lot of new things. But I didn't understand the data. can anybody please explain to me what the data actually means? What are time bands? what is total here, does it mean the number of days waited? what are the archive dates?

Its highly encouraging for a beginner !

i think there is a reverse function in postgresql.

awesome explanation

Until 29 minutes of video, it was working fine, But whenvideo is at 29mins + some seconds it is showing blurred video, its foggy, its not showing the screen of the powerbi video, Why like that. After refeshing the browser, the youtube window went into default mode, it is clearly visible now. I got it, When I the youtube video in full screen mode its blurry, I figured it out that when the youtube video is in default view then it is clear. Thanks

Thank you. This was really helpful.

Well explained, thanks

16:52 i stucked here in sql workbench it shows error (1064) please help me to resolve it

Thanks. Nicely explained. Very useful video for the beginners.

Good one

❤

I dont see the link for the Specialty and Specialty Group documents

Oh Great Tutorial For PowerBI Students. But i have problems to typing the Formulas, if any videos Regarding PowerBI formulas. I will be grateful. Thanks

Hi, thank you again for the great video. In my work, after creating the reference table ("Mapping age group"), in model view there is no connection between Via Age. Don't know why? I followed the exact path and rechecked. PS: I manually made a connection between them in model view, now I am getting correct results. This isn't incorrect, right?

Great Video!! Loved creating this dashboard along with the video. Just one doubt, I'm not able to sort the x-axis in bar diagram, the time band is not getting sorted on the x-axis of that bar diagram as you've shown in the report. I tried creating a new index column where i calculated the values as if timeband "0-3",1, if timeband "3-6",2...."7". But it is throwing circular dependency error while sorting the timeband column with this newly created index column. Could you/someone please share how can we sort the axis properly?

Great video. very detail and straight to the point. Love it. Except for the background music. Can do without it? Its a little distracting.

Really great explanation

Hi, thank you for sharing this awesome project! I am unable to load the data to Jupyter notebook at ML step. Got this PermissionError: PermissionError: [Errno 13] Permission denied:'C:\\Users\\Home\\iCloudDrive\\Documents\\coding_temple\\projects\\customer_churn' Do you know what's wrong with this?

It is really very good project implementation. End to End.

Good presentation, very clear and easy to understand. Thankyou

Thank you so much for just explaining the topics in a concise manner! :)

There are blanks in Speciality Name, how to check them

EDate returns only a date why are you treating as its return month

Thanks