Data Analysis Expressions, known as DAX, is the Function language that is used to solve data analysis problems in Power BI. DAX is used in the much the same way that you use Formulas to solve analysis problems in Excel. These expressions, when used in Measures, analyse our data by applying or removing specific filters from the data, filters that would be difficult to accomplish with the normal filtering tools in Power BI such as Slicers and Visual Level Filters.… Read More
THE BURNINGSUIT BLOG
Case Study: Consultancy with Berry Bros. & Rudd
In 2018 the world-renowned wine and spirit merchant Berry Bros. & Rudd attended a public London course with us, and then booked several consultancy days, also in the capital. About Berry Bros. & Rudd Operating since 1698 from the same central location in London, Berry Bros. & Rudd are Britain’s oldest wine and spirit merchant, and now have offices worldwide. With their history and experience, they stock over 4000 fine wines selected by their Masters of Wine. Still family-run, they… Read More
Invest in training in Power BI for your team
Training your team is vital to ensure their skills are up to scratch, as well as ensuring that everything in your business is running as smoothly as possible. When it comes to Power BI, it is a very powerful system and training your staff members how to utilise it to its full potential is vital to get the best return on the investment you have made in software licences and business time. Discover here how training your team in Power… Read More
Case Study: Power BI Training with Arthur J. Gallagher & Co.
In 2018 the international insurance and reinsurance company Arthur J. Gallagher & Co completed five Power BI courses with us onsite in London. About Gallagher Gallagher, founded in the 1920s, provides insurance, risk management and consulting services for businesses, based on a history of passion and excellence. Significantly, they are the only insurance broker on the Ethisphere Institute's list of the World's Most Ethical Companies. As part of their services, they work with a large amount of sensitive data that… Read More
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
Data Visualisation Tools: 4 Creative and Inspirational Dashboard Examples
Power BI is a useful tool in a wide range of fields and industries because its dashboards and reporting functionalities can be tailored and implemented to reflect your company’s exact requirements. With this being the case, there are some really unique and useful dashboards out there with some of the best being found in the Power BI Data Stories Gallery. We spoke to our Director, Stuart Box, who has put together a guide of useful elements to consider when creating… Read More
Case Study: Training Heathrow Airport Staff
Heathrow Airport is the UK’s largest airport, serving 204 destinations in 85 different countries and with 78 million passengers passing through the airport in 2017. Burningsuit have been providing Power BI Training and Consultancy to Heathrow Airport since August 2017. Heathrow Airport approached us after two of their staff members attended one of our Public Microsoft Power BI Service Courses in London in August 2017 and found the training useful and appropriate. Following this, Heathrow decided to book several on-site… Read More
DAX: Is the Total Row in a table giving you grief?
If you are having issues with the total row of tables in DAX, this may be a familiar sight: When actually, all you want is this: So, what’s going on here? Why does my first table multiply the totals together, but my second table sum the values in the column above? Stuart Box, Owner of Burningsuit explains. Our solution to create the correct table In the first measure, “Sales V1”, I used this DAX expression: Sales V1 = SUM… Read More
DAX: How to group measures into numeric ranges
DAX (Data Analysis Expressions) is a useful library of functions used across Power BI, Excel and SQL. Stuart Box, Burningsuit's owner and trainer who is both a Microsoft Certified Professional and Member of the Learning and Performance Insitute, explains how to use DAX in Power BI to easily group or categorise numeric fields into ranges (sometimes called 'bins') below: How to group numeric fields Firstly, right click on the numeric field in the field list, as select “group”. Once grouped, you can… Read More
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