Resource Collection

Power BI

Power BI is a tool that allows analyst to quickly generate dashboards and reports from a variety of data sources.  Thanks to the Department of Technologies recent acquisition of Power BI premium CCSF analyst have an easy way of distributing these reports within CCSF.

Power BI’s greatest asset is the ability to automate the often laborious ‘data wrangling’ stage of dashboards and report creation, eliminating the need to reshape, clean, or edit data in excel before visualizing.  Learn more:

  • Brown Bag slidedeck explains the benefits of Power BI versus other tools
  • Tipsheets on use of the CCSF Premium Capacity & Publish-to-Web feature

Data Visualization Guide for

Guide for making accessible public dashboards and data visualization for the City and County of San Francisco website. Includes pre-made PowerBI template files and step by step video tutorials.


Accessing data on DataSF's Data Portal in Power BI

A guide with best practices for connecting datasets on the City's Open Data Portal to Power BI.


Power BI Brown Bag

A high level overview of Power BI compared to Tableau, Excel, and R.


Power BI Premium Report Optimization Tipsheet

A guide for CCSF employees to optimize their PowerBI data models for use in the Premium capacity


PowerBI Publish-to-Web Tipsheet

A tipsheet for CCSF employees when using publish to web feature in PowerBI


PowerBI Resources for IT

Curated list of external resources for IT departments to understand the PowerBI ecosystem.

One Pager

DataSF PowerBI Cheatsheet

A 2 page visual cheat sheet to Power BI's Report Editor and Query Editor. Created for Intro to PowerBI course.


DataSF Dashboard Template File

A report template for Power BI that incorporates a date table and helpful links. Created for Intro to PowerBI course.