Monthly Archive: June 2017

Jun 22

How to calculate lift measure– part II

Lift measures describe the models through the prism of profits which is easily understandable to the management and business users that the model should be applied. Measure lift determines how the model is better than the absence of models and worse than the best model, but does not tell us how many events (“hits”) we …

Continue reading »

Jun 10

How to calculate lift measure – part I

Suppose you’ve hired consultants to create a predictive model which predict that some event will occur and the result their work is function of model and you have to implement it as scalar or CLR function in your RDBMS. f(X1,X2,..Xn): RxRx…xR -> (0,1)

Continue reading »

Jun 09

Power BI Report Server (on premises Power BI report publishing)

Januara meseca ove godine se je pojavila prva (još uvek u razvoju) verzija SQL Server Reporting Services-a koja je omogućavala da na SQL Server Report Server budu, pored Paginated reporta (standardnih report-a) i mobilnih reporta, budu postavljavljani i Power BI report-i. Za objavljivanje reporta na tim SQL Server Reporting Services-ima bilo je potrebno instalirati, pored …

Continue reading »

Jun 07

Šta je BICC?

BICC (Business Intelligence Competency Center) predstavlja funkcionalan tim (formacijski obično virtualan) u organizaciji sa jasnom misijom: razvoj, podrška, promocija i unapređenje BI sistema unutar organizacije. BICC je zadužen za definisanje i sprovođenje BI strategije, realizaciju planova i izvršenje zadataka koji će doprineti ispunjenju njihove misije.

Continue reading »

Jun 06

Microsoft BI tools – na SQL Server UG maja 2017-te

Goran Milanov i Vladimir Marković su na majskoj SQL Server UG pričali o Microsoft BI tools-ima. Fokus je bio na mogućnostima i funkcionalnostima SQL Server 2016 Reporting Services-a, pogotovu na razvoju reporta za mobilne uređaje. Pored toga prisutni su upoznati sa zadnjom verzijom Power BI Report server-a tj. mogućnostima on-premises Power BI report publishing-a.

Continue reading »