telangana state technology services ltd - tsts state technology services ltd brkr bhavan, 1st floor,...

16
----1---- Telangana State Technology Services Ltd BRKR Bhavan, 1st floor, C-Block, Tank bund Road, Hyderabad – 500063, Telangana, India. CIN NO: U74900TG2015SGC101517 website: http://tsts.telangana.gov.in/ TSTS/CS/5972/TABLEAU-SW/2017, Dated 04.09.2017 To The Prospective Bidders Short Tender Notice Sub: TSTS -CS- Supply & Installation of Tableau Software Licenses , Design & Development of Tableau Dashboards by deploying 2 resources for Commissioner & Inspector General, Revenue & Stamps Department- Reg. On behalf of the IGRS Dept, TSTSL invites eProcurement quotations for Supply & Installation of Tableau Software , Design & Development of Tableau Dashboards by deploying 3 resources as per the details given in this Tender. For more information on the scope of work, the interested bidders may contact the IGRS Department through TSTS and obtain required data within 3 days from date of issue of Tender notice. Bid Document Fee : Rs. 5,000/- (DD shall be drawn in favour of The Managing Director, TSTS, Hyderabad) Time Schedule : Last date and time for Bid submission : 11/09/2017 03:00 PM on eProcurement portal Opening of Bids : 11/09/2017 03:30 PM For any further details related to tender, please contact Mr. Sridharachary M, SSE, 9963029421, Email: [email protected], [email protected] 1 Bids should be submitted online on e-Procurement Website only. The Original EMD & Bid document fees to be submitted to TSTS on bid closing date. 2 Any deviations in format may make the quotation liable for rejection. Conditional bids not acceptable and liable for rejection 3 Quotation should be valid at least for a period of 60 days from the date of bid opening 4 The Managing Director, TSTSL reserves the right to accept or reject any or all the quotations without assigning any reasons thereof and to add, modify or delete any of the terms and conditions without any notice. 5 Bidders have quote as per the Proforma provided in the Commercial Bid format. The bid/tender will be rejected if the bid submitted is conditional. 6 No options will be accepted. If the vendor wants to give option, he may submit it as separate bid along with Separate EMD. This will be treated as a separated bid for evaluation. 7 Persistent complaints from the user Department during the warranty period relating to the improper service will be sufficient ground for the TSTSL to blacklist the successful bidder from participating in future tenders 8 EMD: The vendor should submit EMD of Rs. 50,000/- in the form of Demand Draft from any Nationalized/Scheduled bank in favour of The Managing Director, TSTS, Hyderabad with validity of 90 days from Bid closing date. The scanned copy of EMD should be uploaded on e-procurement website in technical bid. The original EMD should be submitted before opening of the Bid. EMD will be returned to unsuccessful bidders after issue of Purchase order to L1 bidder. The EMD of the successful bidder will be returned after submission of PBG to TSTS. 9 Bidder Eligibility : A. The bidder should be a Registered Company in India under Company Act 1956/2013 in India and should be registered with relevant tax authorities. Should submit valid Statutory documents in technical bid : copy of PAN card and copy of GST, Sales tax etc. B. The bidder should be authorized partner of Tableau and should submit valid partner certificate from the OEM.

Upload: phungtruc

Post on 18-Apr-2018

226 views

Category:

Documents


2 download

TRANSCRIPT

----1----

Telangana State Technology Services Ltd BRKR Bhavan, 1st floor, C-Block, Tank bund Road,

Hyderabad – 500063, Telangana, India.

CIN NO: U74900TG2015SGC101517

website: http://tsts.telangana.gov.in/

TSTS/CS/5972/TABLEAU-SW/2017, Dated 04.09.2017

To The Prospective Bidders

Short Tender Notice

Sub: TSTS -CS- Supply & Installation of Tableau Software Licenses , Design & Development of Tableau Dashboards by deploying 2 resources for Commissioner & Inspector General, Revenue & Stamps

Department- Reg.

On behalf of the IGRS Dept, TSTSL invites eProcurement quotations for Supply & Installation of Tableau

Software , Design & Development of Tableau Dashboards by deploying 3 resources as per the details given

in this Tender. For more information on the scope of work, the interested bidders may contact the IGRS Department through TSTS and obtain required data within 3 days from date of issue of Tender notice.

