Beautifully explained. Thank you.

This video explains best how/why to remove NAs!

When you created the parameter

Thank you Sir

This video is brilliant! Could you please make more tutorials on DAX and analyzing performance implications using DAX Studio?

Very useful

Would you recommend also comparing the mean of the cholesterol variable from the initial data set vs. the imputation through the mice method to choose the best imputed dataset (like you did with BMI at 18:00)? I was wondering if it's safe to assume that imputation 5 would be the best option for cholesterol as well as BMI. If not, then could you mix imputations like #3 for cholesterol and #5 for bmi?

but the update will keep updating all the records rite whether there is any modification or not ?

why do none of these videos EVER explain how to appropriately handle missing values? i know how to find missing values, i know how to coutn them, i know how to impute them or remove them. whats NEVER explained is how to handle them APPROPRIATELY. its so fucking infuriating

please, how can I solve this error." iter imp variable 1 1 df.IN_Ratio df.APTT_Ratio df.Clauss_Fibrnogen_level df.D_Dimer_Level df.Serum_UreaError in solve.default(xtx + diag(pen)) : system is computationally singular: reciprocal condition number = 8.02788e-23

what if you have over 50000 variables? when i try to use these functions such its not possible to call out a specific variable

the jeet imputatoor

i have done the update in OLEDB task to make isDeleted=1 where PrimaryKeyColumn=? even i did not delete any record in source table, all the values of isdeleted column in destination as marked as 1

Thanks for the video it helped me. I have bit different situation here as I have 2 inputs (Raw data and mapping file in which I used file browse tool ) and the output file (used file browse tool). Now I have to use the output file(coz there is some manual intervention is required in the data) as input data in next step and the final output should arrive but in user interface it is asking all 5 inputs in one go (Raw data, Mapping file, Output data path, Input the output file again, and the consolidated output. I am not able to achieve this in alteryx. Can you please help. Looking forward to hear from you.

Nice info. But I am stuck in one of my development where I am using summarizecolumn in a measure but the total value is incorrect .. Can you help me with that

How can i fix this when my source an ODBC is? My Target table is an OLED DB Destination. But when i want to look backup to my source i cant use the lookup functionallity.

Thank you, very well explained. Appreciate it

Top tier explaining

please do more videos in DAX, Thanks

Thank you for the video.

Thanks for the explaining the difference. I have sued the summarised function in the same way you used but my grand total is not correct ? Any guidance would really help

I want to apply the selection value in drop down or radio button that user can choose filterization by male or female how do I do this can you tell the which one I drag from interface

What program did you use to draw the flow chart?

How can fetch tables from website has credentials, give error?

Such a great and clear video! I watched so many videos but couldn't find something which clearly explains linear and multiple regression on R so clearly. Thanks a lot!

hahaha the windows sound at 5:52 scared me!! well explained video though thank you

Please put a video on : How do we add parameter for the ADO source, like using variables to filter the records. select * from table1 where date > ? I am connecting to a DB2 source and retrieving data, it already got 20million records on it, i just what to upload it incrementally on last modified date. need to query the DB2 using the date modified.

Thanks for sharing.

Thank you so much! Very well explained.👍

bro why is the data partitioned and a testing data set is created ? @DataExplained

How to if i use ODBC Destination pls?

Thank you for you simple instructions!

Thanks for the explanation, it was really helpful ☺️

Very good explanation> Thank you very much.

I am trying to create a user input to a workflow -like inputting a account# and for it to run only for that account #. is this possible?

is Filter the only place we can add this?

great video. thank you very much.

Do you know from which author this multiple imputation is? I have to cite the method used in my article.,

why there is no adventurework db in my server?

Hi Sir, thank you for your tutorial. I did data imputation on my small size(n=46) dataset and now need to do exact logistic regression by "elrm" package of R studio. fof is my dependent binary variable, age is numeric and predictor, injuries is binary predictor, minutes and mental health are continious predictors, and race is categorical with three groups. But my code fails because it does not recognize one part "n". I searched in online examples, They did not mention what this n(number of binomial trials) is and how they added this column to their datset. my code: data.elrm <- elrm (fof /n ~ age+ injuries + minutes + mentalhealth + rece , interest = ~mental health, iter = 20000, burnIn = 500, Dataset = imp) Do you have any suggestions for me ?

Good explainer Re: using mice. However, in addition to @annap9782's comment, I'd also flag that finding that your imputed data is distributed similarly to the observed data is not a meaningful test of imputation performance. If we had a (conditionally) ignorable missigness mechanism (i.e., MAR), it may even be expected that these distributions will differ, without this saying anything about the performance of a given imputation.

Hey Senthil, I n getting this error message when I try any of the functions "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.". I m using the same database. Any suggestion please?

excellent video. easy to understand and follow

thank you for this tutorial video. It was really helpful. Is there any specific rule for the number of datasets( in your case:5) we choose?

Well done. A very simple case (those are the best for these kinds of instruction videos) that says in a concise way how to use this very powerful feature of Alteryx. The one thing I would have liked to see is how to configure the text box so only Male or Female (and maybe Other) is an allowable entry. These UI elements do typically need data validation. But great job. I am building an Alteryx workflow myself and adding a UI element similar to above, and you saved me a lot of research and looking around.

Great tutorial! Thank you!

Your video screen is not visible, could you please check it?

It doesn't seem too efficient to keep updating all rows... In source table you should have a column: RevisionDate and set a trigger on this to auto update. Then filter on this column.

Delete this video. You did not pass on any information. Next time uninstall the program and take newbies in a step by step guide. This video conveyed nothing

very informative, thanks for uploading !