Moving from Business Intelligence to Analytics with Power BI?

I conducted a workshop in Florida in 2019. Although some of the technology will be out of date, the principles will still be useful for concepts such as sales and marketing analytics, and Python, for example. The conference was aimed at helping people to move from Business Intelligence to Analytics. I thought I'd post the … Continue reading Moving from Business Intelligence to Analytics with Power BI?

Data Lineage and Power BI: Why is it important?

The Microsoft Power BI team have released a preview Data Lineage feature and I couldn’t be happier! The Power BI lineage view displays the lineage relationships between all the artifacts in a workspace, and all its external dependencies.

Businesses need a clear line of sight on data asset ownership and stewardship. This has traditionally been in the hands of the IT department, but unfortunately the projects can become deprioritized as IT fight other battles elsewhere. IT can do so much, but the business do need to bring things to the table. Hence, we now see accessible tools appearing in technology such as Power BI.

University of Washington Foundations of Data Analysis Course

I’m pleased to announce that the University of Washington are running a Foundations of Data Analysis course, starting in January 2020.  In this 10-week course, you’ll learn how to understand and analyze data. We’ll start with fundamental data-related concepts, terminology and ethical considerations. You’ll learn how to articulate business problems and identify required data. Using Microsoft Excel and SQL, you’ll practice gathering, cleaning and organizing data. Finally you’ll use Tableau to effectively describe, analyze and visualize data.

Marketing as a strategic business partner: mixing theory, research and #data

Marketing is viewed as a key strategic participant in achieving the goals of businesses, both large and small. I thought I’d share how we started to apply marketing theory, practice, and insights from data. There are tons of ‘skate on the surface’ marketing soundbite books, which may sound good at the first glance with no … Continue reading Marketing as a strategic business partner: mixing theory, research and #data

Power BI Dataflows and fixing ‘Your Azure storage account must be in the same Azure Active Directory tenant as your Power BI tenant.’

I’m excited about Power BI dataflows, since I believe it’s a great way forward for companies to sort out the issue that nobody likes to talk about: cleaning data. I’m passionate about this topic since I believe in inheriting technical debt as much as I can, so I leave the organization’s technical debt in a … Continue reading Power BI Dataflows and fixing ‘Your Azure storage account must be in the same Azure Active Directory tenant as your Power BI tenant.’

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

Financial Storytelling and Data Storytelling with Profitability Ratios

Following on from my earlier blog post, discussing Accounting Ratios, let’s take a look at a specific set: Profitability Ratios.Profitability Ratios can be defined as understanding the effectiveness of the company in generating profit. In this blog post, we will concentrate on profitability ratios, working our way around the flow chart presented here: The formula … Continue reading Financial Storytelling and Data Storytelling with Profitability Ratios

I’m speaking at #ITDevConnections 2018!

I’m speaking at #ITDevConnections 2018! Join me in Dallas and learn on topics such as: Blockchain Demystified for Business Intelligence Professionals Data Analytics with Azure Cosmos Schema-less Data and Power BI R in Power BI for Absolute Beginners There is also a Women in Technology lunch and I’m excited about that, too! Join me in … Continue reading I’m speaking at #ITDevConnections 2018!

Fun DataDive with DataKind UK

This weekend, I volunteered with DataKind UK on their Summer DataDive, which took place on the weekend of 28th and 29th July 2018 in the Pivotal London offices in Shoreditch. I had a fantastic, memorable weekend, mixing with around 200 other data scientists. I’d like to thank the DataKind team for being so inspirational, giving, … Continue reading Fun DataDive with DataKind UK