Schema Archives - BI and Predictive Analytics

Leveraging SQL Server Database Schema

June 24, 2015 by Derek Leave a Comment

Leveraging SQL Server Database Schema Data warehouses typically pull data from various sources and combine the data into a common repository. Keeping up with the source systems and what data is being pulled from each system can be challenging. One method that can be used to easily identify the source and type of data in … [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 [...] […]