Latest Power BI and AI articles from RADACAD team
In the last post, I have explained how to work with Azure Databricks. In this post, I will show: 1- Upload data in Azure data Lake Store 2- get data from Azure Data Lake Store into Azure Data Bricks 3-clean Data with Scala language 4- visualizes with R language 5- Predictive Analysis with R In Read more about Azure data Bricks – Part2[…]
Carrying on from my recent article on how to build a game of Blackjack using Power BI and DAX, this time I thought I would see if I could build a fully playable game of Sudoku. A big thanks to my good friend Tom Martins over at minceddata for giving me the idea. The end result Read more about Fun with DAX – Sudoku[…]
A not so obvious use of the recently added GENERATESERIES function to use it to generate time buckets. The more common use of this function is to generate series of numbers, but it works just as well with Time based data. Say you want to create a data table with rows that represent time periods. Read more about Quick DAX: Use GENERATESERIES to create Time buckets[…]
Databricks is an analytics service based on the Apache Spark open source project. Databricks has been used for ingesting a significant amount of data. In February 2018, there is integration between Azure and Databricks. This integration provides data science and data engineer team with a fast, easy and collaborative spark-based platform in Azure [1]. Azure Read more about Azure data Bricks – Part1[…]
I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the version 2.0 of this product is now available for everyone to use and enjoy. This version comes with Read more about Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables[…]
I thought it might be fun to try something a little different with this blog and use a combination of bookmarks with a little DAX magic to come up with a game that plays a hand of Blackjack. Power BI and DAX are not the ideal engine to build a game of Blackjack with, but Read more about Fun with DAX – Blackjack Game[…]
Using DAX time intelligence functions for a while; you may ask this question from yourself that what is the difference between functions below; SamePeriodLastYear function vs using ParallelPeriod with Year parameter ParallelPeriod for a month vs DateAdd for a month ago and many other questions that lead to this final question: Which function should be Read more about DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question[…]
Azure Data Lake store is one of the components in Microsoft cloud, that helps the developers, data scientists and analyst to store any data size, shape, and speed. Azure Data Lake is optimized for processing large amounts of data; it provides parallel processing with optimum performance. In Azure data lake we can create hierarchy data Read more about R In Azure Data Lake- Part1- Sample Data[…]
I sometimes see requests asking how to convert a number between 1 and 12 into a month name such as “Jan” or “February. The most common solution I see offered is along the lines of a SWITCH statement that lists 12 conditions (one for each month). This works, but can also be done using existing Read more about DAX : Convert Number into Month Name[…]
In the last Post, I have explained some parts of creating Custom visual such as how to create an icon, name of visual, and the how-to allocates fields to a custom visual. There are some other settings that need to be set up beforehand as well. the number of data fields you able to pass to Read more about Create Custom Visual with R and JSON- Part 4[…]