डाटा-एनालिसिस-में-करियर- नौकरी-एंव-स्कोप

 डाटा-एनालिसिस-में-करियर- नौकरी-एंव-स्कोप

आप  के पास एक्सेल ( MS-Excel ) कि  अच्छी  समज  है  या  खुद से  कुछ  करणे  की  इच्छा  है  तो  आप  इस मे  करिअर  बना सकते  है

आज युवाओं में अच्छी नौकरी की होड़ लगी हुई है हर कोई एक अच्छी नौकरी के साथ अच्छी सैलेरी वाली नौकरी चाहते हैं। ऐसे में बहुत से युवाओं को अपना फ्यूचर बनाने में प्रॉब्लम होती है वह सोचते रहते हैं की ऐसा क्या किया जाए जिससे उन्हें अच्छी नौकरी मिले और अच्छा पैसा भी 

टेक्नोलॉजी ने बिज़नेस करने के तरीकों को ही बदल कर रख दिया जिसकी वजह से आज युग डिजिटल युग की श्रेणी में आने लगा है | डिजिटल को आगे ले जाने में सबसे  योगदान डेटा का होता है जिसके माध्यम से कोई भी कम्पनी घर बैठे आप तक पहुंच जाती है |

आज के युवा डाटा साइंटिस्ट के रूप में अच्छा पैसा कमा सकते हैं एंव पिछले कुछ सालों में अगर बात की जाए तो डाटा एनालिस्ट की डिमांड बहुत ज्यादा बढ़ गई है। आइये जानते हैं की

डाटा क्या होता  है ?

डेटा जानकारियों का संग्रह होता है यह किसी भी व्यक्ति या वस्तु की सूचना से जुडा होता है | यह किसी भी रूप में हो सकता है  जैसे टेक्स्ट , इमेज , न्यूमेरिक एल्फा न्यूमेरिक फ़ाइल , ऑडियो , वीडियो  ग्राफ इत्यादि | जब इन सबको एक जगह मिलाया जाता है तो ये इन्फॉर्मेशन बन जाता है और इसी इन्फॉर्मेशन के समूह को डाटा कहते है | डाटा सर्जन में  मोबाइल इंटरनेट  इस्तेमाल करने वाले सभी व्यक्ति मौजूद है |

इन सभी इन्फॉर्मेशन को डेटा के रूप में सेव करने के लिए कुछ सॉफ्टवेयर की जरूरत पड़ती है जिनकी सहायता से आप अपना डेटा सुरक्षित रख सकते है |  कुछ ऐसे साधारण सॉफ्टवेयर जिनका इस्तेमाल ज्यादातर लोग करते है | 

डेटा एनालिस्ट के काम क्या होता  है

डाटा साइंटिस्ट का काम होता है  विभिन्न सेक्टरों द्वारा डाटा कैप्चर करे  और उन्हें  एम एस एक्सेल, गूगल शीट्स, पावर पॉइंट, सॉफ्टवेअर वर प्रोग्रामिंग  की मदद से एक कहानी की तरह कंपनी और  लोगों के सामने प्रस्तुत करते हैं। इनका काम डाटा को संभालकर रखना एंव उन्हें जरूरत पड़ने पर सामने लाना होता है,

डेटा एनालिस्ट उन पेशेवरों को कहा जाता है, जिनके पास MS - EXCEL प्रोग्रामिंग, स्टैटिस्टिक्स, एप्लाइड मैथमैटिक्स और कंप्यूटर की अच्छी जानकारी होती है। इनके पास किसी भी तरह के डेटा को बेहतर तरीके से विजुलाइज करने की क्षमता होती है। इंडियन इंस्टीटय़ूट ऑफ मैनेजमेंट डेटा एनालिस्ट को डेटा माइनर्स नाम से संबोधित करता है। कॉरपोरेट जगत में इन्हें डेटा एनालिस्ट और डेटा साइंटिस्ट के नाम से भी जाना जाता है। डेटा एनालिस्ट विभिन्न सेक्टरों द्वारा दिए गए उलझाऊ और जटिल डेटा में से अहम जानकारियों को बारीकी से खंगालते हैं। वे यह भी पता लगाते हैं कि किस वजह से कंपनी की स्थिति में गिरावट आ रही है या कंपनी के लिए कौन सा नया उद्यम लाभकारी होगा।

