By Burningsuit

DAX Learning Power BI Resources 14th March 2018
Power BI

DAX: How to use a slicer to select different measures

DAX (Data Analysis Expressions) is a library of functions used across Microsoft SQL, including Excel and Power BI. These operators can be combined to perform a range of actions, through building expressions and formulas. Here is how to use DAX in Power BI to create a slicer to select different measures in a chart, using our experience as training providers: Using a slicer to select different measures on a chart What if you want to use a slicer to select… Read More

By Burningsuit

Learning Microsoft Power BI Resources Training 1st March 2018
Power BI

How to Use Power BI Bookmarks & New Features

Recently, a range of new features have been added to Power BI. From a user point of view, some of the most interesting are bookmarks, selections, links and hidden pages. These give much greater control over how users can interact with reports. Burningsuit Ltd Managing Director Stuart Box has created a guide and example uses for each feature to help you get to grips with what is possible: Activate Bookmarks Currently (February 2018) Bookmarks are still in Preview in Power… Read More

By Burningsuit

Power BI Resources 6th February 2018
Power BI

Power BI Free vs Pro

Power BI is the leader of the pack when it comes to Business Intelligence tools. Once you’ve chosen this software you need to consider which version to use. So, which one is best for your business? If you’re thinking about using Power BI business analytics tools to deliver insights throughout your organisation, there are two main versions of the application that you can consider: Power BI Free and Power BI Pro. Our in depth look at each shows exactly how… Read More

By Burningsuit

Power BI Resources 6th February 2018
Power BI

How to share Power BI Reports

Sharing Power BI reports is a good way to give more than one person in your business access to dashboards and reports, and is a productive feature in the Power BI Pro package. Through our training courses, we understand it can initially seem unclear how to share reports. What you need You and the person you are sharing the report with must both have a Power BI Pro license. Unfortunately, you are unable to collaborate and distribute your reports using… Read More

By Burningsuit

Microsoft Power BI Resources 28th November 2017
Power BI

Power BI vs Tableau: Five reasons Power BI wins

When it comes to business intelligence tools there is no doubt that the two front-runners are Power BI and Tableau. With both of them being very similar products, it can be tricky to choose which one is best for you. It would be easy for us to simply say that Power BI trumps Tableau and you shouldn’t even consider Tableau as an option, but the truth is the best product very much depends on you, your organisation, budget and your intended use… Read More

By Stuart Box

Power BI Resources Training 29th September 2017

We could tell you but then……

We’ve been training Power BI since its first release. It’s an interesting application to learn, as the monthly updates mean there is always something new to master before training others. I’m staggered to find that there have been over 800 new features brought in to Power BI Desktop and Service since July 2015. I’ve often said, we have to run as fast as we can just to keep up with the release schedule. But now we’ve got help. Earlier this… Read More

By Alison Box

Excel Power BI Resources 12th May 2017
Burningsuit blog post featured image graphic

Quick Measures or Quick Fix – are Power BI’s Quick Measures up to the mark?

Hey Excel users, anyone remember this? Yes, it’s the now defunct “Lookup Wizard” which, according the MSDN Library entry of January 1996, “…helps Excel users create lookup formulas quickly. Even expert users will find the Wizard’s lookup formulas useful in advanced spreadsheet and application development projects” Well, this was obviously not the case or else this “useful” wizard would still be with us today.  What “expert” Excel user can’t construct a simple Vlookup or even use the fiddly Index/Match combo?… Read More

By Stuart Box

Microsoft Power BI Resources 13th March 2017

Theme Colours in Power BI

The March update to Power BI has added a host of new features, take a look here to see them all. One preview feature we've been waiting for is the ability to use "Theme Colours", packages of colour themes for charts and graphs. So now we can customise our Dashboards and Reports to use corporate colours, highlight particular data sets, or just get some differentiation by using some funky colours. One slight downside to this is that the themes are… Read More

By Stuart Box

Power BI Resources 21st February 2017

Top Five Reasons to Persuade Your Boss to Implement Power BI

We love Power BI, and have run many courses in it. The cloud-based data analytics tool speaks to our inner data geek. I can manipulate large amounts of data, and produce informative and compelling dashboards and reports, then share them with my colleagues, easily quickly and without having to be a programmer or “Power User”. Our course attendees love Power BI too, but some of them have said that they need to convince their Boss to implement it. So, if… Read More

By Stuart Box

Power BI Resources 6th July 2016

Power BI Resources

We're doing a lot of training in Microsoft's Power BI, from PowerPivot in Excel to the new Power BI service. To help our trainees, and anyone else that finds it useful, I've collated a number of resources we use to learn and teach Power BI, I hope you find them useful. Books Applied Microsoft Power BI - bring your data to life by Teo Lachev and Edward Price Teo pulls of a difficult job in writing about a service that… Read More