Bid Document Fee : Rs. 5,000/- (DD shall be drawn in favour of The Managing Director, TSTS, Hyderabad) Time Schedule : Last date and time for Bid submission : 11/09/2017 03:00 PM on eProcurement portal

Opening of Bids : 11/09/2017 03:30 PM

For any further details related to tender, please contact Mr. Sridharachary M, SSE, 9963029421, Email: [email protected], [email protected]

1 Bids should be submitted online on e-Procurement Website only. The Original EMD & Bid document fees to be submitted to TSTS on bid closing date.

2 Any deviations in format may make the quotation liable for rejection. Conditional bids not acceptable and liable for rejection

3 Quotation should be valid at least for a period of 60 days from the date of bid opening

4 The Managing Director, TSTSL reserves the right to accept or reject any or all the quotations without assigning any reasons thereof and to add, modify or delete any of the terms and conditions without any notice.

5 Bidders have quote as per the Proforma provided in the Commercial Bid format.

The bid/tender will be rejected if the bid submitted is conditional.

6 No options will be accepted. If the vendor wants to give option, he may submit it as separate bid along with Separate EMD. This will be treated as a separated bid for evaluation.

7 Persistent complaints from the user Department during the warranty period relating to the

improper service will be sufficient ground for the TSTSL to blacklist the successful bidder from

participating in future tenders 8 EMD: The vendor should submit EMD of Rs. 50,000/- in the form of Demand Draft from any

Nationalized/Scheduled bank in favour of The Managing Director, TSTS, Hyderabad with validity of 90 days from Bid closing date. The scanned copy of EMD should be uploaded on e-procurement website in technical bid. The original EMD should be submitted before opening of the Bid.

EMD will be returned to unsuccessful bidders after issue of Purchase order to L1 bidder. The EMD of the successful bidder will be returned after submission of PBG to TSTS.

9 Bidder Eligibility :

A. The bidder should be a Registered Company in India under Company Act 1956/2013 in India and should be registered with relevant tax authorities. Should submit valid Statutory documents in technical bid : copy of PAN card and copy of GST, Sales tax etc.

B. The bidder should be authorized partner of Tableau and should submit valid partner certificate from the OEM.

----2----

C. The bidder should have financial turnover of minimum Rs. 1.00 crore or above in each of the

last 2 Financial years from IT Development & ITeS services. The bidder should submit audited balance sheets / CA certificate in the Technical bid.

D. The bidders should have experience in executing of 2 projects in design, development & maintenance of Tableau dash boards for any State /Central Govt./PSU or reputed Private Organizations in the last 2 Financial years i.e. 2015-16 , 2016-17. Copy of Work Orders, Agreements to be submitted.

E. The bidder should be CMMI Level 5 certified Company and copy of valid certificate to be submitted in the bid.

F. The bidder should have at least 20 Nos of IT development manpower with knowledge &

experience in Tableau Software on their roles as on bid calling date.

G. The bidder should submit declaration stating that they are not debarred/ blacklisted in Technical bid.

10 Project Time Lines:

i. Supply & Installation of Tableau Licenses (1Desktop License & 10 Server licenses) --- 1 week from date of issue of Purchase Order.

ii. Deployment of ‘2’ nos of Technical Resources at IGRS dept for design,

development/customization of the Tableau Dashboards -- within 1 week from issue of Purchase Order.

iii. Completion of Design, Development/Customization & training on the Tableau Dashboards –

2 months from the date of Purchase Order.

11 Payment Terms:

Supply, Installation of required Tableau Licenses 100% of License Cost.

After Completion of Design, Development/ Customization & training on the Tableau Dashboards

100% of Manpower Cost.

12 Bidding Procedure: Bids should be submitted in two parts namely, “Technical bid” and “Financial bid on e- procurement website. The bidder should upload all the required formats and documents as mentioned in the tender document.

Technical Bid: 1. Bid Letter Form 2. EMD scanned copy 3. General Information of Bidder along with Address & Contact Person Details Form P1 4. Firm Turnover: Audited balance sheets / CA certificate 5. Declaration regarding not black listed 6. Un-Priced Form - F1 7. PAN card and VAT/Sales Tax certificates 8. Bid Document Fee DD 9. Past Experience Details in Form P3 with relevant supporting documents. 10. Documentary evidence for Partnership with OEM 11. Any other documents, if any

