BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl blogs written in 2017 (page 2 of 3)
Showing blogs 21-40 (out of 42)
Find the many ways to interact directly between Excel and Power BI Service
Posted by Andy Brown on 29 June 2017
You can pull Excel workbooks (or individual data ranges) into Power BI Service, or push them from Excel using a special add-in. This blog shows how to use both approaches, as well as the underwhelming Analyze in Excel feature.
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.
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!
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.
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
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.
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!
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.
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.
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.
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).
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.
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.
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.
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.
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.