Stay updated with the latest news, tutorials, and best practices for using Microsoft products and services to their full potential.
Power BI is an ever evolving app with Microsoft releasing new features on a monthly basis as voted for by users. It’s almost a fulltime job just keeping on top of all these new developments, not to mention sifting out which features are going to be most beneficial. Well fear not, our dedicated Power BI […]
(In conversation with Jens, one of our Excel/Power BI trainers) In this post we sit down with one of our training delivery team, Jens, to look at the pros and cons of Excel and Power BI when considering which reporting path is best for you and your organisation. Jens, you mentioned a frequently occurring question […]
One word That describes Power Query in Excel – MAGIC! Power Query will completely change the way you work in Excel! For most Excel users, Power Query could be the tool that reduces time spent in Excel dramatically. Power Query could also minimise the use of VBA coding in Excel. It can be seen as a […]
Using Live Events efficiently in Microsoft Teams Microsoft Teams meetings are great for a few people to meet, but for a larger scale online webinar, the option of a Live event will be more efficient. This blog discusses how to use Live Events efficiently in Microsoft Teams. The organisers can line up content for a […]
When managing a project using Microsoft Project, stakeholders often need to receive progress updates. Because not everyone can read a Gantt chart, MS Project comes with a set of pre-designed reports and dashboards to help you better understand your data. You can easily create amazing reports with Microsoft Project. Below is an explanation of the […]
What is Power BI? Perhaps you have heard it said that everybody should be using Power BI. But what is it, exactly? Power BI is a collection of software services, apps, and connectors. These work together to turn unrelated data sources into coherent, visually immersive, and interactive insights. The application consists of several elements that […]
Changing to Office 365 Office 365 has more applications, as well as faster and more collaborative ways to work and communicate than ever before. There are both online and desktop versions available for most of the apps. Office 365 also offers amazing new tools and features. Are you upgrading to Office 365 but finding that […]
A lot of people out there think that the story of Power BI is too good to be true. Here is a list of the reasons that we think you should consider Power BI as a self-service and/or Enterprise Business Intelligence Solution. It’s like the new Microsoft Microsoft have not been the best at listening […]
With the Analytics Pane in Power BI, you can quickly and easily make dynamic reference lines, which can be extremely helpful when analysing data and making key business decisions. From simple trend lines to more complex forecast lines, there are so many options to choose from! First, find the analytics pane by going to the […]
Are you getting the best out of your OneDrive for Business? With storage of more than 1TB per user, OneDrive provides a fantastic cloud service to work with your documents and images. Read these tips to learn how to maximise your use of this amazing application! Add Content Quickly You can easily create new documents […]
If you’re working from home and not using MS Teams to co-ordinate your efforts, you’re possibly not being as productive as you could be. In this article learn more about Microsoft Teams and how this super-app could save you and your team not just time, but also probably a few headaches too! 1. Improve your […]
Why use What if? Have you ever wanted to quickly demonstrate how your data changes in different scenarios? The What if parameter in Power BI is a powerful tool that allows you to do just this, by dynamically transforming your data. For example, maybe you want to know how much your profits will increase if […]
I can use What If analysis, how can I make this even better? In Part 1 we learnt how to create a simple What if parameter in Power BI. However, you will have more options for analysing your data if you create the parameter tables yourself. This lets you not only work with nonlinear incremental […]
There’s a reason why firms spend millions investing in data sets or in curating their own data recovery and organisation methods. Maximising the use of collected business data is an important proofing system required at every stage of your decision-making process . Statistics and an informed look at results will always be your friends. If […]
For many years, Microsoft Excel has been the tried and tested reporting tool for many businesses. In 2019. more and more organisations are turning to Power BI as an alternative with its strong analytics and reporting functions. With faster visualisations, statistical functions and calculations across broad datasets, it’s obvious that Power BI can […]
Having the right business intelligence at your fingertips is crucial in the drive to become agile and competitive. As businesses grow, it becomes increasingly difficult to manage data being generated regularly. With a siloing effect and biased reporting structures, it leads to the decision makers in business to make their judgement on data that may […]
Our FEBUARY Power BI blog had some great insights and tips into creating power bi tooltips – so what else is new for Power BI? Python Visuals In February 2019, Microsoft have announced an update of Power BI where you can now share, publish and view Python visuals in your reports and dashboards. This update […]
Excel charts are great visual tools to show changes in data. You can build dynamic charts in Excel with a few easy steps. Below is an example of a table which can be used to build an interactive chart. The Quantity column’s values are simply entered into the cells, but the Revenue figures are the […]
We all wish we could do more with the time we had, but our inbox tends to get in the way of the productivity boost we’re craving. Here, we’re going to take a look at 10 effective email management tips that can help you save time, get productive, and even get a step closer to the […]
Office 365 has been around for a long time, but should your business start using it? The short answer is yes, particularly if you care about productivity! To embellish on this, here are 15 reasons your company needs to use Office 365, starting today: Improved Planning With the calendar requests feature, you can schedule and plan […]
Is it worth taking advantage of the Free Upgrade to Windows 10? Microsoft are offering Windows 10 as a Free upgrade for Windows 7/8 users. Why should you upgrade, is it really worth it? Windows 7 users are decidedly hesitant, after all, Windows 8 removed the Start Menu, Power Button and adjusted how individual Windows closed! Is Windows 10 something to be […]