Fresh Online Grocery Ordering Website Project

Project Overview

Fresh Online Grocery Ordering Website is an online web application for automating the process of ordering grocery products from suppliers and paying for them in advance. Therefore, there is no need for the suppliers to wait for a long time and pay in cash at the time of delivery. This system also helps farmers to sell their products through this system.

The current Grocery Ordering system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this Online Grocery Ordering application is to provide an environment where the users will be able to order products from a supplier and pay in advance.

To what extent the system is proposed?

The proposed Grocery Ordering system automates the manual process of users the shop owners which can be used for ordering products from suppliers online and farmers visiting the shop with their products for selling and physically paying for the products with cash by introducing an online automated system that sends product requests online. The current system is not much efficient and can lead to a major waste of time as the supplier needs to wait for a long period. The main purpose to design this application is to provide an environment where users will be able to order products from a supplier and pay in advance.

Specify the Viewers/Public who is to be involved in the System?

The Viewers/Public that are mainly involved in this system include staff, suppliers, and farmers. The staff, suppliers, and farmers can also register to this system with valid information. They can buy/sell products and also include payments

List the Modules included in your Grocery Ordering System?

The system includes 4 modules. They are:

• Admin Module

Admin is the one who does the staff and supplier registration and approves or rejects the leave request of staff and farmer’s product request, publishing notifications to the users, fulfilling staff and farmer’s product requests, and can view and block and unblocking of existing users. Admin can do a secure payment for their products through the online payment system. Admin can also view their request status from Suppliers and notifications from the Staff. Admin can approve or reject the leave requests as well as admin can view the existing products and order the products and view the status of the ordered products.

• Staff Module

The staff can view the current stock and update the stock. After product stock reaches a critical value the staff can issue a notification to the admin. Staff can send leave requests and see the status of the requested leave and also
able to update their profile.

• Supplier Module

The suppliers can view and update their profile as well as their stock.
Suppliers can add new products and can view product requests send by shop owner/admin and process orders. Suppliers can get a secure payment for their products through the online payment system.

• Farmer Module

The farmer can send a request for selling their products through that shop.

Farmers can see the status of product requests send to the admin as well as can view and update their profile. Farmers also can get a secure payment for their products through the online payment systems and can also view their
request status and notifications from the admin.

Sequence Diagrams for the Project:

Farmer Supplier Sequence Diagram Online Grocery Ordering system Online Grocery Ordering Farmer Admin Sequence Diagram

Identify the users in your project?

The main users of this project include:

  • Admin who controls and coordinates the entire activities of the system including provisioning users to buy/sell their products and responding to requests from farmers.
  • Staff who manages the day-to-day activities of a grocery shop including updating seller stock and logging and maintaining transactions to and from the grocery shop.
  • A supplier who processes the order that was made by the admin.
  • The farmer who requests products online.

Who owns the system?

The owner of Online Grocery Ordering is the grocery shop in which the system is implemented. A system administrator is appointed by the organization for managing and coordinating the system activities.

The system is related to which firm/industry/organization?

Online Grocery Ordering is a grocery shop management system and it is associated with a grocery shop in which the system is implemented.

Details of the person that you have contacted for data collection?

Questionnaire to collect details about the project? (min 10 questions, include descriptive answers, attach additional docs (e.g. Bill receipts, certificate models) if any?)

1. Is there any discount streams available?
Several discounts are available for a range of products if the customers purchase products in a bulk range.

2. Is there any products available in your shop other than grocery items?
Yes, we also sell products including vegetables and fruits as well as sweets.

3. Is there any wholesale products in your shop available?
Yes, we provide products for wholesale.

4. Which among the products are most frequently sold out?
Sugar, cerials, vegetables.

5. How do you maintain the records of day-to-day transactions? What all features do you expect if this system gets automated?

6. How do you keep track of inventory?

7. How do you transport your groceries?

We use paper bags for the transportation of products.

8. What are the pricing strategies that you follow for selling your products?

It depends on the market value/price.

9. Is your supplier responsible for restocking?

Yes, our supplier is responsible for restocking, if the products meet their time limit.

10. How do the details and contacts of suppliers maintained?

