Data Analysis – Particulate Matter in Cities
To verify PM2.5 Particulate Matter small particle pollution in China, measurements were taken hourly from 5 key cities over a period of several years.
News & Posts
Data Analysis – Brexit Vote
To see which variables are helpful for classification of voting leave or remain, we ran analysis through logistic regression.
Excel Clanger – “Cannot group that selection”!
by TickboxPhil
in BI & Analytics
Got that sinking feeling (again) when you get the error message “Cannot group that selection”?
From Databases to Analytics
by TickboxPhil
in BI & Analytics, Databases, DB Design, Power BI
Analytic insights are more important than databases!
SSAS Tabular available in SQL Server SE?
by TickboxPhil
in Databases
Where has the SSAS Tabular model gone…?
SharePoint Online – overlooked but handy
by TickboxPhil
in Cloud, Systems
SharePoint was pretty clunky in the noughties, but now it’s racing ahead and the premier Document Management System integrated with Office – about time too.
Microsoft Licence Sales
by TickboxPhil
in Server Licencing
Licence sales are not a big part of our business anymore (we focus on database and BI system design and implementation).
November 6, 2016
Where’s that Darned Licence Server?
by TickboxPhil
in DBA & DevOps
Where on earth do you tell this server where to contact the Licencing Server you carefully setup?
October 14, 2016
Win Server 2016 now core based!
The big shock is that Microsoft moved it to Core based licencing, rather than the previous CPU based – more like SQL Server. So expensive!
August 7, 2016
OneDrive For Business / Personal – Confusion & Fit For Purpose?
by TickboxPhil
in DBA & DevOps
Previously, OneDrive and OneDrive For Business (ODFB) were hardly worth wasting time on…