محاسبه حداکثر میزان تخفیف قابل پرداخت به مشتریان جهت بازگشت

فرمول محاسبه (از نظر ما) اینه:‌
حداکثر تخفیف قابل تخصیص = میانگین درآمد از هر سفارش + احتمال بازگشت‌های بیشتر * متوسط تعداد خریدهای بعدی * میانگین درآمد از هر سفارش

رفع خطای اتصال به سرور MDS توسط افزونه Excel

مطمئن بشید ویندوزتون آپدیته
ببینید سرور روی نام دامنه یا نام سیستم شما فیلتر شده یا نه.
Control Panel\All Control Panel Items\Credential Manager\Add a windows credential \
یادتون نره با دامنه مربوطه یوزرنیم رو وارد کنید. چون در اصل دارید توی سرور مربوطه این یوزر رو وارد می‌کنید.
تمام!!

Sales Process types (Sales Channels)

Sale fro stock Make to order Selling services Service contract Return material Cancellation Back to back Drop shipment Internal orders Also we have : Business to Business Business to customerBusiness to OrganizationBusiness to GovernmentCustomer to Customerand …

What Is Customer Retention Rate and Why Does It Matter?

By Amanda DiSilvestro; When a company talks about analyzing calculations, it can be intimidating. However, once you get a handle on the right metrics and what benchmarks customers expect, it turns into a simple process. Customer retention rate (CRR) is a great place to start: It’s easy to calculate. It’s also crucial to understand in… ادامه خواندن What Is Customer Retention Rate and Why Does It Matter?

Data Warehouse Modeling Star Schema vs. Snowflake Schema

 The First Difference: Normalization As mentioned, normalization is a key difference between star and snowflake schemas. Regarding this, there are a couple of things to know: Snowflake schemas will use less space to store dimension tables. This is because as a rule any normalized database produces far fewer redundant records. Denormalized data models increase the… ادامه خواندن Data Warehouse Modeling Star Schema vs. Snowflake Schema

۷ Steps to Data Warehousing

Data warehousing is a business analyst’s dream—all the information (we will talk about the differences between data, information and knowledge and how they will lead to decisions.) about the organization’s activities gathered in one place, open to a single set of analytical tools. But how do you make the dream a reality? First, you have… ادامه خواندن ۷ Steps to Data Warehousing