The details and contact of suppliers are maintained in records physically.

Download the complete Grocery Inventory Management System PHP & MySQL Project.

Travel and Events Portal Website Development

Project Statement:

Need to develop a travel and events portal website to provide users different tours and travel packages depending upon their interests.

It will allow users to register and search through various tours which will be displayed on the website. Tours related info will be managed by admin panel in the back end and will be dynamic.

Search will also be location-based and package based. Admin panel will be provided to manage locations, regions, packages, and tours as per search are done by the user.

Once a user searches through the related info he or she will request a quote and email will be sent. Either user or travel admin will follow up.

The request form will capture all important info like Email, name, number, etc. If hotels are also being planned then we will also include a related field in the request form. 

Basically, we will manage it basing:

Destinations
Packages
Places to enjoy
Weekend Plans
Recommended Tours 

It will basically have two logins:

Admin and User.

Admin will manage all back end data. Will update tours, packages, destinations, locations, weekends plans, etc.

These all will be seen by the user in the front end. So the project will be basically divided into Front end website and back end admin panel for managing data.

Website Structure:


1. Application & General Site:

Welcome screen with the option to register/sign in
Terms & Conditions
Disclaimer
Privacy Policy

Blog
Stories
Brochure
Company Profile
About Us

2. Admin pages:
Admin panel login and forgot password option

Manage Enquiry Requests 

Manage Blogs
Manage tours
Manage packages
Manage Destinations
Manage weekend plans
Manage Recommended tours
Manage Customers 
Manage Bookings 

3. Quality Control:

At the end of the development cycle, you will have a properly functioning and quality assured site.

By ensuring implementation of the following points we maintain quality in the products we deliver.

  • W3C validated semantic HTML code
  • Well commented and indented PHP code
  • Proper escaping of user entered data to prevent XSS, CSRF and other security issues
  • Optimized database tables
  • Minified CSS, JS and optimized images for faster loading
  • Implementation of meta tags, descriptions, open graph tags for help in SEO

4. Search Engine Optimization:

All the below points will be implemented for making the site on page SEO ready:

Search Engine Friendly Code i.e. H1-H6 and Meta Tags, ALT Tag for images, etc.

Page Title and Page description

sitemap page

robots.txt

DIV Based Code (Table Less)

Friendly URLs, such as www.domain.com/about, etc.

Keywords, Meta Description Placement

Custom Design 404 Error Page

Organized and Commented Code

Faster website loading and good speed score

SL NO

Task / Modules Page

1

Initial Planning and Design

2

Primary Database Design

3

Responsive HTML Design of All Pages

 

Front End Section

 

Landing activity for the welcome screen along with login/register option
Terms & Conditions
Disclaimer
Privacy Policy

Blog
Stories
Brochure
Company Profile
About Us

Search Criteria
Packages selections
Destination selections
Places to enjoy selections
Weekend Plans selections
Recommended Tours selections 

 

Admin Panel 

 

User management
Tours, Destinations, Places to Enjoy, Weekend tours management

Settings
Manage categories and subcategories

Manage bookings 

Manage blogs and Enquiry requests  

 

Testing & Bug Fixing 

 

Web service, DB Design, Architecture, and deployment 

Related Projects on Travel & Tourism below:

Crystal Market E Kart Web Portal Project

Abstract

This concept basically related to a portal which will allow dealers or vendors and customer linking on a common platform. This portal will be a web platform wherein vendor will register and add crystal products. They can also differentiate and highlight special crystals as per horoscope ( as they have a huge market). Once crystals are added they will be available for sale which can be searched and added to kart by customers for buying. Portal will provide an easy to use and responsive website.

Project Description in Brief:

The requirement will be to develop an admin module which will be used to sell products, register vendors, register customers, cart functionality and related crystals functionality. We can also manage coupons from admin panel. This will also involve web service / API which will communicate with Website front end and database and save data securely via admin panel.
We will also have employee management wherein executives delivering the sold products to customers will be registered and in turn, will track the delivery part. The application will involve order management and delivery. This will involve executive, the order created and tracking id.
The application will have an informational part too like About US, Terms & conditions, Privacy policy etc which basically will be static pages.

