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
Guide

Data Visualization Guide for sf.gov

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.

Document

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.

Document

Power BI Brown Bag

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

Document

Power BI Premium Report Optimization Tipsheet

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

Document

PowerBI Publish-to-Web Tipsheet

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

Document

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.

Template

DataSF Dashboard Template File

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