Wise Owl Blogs - Home (page 4 of 19)

Showing blogs 61-80 (out of 368)

Publishing reports, editing them in Power BI Service and using dashboards/tiles

Posted by Andy Brown on 29 June 2017

This blog shows how to publish reports that you've created in Power BI Desktop to Power BI Service. The blog also shows how you can create and edit reports online, how to create dashboards and add tiles, and how to get insights into your data.

Online Power BI Service training - publishing, sharing, refreshing data, etc

Posted by Andy Brown on 29 June 2017

When you've created a report in Power BI Desktop, what happens next? This comprehensive online Power BI training shows how to publish reports, edit them online, get insights into your data, link to Excel, share reports, apply security, control what happens when you refresh your reports and much more!

A summary of the tests taken on our skills assessment site in the last 6 years

Posted by Andy Brown on 26 June 2017

Over a third of a million people have completed one of our skills assessment tests since 1st May 2011 - we thought we'd have a look at how these tests break down into categories.

Tags:   Musings | Nostalgia

The most important changes included in the June 2017 Power BI Desktop update

Posted by Andy Brown on 26 June 2017

This update includes lots of nice features, such as line markers and the ability to change font typefaces, as well as many more changes!

Tags:   Power BI | Updates

Some ideas for how to map data in Power BI Desktop

Posted by Andy Brown on 08 June 2017

Anyone who has tried to get a meaningful non-US map out of Power BI Desktop will know that it's often not straightforward! This blog shows you how to overcome some of the issues, including geocoding data, getting latitude and longitude settings and changing cross filter settings in relationships.

Tags:   Power BI | Maps

A simple way to move a measure from one table to another

Posted by Andy Brown on 08 June 2017

You can't drag and drop measures between tables, but there is an easy way to move them in Power BI Desktop, as this blog shows

Tags:   Power BI | Measures / DAX

Three different ways to find the differences between two Excel worksheets

Posted by Andy Brown on 01 June 2017

There are a few ways to find the differences between two Excel worksheets. This blog considers 3 methods (using Excel formulae, using Query Editor and using the Inquire add-in).

The most important changes made for the May 2017 Power BI Desktop update

Posted by Andy Brown on 17 May 2017

The May 2017 Power BI Update brings in a couple of nice new query transforms and some new chart features, but the big changes are still in preview mode.

Tags:   Power BI | Updates

A list of the updates made in the April 2017 update to Power BI Desktop

Posted by Andy Brown on 28 April 2017

This update includes some nice new features - for example, creating columns by example and changing chart axis titles. Read this blog for a full list!

Tags:   Power BI | Updates

This blog shows a clever way to annotate expression constraints in SSIS

Posted by Andy Brown on 27 April 2017

If you've added an expression constraint to control flow in a package in Integration Services, this blog will show you how to display what the constraint does automatically.

Tags:   SSIS | Control flow tasks

How to loop over the worksheets in an Excel workbook using Integration Services

Posted by Andy Brown on 21 April 2017

Follow this blog to learn how to use an SSIS package to loop over the worksheets in an Excel XLSX workbook, importing the contents of each.

Tags:   SSIS | Data flow

The main new features in the March 2017 update of Power BI Desktop

Posted by Andy Brown on 24 March 2017

This is a small update, although the new matrix tool which is currently in preview mode will be a big change.

Tags:   Power BI | Updates

Speed comparison of temporary tables against table variables

Posted by Andy Brown on 02 March 2017

When you are programming in SQL, you often have the choice of using table variables or temporary tables. This blog considers whether one method is substantially quicker than the other (spoiler alert: not really).

Tags:   SQL | Programming tables

Combine all the files in a folder into a single table using Power Query

Posted by Andy Brown on 21 February 2017

Sure, you can use Power Query (or Get & Analyze, as it's now called) to load and transform data, but did you know you can loop over all of the files in a folder, combining their data into a single set of results? This blog explains how to do this for CSV files, and gives a lead for how to proceed with Excel ones.

The new functions in Excel 2016, including IFS, SWITCH and TEXTJOIN

Posted by Andy Brown on 18 February 2017

Excel 2016 has a few interesting new functions! TEXTJOIN allows you to concatenate all the cells in a range, and IFS and SWITCH provide other ways to make choices.

Tags:   Excel | Formulae

Updates made in February 2017 to Power BI Desktop.

Posted by Andy Brown on 16 February 2017

A summary of the most important changes for Power BI Desktop users in the February 2017 update.

Tags:   Power BI | Updates

Power BI Desktop - January 2017 update

Posted by Andy Brown on 08 February 2017

A summary of the (small) changes in Microsoft's January 2017 Power BI Desktop update.

Tags:   Power BI | Updates

A list of one owl's 5 favourite system stored procedures in SQL!

Posted by Andy Brown on 03 February 2017

Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.

Tags:   SQL | Stored procedures

Wise Owl coding standards for T-SQL (the SQL dialect used in SQL Server)

Posted by Andy Brown on 01 February 2017

A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.

Tags:   SQL | General

Want to be get at the file path for an Excel workbook easily? Here's how!

Posted by Andy Brown on 26 January 2017

This short blog explains how you can customise your quick access toolbar to display the path of the file that you are currently working on.

Tags:   Excel | General
This page has 0 threads Add post