Avoid Transformation steps in DAX (Excel and PowerBI)
Avoid Transformation steps in DAX (Excel and PowerBI) and learn to carry out data transformation in Power Query
Avoid Transformation steps in DAX (Excel and PowerBI) and learn to carry out data transformation in Power Query
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
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,
are you a PowerBI user? here are 9 tips so you can make the most of PowerBI
Modeling for DAX Power Pivot and Power BI – Learn why and how you should keep dimensions and facts tables separate.
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 […]
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 […]
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 […]
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 […]
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 […]