Find the best tutors and institutes for Data Analysis

Find Best Data Analysis Classes

Please select a Category.

Please select a Locality.

No matching category found.

No matching Locality found.

Outside India?

Search for topics

Data Analysis Updates

Ask a Question

Post a Lesson

All

All

Lessons

Discussion

Answered on 13 Mar IT Courses/Data Analysis

Sachin Talekar

Trainer

You need to have basic knowledge of Excel to do better analysis. And yes there is scope for data analysis in each and every sector.
Answers 7 Comments
Dislike Bookmark

Lesson Posted on 19 Feb IT Courses/SPSS Training Functional Training/Business Analysis Training IT Courses/Data Analysis

What Is SPSS Software (SPSS Data Analysis Tool) ?

Gaurav Mishra

I have enriched experience in online and classroom training of Statistical tools, Programming languages,...

SPSS is a Windows-based program that can be used to perform data entry and analysis and to create tables and graphs. SPSS is capable of handling large amounts of data and can perform all of the analyses covered in the text and much more. SPSS is a widely used program for statistical analysis in social... read more

SPSS is a Windows-based program that can be used to perform data entry and analysis and to create tables and graphs. SPSS is capable of handling large amounts of data and can perform all of the analyses covered in the text and much more.

SPSS is a widely used program for statistical analysis in social science. It is also used by market researchers, health researchers, survey companies, government, education researchers, marketing organizations, data miners, and others.

The Uses of SPSS Software. SPSS, which stands for a statistical package for the social sciences, is an application that can aid in quantitative data handling. Before SPSS, researchers had to run statistical tests on data sets by hand. However, SPSS automates this process.

i. Data Collection and Organization:

SPSS is often used as a data collection tool by researchers. The data entry screen in SPSS looks much like any other spreadsheet software. You can enter variables and quantitative data and save the file as a data file. Furthermore, you can organize your data in SPSS by assigning properties to different variables. For example, you can designate a variable as a nominal variable, and that information is stored in SPSS. The next time you access the data file, which could be weeks, months or even years, you'll be able to see exactly how your data is organized.

ii. Data Output:

Once data is collected and entered into the data sheet in SPSS, you can create an output file from the data. For example, you can create frequency distributions of your data to determine whether your data set is normally distributed. The frequency distribution is displayed in an output file. You can export items from the output file and place them into a research article you're writing. Therefore, instead of recreating a table or graph, you can take the table or graph directly from the data output file from SPSS.

iii. Statistical Tests:

The most obvious use for SPSS is to use the software to run statistical tests. SPSS has all of the most widely used statistical tests built-in to the software. Therefore, you won't have to do any mathematical equations by hand. Once you run a statistical test, all associated outputs are displayed in the data output file. You can also transform your data by performing advanced statistical transformations. This is especially useful for data that is not normally distributed.

read less
Comments
Dislike Bookmark

Lesson Posted on 03 Jan Financial Planning/Business Analytics Training IT Courses/Data Analysis Tuition/BTech Tuition/Big Data Analytics +1 IT Courses/MS Office Software Training less

Data Sorting In Excel

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest. To Sort the data follow the steps mentioned below: Select... read more

Sorting data in MS Excel rearranges the rows based on the contents of a particular column. You may want to sort a table to put names in alphabetical order. Or, maybe you want to sort data by Amount from smallest to largest or largest to smallest.

To Sort the data follow the steps mentioned below:

  • Select the Column by which you want to sort data.
  • Choose Data Tab » Sort Below dialog appears.
  • If you want to sort data based on a selected column, Choose Continue with the selection or if you want sorting based on other columns, choose Expand Selection.

  • You can Sort based on the below Conditions.

    • Values: Alphabetically or numerically.

    • Cell Color: Based on Color of Cell.

    • Font Color: Based on Font color.

    • Cell Icon: Based on Cell Icon.

Sorting option is also available from the Home Tab. Choose Home Tab » Sort & Filter. You can see the same dialog to sort records.

read less
Comments
Dislike Bookmark

Looking for Data Analysis Classes

Find best Data Analysis Classes in your locality on UrbanPro.

FIND NOW

Lesson Posted on 27/12/2017 Financial Planning/Business Analytics Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel IT Courses/Data Analysis

Data Consolidation In Excel

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

Before you begin consolidating the data, make sure that there is consistency across the data sources. This means that the data is arranged as follows: Each range of data is on a separate worksheet. Each range of data is in list format, with labels in the first row. Additionally, you can... read more

Before you begin consolidating the data, make sure that there is consistency across the data sources. This means that the data is arranged as follows:

  • Each range of data is on a separate worksheet.

  • Each range of data is in list format, with labels in the first row.

  • Additionally, you can have labels for the categories, if applicable, in the first column.

  • All the ranges of data have the same layout.

  • All the ranges of data contain similar facts.

  • There are no blank rows or columns within each range.

