As the VertiPad engine used in Power BI is an in-memory data analytical engine, the key to optimise your Power BI report performance is to reduce the memory usage of your data model. A smaller data model not only increase the data scan speed but also allow you to processing a larger dataset with the … Continue reading Building Power BI Memory Usage Dashboard using DMV
Category: Power BI/DAX/M
Things better to do When Working with Power BI
This is the third part in the blog series summarising my experience with Power BI from the real-world projects. Things Better to Know Before Implementing Power BI Service Pain Points of Power BI Things Better to Do When Working with Power BI Create separate QA/UAT app workspace from Dev app workspace Separate QA/UAT app workspace … Continue reading Things better to do When Working with Power BI
Pain Points of Power BI
This is the second post in the blog series summarising my experience with Power BI from the real-world projects. Things Better to Know Before Implementing Power BI Service Pain Points of Power BI Things Better to Do When Working with Power BI This blog post covers some very interesting topics, namely the pain points of … Continue reading Pain Points of Power BI
Things Better to Know Before Implementing Power BI Service
I love Power BI, sincerely, since as early as the PowerPivot 1.0 era. However, I must admit Power BI does drive me crazy sometimes. It can play very well when you follow the rules Power BI expecting you to follow, otherwise, it can cause you much pain. This blog series summarises my experience with Power … Continue reading Things Better to Know Before Implementing Power BI Service
R Visual – Building Component Cycle Timeline
One common approach to detect exceptions of a machine is to monitor the correlative status of components in the machine. For example, in normal condition, two or more components should be running at the same time, or some components should be running in sequential order. When the components are not running in the way as … Continue reading R Visual – Building Component Cycle Timeline
Power BI Fun – Ninjago Driver Scorecard for Fuel Saving
Just for fun, created the Ninjago driver scorecard dashboard for fuel saving. The idea behind this dashboard is actually from real-world IoT business cases for fuel saving through monitoring drivers' driving styles and behaviours.
Build Custom Component Status Diagram for Power BI using Synoptic
One common visualisation requirements of IoT analytics is to display the current status of machine components using status diagram of the machine in an interactive reporting tool such as Power BI. The task to build custom machines diagram can be very time-consuming for report authors. Fortunately, I found we can actually build machine diagrams for … Continue reading Build Custom Component Status Diagram for Power BI using Synoptic
Inspecting SharePoint Metadata using Power Query
Power Query is a self-service ETL tool from Microsoft which is able to extract data from a broad range of data sources, transform the data, and finally load the data to PowerPivot. However, I have recently found that Power Query could also be a very handy SharePoint Metadata viewer to inspect the schema of SharePoint sites, lists, content … Continue reading Inspecting SharePoint Metadata using Power Query
Data Ninjago (Finsight-Tech Blogs) 
You must be logged in to post a comment.