• Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • About Us
  • Contact Us

PK: An Excel Expert

Transforming Data into Decisions

Tag: Smart City Dashboard

Dashboard Power BI

Street Lighting Services KPI Dashboard in Power BI

March 8, 2026March 8, 2026 PKComments Off on Street Lighting Services KPI Dashboard in Power BI
Street lighting services play a vital role in maintaining safe and functional urban environments. Well-managed lighting infrastructure improves road safety, reduces accidents, enhances public security, and supports smart city initiatives.
Read More
Dashboard Power BI

Smart Parking Systems KPI Dashboard in Power BI

March 8, 2026March 8, 2026 PKComments Off on Smart Parking Systems KPI Dashboard in Power BI
Modern cities face serious parking challenges every day. Traffic congestion, limited parking spaces, inefficient monitoring systems, and poor data visibility create major operational issues for city authorities and parking operators.
Read More
Dashboard

Smart Parking Systems KPI Dashboard in Excel

March 8, 2026March 8, 2026 PKComments Off on Smart Parking Systems KPI Dashboard in Excel
Urban areas continue to face serious parking challenges as the number of vehicles increases every year. Drivers often spend a significant amount of time searching for parking spaces. As a
Read More
Dashboard

Urban Metro Development KPI Dashboard in Excel

March 8, 2026March 8, 2026 PKComments Off on Urban Metro Development KPI Dashboard in Excel
Urban metro systems play a crucial role in modern cities. As urban populations grow rapidly, governments and transportation authorities must manage complex metro infrastructure projects efficiently. These projects involve multiple
Read More
Templates

Smart Cities KPI Scorecard in Excel

January 23, 2026January 23, 2026 PKComments Off on Smart Cities KPI Scorecard in Excel
Smart cities rely on data to deliver better services, improve infrastructure, and enhance the quality of life for citizens. However, when city departments track performance using disconnected reports or manual
Read More
Dashboard

Municipal Services Dashboard in Excel

January 9, 2026January 9, 2026 PKComments Off on Municipal Services Dashboard in Excel
Managing municipal services has become more complex than ever. Cities and local governments must handle service requests, labor resources, material costs, citizen complaints, and satisfaction scores—all at the same time.
Read More
Dashboard

Smart Cities Procurement KPI Dashboard in Excel

December 26, 2025December 26, 2025 PKComments Off on Smart Cities Procurement KPI Dashboard in Excel
Smart city projects continue to expand across the world. As cities invest heavily in infrastructure, technology, utilities, and public services, procurement teams face growing pressure to control costs, ensure compliance,
Read More
Dashboard

Urban Infrastructure KPI Dashboard in Excel

November 16, 2025November 16, 2025 PKComments Off on Urban Infrastructure KPI Dashboard in Excel
Urban infrastructure plays a major role in the growth, safety, and comfort of any city. Roads, water supply, waste management, public transport, power distribution, and community services must work smoothly
Read More
Dashboard Power BI

Housing & Urban Development Dashboard in Power BI

November 7, 2025November 7, 2025 PKComments Off on Housing & Urban Development Dashboard in Power BI
In today’s rapidly urbanizing world, effective data-driven decision-making has become a cornerstone for planning and managing cities. Governments, developers, and real estate planners must evaluate numerous metrics — from project
Read More
  • Excel and VBA
    • VBA Course
    • Shortcut Keys
    • Useful Formulas
    • Basic Charts
    • Advanced Chart
    • Sort and Filter
    • Pivot Table
    • Data Validation
    • Conditional Formatting
    • Auto Fill and Flash Fill
    • Find and Replace
  • Charts
    • Progress Charts
    • Info-graphics
    • Animated Charts
    • Comparisons
    • Gantt Charts
    • Heatmaps
    • Speedometers
    • Timelines
  • Templates
  • Tutorials
    • Charts and Visualization
    • VBA
    • Excel Tips and Tricks
  • Power BI
  • Template StoreNew
  • CoursesNew
  • Ready to Use Templates
  • About Us
  • Contact Us
Copyright © 2023 PK-AnExcelExpert.com - Privacy Policy
This website uses cookies to improve your user experience, analyze site traffic and serve targeted ads in accordance with our Privacy Policy ACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT