Twenty19

Login or Create Your Twenty19 Account


New to Twenty19? No Worries. Register for free!

Data Analysis and Business Intelligence

Rs 3499 Flash sale

90%

21 Reviews

Every industry today requires the ability to perform data analysis to derive intelligent insights. As an early stage professional you will learn the right approach to Data Analysis problems, understand tools and methods, and get hands on experience through this course –with the “Real Life” picture always running in the background.

You will work end to end on the concepts of Data Collection, Analysis and Insights through one long case study in Excel. You will find in this course a health mix of concept slides, practice, quizzes, exercises and projects.

Whether you are a student trying to secure an Internship or Job across Sales, Marketing, Finance, Business Analysis or planning roles – or a professional already working – this course will provide you the tools to reach the next level in Data Analysis & Business Intelligence!

  • Learn Anytime/Anywhere
  • Clear your doubts
  • Project Based
  • Get Certificate

Buy "Data Analysis and Business Intelligence"

Rs 3499 Have a Coupon Code ? Click 'Pay Online' & login to apply coupon code

pay online

or

Pay by DD/Cheque

Call us on 09962033243 in case of any difficulties.

  • Step 1 Buy this course by making an online or an offline payment

  • Step 2 Access the course anytime, anywhere, learn, practice, evaluate, clear your doubts & track your progress

  • Step 3 Complete the course & get Twenty19 Certificate

Buy & Start Training or Free Demo

875 views
  1. Chapter 1

  2. Chapter 2

  3. Chapter 3

    • 3.1 - Understanding Primary Keys
    • 3.2 - Preparing the worksheet
    • Quiz 3
  4. Chapter 4

    • 4.1 - Customer Table - Introduction
    • 4.2 - Customer Table - Vlookup function
    • 4.3 - Product Table
    • 4.4 - Other Tables
    • 4.5 - Returns Table - IFERROR function
    • 4.6 - Returns Table - Switch parameter
    • 4.7 - Conclusion
    • Quiz 4
  5. Chapter 5

    • 5.1 - Recap & Exploratory analysis
    • 5.2 - Preparation for Exploratory analysis
  6. Chapter 6

    • 6.1 - Pivot Table
    • 6.2 - Profit computation
  7. Chapter 7

    • 7.1 - Hypothesis 2 Overall profitability
  8. Chapter 8

    • 8.1 - Hypothesis 3 Book cases
  9. Chapter 9

    • 9.1 - Sales growth computation
    • Quiz 5
  10. Chapter 10

    • 10.1 - Overview - High Level Explorations
    • 10.2 - Product Wise Exploration
    • 10.3 - Customer type wise exploration
  11. Chapter 11

    • 11.1 - Overview - Deep Dive Analysis
    • 11.2 - Product wise deep dive
    • 11.3 - Customer type wise - exercise
    • 11.4 - Customer type wise - solution
    • 11.5 - Corp Customers - exercise
    • 11.6 - Corp Customers - solution
    • 11.7 - Corp Customers - Tech - exercise
    • 11.8 - Corp Customers - Tech - solution
    • 11.9 - Corp Customers - office supplies - exercise
    • 11.10 - Corp Customers - office supplies - solution
    • Quiz 6
  12. Chapter 12

    • 12.1 - Project
    • 12.2 - Project charts
    • 12.3 - Thank you
  • About this Training

    In this course you will understand the importance of Data and how it is used in businesses. The course begins with the concepts data collection and data acquisition. The course then goes on to the exploratory analysis and high level explorations. Throughout the course you will find examples and cases based on Microsoft excel.

  • Project in this Training

    The project of the course deals with cases using microsoft excel.

  • Clear your Doubts

    You can ask all the questions in Clear your Doubts forum anytime, course experts will answer all your questions.

  • Get Certificate

    Receive an E-certificate from us once you complete the course. You can Download the Certificate from your Twenty19 account and also showcase it to your friends and family.

from where dataset is to be downloaded?

asked by SHUBHAMRAJ

There is an option called 'exercise files' on top right.click on that,it will download datasets required

answered by RahulK.R, 3 months ago. [ 15th - Jul, 2017 ]

Data set

asked by SurbhiKumari

There is an option called 'exercise files' on top right.click on that,it will download

answered by RahulK.R, 3 months ago. [ 15th - Jul, 2017 ]

2.2 and 2.3 are same!

asked by RahulK.R

No Answers yet

Can I download the videos & learn?

You can re-watch the videos as many times you wish but we do not allow downloading on our platform as we keep track of your progress in regards to the course you learn.

What is special about Twenty19 courses?

Twenty19 Training are fun to learn and they are structured to be easily understood by anyone.The courses are developed with College students in mind.So courses will have a lot of real world examples and Twenty19 courses are easy to take up and earn a certificate.

If I have any doubt while learning, How can I clear my doubts?

You can raise your doubt in Clear your doubts forum anytime, training experts will answer all your questions. You can also reach us at +91 9962033243 (give us a missed call), send an SMS or drop an email to trainins@twenty19.com, one of our team member will call you to support.

Is it safe to use my debit/credit card for making the payment?

No doubt, Your transaction is always safe and secure with Twenty19.

Do I get a certificate of completion?

Yes!! you will receive an E-certificate from us once you complete the training. You can include this is in your Resume to get placed better.

How will I receive the certificate?

Twenty19 certificates will be emailed to your Twenty19 registered Email ID .The very next day of your training completion you will be receiving the certificate.You can download and print your certificate.

Have Questions? Get in touch with us

Call
+91 9962033243

Email
trainings@twenty19.com

This is a Free Demo for "Data Analysis and Business Intelligence" Course

Experience this course with few video lessons rightaway!

Start Learning

Live Trainings Feed

Latest Questions in Forum

Suggest a new Training

Teach

Are you an expert in your industry & are passionate about teaching? Join us!

create a training


This feature is not available during Free Demo. Purchase the course to access

Purchase "Data Analysis and Business Intelligence"


Buy & Start Learning

Send me amazing internships by email

Confirmation email has been sent to your email address. Please click on "Confirm to get Internship alerts" button in the email.
Please provide a valid email address.
There were some issues. Please try again later.

Close