Loop Through Webpages with Multiple Parameters in Power Query 19. October 2017 Callum-Green Power BI Desktop, PowerBI, Power Query, M (15) Back in February 2016, I posted a step by step article (found here) on how to loop through a website... [More]
Master Data in the Cloud 17. October 2017 matthow (2) As data warehouses become more advanced and move to the cloud, Referential Data Management is often ... [More]
SSIS Azure Data Lake Store Destination Mapping Problem 6. October 2017 Zach-Stagers SSIS, Data Lake (0) The ProblemMy current project involves Azure’s Data Lake Store and Analytics. We’re using the SSIS A... [More]
Geek in a Lift 6. October 2017 UstOldfield Personal, Life at Adatis (1) This is probably my first proper non-technical post and I’m posting it because life at Adatis isn’t ... [More]
Migrating to Native Scoring with SQL Server 2017 PREDICT 4. October 2017 SachaTomey Azure, Business Intelligence, SQL Server 2017, AI, Machine Learning (0) Microsoft introduced native predictive model scoring with the release of SQL Server 2017. The PREDI... [More]
Working with Manual and Automated KPIs in a Tabular Cube 19. September 2017 josemendes MDS, DAX, Tabular (1) In a recent project, we had to produce a scorecard using a set of manual and calculated KPIs. To obt... [More]
Pow WoW 14. September 2017 Dave-Stokes (52) Most will know that a pow wow is a native North American term for a social gathering. It originated ... [More]
Themes in Power BI – Part 2 14. September 2017 Callum-Green PowerBI, Power BI Desktop (11) In September’s Power BI Desktop release, one of Microsoft’s announcements was a new offering of Them... [More]
Automating The Deployment of Azure Data Factory Custom Activities 6. September 2017 UstOldfield Azure, Data Factory, PowerShell, DevOps (2) Custom Activities in Azure Data Factory (ADF) are a great way to extend the capabilities of ADF by u... [More]
Generating Usage Statistics from a SSAS Tabular Cube 24. August 2017 tristanrobinson SSAS, Usage Reporting, Power BI (3) Once you have users accessing your cube it’s almost inevitable at some point that someone will ask y... [More]
How to prepare for 70-766 - Perform Big Data Engineering on Microsoft Cloud Services 14. August 2017 terrymccann Azure, Azure Data Factory, Microsoft, Modern Data Warehouse, Data Lake, Stream Analytics (3) There is a new exam currently in beta titled "Perform Big Data Engineering on Microsoft Cloud Servic... [More]
How to Find Your Next Job with Power Apps and Flow 11. August 2017 matthow Logic Apps, Power BI, Flow, PowerApps, Common Data Service (4) Both PowerApps and Flow exist within the Office 365 suite and bring enormous amounts of possibilitie... [More]
Scrum Insanity 6. August 2017 Dave-Stokes (4) When agile projects go wrong it’s often not a single massive mistake, but a series of small ones tha... [More]
Hashing for Change Detection in SQL Server 1. August 2017 NigelMeakins Hashing, Change Detection (4) HashBytes() in SQL Server 2016The HashBytes() function is primarily intended for hashing values for ... [More]
How to run a successful testing stage 26. July 2017 josemendes SQL (2) As we all know, testing is one of the most important stages of an IT project, however, either becaus... [More]
The Rad Retro 24. July 2017 Dave-Stokes (55) On our Agile / Scrum projects, we found we were suffering from the same issues coming out of Sprint ... [More]
Direct Query vs Live Connection in Power BI – Part 2 19. July 2017 Callum-Green Power BI Desktop, PowerBI, Live Connection, Direct Query (3) This instalment of the Power BI blog series focuses on the two other differences between Direct Quer... [More]
Direct Query vs. Live Connection in Power BI – Part 1 18. July 2017 Callum-Green Power BI Desktop, PowerBI, Live Connection, Direct Query (9) There are lots articles out there that compare Import Mode vs.Direct Query, but people rarely talk a... [More]
Instant Bot: deploying a Bot in minutes with Azure Bot Service 17. July 2017 UstOldfield Azure, Introduction, Bot Framework (1) I had been playing around with the Bot Framework for a while but hadn’t really got anywhere, largely... [More]
Geographic Spatial Analysis with Azure Data Lake Analytics (ADLA) 10. July 2017 SachaTomey Azure, Big Data, Business Intelligence, Data Lake, Data Lake Analytics, Data Lake Store, U-SQL, Data Warehouse (5) Whilst working on an Azure Data Lake project, a requirement hit the backlog that could be easily sol... [More]