User Types: Admin, Customer, Employee logins (no vendor login as discussed)

  • Admin will have access to all modules in the web and can monitor everything in the application.
  • Customer / Buyer will have access to crystal products view and can browse through and access offers and then finally add products to the kart and order the same.
  • The employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only
  • Vendor / Seller is basically related to sellers who will register themselves, add their products to the admin panel and the added products will be marketed via the website.

Modules:

Users Modules: Will involve login, registration and log out as the basic functionalities. Users will also have My basket functionality to manage the crystal products added to the kart. My orders will deal with the story of transactions and orders for a logged in and registered customer. My profile will have edit, delivery address manage option, change the password and other details that are necessary.

Admin Panel: Admin being an important module will manage delivery executive employees and their delivery history as it will be linked to order and delivery management. Customers also will be managed by the admin panel. Vendors will register to the application and we can manage vendors via admin panel. Registered vendors will be able to add their products which will be advertised for sale in the crystal market portal. Admin will most importantly manage the categories and subcategories that are involved in adding products and then their sales via the portal. It will also manage the filters that will be provided for searching for various types of crystals.

Kart Module: This Module actually will handle the addition of crystal products which are anticipated to be ordered by a viable customer.  It will be then linked to order management and delivery tracking.

Delivery / Order tracking: It will basically show which order is linked to a particular executive as admin will assign it to a particular executive. Complete delivery status can be tracked in this module. As per order management is concerned once a product is confirmed in kart it will be transferred to order tracking as an order id is assigned to it. And then a delivery executive is assigned an order. This workflow actually provides a flexible tracking system.

Future Enhancements:

  • We can come up with SMS alerts for delivery tracking and registration messages.
  • We can provide reports module with a different type of reports for admin login related to sales, order and delivery reports.
  • We can also introduce a comprehensive invoice module too.
  • Add coupon management system via admin panel

Technology to Use

  • HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior
  • Bootstrap / Angular JS will be used for making the site responsive and as a framework.
  • PHP (CodeIgniter, CakePHP, Phalcon or Laravel) OR .Net with framework
  • MySQL
  • SQL Server

Hardware Requirements:

Intel Core processor
RAM 4GB and Above
HDD 100 GB Hard Disk Space and Above
64 or 32 bit OS Windows 8 and above

Grocery Ekart Management Real Time Project

Project Understanding:

The reference website link provided to the developer and also need few clarifications and inputs from the customer side specifically to understand the project flow. In this document, we present our understanding of what needs to be accomplished in the project along with the budget and time estimation.
Reference site link: https://www.bigbasket.com/  (checked only to have an idea regarding the features that will be there in the app)

Project Statement:

→ To design and develop an ekart marketplace and mobile app for Android platform which will provide an option to browse through various household groceries and related products.

Project Description in Brief:

The requirement is to develop and implement a fully functional ekart module which will allow customers register and browse through all products online. They can add products to kart and order them. It will also involve admin panel to manage the addition of products, editing details related to a product. It will manage payment gateway also. We will also provide an option to manage offers via offer management module in the admin panel.

1. Admin Module
2. Kart Module
3. User Module
4. Payment Gateway Integration (Let us know which all need to be integrated like Paytm, PayPal, VISA MasterCard etc)
5. Coupon / Offers Management
6. Employee and Executive Management
7. Order Management
8. Review and Rating Management
9. About Us
10. Careers
11. Privacy Policy (Client needs to provide us the info related to terms and conditions)
12. Terms and Conditions (Client needs to provide us the info related to terms and conditions)
13. Blogs (Let us know if this is needed)
14. Logo design
15. Notifications (Email and SMS , client need to purchase SMS package and it will be integrated)
16. Delivery management

Quality Control:

At the end of the development cycle, you will have a properly functioning and quality assured site. By ensuring implementation of the following points we maintain quality in the products we deliver.

➔    W3C validated semantic HTML code
➔    Well commented and indented PHP code
➔    Proper escaping of user entered data, the addition of captcha to web forms for preventing XSS, CSRF and other security issues
➔    Properly Optimized and indexed database tables for speed and consistency
➔    Minified CSS, JS and optimized images for faster loading of the site
➔    Implementation of meta tags, descriptions, open graph tags for help in SEO

