Wise Owl Blogs - Home (page 2 of 32)

Showing blogs 21-40 (out of 632)

The Magic of the Power Query SHARED Global Environment

Posted by Andy Brown on 26 July 2021

How to use the #shared keyword to bring up a list of all of the M functions in Power BI Query, and then use this list to create your own help table or even your own function.

Tags:   Power BI | Query editor

Power BI July 2021 Update

Posted by Andy Brown on 26 July 2021

This month's update sees the launch of small multiples, a range of new dynamic format properties and the roll-out of sensitivity labels.

Tags:   Power BI | Updates

Showing Small Multiples in Power BI charts

Posted by Andy Brown on 26 July 2021

Small multiples are mini-charts shown in a two-dimensional grid, with each chart showing the state of play for a different field's value. After a number of improvements small multiples have finally emerged from preview!

Tags:   Power BI | Visualisations

5 short tips for Power BI

Posted by Sam Lowrie on 19 July 2021

Sometimes our Owls come across little titbits that aren't big enough to count as a full meal. Instead we bide our time and create a smorgasbord of little bites for you to feast on. With that in mind, here are 5 Power BI tips that you might not know.

Tags:   Power BI | General

Power BI Reports vs. Paginated Reports

Posted by Andrew Gould on 19 July 2021

Confused about the difference between Power BI Reports and Power BI Paginated Reports? Allow this blog to clear up the confusion!

Tags:   Power BI | General

Project yourself on your shared screen in Teams

Posted by Andy Brown on 01 July 2021

You can now share your screen in Teams, and have your floating head appearing on top of it (the effect is weird if you're the presenter).

Power BI Channels you should watch

Posted by Sam Lowrie on 01 July 2021

There are many great resources for learning Power BI, and so many of them are completely free! Level up your BI skills with some of the best. Here Sam covers some of his favourite BI channels. You even get a glimpse behind the curtain to see other channels he watches!

Tags:   Power BI | General

Practise SQL in your browser with SQL Fiddle

Posted by Sam Lowrie on 01 July 2021

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

Tags:   SQL | General

Useful short-cut keys for use in the DAX formula editor

Posted by Andy Brown on 30 June 2021

DAX contains a number of incredibly useful hidden short-cut keys, allowing you to move lines, comment code and much more!

Tags:   Power BI | Measures / DAX

June 2021 Newsletter Competition Winner and Answer

Posted by Andy Brown on 30 June 2021

We received 27 correct entries for last month's COVID-safe logic puzzle competition - you can see the winner and correct answers here.

July 2021 newsletter competition - search the globe!

Posted by Andy Brown on 30 June 2021

After a few challenging puzzles, this month's should be a nice easy one - just use the WHAT 3 WORDS website or app to find the four listed locations, and work out which one is missing!

Power BI Desktop update - June 2021

Posted by Andy Brown on 29 June 2021

This update only includes a couple of tweaks for charts, although more excitingly the paginated reports visual is now in preview.

Tags:   Power BI | Updates

The ridiculously wide Samsung CRG9 49" monitor

Posted by Andy Brown on 02 June 2021

How wide is too wide when it comes to a computer monitor? Perhaps the answer depends on the size of your desk, but you'll need plenty of space for this monster.

Answers and winner for our May 2021 film reviews competition

Posted by Andy Brown on 02 June 2021

Our film reviews competition was won by Andrew Kenyon of NICE, with his review of Die Hard, with runners-up reviewing Apollo 13, 2012, Skyfall and Avatar.

June 2021 Wise Owl Newsletter Competition

Posted by Andy Brown on 02 June 2021

For this month's competition you are invited to work out which work colleagues received which COVID vaccine on which days, using the grid supplied as an aide. The first correct answer picked out of our randomised sorting hat will receive a fifty-pound Amazon voucher!

Our experience of switching to Stripe payments

Posted by Andy Brown on 01 June 2021

This is the blog which I wish I could have read before starting to integrate Stripe payments on our website! It explains why I'm ultimately glad we went for Stripe, but also some of the things which are harder than they need to be.

Creating picture charts in Power BI using the Infographic Custom Visual

Posted by Andy Brown on 19 May 2021

Want to use your pet's picture for a column chart? This blog shows how to create stacked picture charts in Power BI using the powerful Infographic custom visual.

Tags:   Power BI | Visualisations

Power BI Desktop update for May 2021

Posted by Andy Brown on 19 May 2021

May's update to Power BI Desktop is a big one, encompassing new ways of viewing models, tables and fields, a new text box, smart narratives (to explain data) and a new anomaly detection feature (to explain exceptions).

Tags:   Power BI | Updates

Understanding our figure for outstanding reviews

Posted by Andy Brown on 10 May 2021

Our website quotes an impressive figure for our average feedback from courses given, but how is this calculated, and how can you know that it's accurate?

Easter Quiz 2021 - Competition Winner, Results and Analysis

Posted by Andy Brown on 03 May 2021

Congratulations to Pat Watt of Skills Development Scotland for winning the prize this month (and generously donating it to charity) - answers and winners here!

This page has 0 threads Add post