In case the data sources are external, ensure usage of a predefined layout in the form of an Excel template.

Suppose you have the sales data of various commodities from each of the regions East, North, South, and West. You might need to consolidate this data and present a product wise summary of sales from time to time. Preparation includes the following:

  • One worksheet per region – i.e. four worksheets with names East, North, South, and West. These could be in the same workbook or different workbooks.

  • Each worksheet has same layout, representing the details of product, number of units, and amount.

  • You need to consolidate the data product wise. Hence, ensure that the column with the label Product is the first column and it contains the Product labels.

read less
Comments
Dislike Bookmark

Lesson Posted on 27/12/2017 IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel Financial Planning/Business Analytics Training IT Courses/Data Analysis

Data Validation In Excel

iTech Analytic Solutions

"iTech Analytic Solutions" (iTAS) is ranked as No. 1 Analytic Training Center in Bangalore by ThinkVidya.com "iTech...

MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry, you can display a custom message. Validation Criteria... read more

MS Excel data validation feature allows you to set up certain rules that dictate what can be entered into a cell. For example, you may want to limit data entry in a particular cell to whole numbers between 0 and 10. If the user makes an invalid entry, you can display a custom message.

Validation Criteria To specify the type of data allowable in a cell or range, follow the steps below while you refer to which shows all three tabs of the Data Validation dialog box. Select the cell or range.

Choose Data » Data Tools » Data Validation. Excel displays its Data Validation dialog box having 3 tabs settings, Input Message and Error alert. Settings tab Here you can set the type of validation you need.Choose an option from the Allow drop-down list.The contents of the Data Validation dialog box will change, displaying controls based on your choice.

Any Value: Selecting this option removes any existing data validation.

Whole Number: The user must enter a whole number.For example, you can specify that the entry must be a whole number greater than or equal to 50.

Decimal: The user must enter a number. For example, you can specify that the entry must be greater than or equal to 10 and less than or equal to 20.

List: The user must choose from a list of entries you provide.You will create drop-down list with this validation. You have to give input ranges then those values will appear in the dropdown.

Date: The user must enter a date. You specify a valid date range from choices in the Data drop-down list. For example, you can specify that the entered data must be greater than or equal to January 1, 2013, and less than or equal to December 31, 2013.

Time: The user must enter a time. You specify a valid time range from choices in the Data drop-down list. For example, you can specify that the entered data must be later than 12:00 p.m.

Text Length: The length of the data numberofcharacters is limited. You specify a valid length by using the Data drop-down list. For example, you can specify that the length of the entered data be 1 a single alphanumeric character.

Custom: To use this option, you must supply a logical formula that determines the validity of the user’s entry alogicalformulareturnseitherTRUEorFALSE.

Input Message tab:

You can set the input help message with this tab. Fill the title and Input message of the Input message tab and the input message will appear when cell is selected..

Error Alert Tab:

You can specify error message with this tab. Fill the title and error message. Select the style of the error as stop, warning or Information as per you need.

read less
Comments
Dislike Bookmark

Answered on 30/12/2017 Functional Training/Admin Training IT Courses/Data Analysis

Introtallent Pvt Ltd

Hi Shailaja, As suggested by other colleagues, we also have same opinion. Data Science and Analytics is going to be the booming industry and demand is going to increase every year. People who already have skills like R, Python, Excel, VBA, SQL etc will definitely get an advantage in terms of better... read more
Hi Shailaja, As suggested by other colleagues, we also have same opinion. Data Science and Analytics is going to be the booming industry and demand is going to increase every year. People who already have skills like R, Python, Excel, VBA, SQL etc will definitely get an advantage in terms of better job offer. You must start preping up so that you will be ready for the industry in 3 to 6 months time. Hope this helps! Regards, Mukesh (86185 69998) read less
Answers 6 Comments
Dislike Bookmark

Looking for Data Analysis Classes

Find best Data Analysis Classes in your locality on UrbanPro.

FIND NOW

Answered on 03/12/2017 Functional Training/Business Analysis Training IT Courses/Data Analysis IT Courses/MS SQL/MS SQL Reporting +1 IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training less

Lakshman Satyanarayan Prasad Kalavala

Experienced Quality Management

Hi Kartik, It is very good to know your experience in the field of Data Analytics. You just master those skills so that it is easy to sell your skill. I believe you are good at BIG DATA. If you possess the Architect level in the BIG DAGA/HADOOP it will fetch you good jobs in the IT world. Please... read more
Hi Kartik, It is very good to know your experience in the field of Data Analytics. You just master those skills so that it is easy to sell your skill. I believe you are good at BIG DATA. If you possess the Architect level in the BIG DAGA/HADOOP it will fetch you good jobs in the IT world. Please think of it and invest your spare time in nurturing these skills and be valueable resource. Certification is only for the recruiters not for you. So be cognizant to the fact that you gain the knowledge which is primary for now. Thanks and regards lakshman read less
Answers 5 Comments 2
Dislike Bookmark