User Types: Admin, Customer, Employee logins (no vendor login as discussed)

Admin will have access to all modules on web and can monitor everything the application.
Customer will have access to products view and can browse through and access offers and then finally add products to the kart and order the same.
Employee is basically the delivery executive login who will actually manage the deliveries and will have access to the related delivery management screens only

Module Details:

Web development: 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)
10 MD
       2. Common Admin panel:
Admin login features
Manages Employee executive delivery history
Manage Customers
Manage Products addition to applicationManage Reviews and Ratings in applicationManage Coupons and Offers in applicationsManage new offers (to be displayed in splash screen )
About Us submissions
Blogs management (if needed)
Categories / Sub-categories management
Brand management
Filter management
Location Settings
20 MD
       3. Designing:
Homepage design with splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including smtp configurations), Careers, Privacy Policy, Terms & Conditions , Blogs design , Individual page designs , Menus and Submenus, Location selection design
15 MD
      4. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option , a grid to view and manage all deliveries for executive login , option to update payment status for orders delivered 5 MD
      5. Testing, bug fixes, changes from client feedback 12 MD
      6. Total 62 MD (approximate)

 

Mobile: (2 Android Apps)

User App: Will follow all modules mentioned above except admin panel as it will be maintained only on the web.

Executive App: Will have screens designed for tracking deliveries, managing the delivery status, update the delivery and payment status 

SL NO Type Time Estimation (in MD)
1. Users Module:
Login / Registration / Logout (Sign In with Google / Facebook social logins)
My Basket ( This actually deals with products being added to kart and manage it)
My Orders  ( This deals with the history of  transactions  and orders for a logged in customer)
My Profile (Edit Profile , Delivery Address mgmt, Change Password , Email Address)
15 MD
        2. Designing:
Homepage design with a splash screen, Banner with sliders and effects, offer views, products display designs, admin panel design, About Us (including SMTP configurations), Careers, Privacy Policy, Terms & Conditions, Blogs design, Individual page designs, Menus and Submenus, Location selection design
15 MD
     3. Delivery management: status of products delivery  and related notifications, Pending / Confirmation option, a grid to view and manage all deliveries for executive login, option to update payment status for orders delivered 10 MD
     4. Total 40 MD (approximate) + 10 MD for testing and feedback changes

 

Technology to Use

Design and Markup

– HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior

– Bootstrap / Angular JS will be used for making the site responsive and as a framework.

Server-side language (anyone can be used depending upon your preference)

– PHP (codeigniter, CakePHP, Phalcon or Laravel)

Database Software (anyone can be used depending upon your preference and server setup)

– MySQL

– SQL Server

Android: Java  (Android v 5.1 and higher)

Time frame for execution of the project ( Total 112 Days  approximate)

Designs & Web Services : 30 Days

Admin Panel :- 20 Days

Android App: 40 Days

Testing: 22 Days

Online Auditorium Booking Management Application

Project Understanding:

In this document, we present our understanding of what needs to be accomplished in the project along with the budget and time estimation. Reference site link: https://1000projects.org/online-seminar-hall-auditorium-booking-system.html  (checked only to have an idea regarding the features that will be there in the app)

Note: This link is basically for academic purpose only and cannot handle the live project activity.

Project Statement:

To design and develop an online Auditorium booking application which will allow sunshine hospital employee users and external users also to book auditorium as per their expected event schedules. Any user internal or external has to raise a request for auditorium booking and it will be approved by admin. A logged in user can check availability date wise and hourly wise too. Will have the option to provide the hourly availability info too while raising the request. Once approved an email notification can be  sent over confirming the booking, we can also send SMS notification (client needs to have an SMS package integrated for that)

Situation:

The proposal describes a solution that enables to solve specific auditorium availability issues so as to avoid confusion at the occupancy of a party at any specific time frame.

User Types: Admin, User, Customer

Admin will basically be able to access all the modules in the application and will have the option to approve a booking request raised by a user or customer.

