Wise Owl blogs written by Andy Brown (page 1 of 17)

Showing blogs 1-20 (out of 330)

Our take on the new features introduced in the October 2019 update for Power BI

Posted by Andy Brown on 20 October 2019

This month's big story is a huge range of improvements to the Q&A feature in Power BI, with more in the preview pipeline. There are also a built-in PowerApps visual, improvements to data profiling in Query Editor and a new template for connecting to datasets.

Tags:   Power BI | Updates

A comparison of SQL Server Reporting Services and Power BI

Posted by Andy Brown on 18 October 2019

Power BI improves with each monthly update. Will it reach a point where SSRS (SQL Server Reporting Services) becomes redundant? This detailed blog compares the two products, and considers the future of SSRS.

Tags:   SSRS | General    |    Power BI | General

Excel MasterClass: creating a worksheet and chart to track your weight

Posted by Andy Brown on 14 October 2019

It's fairly easy to create a simple Excel worksheet to chart your weight, but this master class shows you lots of tips and tricks to make the final result quicker to create and easier to use.

Tags:   Excel | Masterclass

The Wise Owl October 2019 newsletter competition - complete the phrase

Posted by Andy Brown on 14 October 2019

Test your Excel skills by finding a way to follow a series of instructions to accumlulate numbers and unlock the hidden question.

Tags:   Musings | Competitions

The answer to (and winner of) our September 2019 newsletter competition

Posted by Andy Brown on 11 October 2019

This month's word search proved challenging, with only four correct answers submitted. The unused letters in the word search revealed a question, as this blog explains.

Tags:   Musings | Competitions

The competition for the Wise Owl September 2019 newsletter

Posted by Andy Brown on 23 September 2019

If you're a subscriber to the Wise Owl newsletter you can enter our competition and win a fifty-pound Amazon voucher (this month's puzzle is a word search with a twist).

Tags:   Musings | Competitions

The answers to our August 2019 newsletter competition (SQL query)

Posted by Andy Brown on 23 September 2019

Last month's newsletter competition asked you to identify 8 errors in a SQL query. Here are the results, with the name of the lucky winner!

Tags:   Musings | Competitions

Some ideas for lunch boxes for the school run or the office microwave

Posted by Andy Brown on 23 September 2019

Bored of the same sandwich every day? Be creative, and try one of these recipes from Lunchbox Dad.

Tags:   Musings | Random musings

Andy Brown of Wise Owl reviews his top 15 podcasts - see if you agree!

Posted by Andy Brown on 23 September 2019

When travelling to Wise Owl training courses Andy Brown is a podcast enthusiast. In this blog he lists his 15 favourites - see if yours make the cut, or if there are any in the list that you haven't heard of.

Tags:   Musings | Random musings

Introducing three new functions in SQL to make concatenating text easier

Posted by Andy Brown on 20 September 2019

The CONCAT function makes it much easier to join columns together, while the STRING_AGG and CONCAT_WS functions make it easier to create things like comma-delimited lists.

Tags:   SQL | Calculations

A summary of the changes introduced in the September 2019 update to Power BI

Posted by Andy Brown on 20 September 2019

This month sees the welcome (if belated) introduction of Excel-style custom number formats, as well as more (and easier-to-create) themes and a host of other minor improvements.

Tags:   Power BI | Updates

Using the new Power BI template app to view Google Analytics data

Posted by Andy Brown on 20 September 2019

How to create a new app to view your Google Analytics data in Power BI Service.

Tags:   Power BI | Data sources

Introducting the new XLOOKUP and XMATCH functions

Posted by Andy Brown on 13 September 2019

Microsoft have finally recognised the limitations of the VLOOKUP function, and are rolling out the XLOOKUP function to supersede it, as well as the useful (if less significant) XMATCH function.

Tags:   Excel | General

A summary of new features introduced in the August 2019 Power BI update

Posted by Andy Brown on 19 August 2019

This was a month of few updates. Our favourite by far is that you can now group visuals, but the Key Influencers visual has also emerged from the preview shadows.

Tags:   Power BI | Updates

We have unearthed two new sources of information on future Power BI features

Posted by Andy Brown on 14 August 2019

In addition to the Power BI preview features dialog box, Andy Gould has discovered two excellent new sources of information on forthcoming changes for Power BI, as this blog explains.

Tags:   Power BI | Updates

How to confuse other Excel users by changing your cell styles

Posted by Andy Brown on 14 August 2019

Want to make a worksheet inexplicably change colour, and display strange text in cells? This blog explains how you can do this using the Normal style.

Tags:   Excel | Formatting

Another OOH moment in Excel - a quick way to create charts

Posted by Andy Brown on 14 August 2019

The previous blog listing great OOH moments in Excel omitted one of the biggest - the absolute quickest way to create a chart.

Tags:   Excel | Charts

Congratulations to Shaun Rowark for his suggestion for a new acronym for SFWGHO!

Posted by Andy Brown on 14 August 2019

We're always on the look-out for a new acronym for the order of SQL commands, and are pleased to award a gift voucher to another worthy winner of our competition.

Tags:   SQL | General

See how the Wise Owl stand came about at the Public Sector Expo

Posted by Andy Brown on 14 August 2019

We attended our first proper exhibition in June 2019, as these pictures attest.

Tags:   Musings | Exhibitions

The new Office 365 icons are horrible, but you are probably stuck with them

Posted by Andy Brown on 05 August 2019

For nearly all new Microsoft software updates Wise Owl are prepared to wait before commenting, but the new Office 365 icons are much harder to read and distinguish than the old ones!

This page has 0 threads Add post