By Alison Box

Learning Microsoft Power BI in Practice

It’s Complicated – Dealing with Many to Many Relationships in Power BI

If you're building a DataModel in Power BI, and creating relationships between tables you may have come upon this message. What the heck does "Cardinality Many-Many" mean? And what is the "Significantly different behaviour" they're warning me about here? In this post I set out to find out what these Many-to-Many relationships mean and how they work. The answer is complicated, but worth understanding if you want to create efficient data models in Power BI. Two Types of Many-to-Many Relationship… Read More

By Stuart Box

Microsoft Power BI in Practice

The Filter Pane Pain in Power BI

The July 2019 update to Power BI is now out, you can get all the details from Microsoft here. As usual there are a list of new features and tools released in the product. One of the main updates is the release of the new Filter Pane. Existing reports can upgrade to the new pane through the Options dialog, but any new reports should automatically have the new pane on by default. The Filter Pane is a new way of… Read More

By Stuart Box

Microsoft Power BI in Practice

Joke’s Over – send Email to users when refresh fails

I do a lot of Power BI Training, and have been doing it since Power BI came out over three years ago. So to keep myself fresh, amuse myself and hopefully my delegates, I've built several "Jokes" into my Power BI training. But now with the latest update to the Power BI service one of my favourite gags has been stopped. The joke used to go like this. The Tale I'm an Office 365 users, that means my Email, Diary,… Read More

By Burningsuit

Microsoft

Burningsuit Featured at the Microsoft Business Applications Summit

This week, the Burningsuit team were delighted to attend the Microsoft Business Applications Summit which took place in Atlanta, Georgia. The summit featured many insightful talks, training sessions and updates about the Power BI platform. Keep an eye out for our next blog post that will be an in-depth look at the two day event and everything that we experienced and learnt. For now, discover why this summit is so important for our industry and our main highlight from the… Read More

By Burningsuit

Excel Microsoft
Excel

Microsoft Excel: Why you Need to be an Expert!

Microsoft Excel is one of the most well known and used computer programs in the world. Whilst you probably know the basics of how to use it, there are many benefits to undergoing training and improving your knowledge and skills. Discover our top reasons why you need to become an expert in Excel. Improve your day-to-day work life In the majority of office jobs, there is at least some need to use Microsoft Excel, from HR tasks to big data… Read More

By Burningsuit

Excel Microsoft Power BI Resources
Power BI

Why Power BI is the future of Excel

Microsoft’s Power BI is powerful and easy to use, and with new features being added every week, it is fast becoming the future for business analysis. Excel formulas and pivot tables may well be the most popular programming language in the world, and the addition of tools like Power Query, Power Pivot, Power Map, and Power View mean you can connect to, clean, remove duplicates and transform almost any data you have. We have discussed the benefits of Power BI… Read More

By Burningsuit

Learning Microsoft Power BI Resources Training
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

Microsoft Power BI Resources
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

Microsoft Power BI Resources

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

Cloud Microsoft Office 365

The great Office 365 Turn Off

After nearly twelve years I've finally been able to turn our Server off, permanently! Most businesses need a server, something that collects and redistributes email, stores files, manages users and communications, stuff like that, and we are no exception. Our first server, way back in 2000 was a second-hand laptop, running Linux that ran "sendmail" and other arcane Linux applications. That "server" sat in the loft and just about managed our email and internet. Back in those days, we had a… Read More