Business Intelligence, PowerBI

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.

Business Intelligence, PowerBI, Tableau

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.

Data Science, PowerBI

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

Business Intelligence, PowerBI

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.’

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

MBA, PowerBI

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

Business Intelligence, Data Relish Services, Data Science, PowerBI, SQLServerPedia Syndication

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!

Data Science, PowerBI, Tableau

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

PowerBI, Tableau

Tableau Prep, Power Query and Power BI – Good together?

A question I often here is this: Which tool should I use, Tableau or Power BI? The truth is: They are not mutually exclusive. Tableau is great at business mysteries: ill-defined questions where you have to surf the data for results. Power BI is particularly great at modelling and cleaning the data, with clean, crisp… Continue reading Tableau Prep, Power Query and Power BI – Good together?