Answered on 09/06/2017 IT Courses/Data Analysis

Ashish R.

Data Scientist

I think you can learn data analytics skills. i would definitely help you in your current role to do better. You need to learn some data analytics tools like R/SAS/SPSS as well along with the google analytics tools that you are using in your current role.
Answers 4 Comments
Dislike Bookmark

Lesson Posted on 02/05/2017 IT Courses/Big Data IT Courses/Data Analysis

Big data Training Catalogue

Xcelframeworks

eXcelFrameworks is a Learning Service and Professional Development Solution provider. eXcelFrameworks...

Course: 1 Understanding Fundamentals of Big Data Duration: 1 Day Level: Basic Fundamentals of Big Data Understanding Big Data Big Data Drivers Big Data Use cases Understanding Big Data Dimensions Characteristics of Big Data Big Data Governance Big Data tools Hadoop a brief Introduction File... read more

Course: 1 Understanding Fundamentals of Big Data

Duration: 1 Day

Level: Basic

Fundamentals of Big Data

  • Understanding Big Data
  • Big Data Drivers
  • Big Data Use cases
  • Understanding Big Data Dimensions
  • Characteristics of Big Data
  • Big Data Governance

Big Data tools

  • Hadoop a brief Introduction
  • File System (HDFS) A technical Introduction
  • Hadoop Ecosystem
  • Using Data Processing Tools: Pig, Hive,Sqoop and HBase
  • YARN Architecture

Big Data Application Development

  • Big Data patterns
  • Application Development Framework
  • Execution Model
  • Comparing MapReduce and other Frameworks

Using NoSQL for Big Data management

  • Understanding NoSQL
  • Schema-less Model Benefits
  • Data Modelling using Key/Value, Document Driven, Column Oriented and Graph
  • NoSQL Product Comparison

 Big data Analytics

  • Understanding Concept of Analytics
  • Building a POC to implement Big data lake
  • Evaluating Platforms for Big Data Implementation
  • Concept of Data Science and its driving force

Course: 2 Hadoop Fundamentals

Duration: 1 day

Level: Basic

Hadoop Fundamentals

  • Big Data introduction
  • Hadoop in Making: History
  • Hadoop capabilities and Scenarios
  • Building Data Lake using Hadoop
  • Analytical and Operational Big Data Frameworks and Hadoop

Components of Hadoop

  • Understanding Components of File System
  • HDFS: Features and Benefits
  • Cluster management (YARN and MapReduce)
  • Building Hadoop Distribution using Open Source
  • Installing and Configuring Hadoop for Big Data.

Data Ingestion in Hadoop

  • Understanding Data in Motion and data at Rest
  • Basic Copy Data
  • Using Flume
  • Sqoop
  • Fundamentals of Kafka

Application Development in Hadoop

  • Using java/Python to implement MapReduce
  • Working with Pig and Pig Latin
  • Hive and Impala
  • Oozie

Critical Components of Hadoop

  • Zookeeper
  • HBase
  • Lucene and Solr
  • Avro

Course: 3 NoSQL Fundamentals

Duration: 1

Fundamentals of NoSQL

  • NoSQL: why?
  • Overview of NoSQL
  • Characteristics of NoSQL
  • NoSQL storage types
  • Advantages and Drawbacks
  • Comparing NoSQL Products

 

Understanding Storage Architecture

  • Understanding Key/Value stores using Memcached and Redis
  • Document Driven and Column oriented Architectures(MongoDB/Cassandra0
  • Graph Oriented Database
  • Performing CRUD operations
  • Querying NoSQL Stores

Understanding NoSQL Principles

  • Understanding CAP Theorem
  • Understanding BASE and Comparing with ACID
  • Concept of Scalability
  • Indexing and Ordering DataSets(MongoDB)

NoSql Internals

  • MongoDB
  • Membase
  • Apache Cassandra
  • Berkeley DB

Using NoSQL in the Cloud

  • Benefits of Cloud Architectures
  • Working with Google App Engine: Workshop (2 Hours)
  • Amazon SimpleDB:WorkShop(2 hours)
read less
Comments
Dislike Bookmark

Looking for Data Analysis Classes

Find best Data Analysis Classes in your locality on UrbanPro.

FIND NOW

Answered on 14/04/2017 IT Courses/Data Analysis

Bestintown Analytics Private Limited

Rs. 6000 / 20 hours only R.
Answers 8 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best Data Analysis Classes in India. Post Your Requirement today and get connected.

Overview

Lessons 41

Total Shares  

+ Follow 3,839 Followers

Top Contributors

Connect with Expert Tutors & Institutes for Data Analysis

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more