Cohort

Cohort چیست؟   میزان بازگشت مشتریامونه. یه نمودار معمولا درصدی که مثلا میگه:‌در ماه اردیبهشت ۹۶ اگر ۱۰۰ نفر اومدن خرید، ۳۰ تاشون ماه بعد هم اومدن، ۴۰ تاشون دو ماه بعدشم اومدن، ۲۰ تاشون ۳  ماه بعد اومدن و الی ما شاء الله. لازمه درست کردن Cohort Analysis: لازمه درست کردن این گزارش:‌ شماره کاربری… Continue reading Cohort

ssrs ERROR

The report server isn’t configured properly. Contact your system administrator to resolve the issue. System administrators: The report server can’t access or use the encryption key. You might need to add the server to the scale-out group, re-import encrypted content, or delete all encrypted content and generate a new encryption key. to solve: go to… Continue reading ssrs ERROR

How to add Business intelligence in visual studio 2017

How to add Business intelligence in visual studio 2017 How to add Business intelligence in VS 2017 It is so easy just install this package fro reporting service and this package for  Analysis service

The average for Date or Time in T-SQL

The average for Date or Time in T-SQL: We cannot use the average function (AVG) to average dates or times or date-times. I think the best way for this is to convert the date/time to float with Convert(Float,DateField). This function will return the number of days between the DateField and ‘۱۹۰۰-۰۱-۰۱ ۰۰:۰۰:۰۰’. For example it… Continue reading The average for Date or Time in T-SQL