Power Series Webinars

Course Language: English
 

Schedule

  • All sessions are held at 1200 Eastern time

    • January 18th-Intro to Power Query*
    • February 15th-Transforming data in Power Query*
    • March 15th-Cleaning data in Power Query*
    • April 19th-Combining data from multiple sources*
    • May 17th-Intro to Power Query M Formula Language*
    • June 21st-Intro to Power BI*
    • July 19th-Simple Visualizations in Power BI*
    • August 23rd-Power BI Visualizations Cont'd*
    • September 20th-Mapping in Power BI
    • October 18th-Temporal Analysis
    • November 15th-Modeling
    • December 20th-Introduction to the DAX
    • * currently available in the webinar library for IACA members

Description
 

Microsoft Power Bi is a powerful application for data visualization and reporting that can handle millions of rows of data. Power Query is a data transformation and preparation engine that can help you clean and process data from any source, and then repeat those steps when you get updated data. The data can then be passed to other applications such as Microsoft Excel or Power BI.

This webinar series will walk you through using Power Query and Power BI using live demonstrations in the applications with open source crime data. The data set can be found here. 

  • January-Intro to Power Query
    • Click here for the class materials for this session
    • What is Power Query?
    • Why should we use it
    • Examples
    • Where to start
  • February-Transforming data in Power Query
    • Click here for the class materials for this session.
    • Data formats
    • Add columns
    • Formatting and extracting time/date
  • March-Cleaning data in Power Query
    • Click here for the class materials for this session
    • Time/date Cleaning
    • Text cleaning
    • Number cleaning
  • April-Combining data from multiple sources
  • May-Intro to Power Query M Formula Language
    • Click here for the presentation for this session along with the links below for data sets
    • Introduction
    • Where to start
    • Examples
  • June-Intro to Power BI
    • Click here for the class materials for this session
    • What is Power BI
    • Why should we use Power BI
    • Examples
    • Where to start
  • July-Simple visualizations in Power BI
    • Click here for the presentation for this session along with the links below for the data set and example logos
    • Bar charts
    • Pie charts
    • Graphs
  • August-Power BI visualizations Cont'd
    • Click here for the presentation for this session along with the links below for the data set and other files
      • CrimeWatch
      • 8_PBI.pbx (this is a Dropbox link because the website won't allow pbix files)
      • 8_PBI.pbit (this is a Dropbox link because the website won't allow pbit files)
    • Cards
    • KPI
    • Tables
    • Matrix
  • September-Mapping in Power BI
    • Click here for the presentation along with the links below for the data sets and other files
      • Policing Beats (this is a Dropbox link because the website won't allow json files)
      • 9_PBI_1 (this is a Dropbox link because the website won't allow pbix files)
      • 9_PBI_2 (this is a Dropbox link because the website won't allow pbix files)
      • CrimeWatch
      • Alameda County
    • General map
    • ESRI map
    • Other options
  • October-Temporal Analysis
    • Click here for the presentation along with the links below for the data sets and other files
    • Day of week
    • Time of day
    • Matrix of time of day/day of week
  • November-Modeling
    • Click here for the presentation along with the links below for the data sets and other files
    • Star modeling
    • Manage relationships
    • Cardinality
    • Cross filter direction
  • December-Introduction to the DAX
    • Introduction
    • Simple formulas
    • Examples of advanced formulas
Click here for a PDF flyer

Format & Continuing Education credits/Certificates

All Power Series webinars will be recorded; if you cannot attend the live session, we will provide the recording the next day to everyone who registers. For non-registrants, the recordings will be posted to the webinar library after 45 days.

All registrants who are IACA members will receive Continuing Education Credits and you may request a certificate if you want one. Anyone who attends the webinar live will receive a certificate automatically from GoToWebinar. 

We will not be able to award CEUs to those who watch videos in the webinar library, though you can request a certificate for any video in the library. See that page for more details. 

 

Return to Training