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

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

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example