Predictive Analytics Guide For Excel Data Analysts
HTML-код
- Опубликовано: 29 сен 2024
- 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.buymeacoff...
★★★ My online data analysis courses ▶ school.daveond...
-----------------------------------------------------------------------------------------------------------------------
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
👉 Learn the mighty process behavior chart:
📺 ruclips.net/video/xIXymabyFIM/видео.html
Great introduction, and I think a separate video on time series forecasting would be a good addition to this video. Many thanks!
Thank you for taking the time to make the request!
I did not see any tools been used. This is cap
doctor Jhaatuke...
I love you, man! Not only is the content fantastic, but you are also an absolutely great communicator.
@marianarossicampos6263 - Thank you so much for the kind words! I'm so glad you are finding my content useful.
'Thank You' thank you very much 😉I'm looking for ADD Predictive Analysis to my tool belt 😉
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!
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?
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.
Time series forecasting and forecasting using the Facebook Prophet algorithm would be a great video to watch!!!
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.
@@DaveOnData Looking forward to it!
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
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.
Thank you for taking the time to comment and look out for time series forecasting to be in the content rotation soon!
Hi David, thanks for sharing your knowledge.
Thanks for the informative video but my data has too many products so this would be long task in excel
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.
I am so glad you have found my content useful!
BTW - Two new "Python Crash Course" videos will be published tomorrow.
@@DaveOnData, I'll be on them. Was starting T-SQL, but pausing for your videos and learning Python. Such a fantastic method of teaching.
Wow! Thank you so much for the kind words. Much appreciated.
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!
Excellent! I hope you continue to find my RUclips content useful in your new role.
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?
I've never used Google Sheets, but in Excel this is easy enough to do:
=FIND($B$1, A2, 1)
@@DaveOnData thank you!
@@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.
Great video. Will follow your advice to a T.
Spreadsheets can do a lot though there’s a reason Python is needed. Nice video
You are awesome... thx so much!!!
Thank you for the video.
Thank you so much for this....
You are most welcome! Glad you enjoyed the video.
David this is AMAZING!
Smoking weed with this guy would be tremendous, think of all the rabbit holes you can go down. 😃
I learned more from your explanation than going through youtube. Can you take me as your student?
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.
very well explained 👍
Thank you so much. Your content is really well-structured and informative. I have learned a lot from your channel. Keep going!
Thank you for the feedback and glad you found my content useful!
Great presentation. good speed.Easy to follow.
far too much waffling for me.