PowerBI

4


Published:

Categoty:

Project: PowerBI

Data start: 26 Aug 2016

Data end: 24 Nov 2017

 

Business challenge

Create technology for transforms company’s data into rich visuals for you to collect and organize so you can focus on what matters to you.

Scope of services

Dedicated team of 4 developers

Technologies

  • ASP.NET
  • Multitenancy
  • business intelligence
  • WCF

Results

The developed solution work under the IIS and under Apache web server. The architecture is developed in the way, which will allow in future incorporating cubes handling. The architecture is developed in the way, which enable deployment on the cloud with multitenancy provision.

The software architecture is create in the way that a single instance of software runs on a server and serves multiple tenants. A tenant is a group of users who share a common access with specific privileges to the software instance. With a multitenant architecture, a software application is designed to provide every tenant a dedicated share of the instance – including its data, configuration, user management, tenant individual functionality and non-functional properties. There is a resources protection implemented in the system. User who did not pass the authentication procedures cannot get access to the reports, models, views and templates

Application supports connections to the following list of data sources:

  • Microsoft SQL Server Standard/Enterprise/Express;
  • Oracle;
  • MS Access db;
  • MS Excel.

Additionally it is possible to connect to following data sources by using Standard configuration from menu and installation additional connectors or additional system configuration:

  • MySQL;
  • SQLite;
  • PostgreSQL;
  • DB2;
  • Sybase;
  • Informix;
  • Firebird;
  • Microsoft SQL Server Analysis Services (SSAS).

Functionality:

  • Implementation of the users authentication (user roles, access and security is elaborated more in the design document).
  • Possibility to create Repository from Multiple Database source.
  • Possibility to create reports and store them on the web-site (create Repository from reports and multiple database source).
  • Possibility to create models of the reports (using tables, pivots (optimistic case), charts, text) (ability to connect to multiple database simultaneously).
  • Add/remove/Edit data sources (include joins) (adaptors to all known major database and file types).
  • Ability to connect to multiple database simultaneously.
  • Ready adaptors to all known major database and file types.
  • Possibility to create pivot tables.
  • Report templates repository.