TRANSFORM AND VISUALIZE DATA WITH POWER BI

Transform and Visualize Data with Power BI

Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool.

Location	Date	Discount Code	Registration Link
Atlanta, GA	September 26, 2015	FHT_SQLSAT1	Register
Orlando, FL	October 9, 2015		Details coming soon
Houston, TX	To Be Announced		Details coming soon

In this course we will work through four main topics:

• Shaping and Transform Data from Different Sources
• Create a Single Data Model
• Visualizing Data with Reports
• Using the Power BI Service to Create and Share Dashboards

In this full-day workshop, not only will you gain insight into all the new features of Power BI, but you will also walk-through a hands-on lab that helps you experience many facets of the product. The following is the full agenda:

Agenda

8:30 – 9:00           Breakfast and Networking

9:00 – 9:30           Introduction to Power BI

9:30 – 10:45         Importing Data from:

•                                Excel Files
•                                Access Databases
•                                Comma-delimited Files

10:45 – 11:00      Break

11:00 – Noon      Shaping and Transforming Data

•                               Renaming Queries and Columns
•                               Formatting Data
•                               Adding columns
•                               Merging Data Sources

Noon – 12:45      Working Lunch (Power BI Data Model and Reporting Concepts)

12:45 – 2:00        Building the Data Model

•                               Hiding Tables and Columns
•                               Adding Calculated Columns
•                               Adding Measures
•                               Creating Relationships

2:00 – 3:15           Visualizing Your Data

•                               Creating the First Report (Bar Charts, Line Charts, Slicers, Tree Maps, etc…)
•                               Filtering Data (Page and Visualization)
•                               Formatting the Report (Titles, Headers, Adding Images, Color Scheming, etc…)

3:15 – 3:30           Break

3:30 – 4:30           Using the Power BI Service

•                               Uploading the Power BI Desktop File
•                               Creating a Report
•                               Creating and Organizing a Dashboard
•                               Using Q&A

4:30 – 5:00           Questions and What’s Next

In addition, you will be given access to videos that walk you through each module of the lab step-by-step that can be viewed later at your convenience.

Registration is open for the Atlanta event, but room is limited so sign up today!

See you in class,