User is an internal sunshine hospital employee who can log in and request for auditorium booking for a specific date and time interval.

Customer has to first register and once approved can log in and raise a request for auditorium booking as per the scheduled event for any meeting.

WorkFlow:

Admin will manage auditorium booking via a booking UI which will allow him or her to observe the availability and unavailability of the auditorium for any date and hourly time interval also

→ Admin will also manage user logins, will have the option to deactivate any user

→ An external user has to first register and his or her login will have to be approved by Admin and then can log in

→ Once approved external customer can login and raise a request for auditorium booking

→ Admin can deactivate any customer login also

→ Managing Booking activity will be done via a web service logically at the backend

→ An easy to use UI will be provided for checking the availability of auditorium

→ Application will have the option to register users on the basis of their departments as this part also needs to be managed (client needs to provide us departments related info so that we can manage them at backend)

Module details:

S. No Type Time Estimation (in MD)
1 Landing Activity (Splash screen / Login/ Registration Screen) 5 MD
2 Booking Module 10 MD
3 Admin Module :
Dashboard with notifications
User management
Customer Management
Booking management
Booking History
Department management
8 MD
4 Customer Module :
Registration
Dashboard
Notifications
3 MD
5 Web service 10 MD
6 Testing 5 MD
7 Total 41 MD approximate
Costing (Includes Designing, Web development, Web Service, Testing)

 

Technology to Use

 Design and Markup

– HTML5, CSS3, JavaScript & jQuery for markup, design and interaction behavior

– Bootstrap / Angular JS will be used for making the site responsive and as a framework.

– A server-side language (anyone can be used depending on your preference)

– PHP (CodeIgniter, CakePHP, Phalcon or Laravel)

Database Software (anyone can be used depending on your preference and server setup)

– MySQL

– SQL Server

Download Sample Seminar Hall booking System PHP project.

Complete Hospital Management System Synopsis

The main aim of developing this Complete Hospital Management System is to provide best software to Hospitals to provide end to end solution for various departments. We have divided the Complete application into 7 major modules, Those are listed below:

1. Administrator
2. Patient Management
3. Materials Management
4. Laboratory Management
5. Employee Management
6. Financial Accounting
7. Operations Management

Each Module is divided into Sub Modules:

Administrator Module

In This module only admin people entered through Password and able to change or update as well as assign the responsibility to anyone. This module is further sub-divided into Doctor Registration, Employee Registration, Appointment Scheduling, and Hospital Administration

Doctor Registration:- In this sub-module all the information regarding the doctor are stored ex. Doctor ID, doctor name, highest qualification, specialization, as well as availability.

Employee Registration: -In this sub-module all the information regarding the employee is stored. Ex. Employee ID, Employee name, Employee address, Employee joining date.

Appointment Scheduling: – In this sub-module all the information regarding the appointment to the patient with the doctor are stored.

Hospital Administration: – In this sub-module all the information regarding Hospital Details

Patient Management:

In this module, all the information regarding patient are stored. This module is divided into various sub-modules. Inpatient Registration, Out-Patient registration, Itemized Patient Billing, Electronic Medical Records/Clinical History, Online Registration.

Materials Management

This module contain information related to complaint, equipment, Assets, Stock & others items maintenance management and keeps track of AMC of the equipments and the services offered by the vendor / manufacturer. This module is sub-divided into General Store Management, Inventory Management, Pharmacy Management, Blood Bank Management.

Laboratory Management

The Laboratory module is a sophisticated computer data management system designed to handle a large amount of data quickly and efficiently for all Pathology Laboratory disciplines, Clinical Pathology, Microbiology, Hematology, Serology, Cytology, Radiology, Biochemistry, and Neurology.

Employee Management

In this module, all the information regarding Employee is soared. This module is divided into various sub-modules; Attendance Management, Payroll Management. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about different shifts and duty timings, hacking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability. The employee management system incorporates attendance for staff, calculation of working hours, and daily, weekly, monthly and yearly analysis. The application accommodates all aspects of scheduling by assigning and maintaining records about Different shifts and duty timings, checking for scheduling conflicts with patient’s schedule, physician schedules, equipment availability and room availability.

