Predictive Analytics Guide For Excel Data Analysts

This predictive analytics guide for Excel data analysts is designed for ANY professional in up-level their Excel data analysis game. In this video I discuss 5 predictive analytics techniques accessible to any motivated Excel data analyst.

-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
👉 Learn the mighty process behavior chart:

👉 Learn linear regression analysis (NOTE - Not one of my videos):

👉 Learn market basket analysis:

👉 Learn Naive Bayes:

👉 Learn logistic regression analysis (NOTE - Not one of my videos):

Stay healthy and happy data sleuthing!

#ExcelDataAnalyst #PredictiveAnalyticsWithExcel #PredictiveAnalytics

[DaveOnData]

👉 Learn the mighty process behavior chart:

[marianarossicampos]

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

[michaelt]

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.

[guitargimp]

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

[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!

[colewalker]

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.

[vijaykrishna]

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.

[zeynepaydemir]

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!

[carlosbaptista]

Hi David, thanks for sharing your knowledge.

[charlesphillips]

'Thank You' thank you very much 😉I'm looking for ADD Predictive Analysis to my tool belt 😉

[predictiveanalyst]

Spreadsheets can do a lot though there’s a reason Python is needed. Nice video

[HellenofTroy]

Great video. Will follow your advice to a T.

[byronexaporriton]

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

[jakeporteza]

I learned more from your explanation than going through youtube. Can you take me as your student?

[tanyataneja]

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

[minhthuchaungoc]

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

[KP-kysn]

Great presentation. good speed.Easy to follow.

[euday]

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?

[smallfry]

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?

[mmal]

Smoking weed with this guy would be tremendous, think of all the rabbit holes you can go down. 😃