Wise Owl Blogs - Home (page 19 of 24)

Showing blogs 361-380 (out of 473)

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

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

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

Getting Started with Power BI Report Server

Posted by Andrew Gould on 07 July 2023

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 > General Power BI > Power BI Service

The mysteries of context transition explained

Posted by Sam Lowrie on 22 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

Understanding row context in DAX

Posted by Sam Lowrie on 29 January 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 25 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

Showing the top N values of a dimension, where you can use a slicer to vary N

Posted by Andy Brown on 06 December 2018

Following a question from a Power BI course, this blog shows how you can get a page to show the top N customers by sales value, where N is a number controlled by a slicer.

Tags:
Power BI > Measures / DAX

How to monitor stock levels from forecast sales using DAX measures in Power BI

Posted by Sam Lowrie on 05 November 2018

Given your current stock levels and forecast sales, it should be possible to report on future stock depletion in Power BI. This two-part blog shows you how to just that!

Tags:
Power BI > Measures / DAX

Debugging (sort of) in DAX

Posted by Sam Lowrie on 30 July 2018

Learn to use DAX variables, and understand how they can be used to break up code. Not true debugging, but better than nothing!

Tags:
Power BI > Measures / DAX

Five methods for creating partitions of SSAS Tabular tables programmatically

Posted by Andy Brown on 23 July 2018

Need to generate a partition for a fact table for each year, product or region? This blog gives five approaches, so that you can choose which method is for you.

Tags:
SSAS tabular > Partitions and processing

Using partitions/processing to load a large fact table into a tabular data model

Posted by Andy Brown on 23 July 2018

This blog shows how you can load the empty structure of a large fact table into an Analysis Services tabular data model, then use partitions to bring in the data bit by bit.