Data Profiling views in Power Query (Excel and Power BI)
By identifying problems before they become errors Data profiling views in power query helps to ensure your data is clean & ready to be loaded into a model
Category: Power BI
Date tables for DAX users – Power BI and Power Pivot
Everyone should use a date table in Power BI, but creating one with DAX is not the most optimal solution. We have a lot to cover in this article on date tables,
9 Tips for PowerBI Users
are you a PowerBI user? here are 9 tips so you can make the most of PowerBI
Why and how to Keep Dimensions & Facts tables separate – DAX modeling
Modeling for DAX Power Pivot and Power BI – Learn why and how you should keep dimensions and facts tables separate.
DAX SUM and SUMX Functions
The role of both DAX SUM and SUMX functions is to add numerical data together. Yet both these functions are rather different. Let’s talk about the SUM function first. The SUM function is simple. It takes a column of data and adds the values to give a total. It works like the sum function in […]
Power BI – Connecting to tables on a website and transforming that data
CLICK HERE TO LEARN HOW TO DO THIS IN EXCEL WITH POWER QUERY Connecting to data sources and transforming data into a useable format can be complex, even when you are using a powerful tool like Power BI. I know many people that have started a transformation only to give up because they are not too sure […]
Analyzing a Blockchain Database with Power BI – Introducing SteemitSQL
Sometimes it can be difficult to find a good data set to analyse. Kaggle offer data sets and run competitions on analysis and Microsoft also offer sample data sets such as World Wide importers. But sometimes a completely different data set is really cool to explore. Over the last few weeks I have been using […]
Decoding M – Exploring the YouTube Data API with Power BI
For some time now I have wanted to explore connecting Power BI with API’s, however the lack of knowledge of M, and time has held me back. But this week I got a chance to dig a little deeper with my idea. I decided to look at Google’s YouTube Data API. First I just want […]
Power BI and Microsoft Cognitive Services to extract Key Phrases from Text
Extracting key phrases from text can be a key element of text analytics. It would be commonly used by brands when listening to what their customers are saying across social media, such as Facebook and Twitter comments and posts. It’s also often used to analyse survey results. In my example below, I have used Microsoft […]
The Must Have Resource list to Master Power BI
For those of you that know me or have followed me for some time, you will know that I have always been a lover of Excel. When Microsoft introduced the Excel Power Tools, Power Query, Power Pivot and Power View I was in my element. In 2015 Microsoft released Power BI – A self-service business […]