This page has 0 threads | Add post

Blogs

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

Wise Owl blogs written by Andy Brown (page 16 of 20)

Showing blogs 301-320 (out of 394)

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

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

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

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

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!

Tags:
Hardware/software > Microsoft Office

How to switch between monthly and bi-annual updates for Office 365

Posted by Andy Brown on 05 August 2019

Most people will be on either the monthly or semi-annual update channel for Office 365. This blog shows how you can find out which channel you are on, and how to change your channel.

Tags:
Hardware/software > Microsoft Office

How to view the SQL query for a series of transforms in Query Editor

Posted by Andy Brown on 02 July 2019

Did you know that you can view the SQL for a query in Power BI's Query Editor? Me neither!

Tags:
Power BI > Query editor

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl blogs written by Andy Brown (page 16 of 20)

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)

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

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

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

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

How to switch between monthly and bi-annual updates for Office 365

How to view the SQL query for a series of transforms in Query Editor

Head office

London

Manchester