• Analyst, programmer, business user or anyone interested using data analysis with powerful visualization tool

• Basic understanding of Databases

Course Outline:

Day-1

• Introduction
  • What is Power BI?
  • What are the Key Tools?
  • Typical Workflow
  • Power BI Terminology
• Extracting Data
  • Extracting the data (Excel, .csv, SQL, web)
  • Transforming the Data
  • Exploring the Power Query Editor
  • Applied Steps
  • Working With Queries
  • Applying Transformations
  • Loading Queries
• Power BI Desktop Interface
  • Report
  • Visualizations
  • Fields and Filtering
  • Formatting and Analytics
• ploring the Data View
  • Categorizing Geographical Data
  • Formatting Dates
  • Controlling Summarization Behavior
• Reviewing the Data Model
  • What is a Data Model?
  • Examine Existing and Creating New Relationships
• Measures and Calculated Columns
  • Creating Calculated Columns
  • Creating simple DAX measures
  • Creating a Date Table
  • Creating a Dates Table

Day-2

Explore the Visualization Menu

• Review a Sample Report
• Develop a Report Storyboard
• Create and Format Visuals and Pages
  • Column and Bar
  • Pie
  • Adding Pages
  • Line
  • Matrix
  • Formatting Pages
  • Maps
  • Other Available Visuals
• Drill Through Relationships
• Using Filters and Slicers
• Using Custom Visuals & the Marketplace

• Organizational Visuals
• Additional Page Elements

• Create Other Objects in Reports
  • Buttons
  • Shapes
  • Images
  • Bookmarks
• Publishing the Report
• Establishing a Workspace
• Personal and App Workspaces
• Introducing Power BI Service

• App Workspaces
• Create and Format Dashboards
• Get Data
• Update Dashboard

• Create and Maintain Apps
  • Setting Security
  • Finding other Apps
  • Connect to organizational data
• Project Labs

Training material provided: Yes (Digital format)