Overview #

carbon.taharisolutions.com is a Windows-based web application designed for dynamic reporting through Power BI. It leverages the robustness of the Microsoft technology stack to deliver a secure, scalable, and high-performance solution. The key components include a presentation layer hosted on IIS, an application layer built on ASP.NET, an MS SQL Server as the data repository, and seamless integration with Power BI for advanced reporting.

Key Components #

1. Presentation Layer
   • Platform: The web interface is hosted on a Windows Server using Internet Information Services (IIS).
   • Technologies: Built with ASP.NET (MVC or Web Forms) and may incorporate modern JavaScript frameworks (e.g., React or Angular) for enhanced user interactions.
   • Role: Serves as the primary point of interaction for users, delivering responsive dashboards and embedded Power BI reports.
2. Application/Business Layer
   • Platform: Developed using ASP.NET running on a Windows Server.
   • Technologies: Utilizes the .NET Framework or .NET Core for robust server-side logic.
   • Responsibilities:
     • Handling business logic, authentication, session management, and integration with external services.
     • Processing user requests and interfacing with the data layer to retrieve or update information.
3. Data Layer
   • Database: Uses MS SQL Server to store all application data, including user profiles, report configurations, and transactional data.
   • Technologies:
     • T-SQL for querying and managing data.
     • ORM tools like Entity Framework can be employed for streamlined data access.
   • Role: Provides reliable, secure, and efficient data storage and retrieval.
4. Reporting Integration
   • Service: Leverages embedded Power BI reports to offer interactive data visualization.
   • Integration:
     • Uses Power BI APIs for embedding reports within the application.
     • Implements token-based authentication to ensure secure and authorized access to reporting content.
   • User Experience: Users can interact with reports, apply filters, and derive insights directly from the web application interface.
5. Security & Data Flow
   • Transport Security: All communications are secured using HTTPS, ensuring encrypted data transfer between clients and the server.
   • Authentication:
     • May use Windows Authentication or a custom forms-based login mechanism.
     • Role-based access controls ensure that users only access permitted functionalities and data.
   • Data Access: Secure connections between the application and MS SQL Server (using Windows or SQL Authentication) safeguard data integrity and confidentiality.