Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

06 October
2017
Author: Robert Cain

Making Videos for Fun and Profit

As I author this post, I’m at a Microsoft conference. Today’s focus is on the creation of video content to help promote your brand. As I have some experience with this from my Pluralsight videos, I had some suggestions as to technology. The first tool I use is from TechSmith, it is Camtasia. It...
24 September
2017
Author: Robert Cain

Windows 10 Icons Not Showing, Preview Not Working

I had a weird issue with Windows 10 today. All of a sudden, my icons weren’t displaying correctly. When I had the Preview Pane on, nothing was displayed. Even more bizarre, The Layout area of the View pane in Windows Explorer, had all the icons disabled. Turned out I had a corrupted icon cache....
07 August
2017
Author: SteveHughes

Power BI and Data Security – App Workspaces and Power BI Apps

Shortly after I published the Power BI Security Sharing Data post in April, Power BI Premium, Power BI Apps, and Power BI App Workspaces were released. These changes impacted that post in many ways. As part of the follow up, I also did an updated webcast with Pragmatic Works. This is a follow up...
04 August
2017
Author: MitchellPearson

Power BI–Problem, Design, Solution (Text Search)

  At the end of this blog there will be a video that walks you through the solution in depth. In this installment of the Problem, Design, Solution series we are going to show you how to perform a text search using slicers in Power BI, this simulates a “LIKE” type search. In the following...
04 August
2017
Author: SteveHughes

Power BI and Data Security – Free User’s Cannot Share, Read Only in Premium

As part of the Power BI Premium release, Microsoft changed how the “free users” in Power BI work within the platform. There are two key changes that affect the data security within your organization. Power BI Free Users Cannot Share One of the key areas of concern around the free user accounts...
29 July
2017
Author: MitchellPearson

SSIS Performance Tuning

This is my much overdue follow-up blog from the presentation I gave to the New York SQL Server User Group. In this post, I am going to provide some additional resources to supplement the presentation, check out the following blog post on different performance tuning techniques that can be used...
12 July
2017
Author: Robert Cain

Eric Ligman’s FREE Microsoft eBook Giveaway–Revising the download script

Every year, Eric Ligman, director of Sales Excellence for Microsoft, creates a blogpost in which he gives away tons of FREE Microsoft eBooks. This year has 361 in the list. You name it, it’s in the list. SQL Server, Azure, PowerShell, .NET, BizTalk, SharePoint, Windows Server, and more. You can...
12 July
2017
Author: Robert Cain

Temporary Post Used For Theme Detection (7a7ae270-2d45-4bc4-8cd2-e809986daa9c – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (5591406e-a24c-4553-aada-6c4b4f18a8de – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
02 July
2017
Author: Robert Cain

VidCon 2017 – Day 3

My third and final video for my VidCon 2017 coverage. In the video I mention two products I found on the floor I would be making videos of. These are: The 10 Foot Mighty Selfie Stick LumaFusion iOS Video Editor
26 June
2017
Author: MitchellPearson

Advanced DAX: Problem, Design, Solution

Thanks for watching my latest webinar on DAX. If you missed the webinar you can watch the recording here: http://pragmaticworks.com/Training/Details/Advanced-DAX-Problem-Design-Solution I didn’t have a lot of questions from this webinar but I will answer a the ones I did have. Question: What is...