डाटा एनालिस्ट कैसे बन सकते हैं?

डाटा एनालिसिस बनने के लिए अनेक युनिवर्सिटी डिग्री, डिप्लोमा एंव सर्टिफिकेट कोर्स करवाती है। इसके अलावा आप ऑनलाइन भी अनेक संबधित कोर्स कर सकते हैं जो कम फीस में ही हो जायेंगे एंव आप एक डाटा एनालिसिस के रूप में काम कर पायेंगे। इसको को तीन भागो में बांटा गया है पहला डाटा ऑर्गेनाइजेशन , दूसरा डाटा पैकेजिंग एंव  तीसरा डाटा डिलीवर इन तीनो भागो में अनेक युनिवर्सिटी शोर्ट टर्म कोर्स करवाती है। 

ध्यान दें:  इतने  महंगे और  जटिल  कोर्सेस करणे  के पहले अपने आप  को  (Advanced MS Excel )  मे अजमाईये  इसमे आप  को  रुची  और कुशलता  दिखती  है  तो  आगे  आप  सोच  सकते है साथ मे अपनी स्किल्स जावा, पायथन, आर, रास को बनाये ऐसा करने से आप किसी भी क्षेत्र में Data analyst के रूप में अपना भविष्य बना सकते हैं।

डाटा एनालिस्ट को नौकरी अवसर

यानि डाटा साइंटिस्ट की मांग आज हर तरफ है, किसी भी फील्ड में जैसे  ई-कॉमर्स, सोशल साइट्स, सर्च इंजिन, मैपिंग एंव सरकारी विभाग में भी डाटा एनालिस्ट की मांग लगातार बढती जा रही है। पिछले एक साल में देखा जाए विश्व की बड़ी कम्पनियां जैसे:- गूगल, अमेजॉन, फेसबुक एंव ट्विटर में Data analyst (डाटा साइंटिस्ट) की मांग बहुत ज्यादा बढ़ी है। इसके अलावा आज हर क्षेत्र में चाहे वो सरकारी हो या गैर सरकारी हर जगह डाटा एनालिस्ट की डिमांड बढती जा रही है इसलिए इसको किसी भी क्षेत्र में काम करने का मौका मिल सकता है।

डाटा एनालिस्ट के रूप में युवा किसी भी क्षेत्र में काम कर सकते हैं, यहाँ तक की वह अपना खुद का डाटा एक्सपोर्ट कर काम भी कर सकते है क्योंकि आज हर एक बड़ी कंपनी हो या छोटी कंपनी डाटा की डिमांड हर जगह होती है।

ऐसे में एक डाटा एनालिस्ट को इस तरह के नौकरी प्रोफाइल मिल सकते हैं– ......

Read More...

यदी आप  इस सेक्टर  मे  करिअर  अजमाना   चाहते  है  हम  आपकी  मदत  कर  सकते  है  हमारे  इन्स्टिटयूट मे  ऍडवान्सड एक्सेल (Advanced Excel Training ) कोर्स मे ही  डाटा एनालिसिस   का  बेसिक जनकारी  दि जाती  है साथ  आगे  करिअर  के लिये मदत भी मिलेगी 

कोर्स  के  लिये  यहा  क्लीक  करे   

What are the different type of vouchers in Tally Prime ?

What are the different type of vouchers in Tally Prime ?

Voucher is the input feature to record daily transactions in organization and thereby generate reports automatically. After entering the voucher accounting, inventory and payroll reports will be automatically generate according to the voucher type. But a voucher needs to be recorded, which means that the ledgers for the transactions need to be create. No one voucher can not be recorded without a ledger.

A total of 24 vouchers are created in Tally Prime as pre-defined. According to the voucher type, 24 vouchers can be classified as this way.

Accounting Vouchers

Inventory Vouchers

Payroll Vouchers

Non-Accounting Vouchers

LIST OF ACCOUNTING VOUCHERS

