Latest Power BI and AI articles from RADACAD team
Now that you know about the dimension and fact tables, it is time to talk about one of the most important concepts of modeling. You might have heard about dimensional modeling or star schema, but you may have vague ideas about what it is, or alternatively, you might have used it, but not sure if Read more about Power BI Basics of Modeling: Star Schema and How to Build it[…]
Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in one big table. In this article, you will learn about the fact table, and how it positioned in a data model, you will also learn how Read more about Basics of Modeling in Power BI: Fact Tables[…]
In the last post, what is Azure ML Studio and Azure ML Services has been explained briefly. In this post, I will explain how to use Automated machine learning service. Automated machine learning (automated ML) picks an algorithm and hyperparameters for you and generates a model ready for deployment. Automated machine learning helps to identify Read more about Azure Machine Learning Services : Automated Machine Learning -Part 2[…]
I have written previously about the use cases of Dataflow in Power BI, and one of them was using one Power Query table in multiple Power BI reports. However, I that article just covered the surface, and I still see many solutions duplicating Power Query scripts in multiple files which brings a lot of inconsistency Read more about Move Your Shared Tables to Dataflow; Build a Consistent Table in Power BI[…]
There are lots of possibilities to embed cognitive services API in application like Power apps with help of Microsoft flow in the last posts, I have shown how to create Face Recognition application or How to create an OCR application to convert image to text. Face Recognition Application with Power Apps, Microsoft Flow and Cognitive Read more about Image and Activity Processing Application with Cognitive Service, Power Apps and Microsoft Flow[…]
I have previously written about relationships and the cardinality of the relationship. Now is a good time to explain the two types of tables we deal with every day in a reporting data model; Fact and Dimension table. In this article, I will explain what a Dimension table is, and examples of it, and how Read more about Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table[…]
In this post series, I am going to show how we can use Azure Machine learning services and the new features added that make life so easy to train, deploy, automate managing machine learning models [1]. In this post, first I will show how to use a no code environment for Auto ML, how Read more about Azure Machine Learning Services : Introduction – Part 1[…]
Power Query has more than 80 data sources supported, and Microsoft Exchange is one of those data sources. Although it is not a new data source, however, the power of this data source combined with the data transformation power of Power Query is not clear for everyone. Using this data source, you can get all Read more about Import Email Attachments Directly Into a Power BI Report using Power Query[…]
In the previous article, you learned the basics of relationships, you learned why we need a relationship, and what is the filtering impact of it across multiple tables. In this article, you will learn about one of the most important properties of a relationship called Cardinality. Understanding what the meaning is of 1-1, 1-Many, Many-1 Read more about Many-to-One or Many-to-Many? The Cardinality of Power BI Relationship Demystified[…]
There are tons of articles about advanced tips of Power BI modeling such as advanced DAX, and context transition. However, based on my experience with our clients, I realized there is a big gap in basic content. Hence, this article is going to cover the basic essentials of the relationship. Tips such as: What is Read more about Back to Basics: Power BI Relationship Demystified[…]