Data Analytics

9,000.00

Course: Data Analytics
Faculty: Various Professionals
Course Duration: 125+ Hours

Category:

Data analytics involves the systematic computational analysis of data, enabling individuals and organizations to gain insights, make informed decisions, and drive strategic actions. By interpreting complex data sets, data analytics uncovers patterns, trends, and relationships, helping in predictive analysis and enhancing overall decision-making.

What will you learn?

  • MS Excel:
    Master the essential spreadsheet program for saving and analyzing numerical data efficiently.
  • MS Office:
    Gain proficiency in a powerful suite of productivity tools, including Word, Excel, PowerPoint and Outlook to facilitate effective office tasks and communication.
  • G Suite (Google Workspace):
    Learn to leverage cloud-based tools like Google Drive, Docs, Sheets, Slides and Meet for collaboration and productivity in a digital workspace.
  • SQL:
    Understand how to manage and manipulate relational databases using Structured Query Language (SQL) to query and manage data effectively.
  • Power BI:
    Explore Microsoft’s business analytics tool to create interactive reports and dashboards, enabling you to visualize data insights and make data-driven decisions.
  • Python:
    Discover the versatility of Python for data analysis, web development, and more, leveraging its readability and extensive libraries to solve complex data challenges.
  • R Programming:
    Utilize R for statistical computing and data analysis, gaining skills in statistical modelling, visualization and manipulation of complex datasets.
  • Machine Learning:
    Delve into the fundamentals of machine learning, training algorithms to recognize patterns and make predictions based on data.
  • VBA:
    Learn how to automate tasks and customize applications in Microsoft Office using Visual Basic for Applications, enhancing productivity through macros and custom functions.
  • Financial Modelling:
    Master the process of creating financial models using spreadsheets to forecast performance, analyze statements and assess business scenarios.

 

WHAT YOU WILL GET

Course Deliverables

gold medal
Recorded lectures
gold medal
Downloadable resources
gold medal
Videos accessible on any one Windows, MacBook, iOS, Android
gold medal
Certifications on course completion
gold medal
125+ hours of course content
gold medal
15 months validity


FACULTY

Meet The Instructor


Shivangee Agarwal is a Qualified Actuary with a Master’s in Data and Business Analytics from IIM Indore. She secured All India Rank 1 in CT7 – Business Economics and holds a B.Com (Hons in Finance) from St. Xavier’s College, Kolkata. Over 6+ years, she has taught 2500+ students in Actuarial and Data Analytics domain, becoming a favourite coach for CS2, CB2, CP2, and CP3 papers. She has expertise in Excel and R Programming. Her inspiring journey led her to conduct workshops and lectures at various colleges like Lady Shri Ram College, St. Xavier’s College, SRCC, Mithibai College, IIM Indore and IBS Hyderabad.

Vivek Patwari is a Qualified Chartered Accountant (CA) and Company Secretary (CS) with a Master’s in Commerce and has cleared SET and UGC NET in Commerce with a 98.37 percentile. Known for his jolly approach, he has mentored 7000+ students in ACET, CA, CS, CMA, B.Com, and BBA. Currently a professor at Bhawanipur College, he specialises in Mathematics and Taxation. As Eastern India’s first Google Certified Trainer, he is famous for his innovative calculator secrets. An author of 7 books, he has conducted successful Olympiads and seminars in Accountancy, Management, and Mathematics, and is also a motivational speaker.

Prachi Patwari is an MBA from NMIMS, Mumbai, with over 12 years of experience in Capital Markets. She has worked as a Senior Equity Advisor at Motilal Oswal and Edelweiss and has been an Authorized Business Partner of Motilal Oswal Financial Services since 2018. Prachi is also empanelled with AMFI and IRDA for providing consultancy and distribution services for structured financial products. Her programming journey began with Python and C++, where she developed skills in creating robust and scalable solutions. From automation scripts to data analysis, she has contributed to projects requiring a deep understanding of technology and strategic problem-solving. Prachi holds certifications in Stock Market Securities Operations and Risk Management, Equity Derivatives, Currency Derivatives, and Portfolio Management. In addition to her industry expertise, she also teaches ACET, sharing her knowledge and experience to help students excel in their exams.

Co-Founder of Actuators, Praveen Sancheti is qualified Chartered Accountant (AIR 11 and AIR 15) with a stellar record of academic success, having conquered 14/15 Actuarial papers with AIR 1 in 4 sittings. Besides a rich background in Investment Banking and Investment Management spanning over 5 years, Praveen’s passion for teaching since childhood led him to co-found Actuators in 2015. Praveen spearheads the teaching of CP1, one of the lengthiest papers in the Actuarial curriculum, delivering complex concepts in a simple and effective manner that resonates with students, particularly those who are balancing work commitments. In addition to CP1, Praveen covers the fundamentals of finance in papers like CB1, bringing practical industry experience into the classroom.

Praveen also serves as a mentor to aspiring professionals. Determined to motivate and support the upcoming generation of Actuarial and Finance experts, Praveen aims to create a lasting impact through knowledge and mentorship.

Vandita Sarda is a qualified Chartered Accountant and Actuary, with All India Rank 1 in 4 papers. A graduate from St. Xaviers’ College, Kolkata, she has 3 years of experience in mentoring students across actuarial papers. Her problem solving and interpersonal skills ensure that students get an in depth yet simple understanding of the concepts.

PLAYLIST

Demo Class Videos