Power BI Bootcamp

Description:

Join our intensive Power BI Bootcamp to become a Microsoft Power BI Bootcamp expert. This course covers everything from the basics to practical projects. Day 1 introduces you to Power BI essentials, including data extraction, transformation, and report creation. Day 2 delves deeper into visualization, filters, and collaboration using Power BI Service. Our hands-on labs ensure you gain real-world experience, and you'll leave with the ability to connect to organizational data and create impactful dashboards. Don't miss this opportunity to master Power BI Bootcamp.

Duration: 2 Days

Course Code: BDT161

Learning Objectives:

• Understand the Power BI ecosystem, including its tools and workflow.
• Extract data from diverse sources such as Excel, CSV, SQL, and the web.
• Master data cleaning and transformation using the Power Query Editor.
• Create reports and visualizations in Power BI Desktop.
• Develop data models with relationships and calculated measures.
• Explore advanced visualizations like maps and custom visuals.
• Utilize filters, slicers, and drill-through options for data exploration.
• Build and format dashboards for effective data storytelling.
• Participate in hands-on project labs to apply your skills.
• Learn about security, app creation, and data connections in Power BI.

• Basic understanding of Databases

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

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

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)