لینک کوتاه : https://en.magicfile.ir/?p=2633
دانلود نمونه پیشخوان مدیریتی حمل و نقل در اکسل
An example of a dashboard to present the dynamics of key indicators of international logistics in 24 hours. We will use infographic elements to effectively display data visualization. This allows us to stand out from our competitors of Visual Excel report developers.
نمونه تصاویر در زمان اجرا
Let's simulate a situation to inspire the developer's terms of reference. Must be provided for an international express mail delivery company worldwide. The presentation should be dashboard-style and provide the main message about the changes in the company's procurement status during the day. The developer is provided with all the necessary data on key logistics indicators for the accounting period of 1 year. All data is pre-built in terms of time - one day: all source data is in the table in the "Data" tab. No macros are used in the template. All interactive functions are implemented with standard tools available in Excel.
توضیح ساختار ارائه داشبورد در اکسل
In the center of the dashboard is an interactive global map infographic element in the form of a moving planet Earth. It is designed to show the localization of all supply sectors in the entire logistics chain worldwide:
As you change the data on the dashboard, the planet rotates in sequence, changing the sampling time of the database to provide indicators at the current moment. The marks on the base below the planet symbolize the beginning and middle of the day, i.e. 0:00 and 12:00. The colors of the different sides of the base are different. This shows the first and second half of the day.
برای شما کاربر عزیز پیشنهاد دانلود داده می شود.