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

Executive Dashboard with Power BI
Create Executive Dashboards using Power BI Managers need the ability to see data from different areas of the business. Organizing this data into easy to use visualizations enables you to determine trends and discover insights. In addition, you can create mashups that pull data from different sources into a single dashboard view. Executive Dashboard […]
Power BI and Capital Projects
Tracking Capital Projects with Power BI This example pulls data related to projects and creates a dashboard that enables users to quickly see actual vs budget and variance. The status of the projects are shown as well as the breakout of projects by sponsor. The graphs are interactive and can be filtered by selecting a […]
Power BI and Credit Union Membership
Credit Union Membership Map in Power BI This example uses membership data for a fictional credit union to map the members by zipcode. A heatmap is then created to show which zip codes have the most members. The darker the color the more members are in that zip code. In addition, the 4 branch locations […]