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

Build Power BI Covid Reports from GitHub Data
A Step by Step Guide to Build Power BI Covid Data Reports from GitHub Covid-19 is top of mind and getting to the data can be easy if you know how. Currently, there is a GitHub project that is collecting data around Covid-19. In this step by step guide, I show you how to use Microsoft Power BI and the Web Connector [...] The post […]
Trend Analysis with Power BI using MLB Data
Trend Analysis with Power BI Businesses use trend analysis to help improve your business operations. This is done by monitoring data to identifying areas where your business is performing well so you can duplicate success. As well as determine areas in your business that is under performing. One way to improve operations is through [...] […]
3 Ways to Improve Manufacturing Analytics with Dashboards
Improve Manufacturing Analytics with Dashboards Regardless of your specific role in manufacturing. Using dashboards for data and analytics will improve your ability to make data driven decisions. Dashboards are graphical views of your data that focus on Key Performance Indicators (KPIs) and metrics that are critical to the success of your organization. There are several […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example