👉 Learn the mighty process behavior chart: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68
@michaelt3129 ай бұрын
I am so glad I found your channel. I've been in Healthcare Finance for the last 10 years. Both Finance and Revenue Cycle. I've been pushed towards analytics and am mostly self taught by trial and error or internet research. Your way of explaining is perfect.
@DaveOnData9 ай бұрын
I am so glad you have found my content useful! BTW - Two new "Python Crash Course" videos will be published tomorrow.
@michaelt3129 ай бұрын
@@DaveOnData, I'll be on them. Was starting T-SQL, but pausing for your videos and learning Python. Such a fantastic method of teaching.
@DaveOnData9 ай бұрын
Wow! Thank you so much for the kind words. Much appreciated.
@itsrajaz8 ай бұрын
Hi David, I am thrilled to find your channel! I switched departments to begin data analysis (I'm in digital marketing) but it turns out nobody would help me and other departments had no idea about what to analyze (oops), I've been freaking out because I only know basic concepts like forecasting, basic regression and some optimization models. This is a great roadmap!
@DaveOnData8 ай бұрын
Excellent! I hope you continue to find my KZbin content useful in your new role.
@PlotlinesRemix2 жыл бұрын
I love that you are generalizing Market Basket Analysis as a lift calculator. I took a data mining course and they did not help me think more creatively about use cases for this technique. In fact I ended up "uncovering" an informal but known product bundle. Whoops!
@marianarossicampos62635 ай бұрын
I love you, man! Not only is the content fantastic, but you are also an absolutely great communicator.
@DaveOnData5 ай бұрын
@marianarossicampos6263 - Thank you so much for the kind words! I'm so glad you are finding my content useful.
@guitargimp3 жыл бұрын
Great introduction, and I think a separate video on time series forecasting would be a good addition to this video. Many thanks!
@DaveOnData3 жыл бұрын
Thank you for taking the time to make the request!
@vijaykrishna6499 Жыл бұрын
time series forecasting video using commercial merchant shipping as an example [ fuel consumption basis speed and spare parts consumption basis running hours] will be an icing on the cake.
@hari1111 Жыл бұрын
David this is AMAZING!
@colewalker18373 жыл бұрын
Time Series Analysis in excel would be a good video. Thanks. You have a very calm demeanor, and do a great job of making the content easy to approach.
@DaveOnData3 жыл бұрын
Thank you for taking the time to comment and look out for time series forecasting to be in the content rotation soon!
@carlosbaptista75122 жыл бұрын
Hi David, thanks for sharing your knowledge.
@charlesphillips96782 жыл бұрын
'Thank You' thank you very much 😉I'm looking for ADD Predictive Analysis to my tool belt 😉
@jakeporteza Жыл бұрын
I learned more from your explanation than going through youtube. Can you take me as your student?
@laxmanrao45542 жыл бұрын
Thank you for the video.
@HellenofTroy8972 жыл бұрын
Great video. Will follow your advice to a T.
@byronexaporriton3183 жыл бұрын
Time series forecasting and forecasting using the Facebook Prophet algorithm would be a great video to watch!!!
@DaveOnData3 жыл бұрын
Yeah, that would be cool! I might think about doing that in a R video as it really isn't a great fit for Excel.
@byronexaporriton3183 жыл бұрын
@@DaveOnData Looking forward to it!
@hmhkh2 жыл бұрын
This is what I was looking for to understand the concept of Predictive Analytics, definitely would like to learn about time series as the third predictive family concept
@analyst29012 жыл бұрын
You are awesome... thx so much!!!
@sofiabotero4666 Жыл бұрын
very well explained 👍
@predictiveanalyst2 ай бұрын
Spreadsheets can do a lot though there’s a reason Python is needed. Nice video
@eternaltajaliАй бұрын
Thank you so much for this....
@DaveOnDataАй бұрын
You are most welcome! Glad you enjoyed the video.
@tanyataneja59012 жыл бұрын
Thanks for the informative video but my data has too many products so this would be long task in excel
@minhthuchaungoc15913 жыл бұрын
Thank you so much. Your content is really well-structured and informative. I have learned a lot from your channel. Keep going!
@DaveOnData3 жыл бұрын
Thank you for the feedback and glad you found my content useful!
@eu2day6588 ай бұрын
Hi Dave, I am currently a teacher. I'm working diligently to leave the education field to work in the field of analytics. I am currently working on my Master's Degree in Business Analytics. Unfortunately, every course is virtually self-taught. Therefore, I'm struggling in multiple areas. What can I do to have you tutor me in the analytical arena?
@DaveOnData8 ай бұрын
I'm sorry that online/virtual courses are not working for you. Unfortunately, I do not have time available in my schedule for 1-on-1 tutoring. Apologies.
@KP-ky1sn2 жыл бұрын
Great presentation. good speed.Easy to follow.
@smallfry73043 жыл бұрын
I have a question, I'm using Google sheets instead of Excel but I heard most of the syntax is the same: I have this formula =FIND(B1, A2, 1) pasted in each cell of an entire column When I paste it in each, it automatically adjusts the A2 to be the cell next to where I'm putting the function. However, it also changes B1 depending on which cell I paste the function in. Is there a way for me to prevent it from changing the B1 value, so it stays B1 no matter which cell I paste it in?
@DaveOnData3 жыл бұрын
I've never used Google Sheets, but in Excel this is easy enough to do: =FIND($B$1, A2, 1)
@smallfry73043 жыл бұрын
@@DaveOnData thank you!
@smallfry73043 жыл бұрын
@@DaveOnData thank you! i played around with it cuz its not the exact same as you said in google sheets. Instead you have to do $A$1 to lock the column and the row, or you can do $A1 or A$1 to lock just the column or just the row. I'm just saying incase someone else reading this needs to know.
@mma4l Жыл бұрын
Smoking weed with this guy would be tremendous, think of all the rabbit holes you can go down. 😃