-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Data Savvy

Meagan Longoria is a business intelligence consultant with BlueGranite in Denver, CO where she shares her expertise in Microsoft BI and data warehousing through solution envisioning, architecture design, solution development, training, and blogging. She is a speaker at user groups and conferences across the country.

Power BI Report Accessibility Checklist

In many cases, some small changes can go a long way in making your Power BI reports more accessible for users with different abilities. The checklist below lists considerations you should make in your report design to create more inclusive reports. I’ll update this post as new features are released. Read more

2 comments, 664 reads

Posted in Data Savvy on 7 June 2018

Choosing a Color Palette For Your Power BI Report

Color is a powerful attribute in data visualization. In a good visualization, it can focus attention and enhance meaning and clarity. When color is used poorly, it creates clutter and confusion. Power BI has a default color palette, but it isn’t always optimal or even appropriate for many reports. Luckily,… Read more

3 comments, 1,587 reads

Posted in Data Savvy on 27 May 2018

Thoughts and Lessons Learned From A Power BI Embedded POC

I worked on a Power BI embedded POC where a report with an in-memory Power BI model as the dataset was embedded into an application in an “app owns data” scenario. This means that the application handles all authentication and access, and users do not need to be… Read more

6 comments, 2,196 reads

Posted in Data Savvy on 25 April 2018

Please join me for my PASS Summit Pre-Con with Melissa Coates

I’m excited to announce that I’m joining forces with Melissa Coates (aka SQL Chick) to do a full-day PASS Summit Pre-Conference Session this year!

We’ll be talking about Designing Modern Data and Analytics Solutions in Azure.

Many traditional data warehousing professionals as well as other data engineers are… Read more

0 comments, 552 reads

Posted in Data Savvy on 12 April 2018

Four Easy Things You Can Do Now To Make Your Power BI Reports More Accessible

Accessibility is often overlooked or ignored when it comes to reporting and data visualization. I think there are two reasons why:

  • We often don’t consider user scenarios with which we aren’t familiar. If we don’t know someone with color blindness/low vision/dyslexia/repetitive strain injuries, we don’t understand the difficulties they might…

Read more

4 comments, 820 reads

Posted in Data Savvy on 9 March 2018

Power BI Screen Reader Accessibility

I recently wrote a post on the BlueGranite blog called Improving Screen Reader Accessibility in Power BI Reports. It contains some good reasons why accessibility should be considered when it comes to usability features of any web property or data viz. And it shares several tips to make your… Read more

3 comments, 1,674 reads

Posted in Data Savvy on 6 February 2018

Ten Ways To Help Your BI Consultant Be Successful

I’ve been working in the field of business intelligence for over ten years, as a consultant for over five years. One thing I’ve learned from that time is that consultants need the client’s help to complete a project on time and on budget. Even if the consultants are doing the… Read more

2 comments, 2,517 reads

Posted in Data Savvy on 30 January 2018

Design Concepts For Better Power BI Reports Part 5: Affordances

Affordances are a general design concept that comes from physical product design but can be applied to visual design. I first learned about affordances from the book The Design of Everyday Things. The book describes affordances as the following.

“Affordances provide strong clues as to the operations of things…… Read more

1 comments, 356 reads

Posted in Data Savvy on 28 December 2017

Design Concepts For Better Power BI Reports Part 4: The Squint Test

Data visualization should be iterative. You should get a good initial draft put together and then check to make sure it meets your success criteria. Then check the design to ensure it it effectively conveys information in a manner that is easy for your audience to consume. You can then… Read more

6 comments, 560 reads

Posted in Data Savvy on 22 December 2017

Design Concepts for Better Power BI Reports Part 3: Gestalt Principles

The Gestalt principles of visual perception describe how humans tend to organize visual elements into groups or unified wholes to help us make sense of visual stimuli. Basically, we perceive the visual world as complete objects rather than a bunch of independent elements.

For instance, you probably see a triangle… Read more

2 comments, 391 reads

Posted in Data Savvy on 18 December 2017

Design Concepts For Better Power BI Reports – Part 2: Preattentive Attributes

Preattentive attributes are visual properties that we notice without using conscious effort to do so. Preattentive processes take place within 200ms after exposure to a visual stimulus, and do not require sequential search. They are a very powerful tool in your data visualization tool box – they determine what… Read more

5 comments, 583 reads

Posted in Data Savvy on 30 November 2017

Design Concepts To Help You Create Better Power BI Reports

I have decided to write a series of blog posts about visual design concepts that can have a big impact on your Power BI Reports. These concepts are applicable to other reporting technologies, but I’ll use examples and applications in Power BI.

Our first design concept is cognitive load,… Read more

10 comments, 2,143 reads

Posted in Data Savvy on 27 November 2017

Biml for a Task Factory Dynamics CRM Source Component

I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data from Dynamics 365 CRM. My first attempt using a script component had an error, which I think is related to a bug in the Biml engine with how it currently… Read more

6 comments, 1,026 reads

Posted in Data Savvy on 22 November 2017

Data Visualization Panel at PASS Summit

Next week is PASS Summit 2017, and I’m excited to be a part of it. One of the sessions in which I’m participating is a panel discussion on data visualizationMico Yuk will be our facilitator. I’m in great company as the other panelists are Ginger Grant, Paul… Read more

0 comments, 275 reads

Posted in Data Savvy on 28 October 2017

Let Her Finish: Voices from the Data Platform

This year I had the pleasure of contributing a chapter to a book along with some very special and talented people. That book has now been released and is available on Amazon!  Both a digital and print version are available. My chapter is about data viz in Power BI,… Read more

1 comments, 457 reads

Posted in Data Savvy on 19 October 2017

The Tabular Model Documenter is now a Power BI Template

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or Power BI model and display metadata about the model to help you see relationships, calculations, source queries, and more.  I had been meaning to turn it into a parameterized template… Read more

10 comments, 1,854 reads

Posted in Data Savvy on 19 September 2017

My Thoughts After Completing a Power BI Report Server POC

Last month I worked on a proof of concept testing Power BI Report Server for self-service BI. The client determined Power BI Report Server would work for them and considered the POC to be successful.

Here are the highlights and lessons learned during the project, in which we used the… Read more

10 comments, 3,212 reads

Posted in Data Savvy on 18 September 2017

You Can Now Put Values On Rows In Power BI

Back in January 2016, I wrote a blog post explaining a DAX workaround that allows you to put measures on rows in a matrix in a Power BI report. I’m happy to say that you no longer need my workaround because you can now natively put measures on rows in… Read more

7 comments, 1,683 reads

Posted in Data Savvy on 11 August 2017

Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

I recently got a new laptop and had to go through the ritual of reinstalling all my programs and drivers. I sometimes work with SSIS locally to import data from Excel and occasionally do demos with Power BI where I read from an Access database so I needed to install… Read more

10 comments, 264 reads

Posted in Data Savvy on 20 July 2017

Updating a SharePoint List Item With Flow When You Don’t Have The ID

I recently worked on a project that used Flow to update a SharePoint list each time an item was updated in the Power Apps Common Data Service. In order to update a SharePoint list item, you must have the unique ID, even if there are other fields that are unique… Read more

1 comments, 403 reads

Posted in Data Savvy on 17 July 2017

Older posts