This video will demonstrate the ease with which flat file raw data can be integrated, modeled, and deployed for an Excel 2010 dashboard using PowerPivot. If you have experience with Excel 2010, you can follow along with this video to create a Business Intelligence dashboard with slice-and-dice filters. This demonstration will use real Department of Energy Fukushima Incident data from http://Data.Gov.
Greg Beaumont's Data & Analytics Blog
Data, Analytics, AI, Business Intelligence posts and videos
recent posts
- Create Semantic Model Hybrid Columns for the best of both DirectQuery and Import
- NoDAX (Not Only DAX) query patterns with Fabric Data Agents
- Use M365 Copilot to improve Power BI semantic models, power query, and report speed
- Strategic Data Replication Enhances a Single Source of Truth Architecture for Analytics & AI
- Fabric Data Agent for Semantic Model added to our free Fabric Github Repo
about
- October 2026
- June 2026
- March 2026
- February 2026
- January 2026
- November 2025
- September 2025
- August 2025
- April 2025
- January 2025
- November 2024
- October 2024
- September 2024
- June 2024
- April 2024
- February 2024
- January 2024
- December 2023
- November 2023
- August 2023
- April 2023
- August 2022
- July 2022
- May 2022
- January 2022
- August 2021
- June 2021
- April 2021
- March 2021
- February 2021
- December 2020
- April 2020
- March 2020
- February 2020
- November 2019
- October 2019
- January 2019
- April 2018
- February 2016
- January 2016
- June 2015
- January 2015
- December 2014
- November 2014
- October 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- April 2013
- March 2013
- August 2012
- July 2012
- June 2012
- May 2012
- March 2012
- May 2011
- February 2011
- December 2010
- June 2010
-
Below is a recording of a presentation that I did with a colleague at the Minnesota Microsoft BI User Group Meeting on March 6th of 2012:
-
Healthcare organizations swim in an ocean of data. Analysts in both healthcare organizations and research must tie together multiple disparate data sources in order to integrate the data required for a comprehensive analysis of patient care and operations. Microsoft PowerPivot is a valuable Business Intelligence (BI) tool for tying such disparate data together for slice-and-dice, drill-down, cross-functional ad-hoc analysis.
Read the rest of my original post at this link: https://gnetgroup.wordpress.com/2011/05/24/analyzing-cancer-healthcare-data-incidence-with-powerpivot/
Analysis of Cancer Incidence Data using Power Pivot video #1:
Analysis of Cancer Incidence Data using Power Pivot video #2:
-
Video: Using PerformancePoint 2010 Dashboard Designer Series, Bottom Axis, Background and Pie Charts
A common objection to PerformancePoint 2007 Dashboard Designer was often the lack of a pie chart visualization option in reports. When looking for a method to visually display percentages of the whole, I have always been partial to 100% stacked bar charts since they provide sight lines for category proportion comparison. However, pie charts are a tried and true visualization method that many folks are comfortable using.
In PerformancePoint 2010 Dashboard Designer, you can have your pie and slice it too.
In this article, the second installment in a series spotlighting some of the upgrades that can be found in PerformancePoint 2010 Dashboard Designer, I will use the new pie charts to walk you through the use of the Series, Bottom Axis, and Background dimension and value placements for analytic chart building.
Continue reading the rest of the post at this link: https://gnetgroup.wordpress.com/2011/02/16/using-performancepoint-2010-dashboard-designer-series-bottom-axis-background-and-pie-charts/
-
Ever feel limited by PerformancePoint 2007 Dashboard Designer? There are several new features in PerformancePoint 2010 Dashboard Designer that add rich and useful capabilities for the customization of SharePoint 2010 dashboards. In fact, there are far too many improvements to adequately address in a single article. This article will be the first installment in a series of articles spotlighting some of the specific improvements that can be found in PerformancePoint 2010 Dashboard Designer.
In the 2007 Dashboard Designer, sorting and filtering of grids and charts is optimally performed in the underlying data sources. More often than not, that means modifying the underlying cubes in Analysis Services. Fortunately, the 2010 Dashboard Designer brings a WYSIWYG solution to the rescue.
Continue reading original post at this link: https://gnetgroup.wordpress.com/2010/12/16/new-sort-and-filter-features-in-performancepoint-2010-dashboard-designer/#more-100
-
A Pareto Chart, which can be used to visualize the Pareto Principle (the 80/20 rule), can be created in Excel 2010 for display with slice and dice capabilities on a SharePoint 2010 dashboard. Using an Analysis Services cube built with AdventureWorks data, a Pareto Chart is constructed for publication using Excel Services. Also learn how to add a parameter so that the Pareto Chart can be sliced and diced using a PerformancePoint filter.