Financial Accounting:

• Cash Book
• Bank Book
• Ledger Book
• Receipt/Payments
• Journal Voucher
• Insurance
• Invoice
• Purchase Orders
• Records

Operations Management:

In this module, all the information regarding all the available OPD. This module is sub-divided into Housekeeping, Ward Management, Bed Management, Operation Theater, Manager Assistant, Doctors Workbench, and Nursing Workbench.

Inventory Management for Marriage Cards Dealer

Inventory Management for Marriage Cards Dealer involves control of orders, storage and use of components used by a company in the production of items which it sells.
It also involves controlling of quantities of finished products for sale.
It involves creating a purchase plan which will ensure availability of items whenever needed, neither too much nor too little.
It is the supervision of non-capitalized assets stock items in the sense supervise the flow of goods from manufacturers to warehouses and from these facilities to point of sale.
We also provide different types of reports

Inventory Management for Marriage Cards Dealer

Basic Home - Dashboard layout Basic Home - Dashboard layout1 Basic Modules in IMS Sales & Sales Order Purchase order List IMS ArchitectureGeneral :

General actually provide option to access Dashboard /Home Page and Options.
It also provides an easy access to important features of the application.
It provides extra feature list like if any back up options that can be included in the application.

Sales Module :

Sales module allows user  to raise new sales quote.
It allows maintaining sales order list.
This module will  allow user  to generate Sales order easily.
It allows to have all info related to Unfulfilled Orders, Fulfilled Orders, Unpaid Orders and Recent Orders.
This module allows maintenance of  Customer, Addition of customers, their order history, payment history etc.

Purchase Module :

Purchase module allows user  to raise new sales order .
It allows maintaining purchase order list.
It allows use to have all info related to Un-received Orders, Unpaid Orders, and  Recent Orders.
This module allows maintenance of  New Vendor, Vendor list, Vendor Products, Payment history.

Inventory Module :

Inventory module allows user  to Add new product and then maintain product List. It also maintains Product categories and Product Pricing.
It allows user to see  current view of all of the stock and track the movement history.
This module allows maintenance of  New Vendor, Vendor list, Vendor Products, Payment history.
This module  also allows work order maintenance too.

Reports Module :

Reports are user friendly and the parameter based design can be done as per user requirements.

Options Module :

Options will include email sending from app, user advance authentication, back up reports option etc.

School Management System Real Time Java Project

School Management System is a Java based Windows Application developed for different Schools and colleges.

Modules included in this project are below:

  1. Admissions Module
  2. Attendance Module
  3. Examinations Module
  4. Staff Management Module
  5. Library Module
  6. Fee Management Module
  7. Accounts Module
  8. Reports Module

Output Screens of this project are below:

Login Page:

Admin and School Management can login through this login Page by entering user name and password

School Management System Login Page

Home Page View

After logged into the system, admin can have able to see and manage all menu options like admissions, attendence, examinations, staff, library, fee, accounts and reports.

Basic page where admin can add student information, Parent Guardian and Academic details

Home Page View
Admissions Page View

Adminssions page has several fields like Admission number, Date, First Name, Last Name, Father Name, Mothers Name, Date of Birth,  Gender, Class, Section, Contact Number, Identification Marks, Fee Perticulars, Date of Payment, Remarks, etc..

Adminissions Page View
Attendance Page View

Attendance Page View
Examinations Page View

Examinations Page View
Staff Management Page View

Staff Management Page View
Library Page View

Here we can manage Library book information with the help of availability of book and issues books.
Book list contains book name, Author, Total number of books, number of books issued, number of books available

Library Page View
Fee Management Page View

Here we can manage all fee details of the students, Can manage & update all students fee details using the below fields:
1) Fathers Name
2) Mother Name
3) Class
4) Section
5) Contact Number
6) Total Fee
7) Paid Term Wise
8) Mode of Payment
9) Payment Due

Fee Management Page View
Accounts Page View

Welcome to the Accounts Page Section:
In this accounts section we can able to manage money related info for books, accesories, salaries and other miscellaneous details

Accounts Page View
Reports Page View

