Data Insights

An application that allows you to get better insight of your data by building reports, charts, and dashboard. You can query data from data sources, currently Microsoft Sql Server is supported.

Goals

• Make it easier to data mine and get data insights.
• Allow users to easily, and quickly build reports and charts.
• Give organizations the power to quickly build flexible reports and charts to visual their data.

Roadmap

The project is currently in very early stages.

The following has been developed:

1. Create/Update projects.
2. Create new data source.
3. Create new data connection to a Microsoft Sql Server, and query tables and columns from the schema, and import to the data source.

The following are ideas for v1:

1. Create report builder interface and backend.
2. Create chart builder interface and backend infrastructure.
3. Add support for multiple users and security. Ex: certain users can build projects, and certain users have access to only some reports.
4. Add support for export reports and charts to different to platforms, like SharePoint. User should also be able to add web widgets to any webpage.
5. Build dashboards using existing reports and charts in a drag and drop UI.

In the farther future, I have the following ideas:

1. Add support for more data sources, such as MongoDb, Oracle, SalesForce, SharePoint, and Google Analytics.

Tech Stack

This project is built on the following stack:

• Asp.Net Mvc
• AngularJs
• Sql Server
• AutoFac
• BootStrap
• Microsoft Enterprise Library

Architecture

The project is primarily based on the Onion Architecture. We also a multi-tier architecture with domain layer, business layer, and UI layer. On the client side, we primarily use MVC with the help of AngularJs. AutoFac is used for DI/IoC.