<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=931099456970389&amp;ev=PageView&amp;noscript=1">

Category: Excel

12 Results

Our Excel Dashboards Course is Now Available!

Posted Nov 10, 2016 by Pragmatic Works

We're excited to announce the early release of our Interactive Dashboards with Excel ! This course is for data analysts, data wranglers, spreadsheet developers and managers looking to design work for decision makers.

Exploring Excel 2013 for BI: Adding Calculated Measures

Posted Dec 07, 2015 by Steve Hughes

It's been a little while, but Steve Hughes is back for his latest blog in the Excel at Excel series. In this blog, he will discuss adding calculated measures when working with SSAS in Excel.

Exploring Excel 2013 for BI: Retaining PivotTable Size After Data Refreshes

Posted Oct 22, 2015 by Steve Hughes

We're back for another informative blog in our series, Excel at Excel with Steve Hughes! In this post, he will cover how to retain the size of your PivotTable after refreshing your data.

Exploring Excel 2013 for BI: Cleaning-Up Slicers

Posted Sep 16, 2015 by Steve Hughes

Thank you again for reading our blog series Excel at Excel with Steve Hughes! In his previous tip, Steve showed you how to add slicers. In this post, he will discuss cleaning up slicers once they have been added to your spreadsheet.

Patterns and Practices: Creating a Date Table

Posted Sep 01, 2015 by Ginger Grant

There may be a time when you will need to create a table containing a series of dates. Perhaps you want a date table for a data warehouse or a data model in Excel’s Power Pivot. There are a number of ways you can create a date table in SQL Server. I will show a method, which we recommend at Pragmatic Works, that uses a Common Table Expression [CTE].

Exploring Excel 2013 for BI: Adding a Slicer

Posted Aug 14, 2015 by Steve Hughes

Welcome back to our blog series Excel at Excel with Steve Hughes! In his previous posts, he's discussed using the Quick Explore, Show Details and Flash Fill features. In this entry, Steve will show you how to add a Slicer feature in Excel.

Exploring Excel 2013 for BI: Flash Fill

Posted Jul 30, 2015 by Steve Hughes

Welcome back to our series, Excel at Excel, by Steve Hughes! In his last post, Steve discussed using the Show Details feature. In this edition, he'll show you how to use the Flash Fill function by walking you through how to manipulate data and fill a column base using the Flash Fill function.

Exploring Excel 2013 for BI: Show Explore

Posted Jul 16, 2015 by Steve Hughes

Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature. In this post, Steve will delve into the Show Explore feature. Join Steve as he shows you how you can drill into details using the Show Explore feature once you've connected your SSAS cube to Excel.

Exploring Excel 2013 for BI: Quick Explore

Posted Jul 02, 2015 by Steve Hughes

Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel has many functions that can often be confusing to users. In this new blog series Our resident expert, Steve Hughes, will cover a wide variety of Excel topics ranging from easy to complex. Steve will provide you tips and tricks he has discovered in his journey through Excel.

Quick Explore

So, you have connected Excel to your SSAS cube. You really wish you could cross drill easily in the product. If you have used PerformancePoint Services you know the process. Right click on the bar or cell and then choose the dimension to drill to using the information you clicked on as a starting point. You can now do this in Excel 2013 using Quick Explore. Here’s how to do it:

Power Query – Controlling M Query Functions with User Driven Parameters

Posted Apr 08, 2015 by Devin Knight

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in Excel to show the last years worth of data? All of that data brought across your network and then immediately filtered out. Or maybe Excel just can handle the amount of unfiltered data they’re trying to return.

Subscribe to Blog Updates