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

Attending Microsoft Business Application Summit
I will be in Atlanta for the Microsoft Business Application Summit. I hoping to get more information on Power BI and how others are leveraging Power BI along with Power Apps. This should be a great opportunity to meet people and get ideas on best practices and out of the box solutions for data visualizations. […]
CDO Advisors Quick Start Packages
Power BI, Analytics and Data Science Quick Start CDO Advisors Quick Start packages offer businesses a low cost option to explore Power BI, Analytics or data science. Executives know they need better information from their data and are often confused on what technologies are available to transform their data. You know your management team is […]
CFO Dashboard with Power BI
Visualize Financial Data with Power BI CFO's require data from across the enterprise to ensure they can make the best financial decisions for the organization. With data stored in disparate enterprise systems. Presenting a consolidated view of a companies data is more difficult than ever. Creating an executive CFO dashboard with Power BI can quickly […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example