Power BI training in Portland: Dashboard in an Hour by CSG Sept 29th


 

 

CSG is taking the DIAH training and making available FOR FREE!

Additionally the folks at CSG  will be offering a Dashboard in an hour session available at SQL Saturday http://www.sqlsaturday.com/572/eventhome.aspx 

 

image

 

What is Dashboard in an Hour?

A hands-on session using Microsoft Power BI to show you how to build a Power BI dashboard from Excel spreadsheets, or a local/public database. It is led by Microsoft Gold Partner, CSG Pro.

Who is the session for?

Anyone interested in Microsoft Power BI who’d like to gain greater insights from their data.

When is the Dashboard in an Hour?

September 29th, 2016, 9:00 to 10:00 a.m. Coffee, carbs and set-up starts at 8:30 a.m. For those who desire, an optional Q&A and 1:1 is available with our Power BI subject matter experts from 10:00 to 10:30 a.m.

Where?

Microsoft Portland Office (in the Pearl District), 1414 NW Northrup St, Suite 900, Portland, OR 97209. 

Cost and Prerequisites.

There is no cost. This is a Bring Your Own Device (BYOD) session.

In case you don’t know, or want to know a little more, just what is Power BI?

Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

To register:

https://www.csgpro.com/events

 

image

Problem Statement …………………………………………………………………………………………………………………………………………………………………………… 3
Document Structure ………………………………………………………………………………………………………………………………………………………………………….. 3
Prerequisites …………………………………………………………………………………………………………………………………………………………………………………….. 4
Power BI Desktop – Get Data ……………………………………………………………………………………………………………………………………………………………… 5
Power BI Desktop – Manage Relationship ……………………………………………………………………………………………………………………………………………. 8
Power BI Desktop – Create Report ………………………………………………………………………………………………………………………………………………………. 9
Power BI Service – Import Report …………………………………………………………………………………………………………………………………………………….. 15
Power BI Service – Create Dashboard ……………………………………………………………………………………………………………………………………………….. 17
Power BI Service – Power Q & A ……………………………………………………………………………………………………………………………………………………….. 24
Power BI Service – Share Dashboard …………………………………………………………………………………………………………………………………………………. 25
References ……………………………………………………………………………………………………………………………………………………………………………………… 27

 

 

Of course be sure and ask them about advanced training …like the entire Dashboard in a Day class:

 

image

 

Overview ……………………………………………………………………………………………………………………………………………………………………………………………… 5
Introduction ……………………………………………………………………………………………………………………………………………………………………………………… 5
Data Set……………………………………………………………………………………………………………………………………………………………………………………………. 5
Course Outline ………………………………………………………………………………………………………………………………………………………………………………….. 5
Power BI Desktop …………………………………………………………………………………………………………………………………………………………………………………. 6
Importing Data ………………………………………………………………………………………………………………………………………………………………………………….. 6
Transforming your Data ……………………………………………………………………………………………………………………………………………………………………. 17
Interactive Data Exploration ……………………………………………………………………………………………………………………………………………………………… 26
Power BI Service – Part I ………………………………………………………………………………………………………………………………………………………………………. 79
Power BI Service – Creating Dashboard and uploading your Report ……………………………………………………………………………………………………….. 79
Power BI Service – Operational Dashboard and Sharing ……………………………………………………………………………………………………………………….. 83
Power BI Service – Refreshing data on the Dashboard ………………………………………………………………………………………………………………………… 101
Power BI Service — Part II …………………………………………………………………………………………………………………………………………………………………… 112
Distributing content to larger audiences for them to customize ………………………………………………………………………………………………………….. 112
View and manage your Excel reports in Power BI ………………………………………………………………………………………………………………………………. 127
Collaboration via Office 365 Groups …………………………………………………………………………………………………………………………………………………. 134
References ……………………………………………………………………………………………………………………………………………………………………………………….. 137

Comments (0)

Skip to main content