Financial Bid: The Financial bids of the TQ qualified bidders only shall be opened on eProcurement portal and L1 cost shall are arrived based on Grand Total of the items.

13 a) Bid Evaluation: The Bid evaluation shall be undertaken by the Evaluation Committee. The bids

received on eProcurement portal as on bid closing date & time, shall be opened for evaluation. The bids shall be verified prima-fascia with the tender conditions. The Commercial bids of only

TQ qualified bidders shall be opened and L1 cost shall are arrived based on Grand Total.

----3----

14 General Terms & Conditions:

A. Term and Extension of Contract

The term of this Contract shall be initially for a period of 2 months and shall be extended by Dept

based on the performance. The department/ TSTS shall reserve the sole right to grant any extension

to the term mentioned above on mutual agreement including on terms and conditions.

B. Suspension of Work

The Service Provider shall, if ordered in writing by User Department/TSTS representative,

temporarily suspend the works or any part thereof for such a period and such a time as ordered. The

Service Provider shall not be entitled to claim compensation for any loss or damage sustained by him

by reason of temporary suspension of the Works as aforesaid. An extension of time for completion

corresponding with the delay caused by any such suspension of the works as aforesaid shall be

granted to the consulting agency, if request for same is made and that the suspension was not

consequent to any default or failure on the part of the Consulting agency. In case the suspension of

works is not consequent to any default or failure on the part of the Service Provider and lasts for a

period of more than 3 months, the Service Provider shall have the option to request the TSTS/User

Department to terminate the Contract with mutual consent.

C. Resolution of Disputes:

TSTS/User Department and the Bidder shall make every effort to resolve amicably by direct informal

negotiation any disagreement or dispute arising between them under or in connection with the

contract.

• If, after thirty (30) days from the commencement of such informal negotiations, the TSTS/User

Department and the Bidder have been unable to resolve amicably a contract dispute, either

party may require that the dispute be referred for resolution to the formal mechanisms

specified here in. These mechanisms may include, but are not restricted to, conciliation

mediated by a third party.

• The dispute resolution mechanism shall be as follows:

• In case of a dispute or difference arising between the TSTS/User Department and the Firm

/bidder relating to any matter arising out of or connected with this agreement, such disputes or

difference shall be settled in accordance with the Arbitration and Conciliation Act, of India,

1996.

• Governing language

• The contract shall be written in English. All correspondence and other documents pertaining to

the contract which are exchanged by the parties shall be written in same languages.

D. Applicable law

The contract shall be interpreted in accordance with appropriate Indian Laws.

E. Confidentiality and Intellectual Property Rights (IPR)

The IPR and the Customized Dashboard would be owned by the Department, Govt. of Telangana. The service provider will sign a non-discloser agreement with the department.

a. Confidentiality

• The successful bidder must maintain absolute confidentiality of the documents/ data

collected in any form including electronic media and any other data/information provided to

him for the execution of the work.

• The bidder should not use the Project data for any purpose other than the scope of work

specified in the document and added/ amended before signing the contract.

----4----

• The Bidder must remove/ destroy the entire data from his custody after completion of the

warranty period. If at any stage it is found that the bidder is using the data provided by the

client any time during the contract execution or after completion of the contract for any

other purposes, stringent legal action will be initiated as per applicable law of land and the

contract will be terminated without assigning any reasons.

Bidder shall not disclose to any one, any information marked as confidential and communicated or made available or accessible by the firm during execution of the work. b. Use of documents and Information and Ownership of the source code

• The bidder shall not, without prior written consent from User Department /TSTS,

disclose/share/use the bid document, contract, or any provision thereof, or any

specification, plan, drawing, pattern, sample or information furnished by or on behalf of the

User Department/TSTS in connection therewith, to any person other than a person

employed by the bidder in the performance of the contract. Disclosure to any such employed

person shall be made in confidence and shall extend only so far as may be necessary for

purposes of such performance.

• The bidder shall not, without prior written consent of User Department /TSTS, make use of

any document or information made available for the project, except for purposes of