1.      Payment

2.      Receipt

3.      Contra

4.      Purchase

5.      Sales

6.      Debit Note

7.      Credit Note

8.      Journal

LIST OF INVENTORY VOUCHERS

1.      Delivery Note

2.      Job work in order

3.      Job work out order

4.      Material In

5.      Material Out

6.      Physical Stock

7.      Purchase Order

8.      Receipt Note

9.      Rejections In

List of Payroll Vouchers

1.      Attendance

2.      Payroll

3.      Non – Accounting Vouchers

4.      Memorandum

5.      Reversing Journal

ACTIVATE / DEACTIVATE VOUCHERS

In Tally Prime. the voucher must be activated to record. You can also deactivate the voucher if you don’t need it.

To activate / deactivate vouchers,

Go through this path

Gateway of Tally

Masters

Chart of Accounts

Voucher Types

Select Voucher Type, Press Enter

now enable the option, “ACTIVATE THIS VOUCHER TYPE “into YES

Accept the total screen

READ MORE...

How to Create E way Bills on E-way Bill Portal / How to Generate E way Bill?

How to Create E way Bills on E-way Bill Portal / How to Generate E wayBill?

What is an E-Way Bill?

E-Way Bill is an Electronic Way bill for movement of goods to be generated on the eWay Bill Portal. A GST registered person cannot transport goods in a vehicle whose value exceeds Rs. 50,000 (Single Invoice/bill/delivery challan) without an e-way bill that is generated on ewaybillgst.gov.in.

Alternatively, E-way bill can also be generated or cancelled through SMS, Android App and by site-to-site integration through API.

When an e-way bill is generated, a unique E-way Bill Number (EBN) is allocated and is available to the supplier, recipient, and the transporter.

Who should Generate an eWay Bill?

Registered Person – Eway bill must be generated when there is a movement of goods of more than Rs 50,000 in value to or from a registered person. A Registered person or the transporter may choose to generate and carry eway bill even if the value of goods is less than Rs 50,000.

Unregistered Persons – Unregistered persons are also required to generate e-Way Bill. However, where a supply is made by an unregistered person to a registered person, the receiver will have to ensure all the compliances are met as if they were the supplier.

Transporter – Transporters carrying goods by road, air, rail, etc. also need to generate e-Way Bill if the supplier has not generated an e-Way Bill.

The ewaybill (EWB) portal provides a seamless gateway to generate eWay bills (single and consolidated options), change vehicle number on the already generated EWB , cancel generated EWBs and many more…

Eway bills in EWB-01 can be generated by either of two methods-

On the Web

1.      Via SMS

2.      By e-Invoicing

here we provide you step-by-step process of generating the eway bills on the e way bill portal (web-based).

Prerequisites for e-Way Bill Generation

There are some prerequisites for generating an eway bill (for any method of generation):

1.      Registration on the EWB portal

2.      The Invoice/ Bill/ Challan related to the consignment of goods must be in hand.

3.      If transport is by road – Transporter ID or the Vehicle number.

4.      If transport is by rail, air, or ship – Transporter ID, Transport document number, and date on the document.

Steps to generate e-Way Bill on the e-Way Bill portal

Here is a step by step Guide to Generate EWay Bill (EWB-01) online:

Step 1: Login to the eway bill system.

Enter the Username, password and Captcha code, Click on ‘Login’.

READ MORE...

How to Link PAN and Aadhar

 

How to Link PAN and Aadhar

An Aadhaar card contains a unique 12-digit number issued to every citizen in India by the Unique Identification Authority of India (UIDAI). It acts as an identification number that helps access the cardholder’s details from the government database, such as biometrics and contact information.

Any individual, irrespective of age and gender, being a resident of India, can enrol to obtain an Aadhaar number voluntarily. The enrolment process is free of cost. Once an individual enrols, their details are permanently stored in the database. One person cannot have multiple Aadhaar numbers.

If you hold a PAN and are eligible to get Aadhaar or already have an Aadhaar number, you must inform the income tax department. You can do this by linking PAN to Aadhaar. If you fail to do PAN-Aadhar linking, your PAN will become ‘inoperative’.

