Well after getting the data and creating a report and then a chart, let’s get the report onto the web.
Dashboard Charts are the ultimate goal of most Power BI reports, so let’s dive in.
In the previous post we extracted the data from a CSV file. Now let’s create a report. It won’t be the greatest report as the data is pretty basic, but at least its a start.
OK I have bitten the bullet and decided to get stuck in to Power BI. I am going to start playing around with Power BI Desktop – it is free after all. I thought I would blog about the experience and share my journey. I have created a Power BI category. I now have a button on my website that will list Power BI posts.
Microsoft has released Power BI desktop edition for FREE.
Power BI allows you to create reports and dashboards from lots of different sources.
It is not an add-in to Excel, it is a standalone application.
You can download it at the link below.
It is a straight forward process to install.
M is for (Data) Monkey (Holy Macro! Books, 2015)
Don’t be put off by the title, this book is full of gold. It is chock full of tips, tricks and traps.
Power Query allows you to automate data cleansing operations on all sorts of Excel data – both internal and external.
Power Query can replace copying and pasting. No need for formulas and macros to get the data right.
Well worth purchasing – it will save you hours of work.