• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

USAFacts breaks down government financial data with Power BI

April 22, 2018   Self-Service BI
social default image USAFacts breaks down government financial data with Power BI

On tax day this year USAFacts is relying on Power BI to publish a 10-k report to provide a comprehensive view of the combined US federal, state and local governments’ revenues and expenditures. The data is collected from multiple government sources including the US Treasury Department, the Office of Management and Budget, the US Census Bureau, and the Federal Reserve.

The USAFacts team used Power BI to quickly and efficiently build interactive data visualizations that could be published directly to the web, without writing any code. Visitors to the site, across both web and mobile, can click through the charts of greatest interest to them and explore the various elements of the government budget.

The reports leverage some of our favorite Power BI features. For example, the Revenues report showcases the popular Bookmarking feature to toggle between a Table or Chart view. This provides the viewer with the option to increase the amount of detail, or to view only the charts instead of a table.

The Federal Land Ownership in the U.S. Total report has the same toggle button, but this time provides the option to show the data as a table vs. maps. The maps are interactive and display just the selected state data when marked.

The Combined Income Statements report features clean tables with a drop down filter on the top right. This approach gives viewers the flexibility to pick ‘inflation-adjusted’ or not for example, pending their financial reporting needs.

USAFacts is empowering their audience, journalists, academics, think tanks, and analysts alike to be able to reuse the visualizations hosted on USAFacts and even mash them up with their own data, or re-visualize the data discover new stories. USAFacts will share the Power BI content as embeddable links and the underlying Power BI files if you request them by email, so it’s easy for to include interactive reports in stories.

A growing number of media are adopting Power BI because it is a simple and scalable solution to discover, create and share data stories. In addition to individuals creating visuals for stories, organizations like the Associated Press and USAFacts are providing Power BI reports to journalists and others interested in sharing data online with Power BI publish to web to scale the distribution of the data they share. By providing pre-built Power BI reports, these organizations enable anyone to easily include an interactive report created in Power BI in an online story with just a few clicks.

There’s growing demand for collaborative, flexible, data journalism that empowers the audience to reuse, reinterpret, and repurpose data stories to reveal insights and establish a deeper connection with their own audience. By using Power BI, they’re ensuring the tooling required is low cost, easy to use and future-proof because it’s built and supported for core productivity scenario within Enterprises. They’re removing the technological barriers that prevented many from participating in data journalism.

With these choices, they’re showing how Power BI can democratize data journalism, bringing in more journalists, bloggers, and analysts.

Using a Power BI interactive visualization in your data story

If you are interested in using a Power BI embed code, follow the steps below to use the report in your own public story, blog or website. If you want to find out more about how to get started with Power BI to build your own reports, you can download the latest version of the free Power BI Desktop and sign up for the cloud service.

Often an organization providing a Power BI report for data journalism will offer two options:

  1. An “embed code” that enables you to easily include the very same interactive graphic on your own site and offer your readers the ability to also “explore” the data. You can increase engagement from your site visitors by enabling them to uncover how the data relates to them personally. To include the interactive report on your site, simply copy-and-paste the several lines of Web code into your site’s content management system. Note that the embed code should be sized to fit the iFrame on your site, and when implemented correctly, will appear without any extra grey borders.

  2. A “Power BI” file, which contains the data and interactive graphic in a single, editable “.pbix” format for use in Power BI Desktop. If you are interested in publishing the interactive graphic, but would like to make modifications to it first – perhaps changing its colors, fonts, other elements of style – then download the .pbix file and adjust it using Power BI Desktop. Once you have customized the report, you will be ready to add it to your website. Follow these instructions to publish into your service, and then learn how to create an embed code to publish the report to the web.

Where to from here?

If you want to learn more about Power BI we recommend the following resources:

  • Power BI Documentation – covers all aspects of Power BI.

  • Power BI Community – online forum where you can search for answers, learn from others and discuss Power BI with experts and peers. This is also a great resource to keep up to date with Power BI and new features and improvements that are continually being released.

  • Data Stories Gallery – find other reports and examples of data storytelling from members of our community.

  • If you have questions about to use Power BI for data journalism, check our website here or email us directly at MSFTDataJournalism@Microsoft.com.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

Breaks, data, down, Financial, Government, Power, USAFacts
  • Recent Posts

    • Why Some CRM Initiatives Fail
    • Lucas Brothers To Write And Star In Semi-Autobiographical Comedy For Universal
    • NortonLifeLock’s AI-powered smartphone app blurs out sensitive information in photos
    • WHEN IDEOLOGY TRUMPS TRUTH
    • New Customer Experience Needs and Commerce Trends for 2021
  • Categories

  • Archives

    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited