July 2015 - BI and Predictive Analytics

SQL Server Polybase (2016)

July 20, 2015 by Derek Leave a Comment

What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats and technologies to combine data … [Read more…]

HASSUG BI Developer Presentation on 7/14/2015

July 19, 2015 by Derek Leave a Comment

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session resulted from feedback we received in the user group on differences between database developers and BI developers. If you are interested in seeing the presentation content it is uploaded here: Becoming a bi developer from … [Read more…]

How to Model Power BI Covid 19 Data
How to Model Covid-19 Data using Power BI This is the second in my series on helping you turn the Covid data on GitHub into information. In this post, I show you step by step on how to model Power BI Covid data using Power BI, Power Query and DAX formulas. If you are [...] […]
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 [...] […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: July 2015

SQL Server Polybase (2016)

HASSUG BI Developer Presentation on 7/14/2015