Category: Design

Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling

Posted on by Reza Rad

For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to Read more about Creating a Shared Dimension in Power BI Using Power Query: Basics and Foundations of Modeling[…]

Road Map to use Microsoft ML tools

Posted on by Leila Etaati

I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure Read more about Road Map to use Microsoft ML tools[…]

Diagram your Database Tables using Power BI

Posted on by Philip Seamark

Ever wanted to create a diagram of your MS SQL Database tables in Power BI?  Here is what I did to make that happen. The approach is to build a query that can be run against the catalog system views inside each MS SQL database.  The approach is to build a list of “From” and Read more about Diagram your Database Tables using Power BI[…]

Do You Need a Date Dimension?

Posted on by Reza Rad

I’ve hear this question many times; “Do you think we need a date dimension?”.  some years ago, date dimension has been used more, but nowadays less! The main reason is that there are some tools that are using their own built-in date hierarchy. As an example Power BI has a built-in date hierarchy that is Read more about Do You Need a Date Dimension?[…]

Data Preparation; First and Foremost Important Task in Power BI

Posted on by Reza Rad

I’ve talked about Data Preparation many times in conferences such as PASS Summit, BA Conference, and many other conferences. Every time I talk about this I realize how much more I need to explain this. Data Preparation tips are basic, but very important. In my opinion as someone who worked with BI systems more than Read more about Data Preparation; First and Foremost Important Task in Power BI[…]