Azure, Business Intelligence

Error converting data type varchar to numeric where ISNUMERIC finds only numbers

I am writing some SQL to form the basis of views to pull data from a Microsoft SQL Server source into Azure SQL Database, and then the data would go to Power BI. The data was all presented in string format initially (not my data, not my monkeys, not my circus), and I wanted to… Continue reading Error converting data type varchar to numeric where ISNUMERIC finds only numbers

Azure

Moving WordPress websites between Azure Subscriptions

I'm keen to learn practical aspects of Azure and cloud computing, so I can really understand their value for small businesses who rely on cloud computing. I don't feel comfortable advocating for something I don't really understand, or haven't tried myself. So I set up my Data Relish website using Azure and WordPress, and integrated… Continue reading Moving WordPress websites between Azure Subscriptions

Azure, Business Analytics, PowerBI, Thought Leadership

Connecting #Azure WordPress, #HubSpot data for analyzing data in #PowerBI for a small business #CRM

I got to the end of the free WordPress account for my small business account and I wanted to analyse my CRM and sales data better. I wanted to dial up my sales and marketing, and, of course, use data to understand my audience better. With the free WordPress edition, I could not do some… Continue reading Connecting #Azure WordPress, #HubSpot data for analyzing data in #PowerBI for a small business #CRM