Are you tired of needing macros that you never recorded? Are you tired of doing the same redundant steps over and over with the same spreadsheet nightmare each week or month? Dashboards, Smashboards – the best you do right now is to survive basic pivots and charts with slicers. PowerBI has amazing tools just waiting for you to learn how to use them. Stop doing things the hard way – it’s a new day.

It’s worth a day of your time to learn about what PowerBI offers you.

PowerBI Desktop Interface

  • Open a Sample Report
  • Navigate an existing PowerBI report
  • Pie charts
  • Use the Pie as a Filter

Sharing Your Reports, the Basics

  • Publish to My workspace
  • Open My Workspace
  • Export to PDF
  • Export to PowerPoint
  • View Insights on your data

Get Data

  • Connect to a file: Excel
  • Connect to SQL data
  • Use Power Query with your Data

Transforming and Model Data for Reporting and Visuals

  • Remove the columns you don’t need with Query Editor
  • Close and Apply Data
  • Add a basic matrix (Pivot Table)
  • Filter Data in Power Query
  • Set data type
  • Change the Data Type
  • Replace values
  • Convert Data
  • Add Columns

Create Visualizations and Reports

  • Add a Card Visual
  • Add a Table Visual
  • Add a Matrix
  • Add a Pie Chart
  • Adding a Tree Map
  • Use slicers to filter visuals
  • Ask a Question

This session will be in the heart of the Innovation District at the Innovation Depot. The class starts at 9 am, and the welcome starts at 8:45. Class guides will be provided. You have two ticket options – one we provide a laptop setup and ready or you can bring your laptop.

Class Instructor is Robin Hunt; you can read more about Robin on LinkedIn. Robin has a love for sharing technology and has trained thousands of people in every aspect and industry in Excel and Office.

Need to change your date? Email us at anytime askus@thinkdatasolutions.com