Business Analytics with Excel | Data Science Tutorial | Simplilearn
August 26, 2024 2024-08-26 20:57Business Analytics with Excel | Data Science Tutorial | Simplilearn
🔥 Caltech Post Graduate Program In Data Science: https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥IIT Kanpur Professional Certificate Course In Data Science (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-science?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥 Data Science Bootcamp (US Only): https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=DescriptionFirstFold&utm_source=youtube
🔥Data Scientist Masters Program (Discount Code – YTBE15): https://www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=DescriptionFirstFold&utm_source=youtube
Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. The topics covered in this video are:
Introduction 00:00:00
Formatting and Functions 00:05:42
Lookup Functions 00:22:57
Statistical Functions 00:34:02
Who Is A Business Analyst?
A business analyst understands the business problems and identifies the solutions that will maximize the organization’s value to its stakeholders. A business analyst is an individual who works closely with the technology team to improve the quality of the services being delivered. To become a business analyst you need to ensure the customer needs are correctly interpreted and translated into application. Another key factor in knowing how to become a business analyst is possessing skills like Excel, SQL, and business intelligence skills to deliver data-driven solutions.
#Simplilearn #SimplilearnCourses #OnlineTraining #DataScience #Simplilearn #datasciencewithpython #DataScienceTraining #UpskillingSuccessStories #simplilearn
➡️ About Caltech Post Graduate Program In Data Science
This Post Graduation in Data Science leverages the superiority of Caltech’s academic eminence. The Data Science program covers critical Data Science topics like Python programming, R programming, Machine Learning, Deep Learning, and Data Visualization tools through an interactive learning model with live sessions by global practitioners and practical labs.
✅ Key Features
– Simplilearn’s JobAssist helps you get noticed by top hiring companies
– Caltech PG program in Data Science completion certificate
– Earn up to 14 CEUs from Caltech CTME
– Masterclasses delivered by distinguished Caltech faculty and IBM experts
– Caltech CTME Circle membership
– Online convocation by Caltech CTME Program Director
– IBM certificates for IBM courses
– Access to hackathons and Ask Me Anything sessions from IBM
– 25+ hands-on projects from the likes of Amazon, Walmart, Uber, and many more
– Seamless access to integrated labs
– Capstone projects in 3 domains
– Simplilearn’s Career Assistance to help you get noticed by top hiring companies
– 8X higher interaction in live online classes by industry experts
✅ Skills Covered
– Exploratory Data Analysis
– Descriptive Statistics
– Inferential Statistics
– Model Building and Fine Tuning
– Supervised and Unsupervised Learning
– Ensemble Learning
– Deep Learning
– Data Visualization
🔥 Enroll for FREE Business Analytics Course & Get your Completion Certificate: https://www.simplilearn.com/cbap-basics-skillup?utm_campaign=BusinessAnalysis&utm_medium=Description&utm_source=youtube
Learn more at: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=Description&utm_source=youtube
🔥🔥 Interested in Attending Live Classes? Call Us: IN – 18002127688 / US – +18445327688
source
Comments (38)
@SimplilearnOfficial
🔥 Post Graduate Program In Business Analysis: https://www.simplilearn.com/pgp-data-analytics-certification-training-course?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=Comment&utm_source=youtube
🔥Business Analyst Program (Discount Coupon: YTBE15) : https://www.simplilearn.com/business-analyst-certification-training-course?utm_campaign=BusinessAnalysis-W3vrMSah3rc&utm_medium=Comment&utm_source=youtube
@DanAlvard
Do you have a Test Data used in this video for download?
@sbidikar
can you possibly also include a sample dataset that is being used in the video or just any sample having similar details for anyone to practice while going through the video?
@user-God-s-child-0101
Our most beloved godfather Shivbaba bless you always
@user-qk1wk7rn2e
hello, where did you get the sample data?
@opeyemiajayi1164
This is a very nice course, I enjoy it. Can you please provide us with the dataset used in the course #simplilearn @simplolearn
@robertoguzman6347
Hello. Is there any chance to get the excel sample files to complete de excercises? Thank you in advance.
@Dydgl
How can I get the master dataset used in it .
@kumarankit8503
@simplelearn where is the dataset link
@anamitraghosh6737
Helpful for beginners
@ManishKumar-ym9uk
where the data can download
@zuko803
18:46 I already tried that but the cells which became green was randomly not =if 4000 value, how to fix?
@sunnysharma4753
Mam which stream is required to become business analyst
@harunainuwa9463
Please can you forward this set of data to me via diamondmuhd@yahoo.com? I appreciate you a lot. Thanks for the insightful videos. Regards.
@footballmaniacs390
VERY HELPFUL!! KEEP UP THE GOOD WORK! THANKS
@ghislainniyongabo986
Hello team Simplilearn. I have enjoyed this tutorial and I would like to get the sample data sheets to practice.
My email: mugishaghislain1992@gmail.com
@NinaC
What is the purpose of adding $ to some of the cells? Like I notice for example cell H4 some formulas use $H$4? (Or something like that)
@captainayaan
Thank you!
@nameetmankar9806
Atleast give the link of data set for practicing above tutorial
@mosessire5765
Where can I get the dataset to follow along?
@AbcDef-ei6oc
Much better if u could provide the worksheet u use for us to practice
@cottondai
This is great course on excel for business analyst. Thank you.
@bboysaolee
Thanks for the great tutorial. Very useful!
The clicking sounds and the repetition of the each cell, comma, and value when doing formulas is a bit annoying in my opinion. But I get how it might be useful to some people, I guess.
Really nice tutorial either way!
@mynnacobaalts9658
Hoping to learn more of deep learning.
@jayantarianster
Why put up a course when you don't provide the dataset used in the video? Is it a bait to lure people into buying the course? In case you're unaware, there are better Excel data analysis courses available, that are more comprehensive and give away the used file for each topic.
@bhanusharma1442
I am a beginner in data science as well as excel so where should I start.
@imranwalli4806
you lost me after 28:00. I'm confused how you got those values.
@marceljurica6528
Hello. Really great video but I have a question about the Match function.I want to find the position of the date, let´s say 2-jan-12. As we see, the date 2-jan-12 is in the 3rd (19th of the sheet) row of the table. But i noticed, that it is also in the 208th row of the sheet, at 28:43. It´s a little bit confusing for me that the Match function choose only the first position in the 19th row, when obviously there is more than one date like that. Is it supposed to be like that and i just don´t understand? Thank you.
@somdebmazumder9407
good but too basics
@selimcanpolat8664
this video makes it seem like excel is the most powerful and efficient business tool out there, which is not true. there are at least four that i can state
@maometto6812
What is bi ppl?
@vikramnadal
Thanks a TON.. very Clear and easy to understand. Great video
@DiscoverTalent143
Keep doing great work guys
@brandonspiegel2293
thanks for the knowledge!
@TruthofDilly
You’re good , nice clean and clear, thanks
@anuraggarg5243
hey simplilearn can you please provide me with the link to download the excel file to practise the skills learned
@user-ys6pt3wn6t
Hi Simplilearn, I was wondering what the need for the '$' was in some equations and not others. I read an article saying it was for relative and absolute cell references, but even with the '$' it seemed to use the relative reference when filling the rest of the column.
@vinaywadhwa99
Simplilearn, can you please provide the link to other videos to complete this course. I can't find it on your channel.
Or this is enough for Analytics using Excel??