July 2015 - BI and Predictive Analytics

SQL Server Polybase (2016)

July 20, 2015 by Derek Leave a Comment

What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats and technologies to combine data … [Read more…]

HASSUG BI Developer Presentation on 7/14/2015

July 19, 2015 by Derek Leave a Comment

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session resulted from feedback we received in the user group on differences between database developers and BI developers. If you are interested in seeing the presentation content it is uploaded here: Becoming a bi developer from … [Read more…]

Executive Dashboard with Power BI
Create Executive Dashboards using Power BI Managers need the ability to see data from different areas of the business. Organizing this data into easy to use visualizations enables you to determine trends and discover insights. In addition, you can create mashups that pull data from different sources into a single dashboard view. Executive Dashboard […]
Power BI and Capital Projects
Tracking Capital Projects with Power BI This example pulls data related to projects and creates a dashboard that enables users to quickly see actual vs budget and variance. The status of the projects are shown as well as the breakout of projects by sponsor. The graphs are interactive and can be filtered by selecting a […]
Power BI and Credit Union Membership
Credit Union Membership Map in Power BI This example uses membership data for a fictional credit union to map the members by zipcode. A heatmap is then created to show which zip codes have the most members. The darker the color the more members are in that zip code. In addition, the 4 branch locations […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: July 2015

SQL Server Polybase (2016)

HASSUG BI Developer Presentation on 7/14/2015