Getting Started with Power BI

Dashboards, Smashboards – if you’re only surviving with basic pivots and charts accompanied by slicers, you’re missing out on the amazing tools that Power BI has to offer. It’s time to leave behind the hard way of doing things and embrace a new day of efficiency and productivity.

Learning Power BI doesn’t have to be a daunting task, and you don’t have to do it alone. Join us and learn from seasoned experts who work with Power BI daily. We’re sure you’ll appreciate the practical tips and insights we bring to the table.

Investing just one day of your time to explore what Power BI has to offer will be well worth it to discover Power BI’s transformative possibilities and unleash the true potential of your data. Let us empower you with the knowledge and skills to create stunning dashboards and smash through any data challenges you encounter.

What You Will Learn In This Course

Power BI Desktop Interface

  • Open a Sample Report
  • Navigate an existing Power BI 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 value
  • Convert Data
  • Add Columns

Add Columns

  • Custom Column with basic formula
  • Create a Conditional Column
  • Create a column of upper-case values
  • Trim out all spaces
  • Extract values

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