By Burningsuit

DAX Learning Power BI Resources Training

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

By Burningsuit

DAX

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

By Burningsuit

DAX

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

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

Power BI Resources

What is the difference between BI reports and dashboards?

There is a misconception that the Power BI report is a detailed tabular report and that the dashboard is an interactive visualisations with charts. This isn’t the case and in order to build effective power BI solutions, you will need to understand the differences, and in a way that can help you to leverage their unique powers to the greatest possible effect. After the February 2018 update to Power BI Service, both Reports and Dashboards can be shared. It’s a… Read More

By Burningsuit

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