Predictive Analytics Guide For Excel Data Analysts

[@DaveOnData]

👉 Learn the mighty process behavior chart: 📺 kzbin.info/www/bejne/rnq7qqCXl955f68

[@michaelt312]

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.

[@DaveOnData]

I am so glad you have found my content useful! BTW - Two new "Python Crash Course" videos will be published tomorrow.

[@michaelt312]

@@DaveOnData, I'll be on them. Was starting T-SQL, but pausing for your videos and learning Python. Such a fantastic method of teaching.

[@DaveOnData]

Wow! Thank you so much for the kind words. Much appreciated.

[@itsrajaz]

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!

[@DaveOnData]

Excellent! I hope you continue to find my KZbin content useful in your new role.

[@PlotlinesRemix]

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!

[@marianarossicampos6263]

I love you, man! Not only is the content fantastic, but you are also an absolutely great communicator.

[@DaveOnData]

@marianarossicampos6263 - Thank you so much for the kind words! I'm so glad you are finding my content useful.

[@guitargimp]

Great introduction, and I think a separate video on time series forecasting would be a good addition to this video. Many thanks!

[@DaveOnData]

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!

[@colewalker1837]

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.

[@DaveOnData]

Thank you for taking the time to comment and look out for time series forecasting to be in the content rotation soon!

[@carlosbaptista7512]

Hi David, thanks for sharing your knowledge.

[@charlesphillips9678]

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

[@laxmanrao4554]

Thank you for the video.

[@HellenofTroy897]

Great video. Will follow your advice to a T.

[@byronexaporriton318]

Time series forecasting and forecasting using the Facebook Prophet algorithm would be a great video to watch!!!

[@DaveOnData]

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.

[@byronexaporriton318]

@@DaveOnData Looking forward to it!

[@hmhkh]

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

[@analyst2901]

You are awesome... thx so much!!!

[@sofiabotero4666]

very well explained 👍

[@predictiveanalyst]

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.

[@tanyataneja5901]

Thanks for the informative video but my data has too many products so this would be long task in excel

[@minhthuchaungoc1591]

Thank you so much. Your content is really well-structured and informative. I have learned a lot from your channel. Keep going!

[@DaveOnData]

Thank you for the feedback and glad you found my content useful!

[@eu2day658]

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?

[@DaveOnData]

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

Great presentation. good speed.Easy to follow.

[@smallfry7304]

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?

[@DaveOnData]

I've never used Google Sheets, but in Excel this is easy enough to do: =FIND($B$1, A2, 1)

[@smallfry7304]

​@@DaveOnData thank you!

[@smallfry7304]

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

[@alejandrog5902]

I did not see any tools been used. This is cap

[@apsuthar6460]

doctor Jhaatuke...

[@buddiemcgee2673]

far too much waffling for me.