Welcome to Database School

Integrated Dashboard & Power BI Visualization for Sustainable Energy Data

Client: Sunny Sanwar (USA)

Industry: Environmental Data Analytics / Energy Policy

Platform: Angular Frontend, SQL Server Backend, Power BI, WordPress

  1. Project Title:
Full-Stack Dashboard with Power BI Reporting for Energy & Emissions Data

  1. Objective:
To design and implement a robust, scalable, and interactive dashboard for visualizing greenhouse gas emissions, energy policies, and transportation data—enabling real-time insights and API connectivity for a government energy initiative.

  1. Project Description:
The client required a complete solution to display, filter, and manage energy policy data via a web interface and integrate interactive Power BI dashboards for emissions tracking. The system needed to:
  1. a) Migrate from Excel data to SQL database.
  2. b) Display data in categorized tabs (Energy Star, Energy Policy, Building Emissions, Transportation).
  3. c) Integrate with live APIs (e.g., DSIRE, DOE) and custom internal APIs.
  4. d) Provide an admin dashboard with user authentication.
  5. e) Allow dynamic filtering and Power BI chart rendering from both local and live data.
 
  1. Tools & Technologies Used:
  2. a) Frontend: AngularJS, HTML5, CSS3, JavaScript
  3. b) Backend: .NET Core, Node.js, Express
  4. c) Database: SQL Server
  5. d) BI Tool: Microsoft Power BI
  6. e) Collaboration: GitHub, Skype, Dropbox, Google Docs
  7. f) Hosting: dynmhx-api.com
 
  1. Key Features Implemented:
  2. a) Tab-based dynamic Angular UI with form submissions and data filters
  3. b) Power BI dashboards using Excel and then real-time SQL DB data
  4. c) WordPress plugin integration for animated announcements
  5. d) API-driven dropdown filtering and emission calculation interface
  6. e) Admin panel for managing building and transportation policies
  7. f) Live sync capabilities (planned): DSIRE & NREL data feeds
 
  1. Challenges Faced & Solutions:
Challenge Solution
API Unreliability (DSIRE, DOE) Developed Local API Mirror System
Live Dataset Integration Used database-backed dropdowns + Power BI integration
Multi-tab Navigation in Power BI Created top navigation buttons replacing default page navigation
Angular + Power BI data sync Implemented Excel-to-DB migration and tested with parameterized charts
 
  1. Outcome & Benefits:
  2. a) Successfully published on: https://dynmhx-api.com/#/
  3. b) Improved stakeholder decision-making with visual dashboards
  4. c) Enabled client to manage all datasets via backend CMS
  5. d) Established ongoing collaboration and future feature roadmap
  6. e) Positioned Database School as a versatile solution provider for data-heavy full-stack applications
 
  1. Client Testimonial (Summary):
“Looks great, thanks… Works like a charm… I appreciate your effort and the continuous collaboration.”