This page has 0 threads | Add post

Blogs

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

Wise Owl Blogs - Home (page 14 of 25)

Showing blogs 261-280 (out of 487)

Using the CalendarAuto function effectively in Power BI

Posted by Andy Brown on 24 November 2021

This blog shows how to generate a table which includes not only all of the dates in your data model, but also a range of aggregator columns such as financial year and month name for reporting purposes.

Tags:
Power BI > Dates and calendars

What is SQLCMD mode, and how can you use it?

Posted by Andy Brown on 24 November 2021

You can use SQLCMD mode to parameterise the connection, database name, table name and select columns for a query - and much more besides, as this blog explains.

Tags:
SQL > SQL programming

A Power Automate flow to send Xmas gift emails automatically

Posted by Andy Brown on 18 November 2021

Tired of doing repetitive tasks at Christmas? This blog shows you how to create a Power Automate Desktop flow to send emails out to your nearest and dearest programmatically, with each email including instructions on how they should use the gifts they've been given.

Tags:
Power Automate Desktop > Case studies

Introducing Power Automate Desktop

Posted by Andy Brown on 18 November 2021

Power Automate Desktop allows you to automate any common sequence of tasks that you perform in Windows, and has the potential to change your working life. So what is it?

Tags:
Power Automate Desktop > General

International Keyboard Short-Cut Day 2021 - 10 Windows key short-cuts

Posted by Andy Brown on 28 October 2021

To commemorate the rather dubious International Keyboard Short-Cut Day 2021 (the first Wednesday in November of each year, apparently), we offer the 10 Windows key short-cuts which will save you the most time.

Tags:
Hardware/software > Windows

Using personal bookmarks to persist filters

Posted by Andy Brown on 28 October 2021

In Power BI Service you can now create personal bookmarks to retain any changes you've made to filtering for a report.

Tags:
Power BI > Bookmarks and filters

Persistent report filters in Power BI

Posted by Andy Brown on 28 October 2021

Consumers of your reports can alter filters, but you can change an option to prevent these changes persisting for other users.

Tags:
Power BI > Bookmarks and filters

Sharing Power BI Reports using Teams

Posted by Andy Brown on 28 October 2021

You can add a tab for a Power BI report within a Teams channel, and also share a report from Power BI Service within Teams - this blog shows you how to do both these things!

Tags:
Power BI > General

Reading Outlook emails and downloading attachments using Python

Posted by Andy Brown on 08 October 2021

This blog shows how you can use Python to loop over all of the emails in a folder in Outlook, saving the attachments for each to your hard disk.

Tags:
Python > Progamming

Python ModuleNotFoundError in VS Code using Code Runner

Posted by Andy Brown on 08 October 2021

How to solve the problem that Visual Studio Code can't find a module that you've imported.

Tags:
Python > Visual Studio Code

Need a short diversion? Here our 5 random sites to amuse, plus one bonus one

Posted by Andy Brown on 29 September 2021

Some of the sites on this page will make you laugh, and some make you shake your head, but they should all entertain you for a moment or two!

Tags:
Miscellaneous > Random musings

Five differences between Python and other languages

Posted by Andy Brown on 31 August 2021

How does Python compare with other programming languages like C#, VB or SQL? This blog looks at the differences we've come across in preparing our Python courses and videos.

Tags:
Python > General

What to do with your IKEA bags?

Posted by Andy Brown on 31 August 2021

The IKEA blue Frakta shopping bag is iconic, and everywhere. Here are 5 suggestions (not always totally serious) for how you can recycle your IKEA bags!

Tags:
Miscellaneous > Random musings

Review of a book on the Stuxnet worm

Posted by Andy Brown on 31 August 2021

The Stuxnet worm was one of the most sophisticated bits of software ever written. Find out exactly how the US and Israel used it to target Iranian uranium centrifuges, and see the implications this has for us all.

Tags:
Miscellaneous > Random musings

A swear-word alternative to What 3 Words

Posted by Andy Brown on 27 July 2021

You may know about What 3 Words, which allows you to pinpoint your location in the world using just 3 words. Now there's Four King Words, which does the same for the UK and Ireland using just 4 swear words.

Tags:
Miscellaneous > Random musings

9 interesting facts about emojis to lighten your day

Posted by Andy Brown on 27 July 2021

Do you know why World Emoji Day is held on July 17th each year? Or how to see the world's emojis being tweeted in real time? Or that Microsft are trying to resurrect Clippy the paper-clip as an emoji? These are just 3 of the 9 fascinating facts explained in this blog!

Tags:
Miscellaneous > Random musings

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

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

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR

Wise Owl Blogs - Home (page 14 of 25)

Using the CalendarAuto function effectively in Power BI

What is SQLCMD mode, and how can you use it?

A Power Automate flow to send Xmas gift emails automatically

Introducing Power Automate Desktop

International Keyboard Short-Cut Day 2021 - 10 Windows key short-cuts

Using personal bookmarks to persist filters

Persistent report filters in Power BI

Sharing Power BI Reports using Teams

Reading Outlook emails and downloading attachments using Python

Python ModuleNotFoundError in VS Code using Code Runner

Need a short diversion? Here our 5 random sites to amuse, plus one bonus one

Five differences between Python and other languages

What to do with your IKEA bags?

Review of a book on the Stuxnet worm

A swear-word alternative to What 3 Words

9 interesting facts about emojis to lighten your day

The Magic of the Power Query SHARED Global Environment

Showing Small Multiples in Power BI charts

5 short tips for Power BI

Power BI Reports vs. Paginated Reports

Head office

London

Manchester