Automate Power BI Data Refresh to Sage Line 50 (or Other Sources) via Microsoft Query with Powershell, Task Scheduler and Excel Continue reading Power BI 'How To' Blog Number One
tag Dashboards
Best known for being very easy to get started, you might expect it to be skin deep. Not so; not only is graphical modelling environment very powerful, its DAX (data analysis expressions) formula language has a rich set of powerful functions. Continue reading Cool Things About Power BI
The push for visualisations in modern BI products means that more and more products are available to make our data look pretty and engaging. However one analyst’s taste for bright colours and crowded dashboards might not suit the engineer’s taste for simple outlines and clear labelling, while the marketeer’s taste for neutral tones and bold graphics would be fulfilled by neither. Continue reading What's Wrong with Pie Charts and 15 Top Visualisation Tips
Connecting to data stored in Excel spreadsheets or other file sources is great for prototyping Power BI dashboards, gaining quick insight and showing others what the tool can do. Continue reading Options for Connecting Power BI Dashboards Directly to Source Systems
If we asked you what data visualisation was about, what would you say? The easy answer is that data visualisation is simply about the display of data, and to many, it is. Continue reading How to Get the Most Out of Data Visualisation and Dashboards