Welcome to the reports Page Section:
Here reports can be generated by using the search option for selecting the class, Name, Roll Number/Lecturer ID, Admission Number or using the search box for internal search.
Once the Search operation is done, we can find the reports to view, upload and print purpose.

Reports Page View

SAP XI/PI Training & Real Time Projects

 SAP XI/PI Training CATALOG 

In this course you will explore the architecture of SAP PI, understand different components of PI. 

At the end of this training you would be able to 

  • Understand Key Integration Concepts
  • What is SAP PI
  • How SAP PI Helps in Integration
  • Understand SAP PI Features and Functions
  • Understand SAP PI Monitoring Features
  • How Messages are processed in SAP PI
  • Develop Interface using SAP PI (Message Mapping)
  • Configure different Adapters

Overview:

  • Introduction to SAP Process Integration
  • Overview of SAP NetWeaver Architecture and Features 

The System Landscape Directory (SLD) concepts:

Landscape:

  • Technical Systems
  • Landscapes
  • Business Systems

Software Catalog:

  • Products
  • Software Components

Development:

  • Name Reservation

Manage Name Reservations for NetWeaver Development

  • CIM Instances/CIM Classes

View and Maintain data on CIM level 

Enterprise Services Repository:

  • Namespace Definition 

Interface Objects

  • Data Type
  • Message Type
  • Service Interface (Message Interface)
  • External Definition
  • Context Object
  • Data Type Enhancement
  • Fault Message Type 

Mapping Objects

  • Message Mapping
  • Operation Mapping (Interface Mapping)
  • Mapping Template
  • Imported Archive
  • Function Library 

Adapter Objects

  • Adapter Metadata
  • Communication Channel Template 

Version Creation

  • Change List 

Work Areas

  • Software Component Version
  • Namespace 

Process Integration Scenario Objects

  • Process Integration Scenario
  • Action
  • Integration Process
  • Monitoring Process
  • Step Group
  • Alert Category 

Design Menu – TOOLS options

  • Import External Definitions
  • Import Design Objects
  • Export Design Objects
  • Transfer Design Objects
  • Find Transports
  • Java Proxy Generation 

Design Menu – Environment options

  • Integration Builder (Configuration)
  • Cache Notifications
  • Clear SLD Data Cache

Integration Builder – Integration Directory 

ICO: Integrated Configuration Object

Collaboration Profile:

  • Party

Communication Component

  • Business System
  • Business Component (Business Service)
  • Integration Process
  • Communication Channel
  • Process Component

Collaboration Agreement:

  • Sender Agreement
  • Receiver Agreement
  • Direct Connection
  • Integrated Configuration 

Configuration Objects:

  • Receiver Determination
  • Receiver Rule
  • Interface Determination
  • Value Mapping Group 

Administration:

  • Configuration Scenario
  • Folder
  • Change List 

Configuration and Monitoring

Runtime Workbench

  • Component Monitoring
  • Message Monitoring
  • End-to-End Monitoring
  • Performance Monitoring
  • Index Administration
  • Configuration
  • Alert Configuration
  • Alert Inbox
  • Cache Monitoring 

Adapters:

  • File
  • JDBC
  • JMS
  • MAIL
  • RFC
  • SOAP
  • IDOC
  • HTTP
  • BC
  • CIDX
  • RNIF
  • RNIF11
  • WS
  • Marketplace 

Descriptive Information of PI message processing: 

Messaging:

  • SAP PI Pipeline Example for an Asynchronous Scenario.
  • Introducing the scenario
  • PI messages: structure and transfer to the pipeline
  • Logical Routing
  • Mapping and technical Routing
  • Message mapping

Monitoring:

  • Runtime Workbench
  • Runtime Workbench Overview

BPM:

  • Business Process Management
  • BPM Overview
  • ccBPM: Designing and Configuring Integration Processes
  • BPM Runtime

DEMOs On:

Scenarios:

  • File to File (XML),
  • File to File (FCC),
  • File to IDoc/RFC,
  • RFC/IDoc to File,
  • JDBC to File
  • JDBC to RFC
  • File to RFC
  • SOAP to PROXY
  • PROXY to SOAP
  • HTTP to PROXY
  • BPM Scenario