performing the Contract.

All project related document (including this bid document) issued by Department /TSTS, other than the contract itself, shall remain the property of the Department /TSTS and shall be returned (in all copies) to the Department /TSTS on completion of the Bidder’s performance under the contract.

15 Other Terms & Conditions

• Performance Bank Guarantee (PBG): The Successful L1 bidder should submit PBG for an amount of 10% of the Project Value in the name of “The Managing Director, Telangana State Technology Services” within 1 week from issue of Purchase Order. The PBG should be valid for beyond 30 days post warranty Period for each item.

• Transaction fee: All the participating bidders who submit the bids have to pay an amount @ 0.03% of their final bid value online with a cap of Rs. 10,000/- for quoted value of purchase up to Rs.50 crores and Rs.25000/- if the purchase value is above Rs.50 crores & service tax applicable as levied by Govt. of India on transaction fee through online in favour of MD, TSTS. The amount payable is non-refundable.

• Corpus Fund: Successful bidder has to pay an amount of 0.04% on quoted value through demand draft in favor of Managing Director, TSTSL, Hyderabad towards corpus fund at the time of concluding agreement.

16 Bidders are requested to submit the bids after issue of amendments/clarifications duly considering the changes made if any. Bidders are totally responsible for incorporating/complying the changes/amendments issued if any, before bid submission time & date.

17 Bids shall be submitted online on www.eprocurement.gov.in platform 1. The participating bidders in the tender should register themselves free of cost on e- procurement platform in the website www.eprocurement.gov.in.

2. The bidders who are desirous of participating in e-procurement shall submit their technical bids, price bids as per the standard formats available at the e-market place. 3. The bidders should scan and upload the respective documents in Technical bid documentation as detailed mentioned in bid document including EMD. The bidders shall sign on all the statements, documents certificates uploaded by them, owning responsibility for their correctness/authenticity.

The rates should be quoted in online in Indian Rupees only

18 1. After uploading the documents, the copies of the uploaded statements, certificates, documents, original EMD in respect of Bid Security (except the Price bid/offer/break-up of taxes) are to be submitted by the bidder to the O/o The Managing Director, TSTSL , BRKR Bhavan, Hyderabad as

----5----

and when required. Failure to furnish any of the uploaded documents, certificates, will entitled in rejection of the bid. The TSTSL shall not hold any risk on account of any delay. Similarly, if any of the certificates,

documents, etc., furnished by the Bidder are found to be false / fabricated/ bogus, the bidder will be disqualified, blacklisted, action will be initiated as deemed fit and the Bid Security will be forfeited.

2. TSTSL will not hold any risk and responsibility regulating non-visibility of the scanned and uploaded documents. 3. The Documents that are uploaded online on e-market place will only be considered for Bid Evaluation. 4. Important Notice to Contractors, Suppliers and Department users (i)In the endeavor to bring total automation of processes in e-Procurement, the Govt. has issued orders vide G.O.Ms.No. 13 dated. 5.7.2006 permitting integration of electronic Payment Gateway of ICICI/HDFC/Axis Banks with e-Procurement platform, which provides a facility to participating suppliers / contractors to electronically pay the transaction fee online using their credit cards.

19 Note- This tender call is issued on e-procurement market place at www.eprocurement.gov.in. All the terms and conditions are to be read jointly as mentioned in the e-procurement market website and in this document.

20 TSTSL /User Department reserves their right in not considering the bid of a bidder, if such bidder was a previous supplier and had a past bad track record or their earlier performance was unsatisfactory on any count.

21 In case of parts/equipment to be repaired or replaced are not available, the bidder may use equal or higher models. All compatibility issues are the responsibility of the bidder.

22 1. The bidder should upload all the required documents duly signed by the Authorised person of the

bidding Organization with clear visibility, avoid missing documents and avoid bidding mistakes. In such cases, TSTS reserves it’s right in seeking clarification from the bidder and may disqualify the bidder for the bidding mistakes, missing documents and for the documents that are not clear.

2. An undertaking from Supplier is required stating that they would facilitate the Tenderer on regular basis with the technology/product updates and extend support for the warranty and AMC period as well.

