Wise Owl blogs written in 2019 (page 4 of 4)

Showing blogs 61-74 (out of 74)

Andy B's five biggest OOH! moments on an Excel training course.

Posted by Andy Brown on 09 May 2019

All trainers live for that moment when someone's face lights up, as they learn something new which will change their working life for the better. This blog lists my 5 biggest such OOH moments from our Excel training courses. How many of these tips do you know?

Tags:   Excel | General

A summary of the main new features in Visual Studio 2019 for BI developers

Posted by Andy Brown on 08 May 2019

Visual Studio 2019 has a different look (particularly for creating new projects), but Wise Owl can't see any compelling reason to upgrade.

Changes that BI developers can expect from SQL Server 2019

Posted by Andy Brown on 08 May 2019

SQL Server 2019 is not out yet (it's scheduled for release in the second half of 2019), but this blog shows what changes you can expect to see.

Mapping stored procedure parameters to SSRS parameters

Posted by Andy Brown on 02 May 2019

This blog explains why you might want to use the PARAMETERS tab in the Dataset Properties dialog box in SSRS.

Tags:   SSRS | Parameters

The April 2019 update to Power BI has many good features, as this blog explains

Posted by Andy Brown on 18 April 2019

The April 2019 update to Power BI introduces a new concept: the ability to make the value of a property dynamic. Other welcome new changes include M Intellisense, data profiling in query editor and cross-report drill-down.

Tags:   Power BI | Updates

A new acronym for the order of SQL keywords

Posted by Andy Brown on 29 March 2019

Someone has finally won our competition to think of a better acronym for the order of keywords in SQL, we're pleased to announce.

Tags:   SQL | Selecting data

The March 2019 update of Power BI allows you to create multiple table layouts

Posted by Andy Brown on 21 March 2019

In addition to all of the wonderful new features in the March 2019 Power BI update that I blogged about yesterday, you can also create multiple database relationship diagrams (or layouts).

Tags:   Power BI | Updates

Read about the many new features introduced in the March 2019 update

Posted by Andy Brown on 20 March 2019

This is the biggest single update for some time, introducing the new modelling view, tooltip styling, single-select slicers and much more besides.

Tags:   Power BI | Updates

Getting Started with Power BI Report Server

Posted by Andrew Gould on 19 March 2019

Power BI encourages you to publish reports to an online service so that you can share your beautiful reports with the world. If you'd rather keep them a secret you can use Power BI Report Server to deploy your reports to an on-premises server, as this blog series shows you.

Tags:   Power BI | Power BI Service    |    Power BI | General

The mysteries of context transition explained

Posted by Sam Lowrie on 25 February 2019

Context transition happens when a DAX function creates filter context within row context, or vice versa. This blog explains what context transition is, and shows which DAX functions make use of it.

Tags:   Power BI | Measures / DAX

Changes to Power BI in the January and February 2019 updates

Posted by Andy Brown on 15 February 2019

There wasn't an official January update, although there were improvements announced to Power BI Service. This blog lists these, and also new features to wrap titles in visuals, apply rounded corners and change the default way in which visuals interact with each other.

Tags:   Power BI | Updates

Understanding row context in DAX

Posted by Sam Lowrie on 01 February 2019

Row context (along with its sibling, filter context) is one of the most important concepts in DAX. This blog explains what row context is, and how to use it!

Tags:   Power BI | Measures / DAX

Understanding filter context in DAX

Posted by Sam Lowrie on 28 January 2019

Understanding filter context is the key to understanding how to create measures in DAX. This blog aims to explain this vital subject as succinctly as possible!

Tags:   Power BI | Measures / DAX

Creating reports in Power BI with dynamic measures or dynamic dimensions

Posted by Andy Brown on 03 January 2019

This blog shows how to create fully dynamic reports, whereby users can choose which statistics to show and which dimensions to report them by.

Tags:   Power BI | General
This page has 0 threads Add post