Most Technology Training classes will be delivered online until further notice.
Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.
This course covers everything from the basics to practical projects. Our hands-on labs ensure you gain real-world experience, and you will leave with the ability to connect to organizational data and create impactful dashboards.
Prerequisites:
- Basic understanding of Databases
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.
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
Exploring 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
