November 2014 - BI and Predictive Analytics

SQL Server Management Studio Reports

November 17, 2014 by Derek 1 Comment

SQL Server Management Studio Reports Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within your database is critical to the performance of your applications. One tool you can leverage to see what is happening are the built in reports in SSMS. SQL Server includes basic reports that you … [Read more…]

SQL Server Table Partition Example

November 3, 2014 by Derek Leave a Comment

Why Use a SQL Server Table Partition Data warehouses and data repositories often have tables that store millions of records and each day adding thousands more. As the data ages, the older records generally require fewer updates. If all of these records are kept in a single physical table. Queries and maintenance on the table … [Read more…]

Power BI What If Example Step by Step
Power BI What If Example Using Sales Data If you have not tried to use the Power BI What If feature, this blog post is for you. Change how your users perform analytics with simple sliders that let them change the values in their reports to see potential impacts of decisions. By adding in [...] […]
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 [...] […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example