Power BI Bootcamp

Limited Time offer: Along with the Live instructor led training , you would be provided access to related eLearning training with lifetime access ( a $200 value)

https://elearning.bigdatatrunk.com/p/introduction-to-power-bi

https://elearning.bigdatatrunk.com/p/power-bi-hands-on

Description:

Join our intensive Power BI Bootcamp to become a Microsoft Power BI 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

Duration: May 27th & 28th, 2024
2-Half Days (9:00 a.m to 12:00 p.m PST)

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.

Prerequisites

• Basic understanding of Databases

Audience:

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

Curriculum

• 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

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

Event Venue

Online