We look forward to teaching you the capabilities of data analysis in the Microsoft Power BI Report in a Day training November 10 from 8:30 a.m. to 4:30 p.m. EST. Training will be in the training room at 100 Cherokee Blvd, Chattanooga, TN 37405. Let us know if you are attending remotely and we will provide you a Teams link if you cannot make it in-person. Please bring your laptop or let us know if you need us to provide you a laptop to use.

Thank you,

Jeremy Nathan

Email: jnathan@jncomputertraining.com

Mobile: 865-282-1895

Office: 423-654-8599

Here is the outline of what you will learn:

Power BI Report in a Day Training

1. Power Query

• Import CSV, Excel, files from a folder, PDF, and websites

• Use Power Query to transform data

• Work with Power Query steps

• Fill Empty Values

• Split Columns

• Rename Columns

• Change Data Types of Columns

• Add Columns from Examples

• Remove Rows and Columns

• Use First Rows as Headers

• Append Queries

• Make Conditional Columns

• View Query Dependencies

2. Data Model and Visualization

• Create Clustered Column Charts

• Create Relationships in Data

• Create Calculated Columns

• Visual Filters

• Format Visuals

• Group Fields

• Make Tree map Visuals

• Drill-down in Visuals

• Visual Interactions

• Date Calendar

• Hide Fields in Report View

• Make Measures

• Conditional Formatting Visuals

• Use a Logo for Slicers

• Make Gauge Visuals

• Change Report Theme

• Change Colors of Visuals

• Add Text and Pictures to a Report

• Use Bookmarks

3. Power BI Services

• Publish a Report

• Make a Dashboard

• Use Q&A in a Dashboard

• Generate Insights in a Dashboard

• Add Alerts to Reports and Dashboards

• Share Reports and Manage a Workspace