Mike Carlo, Author at - Page 12 of 14

Using Advanced Mapping in ArcGIS Preview

2016-09-30 Mike Carlo

In the September 2016 release of PowerBI, Microsoft introduced a new visual called the ArcGIS Maps preview. For more information on the maps integration you can read the following post from Microsoft. This tutorial will […]

HexBin Plot using R

2016-09-27 Mike Carlo

Continuing on the theme with R this month, this week tutorial will be to design a hexagonal bin plot. At first you may say what in the world is a hexagonal bin plot. I’m glad […]

Digging Deeper with R Visuals for PowerBI

2016-09-21 Mike Carlo

Back by popular demand, we have another great tutorial on using R visuals. There are a number of amazing visuals that have been supplied with the PowerBI desktop tool. However, there are some limitations. For […]

Using R Visuals in Power BI

2016-09-15 Mike Carlo

For those of you who have been hanging around PowerBI for a while you have likely heard about integration with R visuals. No, this isn’t a twisted dream where Power BI now ships with […]

Loading Excel Files from Sharepoint

2016-09-01 Mike Carlo

This is a quick tutorial on how to load Excel files from a SharePoint page. SharePoint is a nice landing place for your data because it can be connected to the PowerBI.com service and thus […]

Building Date Table from Scratch

2016-08-31 Mike Carlo

Recently at work I’ve been working with a number of large data warehouses with time series data. Often when working on such data you need to incorporate a data calendar to compute date ranges. So, […]

Make Calendars Using DAX – Curbal

2016-08-30 Mike Carlo

Often you will need to create some custom calendars within your PowerBI reports. Ruth Pozuelo from Curbal does a great video tutorial on using Calendar() and CalendarAuto(). I have use the Calendar() DAX function many […]

Load Multiple Excel (xls or xlsx) Files

2016-08-10 Mike Carlo

Previously we’ve done a tutorial on loading multiple text files within one query. This is nice, however we will also need to import multiple Excel files. First, to understand the procedure of querying multiple excel […]

Using Variables for File Locations

2016-08-04 Mike Carlo

This week I encountered an issue when working with multiple queries in my data model. Here is the source files in case you want to follow along. Here’s what happened. I had a PBIX file […]

Measures – Intelligent Card Visual – Using DAX

2016-07-28 Mike Carlo

As I have been exploring PowerBI and building dashboards I have noticed that often the visuals can obscure your data. As you click on different visuals there is a need to highlight different pieces of […]