Prem Chandra

BI Developer

Fiverr • Freelance

Jul 2026 - Present • 1 mo

As a BI Developer, my role is to transform raw business data into reliable, actionable insights that help organizations make better decisions. You should work across business analysis, data engineering, data modeling, visualization, reporting, and automation. 1. Business Requirements Understand business goals, processes, KPIs, and reporting requirements. Convert business problems into dashboards and analytical solutions. Define metrics, dimensions, filters, and business rules. 2. Data Engineering & ETL Extract data from databases, APIs, SaaS platforms, files, and applications. Build ETL/ELT pipelines to clean, transform, validate, and load data. Automate data ingestion and scheduled workflows. Ensure data accuracy, freshness, and reliability. 3. Data Modeling Design star and snowflake schemas. Create fact and dimension tables. Build relationships, measures, calculated fields, and semantic models. Optimize models for scalability and performance. 4. BI & Visualization Build interactive dashboards using Power BI, Tableau, Looker, Grafana, and Kibana. Focus on KPIs, trends, drill-downs, segmentation, real-time monitoring, and actionable insights rather than simply creating attractive charts. 5. SQL & Databases Develop strong SQL skills covering joins, CTEs, window functions, aggregations, views, stored procedures, and query optimization. Work with PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake, and Elasticsearch. 6. Reporting & Automation Replace manual reporting with automated workflows: Data Sources → ETL → Data Warehouse → Data Model → Dashboard → Reports/Alerts Automate data refreshes, scheduled reports, KPI monitoring, and notifications. 7. Data Quality & Performance Implement validation, reconciliation, duplicate detection, data freshness checks, access controls, and monitoring. Optimize queries, dashboards, datasets, refresh times, and pipelines.

Dashboard Engineer

Infosys • Freelance

Dec 2015 - Jul 2026 • 10 yrs 7 mos

As a Dashboard Engineer, my role is to design, develop, automate, and maintain high-performance dashboards that transform complex data into clear, actionable business insights. You should combine data engineering, visualization, analytics, UX, and automation to build dashboards that are reliable, scalable, and easy to use. 1. Understand Business Requirements Work with stakeholders to identify business goals and KPIs. Convert requirements into dashboard layouts, metrics, filters, and workflows. Design dashboards around decisions and actions, not just visualizations. 2. Connect & Prepare Data Connect dashboards to databases, APIs, cloud platforms, files, and SaaS applications. Build ETL/ELT pipelines for data extraction, transformation, and loading. Clean, validate, aggregate, and structure data for visualization. 3. Build Interactive Dashboards Develop dashboards using Power BI, Tableau, Looker, Grafana, Kibana, and custom web technologies. Implement: KPI cards and scorecards Charts and trend analysis Drill-down and drill-through Filters and dynamic views Maps and geographic analytics Real-time monitoring Alerts and notifications 4. Data Modeling & SQL Create efficient data models using fact/dimension tables, relationships, measures, and calculated fields. Write optimized SQL queries and work with platforms such as PostgreSQL, MySQL, SQL Server, BigQuery, Snowflake, and Elasticsearch. 5. Dashboard Automation Automate data refreshes, scheduled reports, alerts, KPI monitoring, and recurring reporting workflows. 6. Performance & Reliability Optimize dashboard load times, queries, datasets, calculations, refresh processes, and API calls. Implement caching, indexing, aggregation, incremental refresh, and monitoring where appropriate. 7. Advanced & AI Dashboards Build dashboards with real-time analytics, forecasting, anomaly detection, predictive insights, AI-generated summaries, and natural-language querying. Core Skill Stack Power BI + Tableau + Looker + G