SQL Server Tabular Models (SSAS) and Power BI

Use SQL Server SSAS Tabular Models to Enhance your Power BI reports Companies with SQL Server licenses running in production most likely already own but are not using SQL Server Analysis Services (SSAS).  To get the most from your existing investment in SQL licenses.  Companies should explore how SQL Server SSAS Tabular Models  can increase the performance Read More …

Marketing Customer Information File Overview

Marketing Customer Information File (MCIF) Many financial organizations already have a custom customer view called a marketing customer information file.  Other industries have these as well, called by different name such as master patient index in the healthcare space.  These files are created through existing software or internal jobs to merge data from various sources Read More …

Power BI Leveraging Tabular Models

Power BI Direct Query Power BI can be used in one of two modes to access data.  The import option loads data from the source data to the Power BI model.  Queries are then processed directly against the data in the model.  Using the DirectQuery option, on the other hand, leaves at the source and Power Read More …

Using Power BI to Visualize Houston Crime Stats

Houston Crime Data The city of Houston provides high level details on crime statistics via Excel files on the police website.  These statistics are stored in monthly files available via Excel or Access.  In order to better understand the crime data I created a single Excel file that stored the data from August 2016 to December Read More …