👩🔬👨🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68
@andrewdove3427 ай бұрын
working with data is like taking your brain to the gym, feels good!
@DaveOnData7 ай бұрын
Indeed! It's one of the reasons I enjoy analytics so much.
@CzechCzar Жыл бұрын
Incredibly useful. I am currently learning Excel PowerQuery for analytics at my job, and this provided a really great explanation
@shanabenjamin89456 ай бұрын
Thanks! You clarified the issues I had!❤
@DaveOnData6 ай бұрын
Yay! I am happy to hear that you found the video useful.
@statistikochspss-hjalpen8335 Жыл бұрын
11:00 Does the order matter? Why does the Alice Leader condition need to come first?
@CDDCDj3 жыл бұрын
Great video. Sorry for going out of topic, do you know how to make a desktop direct access icon for an app in r? Thanks for sharing your knowledge.
@DaveOnData3 жыл бұрын
Could you elaborate by what you mean about "an app in R?" Do you mean, for example, a Shiny app or something else?
@CDDCDj3 жыл бұрын
@@DaveOnData I've developed a ShinyApp. Nevertheless, I would like to share it like a .exe file.
@jbj9262 жыл бұрын
Is this video along the lines of data mining in the sense that titles with similar characteristics are grouped together?
@ickorling73283 жыл бұрын
Dude, nice! The relation to higher level structure and planning of the data base filtering anomolies-- that part. Helped me realize there's more... flexible method of outputting even simple data charts in lieu of shoddy pivots and manual lookup formulas. Can that power query thing compile into SQL automatically with Table names used through out in excel?
@davebennett75503 жыл бұрын
Nice video. I haven’t really bothered with power query as I didn’t know that it could do this stuff. I’ve been doing the same sort of categorisation by adding calculated columns in the power pivot model. If you build a separate lookup table in the power pivot model (in your example it would contain two columns: Value and Output) and then add a calculated column to your main table with a formula which uses the DAX CALCULATE(FIRSTNONBLANK…(FILTER sequence. This works like a Select statement in SQL with a join to another table, or explained in excel terms it’s a super lookup function which allows you to look up on as many criteria as you want. Advantages are that this is easy to understand what the criteria are by viewing the lookup table. Also, it’s easily expandable to more criteria and using multiple lookup tables. Dax is weird to learn (coming from either an excel or sql background) but very useful for this type of data manipulation when you want to keep everything in an excel environment.
@DaveOnData3 жыл бұрын
Thank you for taking the time to provide such a thorough comment! Personally, I've never used DAX as PQ, SQL, and R have given me everything I need. However, I've been told by many that DAX is super useful.
@joeltochukwu41992 жыл бұрын
@@DaveOnData True, so many tools out there that there is a cap to what someone can learn.
@garciarogerio63272 жыл бұрын
So far very good. Looks similar to the Query editor of Power Bi
@AkshayA-kj4zk6 ай бұрын
hi, actually i have a doubt while in conditional column i am not able to fetch the suitable column under column name. can u please provide solution for this.
@AlterAgs2 жыл бұрын
I love your tuts
@paulfarmer73938 ай бұрын
Enjoying your content a lot . You should point out in video that you couldn’t use the age column to determine adultness because in prior video you commented age field has a lot of missing records . Age would have been more natural field to use and wouldn’t required complex conditional logic to group adultness and sex together and then you could have avoided logic required to deal with female doctor ( this complex conditional logic will also make queries run slower if you were dealing with massive dataset) but in this case would not have given as wide a statistical coverage in determining if that data dimension has explanatory power. Important to note i feel if you have just watched this video in isolation , you would be left wondering as to why you went this more complex way of using title to infer adultness.
@DaveOnData8 ай бұрын
Thank you for the feedback! I am happy to hear you are enjoying my videos.
@ajinkyatrimukhe3 жыл бұрын
Thank you.
@DaveOnData3 жыл бұрын
You are welcome and hope you found the content useful!
@ajinkyatrimukhe3 жыл бұрын
@@DaveOnData Yes Sir, this is so useful, and your teaching makes it easily understandable.
@DaveOnData3 жыл бұрын
@@ajinkyatrimukhe - Excellent!
@learnwithrahul8083 жыл бұрын
Nice video
@DaveOnData3 жыл бұрын
Thank you for the kind words, very much appreciated!