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 Desktop Overview for Beginners
What is Microsoft Power BI Desktop? Unlock your data with Microsoft Power BI Desktop the developer tool for the Microsoft Power BI platform. Power BI is a self-service business intelligence platform designed to enable automation and insights into your business. Create interactive data visualizations and reports with Microsoft’s flagship data visualization software. Connect to [...] […]
Health Informatics What You Should Know
What is Health Informatics? When you search the internet for health informatics the first few pages of results are mostly college programs. These do a good job explaining their programs and what you might do after graduation with healthcare data. However, they explore what it's like to work in the field and the variety [...] […]
Getting Started with Power BI for Healthcare Analytics
Get Started Using Power BI for Healthcare Analytics Do you currently rely on ad-hoc queries and Excel for your healthcare analytics data? Is your team spending more time trying to find the data you need instead of performing analysis on your data? Are you using VLookups to try to mash up your data from [...] […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example