How to Link Aadhaar With Pan Card?

The income tax department notification states that income tax returns could be e-filed without linking Aadhaar and PAN until 5th August 2017. However, the deadline to link PAN with Aadhaar was extended to 31st December 2017, and after that, the due date was extended multiple times. As per the latest updates, the deadline to link PAN with Aadhaar is 31st March 2022.

Note that if you file the income tax returns without linking, the income tax department will not process the returns until PAN and Aadhaar are linked. People can visit the official e-filing website of the department to link the two identities in both cases– identical names in the two databases or in a case where there is a minor mismatch.

Online Linking of Aadhaar Number and PAN

You can do online linking of the Aadhaar number with PAN by logging on to the income tax e-filing portal. There are two ways of doing it on the income tax portal.

1. Without logging in to your account (2 step procedure)

2. Logging in to your account (6 step procedure)

Method 1:

Without Logging in to Your Account (2 Step Procedure)

Step 1: Go to www.incometax.gov.in.On scrolling down the home page, click on the ‘Our Services’ tab.

READ MORE...

Advanced Excel Skills for Accounting Finance Professionals

 Advanced Excel Skills for Accounting Finance Professionals

When you’re getting ready to work in accounting, you’ll need to know how to make accounting work for others. You spend a lot of time managing the ledger and preparing reports. You can’t do any of this, though, if you don’t know how to make the reports make sense.

When you manipulate data in reports, you remove columns or rows that help you get to the bottom line. People will become confused or bored if you do not get to the bottom line.

You must also ensure that you understand how to collaborate with other financial institutions. You are the person who is responsible for working with the IRS during tax season and for submitting payroll payments throughout the year. To handle these accounts, you’ll need people skills as well as the ability to create an environment where everyone in the office is aware of what’s going on.

Any good firm, particularly its accounting and financial records, relies heavily on records.  is a useful tool for financial and accounting professionals that need to make reports, analyze data, and plan financial strategies. You may have a basic understanding of , but you may be unaware of specialized functions that can make your job easier.

If you work in accounting or , you almost certainly use  regularly. Because of its flexibility, versatility, and user-friendly design, this classic spreadsheet tool has remained relevant for decades.

Excel may also aid with company choices and client suggestions by providing data-driven insights. It also contains built-in math skills, making it incredibly useful in a variety of situations.

However, if you want to work in accounting or finance, you’ll need to be familiar with some of Excel’s more advanced features. Here are a few abilities you must have if you want to succeed in your career.

Functions and formulas

Excel’s mathematical abilities are what propelled it to prominence in the accounting and finance professions.

Accounting and financial professionals must have a thorough grasp of the available formulas and functions. If you’re not comfortable with them, it’s a good idea to brush up on your skills to enhance your profession.

Analysis of Pivot Tables

Accounting and financial professionals can use pivot tables and pivot charts to extract useful information from data. They have access to a variety of data sources and can facilitate a thorough dive into the information.

READ MORE...

All about GST Registration

 

What is GST Registration

In the GST Regime, businesses whose turnover exceeds Rs. 40 lakhs (Rs 10 lakhs for NE and hill states) is required to register as a normal taxable person. This process of registration is called GST registration. The GST registration process can be completed within 6 working days. GST registration can be easily done on the online GST portal. Business owners can fill a form on the GST portal and submit the necessary documents for registration. Businesses must complete the GST registration process.

CBIC has notified the increase in threshold turnover from Rs 20 lakhs to Rs 40 lakhs. The notification will come into effect from 1st April 2019.

GST Registration is a process by which a taxpayer gets himself registered under GST. Once a business is successfully registered, a unique registration number is assigned to them known as the Goods and Services Tax Identification Number (GSTIN). This is a 15-digit number assigned by the central government after the taxpayers obtain registration.

Please note – If you are operating from more than one state, then you will have to take separate registration for each state you are operating from.

Now, you must be wondering if every business is required to register under GST? Let’s understand GST registration and its procedure in detail.

