We can help you with
Academy: Online Learning
The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option.
Remote Coaching and Consulting
We do offer our consulting services remotely or in-person doesn't matter how long your question is, it can be short or long, we can just jump into a call and ...
Don’t hesitate, should you have any inquiries
In the last post, I started to explain how I used Power Automate for my business case scenario using Power automate, Excel, and OneDrive for conference management that can be applied to all other training class scenarios.In the last post, I explained how to trigger a PowerAutomated via Excel and create a folder inside it. Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 2, Send Email)[…]
Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI[…]
Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. In Read more about Power BI Design Tip: Disable the Auto-Detect Relationship[…]
Often you do the transformation in Power Query using the graphical interface, but having the formula bar visible, makes it much easier to understand or change the transformations. In this short blog and video, I’ll explain that. Power Query transformations In Power BI, we use Power Query a lot for transformations, but mostly using the Read more about Power BI Quick Tip: the Formula Bar in Power Query[…]
I have previously explained a number of use cases for dataflows. One really useful case for it is to use dataflow for slow data sources. In this short article and video, I’ll explain how this works. What is a dataflow? Dataflow is a Power Query process that runs in the cloud and stores the result Read more about Dataflow: a remedy slow data sources in Power BI[…]
Here I will share one of my business case scenario using Power automate, Excel and OneDrive for a conference management that can be apply to all other training class scenarios.we normally want to create a personalized folder for your students in class or for our speakers in a conference so they/we can put or files Read more about Streamline Sharing Folder and Email Message using Power Automate ( Part 1, Folder Creation)[…]
It is not possible to change a linked entity in a dataflow in Power BI. Linked entities has to be modified only in the dataflow in which they are created. However, sometimes, you need to do a small modification to the linked entity in a chained dataflow. There is a very simple trick, In this Read more about How to modify a linked entity in Power BI dataflows[…]
Self-service BI! This is what Power BI is all about for business users. They can connect to any available data source and start creating their own reports. However, great Power (BI) comes with great responsibility as per Uncle Ben and not sure business users are aware of their responsibilities when it comes to Power BI Read more about How to stop your Power BI tenant becoming a dataset swamp?[…]
The question I often get in my Power BI architecture consulting sessions is that; “How should we organize our workspaces? should we have one workspace with all the reports in it? or multiple? should we split it based on each report? business unit? or something else?” In this article and video, I’ll explain a guide Read more about How to organize workspaces in a Power BI environment?[…]
In the previous article and video, I explained a method that you can use to have real-time calculations in a Power BI streaming dataset. The calculations done that way are limited though because it is using the Q&A feature of Power BI. If you are after a complex calculation then DAX can definitely help. In Read more about Writing calculations on a real-time streaming Power BI dataset using DAX measures[…]