3. The price quoted should be valid for a period of one year and the price quote should not be higher than the prevailing market price or the price at which sold for the previous order. If found to be higher, the bidder is liable for legal proceedings & penalties.

Yours Sincerely,

I/c Managing Director, TSTS

----6----

Formats for Bidding

Bid Letter Form (To be submitted in TQ bid)

From: (Registered name and address of the bidder) To: The Managing Director, Telangana State Technology Services Limited, Boorgula Ramakrishna Rao Bhavan, C-block, 1st floor, Tank bund Road, Hyderabad, PIN: 500 063,

Sir,

Having examined the bidding documents and amendments there on, we the undersigned, offer to

provide services/execute the works including supply, delivery installation of hardware, firm wares and

software as the case may be, in conformity with the terms and conditions of the bidding document and

amendments there on, for the following project in response to your tender call no & dated

...............................

Project title:

We undertake to provide services/execute the above project or its part assigned to us in conformity with

the said bidding documents for an amount quoted in financial bid accordance with the schedule of

prices attached herewith and coverage options made by TSTSL or its user organization.

If our bid is accepted, we undertake to;

a. provide services/execute the work according to the time schedule specified in the bid document,

b. obtain the performance guarantee of a bank in accordance with bid requirements for the due

performance of the contract, and

c. agree to abide by the bid conditions, including pre-bid meeting minutes if any, which remain

binding upon us during the entire bid validity period and bid may be accepted any time before the

expiration of that period.

We understand that you are not bound to accept the lowest or any bid you may receive, nor to give any

reason for the rejection of any bid and that you will not defray any expenses incurred by us in bidding.

Date & Place: Signature of Bidder & Stamp ----------------------------------------------------------------------------------------------------------------------------------------------

----7----

Form P1 – General Information of the Bidder

(To be submitted in TQ bid)

Sl.No Description Supporting Documents with

page nos.

1 Name of the Company

2 Date of Incorporation (Registration Number & Registering Authority) VAT No., CST No., PAN No.

3 Legal Status of the Company in India & Nature of Business in India

Public Ltd Company/ Private/ Partnership firm

4 Address of the Registered Office in India

5 Name & e-mail id, phone number, fax of the Contact Person

Phone: Fax: Email

6 Web-Site

7 CMMI Level 5 Certification Details

8 EMD details

Amount: DD No. & Date Name of the Bank: Valid up to :

9 Proof of purchase of bid document Receipt No: Date of purchase:

Date Signature of Bidder & Stamp ------------------------------------------------------------------------------------------------------------------------------------

----8----

Form - PQ#2 Financial Turnover Details

(All values in Rs. crores)

Financial Information of Bidder

Sno

Financial Year

Turnover of the firm in Total Profit

after Tax

Net Worth of Company

Total Turnover of the firm

Turnover from IT Development /ITES

(1) (2) (3) (4) (5)

1 FY.2015-16

2 FY.2016-17

Note:

1. Turnover in areas other than mentioned above shall not be considered for evaluation. 2. Please attach audited Balance Sheets and IT return statements to confirming the figures mentioned

in columns (2). 3. Bidder should submit any of the Audited balance sheet / Profit & Loss statement / certificates from

CFO of the Company duly audited by the Charted Accountant and certified by the Company Secretary for all the above stated three financial years.

Place: Bidder’s signature Date : and seal.

----9----

Form – PQ#3 Project Experience

Note:

1. Please submit supporting documents to support the claim and the certificates must be signed by Senior

Executive/ Deputy GM of the organization clearly indicating his/her name, designation and contact

details such as Telephone Number, Fax number, email-id etc.

2. Please attach certificate from the client for the successful completion & implementation of project.

Place: Bidder’s signature Date : and seal.

Description of Item Supporting Document with page number

Name of the Client / Department

Contact address & details of the department

Value of the Project

Date of Start of Work

Date of Completion of Work

Description of Work

Service Provider should submit any of the following:

i. PO / Work order

ii. Work completion certificates / Performance Certificate from client

dept. duly signed by the authorized signatory from the Client end.

iii. Work satisfactory certificate from the client dept.

Enclosures submitted: Yes / No

----10----

Form P4 - Manpower Availability with Bidder of Tableau

# Employee Name Designation Skills & Professional Certification, if any

Proposed Area of