Who is eligible to register under GST?

    GST Registration must be completed by the following individuals and businesses:

    Individuals who have registered under the tax services before the GST law came into effect.

    Non-Resident Taxable Person and Casual Taxable Person

    Individuals who pay tax under the reverse charge mechanism

    All e-commerce aggregators

    Businesses that have a turnover that exceeds Rs.40 lakh. In the case of Uttarakhand, Himachal Pradesh, Jammu & Kashmir, and North-Eastern states, the turnover of the business should exceed Rs.10 lakh.

    Input service distributors and agents of a supplier

    Individuals who supply goods through an e-commerce aggregator.

    Individuals providing database access and online information from outside India to people who live in India other than those who are registered taxable persons.

    Any service provider

    TDS/TCS deductor

Types of GST Registration

Under the GST Act, GST Registration can be of various types. You must be aware of the different types of GST Registration before selecting the appropriate one. The different types of GST Registration are:

READ MORE....

All about E-Way Bill

All about E-Way Bill

E-way bill or Electronic-way bill is a document introduced under the GST regime that needs to be generated before transporting or shipping goods worth more than INR 50,000 within state or inter-state. The physical copy of e-way bill must be present with the transporter or the person in charge of the conveyance and should include information such as goods, recipient, consignor and transporter. The e-way bill was rolled out nationwide on 1st April 2018.

What is GST E-Way Bill?

Under GST, the process and procedural aspects for the movement of goods are prescribed in the e-way bill rules. E-way bill stands for Electronic Way Bill. It is usually a unique bill number generated for the specific consignment involving the movement of goods. However, it is to be noted that the e-way bill implementation was deferred when GST came into being on the 1st of July, in order to give more time to the government, businesses and transporters to prepare for its full and final implementation. States like Gujarat continued to have Form 402 in GST, and clear rules were laid down as to how to help businesses fill a GST Form 402 online till the implementation of the GST e-way bill is complete.

When is the E-Way Bill applicable?

It is applicable for any consignment value exceeding INR 50,000. Even in case of inward supply of goods from unregistered person, E-Way Bill is applicable.

What is the validity of E-Way Bill?

1.      Less than 100 KM: 1 Day

2.      Every 100 Km or part thereof thereafter – 1 additional day

The validity period will be counted from the time of generation of the E-Way Bill. The validity period of the E-Way Bill may be extended by the commissioner for certain categories of goods, as specified in the notification issued in this regard.

Who should generate the E-Way Bill?

1.      When goods are transported by a registered person, either acting as a consignee or consignor in his own vehicle, hired vehicle, railways, by air or by vessel, the supplier or recipient of the goods should generate the E-Way Bill.

2.      When the goods are handed over to a transporter, the E-Way Bill should be generated by the transporter. In this case, the registered person should declare the details of the goods in a common portal.

3.      In case of inward supplies from an unregistered person, either the recipient of supply or the transporter should generate the E-Way Bill.

Documents, Inspection and Verification for E-Way Bill

The transporter or the person in charge of a conveyance should carry the following documents:

1.      The invoice or bill of supply or delivery challan, and

2.      A physical copy of the E-Way Bill or the E-Way Bill number.

At the place of verification, the officer may intercept any vehicle to verify the E-Way Bill or the E-Way Bill number in physical form for all interstate and intrastate movement of goods. On the ground of suspicion of tax evasion, a physical verification of the vehicle can be carried out by an officer after obtaining necessary approval from the commissioner or an officer authorized on his behalf. If the physical verification of vehicle is done at one place –within the state or in any other state, no further physical verification will be carried out again during the transit, unless specific information of tax evasion is made available subsequently.

After every inspection, the officer needs to record the details of the inspection of goods in Part A of Form GST EWB 03 within 24 hrs of inspection and the final report must be recorded in Part B of Form GST EWB 03 within 3 days of inspection. If the vehicle is detained for more than 30 minutes, the transporter has an option to complain by uploading the details in Form GST EWB 04.

GST E-Way Bill Format

The E-Way Bill format in GST comprises of 2 parts – Part A and Part B....

Read More...

AIAT Institute

15, Bhande Plot

Umred Road Nagpur.

9604121000

www.aiatindia.com

3.