This page has 0 threads | Add post

Blogs

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

Wise Owl Blogs - Home (page 18 of 25)

Showing blogs 341-360 (out of 487)

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

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

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

Wise Owl movie connections

Posted by Andrew Gould on 19 August 2019

Lots of our training material uses examples related to movies but did you know that Wise Owl has several tenuous connections to famous films?

Tags:
Miscellaneous > Random musings

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

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl Blogs - Home (page 18 of 25)

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

Introducing three new functions in SQL to make concatenating text easier

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

Wise Owl movie connections

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

How to confuse other Excel users by changing your cell styles

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

Head office

London

Manchester