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.
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.
I am delighted to be presenting at DataPlatformGeeks in Bengaluru, India in August 2019! What is DataPlatformGeeks? The conference packs a punch of learning and information, and you will get actionable knowledge that you and your company can benefit from - right away!
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
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.’
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
how to find the tenant in Power BI.
Be Insights Driven, not Data Driven, and definitely not Tool Driven. Tableau vs Power BI vs Qlik
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! 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!
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
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?