• Home
  • Services
    • SharePoint Corporate Portal
    • Custom development
    • System and application integration
    • Corporate mobile apps
    • Analysis and design. Quality assurance
    • Industrial solutions
  • Solutions
    • SharePoint Corporate Portal
      • Digital docflow
      • Services and applications
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Generate reports and documents
    • Business Application Framework (Devexpress)
      • CRM-client: trading and stocks
      • POS-network: monitoring and control
    • Industrial solutions
      • Process dispatching
      • Material flow control
      • Process deviations control and alarming
      • Industrial enterprise portals
    • Generate and publish docs, reports and business-trends
  • Projects
  • Customers and partners
  • Team
  • Contact us
ISDK - Custom Development, SharePoint Solutions, Devexpress Suite
  • Home
  • Services
    • SharePoint Corporate Portal
    • Custom development
    • System and application integration
    • Corporate mobile apps
    • Analysis and design. Quality assurance
    • Industrial solutions
  • Solutions
    • SharePoint Corporate Portal
      • Digital docflow
      • Services and applications
      • Staff directory and orgchart
      • Helpdesk
      • HR-services
      • Generate reports and documents
    • Business Application Framework (Devexpress)
      • CRM-client: trading and stocks
      • POS-network: monitoring and control
    • Industrial solutions
      • Process dispatching
      • Material flow control
      • Process deviations control and alarming
      • Industrial enterprise portals
    • Generate and publish docs, reports and business-trends
  • Projects
  • Customers and partners
  • Team
  • Contact us

Auto Dealer. Integration, Reporting and BI

Customer

Group of companies, which includes 5 official dealers of leading car brands. Company sells new and used cars

  • CHALLENGE and objectives
  • Solution
  • Results
  • Screens

Company top management had a need for reporting and BI system for each of its divisions (new car sales, used car sales, service) with the ability to get detailed info per each brand (car manufacturer). Such system would allow transparency and quality of management decisions.

First phase was about building unified data model and automating creation of 7 financial reports. Total scope of work including various views and details was about 20 different forms. Development of those reports required integration of data from internal accountant databases.

Second phase was about moving all reports to new system based on internal SharePoint portal (free Foundation edition) and training finance department specialists in building their own complex reports with different slicing and data depth.

Third phase was about configuration of sales and costs forecasting and analysis tools and building tools for plan and actual analysis for past periods.

Pilot project achieved the following goals:

  • Development of data model for the following areas: finance, sales, including data per division and per brand, HR (payroll)
  • Connecting of the following data sources: 1C Accounting, 1C HR, internal sales databases for each brand division
  • Development of unified procedures and business rules for data integration and aggregation
  • Automation of document creation – periodical and on user request reporting and BI generation
  • Implementation of costs forecasting module

Pilot module (its user layer) was developed as a component of SharePoint portal. However, technical implementation is platform-independent and this module can work as standalone Web application.

Project results are as follows:

  • Development of 4 key analytical reports and 15 supporting forms with different data slicing and depth. These reports were put into pilot production;
  • Before reports were generated once in a month at a certain date. Now company management has an analytical tool which is accessible on-line and allows building analytics for any data with any data slicing and depth (based on defined data model);
  • Development of forecasting analytical tools for sales and costs of service;
  • Time saving for report generation of about 80 man-hours of employees per month
0
Number of key analytical reports
0
0
+
Number of additional detailed forms
0
0
x
0
0
0
Reports available on-line and allow building analytics for any data with any data slicing and depth
0
0
Time savings per month (man-hours)

Project attributes

Services
Analysis and design, Integration, Outsource development
Solutions
Reporting and analysis, SharePoint
Industry
Auto Dealer
Technology
1С, SharePoint, Web Services
logo

“The only way to do great work is to love what you do” - Steve Jobs

Search on the topics

.NET Framework 1С Ajax Apache JMeter ARIS ASP.NET ASP.NET MVC Bootstrap Business Connectivity Services DevExpress DevExpress XAF DevExtreme ESB Google Geoservices Google Map InfoPath Java Message Service JavaScript JQuery Knockout.js Knockoutjs Microsoft Azure MS Active Directory MS SharePoint MS SQL MS System Center Nintex Forms Nintex Workflow nopCommerce QlikView Reporting Services SharePoint Sharepoint Search Sharepoint workflow Telerik UML Visual Studio Web Services Yandex maps

Projects

https://isdk.pro/wp-content/uploads/photo_2018-04-12_12-35-59-150x150.jpgE-Commerce Omni-Channel
https://isdk.pro/wp-content/uploads/Enterprise-Corporate-Portal-150x150.jpgEnterprise SharePoint Portal. HRM-Trainings
https://isdk.pro/wp-content/uploads/hr-portal3-150x150.pngAuto Dealer. HR Portal – Request Approval Services
https://isdk.pro/wp-content/uploads/Analitika-otchjoty-BI-2-150x150.pngAuto Dealer. Integration, Reporting and BI
https://isdk.pro/wp-content/uploads/Planshet_Glavnaja_small600-150x150.pngTelecom. Integration and Mobile Solutions. Manager Dashboard – Tablet App
https://isdk.pro/wp-content/uploads/database-google-maps-1-150x150.pngReal Estate. Property Geo-Search Database
https://isdk.pro/wp-content/uploads/Analiz-Proektirovanie-Integracija-2-150x150.pngOil&Gas. Energy Saving Program. Analysis, Design & Integration
https://isdk.pro/wp-content/uploads/Razrabotka-testirovanie-na-zakaz.-telekom1-1-150x150.pngTelecom. Development and Testing of Modules for RF Equipment Control System
https://isdk.pro/wp-content/uploads/direct-sales.-auto-attendance.-testing-and-qa-150x150.jpgDirect Sales. Auto-Store Kiosks. Functional and Stress-testing
https://isdk.pro/wp-content/uploads/Screen_ipad1-150x150.pngFinance. Deals Database and Analytics. Web-Site and Mobile Version
https://isdk.pro/wp-content/uploads/2017/04/2-600x400-150x150.pngMachinery. SharePoint Enterprise Portal. HRM. Trainings
https://isdk.pro/wp-content/uploads/2017/04/site1-600x400-150x150.pngMachinery. SharePoint Enterprise Portal. HRM Reports

Contact us

  • Russia, Moscow: Butyrskaya str. 62
    Latvia, Riga: E. Birznieka Upisa 21
  • +7 (495) 720-40-26, +37127869927
  • info@isdk.pro
  • https://www.isdk.pro
   www.isdk.ru (russian version)
ISDK Information Systems ©2010-2017
All rights reserved.