Greg Beaumont's Data & Analytics Blog

Data, Analytics, AI, Business Intelligence posts and videos

recent posts

about

Greg Beaumont is a technology professional from Minnesota specializing in Microsoft tools.

Category: Legacy Post

  • Managing Deliverable Expectations for Business Intelligence Project Success

    This article was originally published to a blog which has been decommissioned. Business Intelligence (BI) projects are usually intended to meet a hybrid of different needs, frequently including standardized reports and dashboards, self-service reporting, and data discovery tools. Quite often, unexpected relationships and architectural challenges are found in data during the course of a project.…

  • Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 2

    This article was originally published to a blog which has been decommissioned. This is Part Two, the final of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model. Continue reading the full version of the post at this link: https://web.archive.org/web/20150309051644/http://blog.gnetgroup.com/bi/2014/11/13/automate-bus-matrix-documentation-using-dmv-queries-from-a-microsoft-bi-tabular-solution-for-project-management-scope-verification-part-2/

  • Automate Bus Matrix Documentation Using DMV Queries from a Microsoft BI Tabular Solution for Project Management Scope Verification – Part 1

    This article was originally published to a blog which has been decommissioned. This is Part One of two blog posts about automating the creation of a Bus Matrix in Power Pivot for Excel using DMV queries from an SSAS Tabular Model. Continue reading this article at this link: https://web.archive.org/web/20150309051221/http://blog.gnetgroup.com/bi/2014/11/11/automate-bus-matrix-documentation-using-dmv-queries-from-a-microsoft-bi-tabular-solution-for-project-management-scope-verification-part-1/

  • SQL Saturday 332 Minnesota: Open Data & Microsoft BI Tools by Greg Beaumont

    Open Data is freely available for everyone to use and republish as they wish without restrictions from copyright, patents or other mechanisms of control. The United States Government has a dedicated open data portal at Data.gov, and there are now hundreds if not thousands of open data portals from countries, provinces, counties, companies, and cities.…

  • Visualizing the Relationships between Chicago Homicides and Hot Weather

    The media frequently speculates about the relationship between hot summer weather and murders in Chicago.  With both Chicago crime and daily weather information available to the public as open data, comparing the two phenomena is possible.  Below is an interactive data visualization (point and click around on it) of Chicago homicides and weather: var divElement = document.getElementById(‘viz1753911112435’);…

  • An Interactive Data Visualization Dashboard of San Francisco Police Reports in 2013

    San Francisco Police Reports 2013 Dashboard (click the filter values and hover over bubbles and bar graph colors, it’s interactive!) var divElement = document.getElementById(‘viz1753909590175’); var vizElement = divElement.getElementsByTagName(‘object’)[0]; vizElement.style.minWidth=’420px’;vizElement.style.maxWidth=’800px’;vizElement.style.width=’100%’;vizElement.style.minHeight=’587px’;vizElement.style.maxHeight=’827px’;vizElement.style.height=(divElement.offsetWidth*0.75)+’px’; var scriptElement = document.createElement(‘script’); scriptElement.src = ‘https://public.tableau.com/javascripts/api/viz_v1.js’; vizElement.parentNode.insertBefore(scriptElement, vizElement); The above dashboard visualizes San Francisco Police Department Incident Reports for the year 2013.  Tableau Public was used…

  • Liquor Open Data from British Columbia’s DataBC Platform and BC Liquor Stores

    Need a break from browsing accounting ledger open data?  Take an hour to browse the BC Liquor Store Product Price list which is available on British Columbia’s DataBC open data platform.  You might find the data to be interesting and useful, and the hour that you spend working with it might even be a happy…

  • World Bank Forest and Agricultural Data Mashed Up to Visualize Trends

    The World Bank provides open data about development in countries across the globe including data about agricultural land and forest area by country over time.  Combining both of these data sets with their land area data can give new insights into the relationship between agricultural and forestry land over time. The trends of forest land and agricultural land over time can be visualized…

  • Mash Up Minneapolis and New York City Restaurant Inspection Data

    The City of Minneapolis has made restaurant inspection data available to the public as open data.  A useful example of how this data can be used and exposed to the public can be found at this link, which provides a web based map that displays the results of the restaurant inspections on a map.  The Open Twin…

  • Build Your Own Great Britain Road Safety Data Model

    The United Kingdom has a robust, accessible, and useful open data portal.  One of the data sets that has been made available to the public is Road Safety Data from the Department for Transport.  The data set contains a wealth of information about accidents that involved casualties in Great Britain.  Documentation for this data to help you access,…