This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl Blogs - Home (page 17 of 24)

Showing blogs 321-340 (out of 473)

Add the ComicGen custom visual to your Power BI reports to spice them up!

Posted by Andy Brown on 27 April 2020

The ComicGen custom visual allows you to show one of two characters (Dee or Dey) in a variety of poses, and with a range of emotions. Excitingly, the poses and emotions can depend on your data, making these the most human of KPIs. Find out more in this blog!

Tags:
Power BI > Visualisations

This parody of mistakes you can make building a website is surprisingly funny!

Posted by Andy Brown on 13 March 2020

A website which includes help messages which don't, a password with ridiculous rules, an unhelpful timer, annoying default options for almost everything - thoroughly recommended!

Tags:
Hardware/software > General IT

The answers to our exercises are now published online (for personal use only)

Posted by Andy Brown on 13 March 2020

We receive a fair few requests asking us to publish the answers to our exercises. We have now decided to do this, on the understanding that they are for your personal use only.

Tags:
Miscellaneous > Random musings

Talking to Excel to fill in your input forms, using speech recognition and VBA

Posted by Andy Brown on 13 March 2020

What happens when you combine the magic of speech recognition with the power of VBA? A user form which you can fill in without a keyboard!

Tags:
VBA macros > General

How to show rows with no corresponding data in a Power BI visual

Posted by Andy Brown on 12 March 2020

This modest blog explains how you can tell Power BI to show all of the members of a dimension table (even the ones which have no corresponding data).

Tags:
Power BI > Visualisations

Find out how dynamic arrays in Excel will change your (working) life!

Posted by Andy Brown on 14 February 2020

Dynamic arrays are a new feature being rolled out in Excel 365. This blog explains how they work, and why they will make so many things in Excel easier.

Tags:
Excel > General

Our series of Simple Talk tutorials on using DAX within Power BI is now complete

Posted by Andy Brown on 13 February 2020

Simple Talk provide excellent how-to guides on any aspect of Microsoft software. We are proud to have contributed a series of articles explaining how to create DAX calculated columns and measures within Power BI.

Tags:
Power BI > Measures / DAX

Microsoft have rewritten their Edge browser to be based on the Chromium platform

Posted by Andy Brown on 07 July 2023

Microsoft have completely rewritten their Edge browser. The result is (by design) very similar to Chrome - you can even use Chrome extensions -but is probably even easier to use than Google's browser.

Tags:
Hardware/software > General IT

Azure Data Studio versus SQL Server Management Studio

Posted by Andy Brown on 16 January 2020

Microsoft have brought out a new SQL editor called Azure Data Studio, to act as a substitute for SQL Server Management Studio, but this owl cannot see any justification for its existence!

Tags:
SQL > General

Introducing the new CREATE OR ALTER command in SQL

Posted by Andy Brown on 10 January 2020

From SQL Server 2016 onwards you can choose to CREATE OR ALTER a procedure, trigger, view or function, as this blog explains.

Tags:
SQL > SQL programming

Revelations about Power BI - hiding preview and left-click drill-through

Posted by Andy Brown on 10 January 2020

When we find new features which we didn't know about, we try to share them! Did you know that you can turn preview off when getting data? Or that you could left-click to drill-through? We didn't!

Tags:
Power BI > General

Announcing the first Wise Owl online training course (Excel VBA)

Posted by Andy Brown on 10 January 2020

After a huge investment of time and expertise, we're proud to announce that our first full online training course is now live on our website! The course shows you how to program in VBA in Excel, and is completely free (you don't even have to log in to follow it).

Tags:
VBA macros > General

YouTube Silver Award - 100K + subscribers!

Posted by Sam Lowrie on 25 November 2019

We're proud to announce that YouTube have given us their coveted silver award, in recognition of the fact that our video channel has over 100,000 subscribers.

Tags:
Hardware/software > General IT

You can now use AT TIME ZONE to access different time zones in SQL

Posted by Andy Brown on 25 November 2019

If you're working with different time zones, the AT TIME ZONE keywords introduced in SQL Server 2016 will make your life much easier - this blog explains how they work.

Tags:
SQL > Selecting data

History of Wise Owl: The early years

Posted by Jenny Brown on 22 November 2019

The story of Wise Owl starts in a basement in Chorlton-cum-Hardy in 1992, at a time when WordPerfect for DOS was still widely used and Lotus 1-2-3 ruled the spreadsheet roost.

Tags:
Miscellaneous > Nostalgia

Why I became a trainer

Posted by Shaun Wantling on 22 November 2019

People become trainers for many different reasons. In this blog, Shaun explains his journey from being an accountant to training people in IT.

Tags:
Miscellaneous > Random musings

Dynamic comparison calculations in DAX

Posted by Sam Lowrie on 08 November 2019

This blogs shows a clever way in which you can use a slicer to choose which values to compare in a measure.

Tags:
Power BI > Measures / DAX

Explaining the VALUE argument of the RANKX function in DAX

Posted by Sam Lowrie on 28 October 2019

The RANKX function does what the name implies - it ranks values based on a calculation. However, the VALUE argument often causes confusion; this blog explains what it does!

Tags:
Power BI > Measures / DAX

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

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl Blogs - Home (page 17 of 24)

Add the ComicGen custom visual to your Power BI reports to spice them up!

This parody of mistakes you can make building a website is surprisingly funny!

The answers to our exercises are now published online (for personal use only)

Talking to Excel to fill in your input forms, using speech recognition and VBA

How to show rows with no corresponding data in a Power BI visual

Find out how dynamic arrays in Excel will change your (working) life!

Our series of Simple Talk tutorials on using DAX within Power BI is now complete

Microsoft have rewritten their Edge browser to be based on the Chromium platform

Azure Data Studio versus SQL Server Management Studio

Introducing the new CREATE OR ALTER command in SQL

Revelations about Power BI - hiding preview and left-click drill-through

Announcing the first Wise Owl online training course (Excel VBA)

YouTube Silver Award - 100K + subscribers!

You can now use AT TIME ZONE to access different time zones in SQL

History of Wise Owl: The early years

Why I became a trainer

Dynamic comparison calculations in DAX

Explaining the VALUE argument of the RANKX function in DAX

A comparison of SQL Server Reporting Services and Power BI

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

Head office

London

Manchester