Latest Power BI and AI articles from RADACAD team
You have created a Power BI report with many visualizations and calculations, however, it is slow! And the slowest part of that is the report page with a matrix or table visual in it! Why that visual is so slow? Is this the problem of Visual in Power BI? or Power BI problem at all? Read more about Why my Power BI Matrix or Table Visual is SLOW[…]
Dimensions and Fact tables are the two essential parts of building a data model, and their relationship in the form of Star Schema is the best practice of doing the modeling. However, these are all theories until you really experience it in a real-world example. In this article, I want to put everything you learned Read more about Build Your First Star Schema Model in Action: Power BI Modeling Basics[…]
As I have discussed in part 1 and Part 2, the new possibility of creating machine learning without writing any Python or R codes is so amazing. In Part One, the difference between Azure ML Studio (the traditional one) and the Azure ML Services (new component) has been very briefly explained. (I will write Read more about Azure Machine Learning Services : Deploy AutoML Model and Use it in Power BI- Part 3[…]
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. https://radacad.com/face-recognition-application-with-power-apps-microsoft-flow-and-cognitive-service-part-4 In this post, I am going to talk about 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[…]