SQL Server 2016 Archives - BI and Predictive Analytics

SQL Server 2016 Stretch Database

August 17, 2015 by Derek Leave a Comment

SQL Server 2016 Stretch Database One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud. By leveraging the Stretch Database feature your applications can silently migrate data to the cloud without having to change your existing code. Stretch Database … [Read more…]

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…]

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 […]