BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
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.
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!
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.
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!
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!
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!
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!
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.
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.
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).
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!