Intake and approval portal for Power BI report requests. MVP, deployed on Vercel with a live Power BI API integration.
Teams were requesting dashboards over email and spreadsheets, which lost the thread between the business ask, the BI team's interview notes and the developer's build. Prism turns that into one tracked record with sequential sign-off.
What it does:
• Ten-stage, role-gated approval workflow
• Row-level security per role (about 20 Postgres policies)
• Change requests against already-published reports
• File attachments via signed URLs from private storage
• Power BI Service integration over Azure AD OAuth
• Notifications to email and Microsoft Teams
A Playwright end-to-end test runs in GitHub Actions on every PR and nightly against production.
Stack: Next.js, React, TypeScript, Tailwind CSS, Supabase, PostgreSQL, Resend, Power BI REST API, Playwright
Live: tcmplanner.vercel.app (http://tcmplanner.vercel.app)
0
89
MongoDB Atlas Data Management & Interactive Dashboard
Project Overview😍
- The project focuses on leveraging MongoDB Atlas for efficient data storage, management, processing, and visualization through interactive dashboards. The solution enables organizations to manage structured and unstructured data, monitor business operations, and transform raw information into meaningful insights through real-time data access and analytics.
Project Requirements:
1. Configure and manage cloud-based databases using MongoDB Atlas.
2. Design efficient database schemas and collections for business data.
3. Implement CRUD operations for seamless data management.
4. Develop secure database connectivity using APIs and backend applications.
5. Perform data aggregation, filtering, querying, and transformation.
6. Build interactive dashboards to visualize business metrics and KPIs.
7. Enable real-time or near-real-time data monitoring and reporting where supported.
8. Implement database indexing and query optimization for better performance.
9. Integrate MongoDB Atlas with analytics tools and application workflows.
10. Ensure data security, access control, backup, and scalability.
Overall Business Impact:
- The combination of MongoDB Atlas, data analytics, and interactive dashboards creates a scalable data management ecosystem that improves data accessibility, operational visibility, reporting efficiency, and strategic decision-making.
#Blackcoffer #MongoDB #MongoDBAtlas #DatabaseManagement #DataAnalytics #DataVisualization #InteractiveDashboard #BusinessIntelligence #DashboardDevelopment #CloudDatabase #NoSQL #BigData #DataEngineering #DataManagement #RealTimeAnalytics #DataDriven #CloudComputing #DigitalTransformation #DataInsights #TechnologyInnovation
0
25
AI Data Assistant Inside Power BI
I built an AI-powered chatbot directly inside Power BI to help users interact with their existing dashboards and data through natural-language questions.
Instead of manually opening multiple dashboards to find a specific metric, users can ask the assistant a business question and receive a data-grounded answer along with the relevant report/dashboard source.
The assistant works across multiple Power BI dashboards and can provide context from the available reports, making it easier to find insights without changing the existing BI environment.
Key capabilities:
- Ask questions directly inside Power BI
- Connect with existing Power BI data
- Search across dashboards and reports
- Get relevant metrics and insights
- Identify the source report/dashboard
- Answer data-driven business questions
- Work within existing BI infrastructure
- Add a conversational layer to Power BI
2
209
AI-Powered Geopolitical & Supply Network Exposure Intelligence Dashboard
Global supply chains are complex. Understanding where your business is exposed shouldn’t be.
I designed Global Shield Analytics as an executive-level Power BI solution that connects geopolitical risk, supplier dependency, critical materials, operational disruption, recovery time, and financial exposure in one intelligent reporting environment.
Instead of simply showing what happened, the solution is designed to help leadership understand:
Where are we exposed? → What could be affected? → What could it cost? → How long could recovery take? → What should we investigate next?
What I Can Build for Your Business
Every organization has different data, KPIs, reporting processes, and decision-making requirements. I build the Power BI solution around your actual business needs, rather than forcing your data into a generic template.
Requirement Discovery
I understand your reporting challenges, business objectives, KPIs, stakeholders, existing reports, and required outcomes.
Data Preparation
I connect, clean, transform, and structure data from sources such as Excel, SQL, ERP, CRM, and other business systems using Power Query.
Data Modelling
I develop a scalable semantic model with relationships, dimensions, measures, and business logic designed around your reporting requirements.
DAX & KPI Development
I create the calculations required for your business — financial metrics, operational KPIs, supplier performance, risk indicators, trends, targets, and other decision metrics.
Power BI Dashboard Development
I transform the prepared data into a professional, interactive dashboard with executive KPIs, drill-down analysis, filters, trends, comparisons, risk views, and actionable insights.
Business Validation
I validate the calculations and outputs against the agreed requirements and source data so the final reporting solution is consistent and business-ready.
Performance Optimisation
I structure and optimise the model and report for better performance, usability, navigation, and scalability.
Final Delivery
I provide the completed Power BI solution with the agreed reporting structure, visuals, calculations, and handover documentation.
🔗 From Business Requirement to Final Intelligence
Requirement → Data → Power Query → Data Model → DAX → KPIs → Dashboard → Validation → Final Delivery
Whether your organization needs to replace manual Excel reporting, consolidate fragmented data, improve an existing Power BI environment, or build a new executive BI solution, the dashboard can be designed around the specific problem you need to solve.
The Business Value
The goal is not to create more charts.
The goal is to create a single, clear decision-support layer that helps teams understand complex business exposure faster and focus attention where it matters.
Power BI | Microsoft Fabric | SQL | Power Query | DAX | Data Modelling | Executive BI
📅 Dashboard Date: 17 September 2026
📊 Reporting Period: 01 January 2026 – 17 September 2026
🔄 Last Refresh: 17 September 2026, 17:20 IST
Have a Power BI or Business Intelligence requirement?
Share the business problem, reporting challenge, or data requirement. I can design and build the Power BI solution around it — from initial requirements through final delivery.
0
145
Power BI Sales Dashboard | Multi-Year Day-Range Analysis
Built a fully interactive Power BI sales dashboard that breaks down revenue not just by the usual year/month/product view, but by a custom "day-range" pattern (0–10, 11–20, 21–31 days) giving management visibility into when within the month sales actually happen, which is critical for cash flow and production planning in trading/manufacturing businesses.
What the dashboard delivers:
5-year trend view : one-click tabs to switch between FY20-21 through FY24-25, with a running "Total" row and column so leadership sees both period and cumulative performance instantly
Quarter and month drill-down: Q1/Q2/Q3 buttons plus a 1–9 month strip let users move from annual to monthly granularity without leaving the page
Day-range breakdown by month : a dedicated matrix showing 0–10/11–20/21–31-day sales split for every month of the year, so seasonal and mid-month sales patterns are visible at a glance
Multi-dimensional filtering : global slicers for Item Group, Sales Employee, and State, so any table or chart on the page can be sliced by product line, individual salesperson, or region in real time
Item Group and Sales Employee performance matrices : day-range sales broken out per product category and per salesperson, useful for both inventory planning and sales incentive tracking
Visual summary charts : a horizontal bar chart totaling sales by day-range, and a color-coded combo chart showing the month-by-month day-range split side by side, so non-technical stakeholders get the story without reading tables
Consistent, presentation-ready formatting : currency in lakhs (₹L), color-coded day-range categories, and a clean header/navigation bar that makes the report feel like a finished product, not a raw data dump
Why this matters to a client:
This isn't just a report that shows totals : it's built to answer a specific business question (when in the month are we actually making money, and who/what is driving it) that standard "sales by month" dashboards miss. I design Power BI dashboards this way: starting from the business question a client actually needs answered, not just wiring up default visuals.
0
87
Developed a role-based MIS for the Govt of , Assam, covering state and district-level employees. It maintains a complete employee database with contact details and date of joining by designation, captures attendance, and tracks filled and vacant positions so the administration can plan recruitment.
0
7
From Chaos to Clarity: Healthcare Dashboard in Power BI
1. Clean and interactive Power BI dashboard for tracking patient trends, hospital performance, and key healthcare metrics in one place.
2. A modern healthcare analytics dashboard built in Power BI to monitor admissions, diseases, and operational efficiency.
3. Turn raw healthcare data into meaningful insights with this intuitive and fully interactive Power BI dashboard.
0
117
Helping business owners gain control of their numbers, improve cash flow, and make confident financial decisions.Yes,
I specialize in:
• Cash-flow forecasting
• Budgeting & forecasting
• Profitability & variance analysis
• Financial reporting
• Business performance insights
• Fractional CFO support
Chartered Accountant | U.S. Accounting | Financial Strategy
#cashflow #financialstrategy #fractionalcfo #finance
1
199
