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

Use Power BI Snowflake Connector to Visual Your Data
Build Power BI Snowflake Based Reports In this post I will walk you through the steps required to use the Power BI Snowflake Connector to access data in a Snowflake warehouse. If you are new either Power BI or Snowflake this will be a quick reference for you to make the connection and where [...] […]
How to Publish to Power BI from Power BI Desktop
Publish to Power BI to Share Your Reporting In order to share your reporting and create dashboards you need to publish to Power BI service to share your work. Power BI desktop enables you to connect to data, model your data and build data visualizations. Once you are ready to share your reporting connecting [...] […]
3 Types of Dashboards Executives Need Today
3 Types of Dashboards that Executives Need Now In this blog, we will be doing a quick review of the benefits associated with each of the 3 types of dashboards to determine which is right for your business. The common dashboards are operational, strategic, and tactical. To learn the basics of dashboards, refer to [...] […]