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

Stay Up-to-Date on All Things SQL Server, Business Intelligence and Cloud

How Power BI Can Make Your Life Easier - I Wish I Knew!

If I knew then what I know now is a timeless adage that is most certainly universal. It is one that keeps popping up in my...

How to Export Power BI Data to Excel

Have you ever had problems with exporting Power BI data to Excel? A recent issue a client ran into was in trying to export...

Translating Your SQL and Excel Skills to Tableau

Are you doing data analytics with SQL or Excel? Would you like to gain more knowledge about using Tableau, or how to...

Our Excel Dashboards Course is Now Available!

We're excited to announce the early release of our Interactive Dashboards with Excel ! This course is for data analysts,...

Exploring Excel 2013 for BI: Adding Calculated Measures

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...

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

We're back for another informative blog in our series, Excel at Excel with Steve Hughes! In this post, he will cover how to...

Exploring Excel 2013 for BI: Cleaning-Up Slicers

Thank you again for reading our blog series Excel at Excel with Steve Hughes! In his previous tip, Steve showed you how to...

Patterns and Practices: Creating a Date Table

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...

Exploring Excel 2013 for BI: Adding a Slicer

Welcome back to our blog series Excel at Excel with Steve Hughes! In his previous posts, he's discussed using the Quick...

Exploring Excel 2013 for BI: Flash Fill

Welcome back to our series, Excel at Excel, by Steve Hughes! In his last post, Steve discussed using the Show Details...

Exploring Excel 2013 for BI: Show Explore

Welcome back to our informative series on Excel by Steve Hughes! In his first post, he conquered the Quick Explore feature....

Exploring Excel 2013 for BI: Quick Explore

Excel is a powerful tool that is used by almost everyone is the business world. Because of its numerous capabilities, Excel...

Power Query – Controlling M Query Functions with User Driven Parameters

Have you ever had a user run a query against one of your largest tables only for them to immediately filter the results in...

Replicating Excel Percentile in DAX

The lack of a percentile function in DAX is a commonly brought up challenge. In order to replicate a version that matches...

Flashback Friday-SSIS ETL for Beginners

I can’t connect my package…never fear Brad Schacht to the rescue!

So you want to connect your SSIS package to Excel, SQL...

bg-img14.jpg

Join Our Blog

Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.

Leave a comment

Posts by Topic

see all

Recent Articles

Popular Articles