expertise

Previous Exp.

Experience with Service

Provider

Note: The Service Provider should submit Self-Certification by the authorized signatory.

Form P5 - Declaration Regarding Clean Track Record (To be submitted in TQ bid)

To

The Managing Director, Telangana State Technology Services Limited, 1st Floor, C Block, BRKR Bhavan, Tankbund Road, Hyderabad 500063

Sir,

I have carefully gone through the Terms & Conditions contained in the Tender Document [No.

]. I hereby declare that my company has not been debarred/ black listed as on Bid calling date by

any Central or State Government / Quasi Government Departments or Organizations in India for non-

satisfactory past performance, corrupt, fraudulent or any other unethical business practices. I further

certify that I am competent officer in my company to make this declaration.

Yours faithfully,

(Signature of the Bidder) Name & Designation Seal Date Business Address: -----------------------------------------------------------------------------------------------------------------------------------------

----11----

FormT1

Technical Proposal

A Brief technical proposal by the bidder on Project Scope, Understanding of the project, technologies proposed covering the following and other issues related to project:

a. Project Plan, Approach & Methodology for development.

b. Technology design and identification of functional requirements of the solution

c. Integration Strategy with department applications

d. Operations & Management Approach

e. Training & Capacity Building Plan

f. Handholding, Operations and Maintenance Plan &Post Implementation Support approach.

g. Manpower deployment plan & Details of Manpower proposed for project (as per the

qualifications mentioned in the Scope of work) 1:2 CVs to be submitted.

h. Infrastructure Requirements – Proposed BoM for deployment of solution

i. Exit Management Plan

Date Signature of Bidder &Stamp

----12----

Financial Bid Format

Form F1

# Particular

Qty (nos)

Unit Rate Rs.

Taxes (Rs.)

Total Cost (incl. of all taxes) Rs.

1 Tableau Desktop Licenses (Perpetual) for development, testing and production

01

2 Tableau Server Licenses (Perpetual) 10

3

Man-month cost for Design, Development/Customization of Tableau Reports/ Dashboards for a period of 2 months

04

4 Training on Tableau Dashboards Lump sum

5 Off site support for 1 year from acceptance

Lumpsum

Grand Total

In Words : _________________________________________________________________________

Note: The L1 bidder is evaluated on Grand total of the above items.

1A. Man-month Cost towards maintenance/modification of the developed Dashboard:

Particular Qty

(nos) Unit Rate

Rs. Taxes (Rs.)

Total Cost (incl. of all taxes) Rs.

Man-month cost 01 nos

The above costing in 1 A man month shall be considered only when the Department requires to have support services. This cost shall not be considered for evaluation. 1B. Annual Technical Support (for patches & upgrades) after 1 year:

# Particular

Qty (nos)

ATS in % for 2nd year

ATS in % for 3rd year

ATS in % for 4th year

1 Tableau Desktop Licenses (Perpetual) for development, testing and production

01

2 Tableau Server Licenses (Perpetual) 10

Date Signature of Bidder & Stamp

----13----

Annexure A

Introduction: The Commissioner & IG, Revenue and Stamps department intends to use Tableau Software for development of ‘Dashboard’ and generate various reports (textual & graphical) on various applications & services of the Department. The Department is in the process of procuring the required Tableau Server Licenses and intends to hire services of ‘2’ technical resources for Design, Development/Customization of the Dashboard and provide training to the Department officials on the use of dashboard for a period of 2 months.

Scope of Work: The brief scope of work is as below:

1. Supply, Install 1 Nos of Tableau Desktop Licenses (development, testing and production) and 10 nos of Tableau Server Licenses.

2. Deployment of ‘2’ technical resources for Design, Development/Customization of the Dashboard for a period of 2 months.

3. Design of various reports in Tableau 4. Onsite (5) Day Training to the Dept., Officials (along with User Manuals) 5. Offsite Technical Support for a period of 1 year.

Detailed Scope Work: The identified bidder should provide following services & undertake designing of reports mentioned below: At a high level the scope includes providing Business Analytics consulting services on design, setting-up and operate Tableau platform which includes:

1. Multiple Data Sources Connectivity. 2. Extracting Data set for required Reports. 3. Data marts in Common folder/server for User based Accessibility 4. Validating the queries. 5. Automate the Update of extracts 6. Architecture flow Diagram 7. Tableau server Installation 8. Load balancing 9. Tableau Desktop Installation

➢ Activities at Business Intelligence Server Level : (Indicative) 1. Deployment of tableau Reports 2. Site creations for Development, Testing, Production. 3. Project Creation for Different Departments 4. Creating Login Credentials for User 5. List of User Level Security. 6. Group Users Creation 7. Permission for different User, Sites, Projects, Reports, fields. 8. Basic Knowledge Transfer for End User.

----14----

9. Scheduling and Subscription Setup 10. Automate the Data updates, report Updates

➢ Activities for Development of Reports at Desktop Level ( Indicative)

• Data Flow Architecture

• Direct Data Sources Connectivity to ad-hoc Reporting

• Business requirements document

• Technical tool evaluation document

• Detailed design specification

• Integrated data warehouse documentation as per approved project plan

• Data repository, model specifications

• Scorecards, visualizations

• User acceptance test specification

➢ Reports/Dashboard to be developed ( Only Indicative)

1. Revenue report at Sub-Registrar Office (SRO), district, zone, state-wise views for revenues

2. Types of challans and cross-sectional views at SRO, district, zone, state-wise views for revenues

3. Types of tax and cross-sectional views at SRO, district, zone, state-wise views for revenues

4. Trend and seasonality for above units of views at SRO, district, zone, state-wise views for revenues

5. Office attendance report 6. Identify reasons for on/off at SRO, district, zone, state-wise views for revenues 7. Day start time at SRO office 8. Identify documents backlog, presented, pending 9. sub-register (unit), DO, DIG, IG hierarchy views at SRO, district, zone, state-wise

views for revenues 10. TAT Monitoring at SRO, district, zone, state-wise views for revenues 11. Pending Monitoring at SRO, district, zone, state-wise views for revenues

➢ Infrastructure health check-up of BI Server. ➢ Periodical System monitoring of entire workflow. ➢ Performance tuning based on the system monitoring report:

Training :

➢ Tableau basic and advanced and developer training should include the following:

• Introduction to Tableau tools

• Desktop level training

1. Connecting to data

2. Data aggregation

3. Date parts

4. Scatter plots

5. Blended and dual axis

6. Sorting

7. Reference lines

8. Trend lines

----15----

9. Forecasting

10. Filters

11. Context filters

12. Global filters

13. Sets

14. Groups

15. Bins

16. Hierarchies

17. Action between sheets

18. Aggregating and disaggregating the data

19. Functions (String, date, number)

20. Logical functions

21. Ratio

22. Usage of YTD

23. KPI

24. Parameters

25. Multi database sources

26. What-if analysis

27. Dynamic what-if analysis

28. Creating dashboards

29. Action between dashboards

30. Table calculations

31. Percentage of totals

32. Latitude and longitude

33. Default location/ edit location

34. Custom geo-coding

35. Filled maps, WMS maps and dual axis maps

36. Open street maps

37. Formatting the visualization

38. Labels and annotations

39. Titles and captions

40. Best visualization practices

• Server Training

1. User and content management

2. Roles and security

3. Single machine installation

----16----

4. Deployment checklist/ best practices to be followed for an onsite/ customer deployment (e.g. performance enhancement etc.)

5. Server UI Features and Commands

6. Embedding Tableau server in an existing web application

7. How to trouble shoot

➢ Other miscellaneous activities on the tool as per Department requirement.

Manpower Requirement:

The bidder should deploy 2 technical resources for a period of 2 months initially and if required the same may be extended.

The minimum qualifications of the resources are as below:

Education: BE/B Tech in CSE, IT, ECE or MCA with a total of 4 years experience

Experience: Minimum 2 years’ experience in application design & development in Tableau software.

Responsibilities of Department:

• Assign a project manager to work with identified bidder for coordination and will be responsible for providing required information and monitoring of the project.

• Department shall make available resources to assist with business questions, application construction, data modeling, database administration, and IT functions.

• The Department will also make available content experts to validate functionality, usability, and accuracy of results.

• Providing required IT infrastructure for deployment of software and development of reports/dashboards.

--o0o--