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.

19 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 86 – Bubble Chart by Akvelon)

In this module you will learn how to use the Bubble Chart Custom Visual by Akvelon. The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble. Module 86 – Bubble Chart By Akvelon Downloads Power BI Custom Visual – Bubble Chart by...
14 January
2018
Author: AlanFaulkner

Exposure Data Audit – Locating Personally Identifiable Information (PII) in SQL Server

Introduction As a BI Architect/Developer, it may become necessary to conduct an Exposure Data Audit to uncover Personally Identifiable Information (PII)-related data within your SQL Server 2016 environment.  The objective is to uncover any potential data security exposure risks in a continued...
12 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 85 – Image Grid)

In this module you will learn how to use the Image Grid Custom Visual. This visual is a unique way to visualize multiple images at once that can be resorted by a measure value. Module 85 – Image Grid Downloads Power BI Custom Visual – Image Grid Dataset – Movie Studios.xlsx Completed Example –...
08 January
2018
Author: Anil
Anil

Happy and excited to be a Program committee member for DATA and BI Summit 2018.

Happy and excited to be a Program committee member for DATA and BI Summit 2018 in Visualize Track focusing on Building and Designing Dashboards and Reports. Thanks to the DATA and BI Summit 2018 Program committee team for giving me an opportunity to work as a Volunteer Program...
02 January
2018
Author: Robert Cain

Opening Port 80 in Windows Firewall to Support Calling SSRS From Another Computer

Recently I was working on another article for RedGate’s SimpleTalk site. As part of it, I had SSRS installed on a Windows 10 computer, and needed to connect to it from another computer. I was having a lot of issues connecting, until I remembered SSRS connects using Port 80, and by default Windows...
02 January
2018
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 84 – ChartAccent – BarChart)

In this module you will learn how to use the ChartAccent BarChart Custom Visual. This visual is a custom bar chart that allows you to annotate individual data points, data series and ranges. Module 84 – ChartAccent – BarChart Downloads Power BI Custom Visual – ChartAccent – LineChart Dataset –...
27 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 83 – ChartAccent – LineChart)

In this module you will learn how to use the ChartAccent LineChart Custom Visual. This visual is a custom line chart that allows you to annotate individual data points, data series and ranges. Module 83 – ChartAccent – LineChart Downloads Power BI Custom Visual – ChartAccent – LineChart Dataset...
26 December
2017
Author: Anil
Anil

SQL Saturday #692 Conference and Nepal Power BI User Group Meetup a big success.

Last Saturday, we conducted SQL Saturday #692 conference and Nepal Power BI User Group Meetup Event in Kathmandu, Nepal successfully on 23rd Dec, 2017. SQLSaturday#692 conference and Nepal Power BI User Group Meetup Event is free event for a Microsoft Data Platform professionals and those...
22 December
2017
Author: Robert Cain

Introduction to DW/BI–My Newest Old Course at Pluralsight

Way back in November of 2010, I published my second course with Pluralsight, Introduction to Data Warehousing and Business Intelligence. Over that time a lot has transpired. While the basic fundamentals haven’t changed, a lot of technology has. In addition, Microsoft’s WideWorldImporters sample...
19 December
2017
Author: DevinKnight
DevinKnight

Power BI Custom Visuals Class (Module 82 – Text Filter)

In this module you will learn how to use the Text Filter Custom Visual. This visual allows you to filter all the other visuals on your report by typing in a value into the Text Filter. Module 82 – Text Filter Downloads Power BI Custom Visual – Text Filter Dataset – All Product...