SQL Dusty

Dustin Ryan works at Microsoft  and he shares a lot of his knowledge for free on his website.

This great site has lots of free content to help you get the most out of Power BI – from beginners to old hands.

Free videos and other content make this a great site to bookmark and check regularly.

It covers a lot of other topics that are related to Power BI as well.

Enjoy!

Power BI – Just starting out

The start of my journey

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.

Power BI Desktop – Download

Its FREE!

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.

Click the here to go to the Microsoft site to Download Power Bi Desktop

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.

 

Great DAX formula site

This website is a great resource for the DAX formula language used in PowerPivots in Excel 2010 and Excel 2013. The site contains solutions to common reporting requirements in PowerPivot Reports They have also published a book based on the content which is cheap as a Kindle edition, I have recently bought it.

Great PowerPivot Site

SQLBI – this website is a great resource for the PowerPivots in Excel 2010 and Excel 2013. Some of it is quite Advanced. See also the DAXPatterns site. These guys have published a few books and I own a couple of them.