Wise Owl blogs written by Andy Brown (page 8 of 15)

Showing blogs 141-160 (out of 299)

A tutorial on using pivot tables in Excel based on SSAS tabular models

Posted by Andy Brown on 24 November 2015

Learn how to create, format and explore pivot tables within Excel based upon SSAS tabular models. This tutorial also shows how to create slicers, and combine them to create dashboards.

How to create a data model in SSAS tabular

Posted by Andy Brown on 16 November 2015

The first - and most important - part of using Analysis Services (tabular mode) is to create a data model, incuding only those tables and columns you need. This lengthy blog shows you how to go about creating the perfect data model!

This blog shows how to create your first tabular project in Visual Studio

Posted by Andy Brown on 11 November 2015

Before you can get started with tabular SSAS, you need to check you have Analysis Services (tabular model) installed on your computer. This blog also shows you how to run and configure Visual Studio, and how to create your first tabular project.

A full tutorial blog on how to create Analysis Services Tabular models

Posted by Andy Brown on 07 November 2015

From SQL Server 2012 onwards there is an alternative way of working with Analysis Services. Say goodbye to difficult-to-create cubes and dimensions, and embrace the new tabular model server mode instead! When finished this tutorial will cover everything you need to know, from creating your first data model to creating measures using DAX expressions.

Should you use tabular or multi-dimensional SSAS mode? Here's the answer!

Posted by Andy Brown on 07 November 2015

If you're building a data warehouse, you'll want to know whether you should be creating cubes using the legacy multi-dimensional Analysis Services server mode, or creating data models in the new tabular mode. This blog gives Wise Owl's take on the subject.

An explanation of how to set up and use the MAM database used by this tutorial

Posted by Andy Brown on 07 November 2015

Our tutorial on using tabular model (Analysis Services) is based on our Make-a-Mammal database. This blog shows how to install this database, and how to understand the tables and relationships that it contains.

How and when to use the Execute SQL task PARSE QUERY button in SSIS

Posted by Andy Brown on 18 September 2015

A short blog explaining how the Parse Query property and BypassPrepare property for an SSIS task are related.

Tags:   SSIS | Data flow

What's new in Microsoft Office 2016 (including Excel 2016 changes)

Posted by Andy Brown on 07 September 2015

The latest incarnation of Microsoft Office (2016) should be released on 22nd September 2015 (Microsoft are always a bit ahead of themselves with versions). This blog gives a detailed guide to what's new, the biggest changes being in Excel and Outlook.

Tags:   Outlook | General topics    |    Excel | General    |    Musings | Microsoft Office

How to lay out diagrams in SSIS packages to look neat

Posted by Andy Brown on 04 September 2015

Arrows in your Integrated Services packages can go all over the place - learn how to control them in this short blog on formatting SSIS diagrams.

Tags:   SSIS | General SSIS

Useful links and downloads for our video tutorials on Power BI applications

Posted by Andy Brown on 15 April 2015

This blog is provided to support our series of tutorials on PowerPivot, Power Query, Power View and Power Map.

Once you've loaded a Power Query, how do you change your load options?

Posted by Andy Brown on 01 April 2015

When you've created a Power Query in Excel, you can close it and load the resultant data. But how do you then change how the query loads? This blog explains how!

Using DAX Studio to edit calculated fields or measures in Excel

Posted by Andy Brown on 20 February 2015

The editor for calculated fields in Excel (aka measures) isn't the greatest; this blog shows you how to install and use DAX Studio as a substitute editor.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | DAX

Ideas for encrypting data in transit in SSIS

Posted by Andy Brown on 08 February 2015

How can you encrypt data flowing within an Integration Services package? We don't think you can, but here are a couple of ideas.

Tags:   SSIS | Data flow

How to send an email to every person in a SQL Server table

Posted by Andy Brown on 30 January 2015

This blog explains how to send an email to every person returned from a SQL query.

Tags:   SSIS | General SSIS

How to refer to parameters by name, not number, in SSIS

Posted by Andy Brown on 30 January 2015

Referring to parameters by their numeric position in a list in SSIS is relatively easy, but there is a way to refer to them by name too, as explained in this blog.

Tags:   SSIS | Parameters

Getting at file attributes from FOREACH loop in SSIS

Posted by Andy Brown on 30 January 2015

SSIS makes it easy to loop over files, but it's less obvious how to get at file attributes such as the date created or last modified date. To do this you'll need a scripting task, as explained by this blog.

Tags:   SSIS | Files and folders

How to insert ActiveX controls after CANNOT INSERT OBJECT message

Posted by Andy Brown on 29 January 2015

When using Excel, we owls have had problems inserting ActiveX objects after recent security updates. Here's a solution which worked for us!

Tags:   VBA macros | User forms    |    Writing VBA | Other

What's new in Analysis Services 2012 versus 2008 R2

Posted by Andy Brown on 19 December 2014

If you're creating multidimensional models (as you probably will be), Analysis Services has barely changed between versions 2008 R2 and 2012 - and the small differences are mostly in the favour of the older version. This blog plays spot-the-difference between Analysis Services 2008 R2 and 2012.

Steps to follow when creating a new flat file in SSIS

Posted by Andy Brown on 04 December 2014

Using an existing flat file in SSIS is straightforward, but creating a new one can be a pain - this blogs gives some steps to follow.

Tags:   SSIS | Data flow

A short blog showing that SSIS 2014 is the same as 2012

Posted by Andy Brown on 27 November 2014

Possibly the shortest Wise Owl blog, listing the changes between Integration Services 2012 and 2014 (there aren't any!).

This page has 0 threads Add post