Predictive Analytics Guide For Excel Data Analysts

Подписаться 74 тыс.

Просмотров 45 тыс.

0% 0

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.
☕ If you found this content useful and would like to support the channel, you can buy me a coffee: www.buymeacoffee.com/DaveOnData
★★★ My online data analysis courses ▶ school.daveondata.com
-----------------------------------------------------------------------------------------------------------------------
Video Resources
-----------------------------------------------------------------------------------------------------------------------
👉 Learn the mighty process behavior chart:
📺 • Introduction to Busine...
👉 Learn linear regression analysis (NOTE - Not one of my videos):
📺 • Multiple Regression in...
👉 Learn market basket analysis:
📺 • Market Basket Analysis...
👉 Learn Naive Bayes:
📺 • Naive Bayes Classifier...
👉 Learn logistic regression analysis (NOTE - Not one of my videos):
📺 • Logistic Regression fo...
Stay healthy and happy data sleuthing!
#ExcelDataAnalyst #PredictiveAnalyticsWithExcel #PredictiveAnalytics

Наука

Опубликовано:

15 авг 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 41

@DaveOnData 2 года назад

👉 Learn the mighty process behavior chart: 📺 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xIXymabyFIM.html

@carlosbaptista7512 Год назад

Hi David, thanks for sharing your knowledge.

@hari1111 Год назад

David this is AMAZING!

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

@laxmanrao4554 Год назад

Thank you for the video.

@analyst2901 2 года назад

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

@PlotlinesRemix 2 года назад

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!

@charlesphillips9678 2 года назад

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

@HellenofTroy897 2 года назад

Great video. Will follow your advice to a T.

@sofiabotero4666 11 месяцев назад

very well explained 👍

@guitargimp 2 года назад

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

@DaveOnData 2 года назад

Thank you for taking the time to make the request!

@vijaykrishna6499 9 месяцев назад

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.

@colewalker1837 2 года назад

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 2 года назад

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

@KP-ky1sn 2 года назад

Great presentation. good speed.Easy to follow.

@michaelt312 5 месяцев назад

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 5 месяцев назад

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

@michaelt312 5 месяцев назад

@@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 5 месяцев назад

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

@zeynepaydemir2710 4 месяца назад

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 4 месяца назад

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

@minhthuchaungoc1591 2 года назад

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

@DaveOnData 2 года назад

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

@tanyataneja5901 Год назад

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

@jakeporteza Год назад

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

@byronexaporriton318 2 года назад

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

@DaveOnData 2 года назад

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 2 года назад

@@DaveOnData Looking forward to it!

@hmhkh 2 года назад

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

@smallfry7304 2 года назад

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 2 года назад

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

@smallfry7304 2 года назад

@@DaveOnData thank you!

@smallfry7304 2 года назад

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

@eu2day658 4 месяца назад

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 4 месяца назад

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.