SAP BW Real Time Projects and Scenarios

BW101 – SAP BW Starter Kit

Online Course Details

What should you expect to learn?

Introduction to DATA

  • Understanding data from an IT perspective
  • BIG DATA – a small discussion

Data storage and retrieval basics in IT systems

  • Data Storage: Files to Tables
  • Tables > Fields & Tuples > Datatypes
  • Building Relationships with data(table joins)
  • The ER model

OLTP and OLAP

  • OLTP system basics
  • OLAP system basics
  • OLTP Vs OLAP (differences and complications)

Introduction to Data-Warehousing

  • Datawarehousing techniques and methodologies (a discussion)
  • Datawarehousing Concepts

The STAR Schema
Snowflake Schema
The Extended STAR schema

Introduction to SAP Business Warehouse

  • Landscape & Architecture
  • Dismantling the Warehouse – Top down approach

Building the SAP Business Warehouse

  • Building Blocks of SAP BW

InfoAreas / InfoObjects / DataSources / PSA / DSOs / InfoCubes / Transformations

  • Defining your Business Warehouse

Business definition / Identification of Business Data / Defining Business Reports

  • Start Building – Discuss Why / Where / When / How for each of the items below

Create InfoArea

Create InfoObectCatalogs

Create InfoObjects

Create Datasources(flat file)

Create DSO(s)

Create Cube(s)

Transformations to the InfoProviders

Load Master and Transaction Data from Flat files

New: Surrogate IDs and Dimension IDs – A discussion

New:Attribute Change Run

                                New: Implement Delta mechanism (flat-file to DSO to Cube)

New: Create a simple Bex report based on the InfoProviders created so far

Explore and Experiment, then Discuss the Building Blocks

  • Explore types, options, settingsand usage scenarios

InfoObjects

InfoProviders

InfoCubes

DataStoreObjects

Multiproviders

RemoteCube

Transformations

DTPs

SAP Modules and their interaction

  • Source Systems
  • Datasources in the context of source systems
  • SAP ECC and ERP an important discussion
  • Understanding SAP FI and SD from a BW reporting perspective
  •  Familiarize yourself with FI & SD tables and Datasources

SAP Business Content

  • Identify Business Content Objects for FI & SD
  • Identify Datasources delivered by SAP for FI & SD
  • Discuss the Business Content objects discovered
  • Install Standard objects and activate them

Filling your Data Warehouse with SAP Business Data

  • Extract FI data using Standard Extraction

Master Data Extraction

Transaction Data extraction

  •  Extract SD data using LOS Extraction

                                Understanding LOS extraction benefits and necessities

LO Cockpit Overview

Data Extraction Full Load and Delta mechanisms

  • A note and an exercise on Generic Extraction

Maintaining your SAP Business Warehouse

  • Administering the InfoCubes
  • Administering the DSOs
  • PSA Maintenance
  • Automation: Creating and Monitoring the Process Chains

Explore SAP BW Data

  • BEx Query Designer
  • Query Design Elements (RKFs, CKFs, Variables, Conditions, Exceptions etc)
  • RRI

Web Application Designer

  •                 BEx Analyzer
  •                 Query Monitor (RSRT)
  •                 Build a Complex Report with ageing, variables, RKFs and CKFs etc

Performance Optimization

  • Understanding Performance Top-Down and Bottom-Up
  • Investigating Performance – The Approach
  • Load Performance Optimization

Building it right
Re-building it if required

  • Query Performance Optimization

BW Aggregates
Partitioning
BW Indexes
Your Eyes and Ears – BI Statistics
BI Accelerator (meet its Big brother SAP HANA)

  • Advanced Data Warehousing(Discussion and Debate on usage and pros and cons)

                Study of Internal Structures and their workings

                                Cubes and Dimensions (SIDs, DIMIDs)

                                DSO mechanics (Delta Management with Active, Change-log tables)

                                InfoSets& Virtual Providers

                                Time Dependent Master Data Management

                                Extracting Hierarchies for ECC Sets (GS01, GS02, GS03 etc)