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

Visualize Baltimore Crime Reports with Power BI
Use Power BI to Visualize Baltimore Crime Reports Using Power BI to Visualize Baltimore Crime Reports With Power BI you can take raw data and quickly transform it into easy to use visualizations. For this example, I will be using data from the Baltimore police crime reports public dataset that [...] The post Visualize Baltimore […]
Use Power BI Decomposition Tree for Root Cause Analysis
Power BI Decomposition Tree Breaking Down Your Data Use the Decomposition Tree Visual in Power BI to explore your data and gain insights into how parts contribute to the whole. Drill into hierarchies to see how each part contributes to the total. Enable faster analysis for your team and gain data driven insights. Using this […]
Where is Your Company on the Data Maturity Roadmap
Maturity Model for Data and Analytics Where are you on your data and analytics journey? Are you getting the value you expect from your business intelligence and analytics reporting environment. Are you still spending more time on gathering data than you spend analyzing your data? Applying a framework such as Gartner's Data Maturity Model enables […]