Hello, you are using an old browser that's unsafe and no longer supported. Please consider updating your browser to a newer version, or downloading a modern browser.

The Future of Data Analysis

Duration

3 Day (Virtual or Physical Classroom)

Expert Instructors

Gain expertise from the best

Hands-on

Practical exercises and lab environments

In an era where companies are flooded with data yet often struggle with inadequate reporting tools, the Microsoft Power BI Boot Camp course empowers you to unlock the potential of your data. You will learn how to provide comprehensive insights to executives, managers, and staff using cutting-edge business intelligence solutions built on the Microsoft Power BI and 365 platform. With unprecedented accessibility and capability, this course provides all the knowledge required to implement robust BI solutions using Power Query, PowerView, PowerPivot, Power Map, Excel Services, and Power BI.

Our Microsoft Power BI Boot Camp Infosec Academy features:

  • Cover the basics to advanced Power BI topics.
  • Real-world scenarios for practical application.
  • Discover best practices for sharing insights and collaborating with teams.

By the end of the boot camp, you’ll be equipped with the skills and confidence to effectively analyze and visualize data, providing actionable insights that can drive your organization’s strategy and performance.

ill

View Course Schedule

Learn More
ill-1

Team Training

Learn More
Placeholder Image
  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • Digital Marketers
  • IT Specialists
  • IT Managers/IT Directors
  • Anyone responsible for implementing BI
  • Utilize the entire Microsoft BI stack
  • Connect on-premise data sources to the cloud
  • Build an enterprise Data Catalog to share queries
  • Implement scorecards, dashboards, and KPIs
  • Analyze data with PowerPivot
  • Integrate data from many different external data sources
  • Implement effective, high-performing BI solutions
  • Provide intuitive ad-hoc reporting for business users by implementing Power View
  • Comprehensive Participant Guide
  • Access to lab environment for hands-on exercises
  • Interactive Lectures
  • Group Workshops
  • Certificate of Completion

What is BI

  1. Business Intelligence Overview
  2. Evolution of Business Intelligence
  3. Common Challenges
  4. Benefits of Power BI

Getting Started with Power BI

  1. Overview & Pricing/Licensing
  2. Components of Power BI
    1. Power BI Desktop
    2. Power BI Mobile
    3. Power BI Embedded
    4. Power BI Gateway
  3. Building Blocks of Power BI
    1. Datasets
    2. Visualization
    3. Reports
    4. Tiles
    5. Dashboards
  4. Power BI Workflows
  5. Resources for Inspiration

Demo: Quick Tour of Power BI Service

Lab Exercise: Quick Tour of Power BI Service

Getting Data

  1. Navigating Power BI Desktop
  2. Connect to Data Sources in Power BI Desktop
    1. File Data Sources
    2. Database Data Sources
    3. Azure Data Sources
    4. Online Service Data Sources
    5. Miscellaneous Data Sources
  3. Clean and Transform your Data
  4. Advanced Data Sources
    1. Advanced Editor
    2. Shaping Data
    3. Applied Steps
  5. Transformations
  6. Cleaning Irregularly Formatted Data
  7. Data Types
  8. Combining Data
  9. AI Analytics
    1. Text Analytics
    2. Vision
    3. Azure Machine Learning
    4. Invoking the Shared Models
    5. Considerations and Limitations

Demo: Quick Tour of Power Query Editor

Lab Exercise: Import Data and Create Queries with Power BI Desktop

Lab Exercise: Transform Data

Lab Exercise: Combining Data

Lab Exercise: Create a Report using Power BI Desktop

Lab Exercise: Publish a PBIX File to the Power BI Service

Power BI and Excel

  1. Excel Integration
    1. Import an Excel Table into Power BI
    2. Use Excel as a Dataset
    3. Import Excel Files with Data Models
    4. Connect, Manage and View Excel in Power BI
  2. Publishing and Sharing

Modeling Data

  1. Overview
  2. How to Manage Your Data Relationships
  3. Create Calculated Columns
  4. Optimizing Data Models for Better Visuals
  5. Create Measures and Work with Time-Based Functions
  6. Create Calculated Tables
  7. Explore Time-Based Data
  8. Grouping
  9. Binning
  10. Hierarchies

Demo: Modeling Relationships Column by Example Conditional Columns, Groups, Hierarchies

Visualizations

  1. Overview
  2. Create and Customize Simple Visualization
    1. Numerical Fields
    2. Text Fields
    3. Geographic Fields
  3. Modify Colors Insert Static Objects, and Set Page Properties
  4. Styling with Shapes, Text Boxes, and Images
  5. Page Layout and Formatting
  6. Z-Order of Report Elements
  7. Customize Visuals with Summarizations
  8. How to:
    1. Use Combination Charts
    2. Manage Slicers and Sync Slicer
    3. Use Map Visualizations
    4. Implement Tables and Matrixes
    5. Apply Conditional Formatting
    6. Interpret Scatter Charts
    7. Work with Water & Funnel Chart
    8. Use Gauges and Single Number Cards
  9. Creating Complex Interactions Between Visuals
  10. Advance Concepts and New Features
    1. Decomposition Tree
    2. Key Influencers
    3. Insights
    4. Visual Hierarchies and drill-down behavior
    5. Custom Visualizations
    6. Drillthrough
    7. Analytics Pane
    8. Forecasting
    9. Tooltips
    10. Chiclet Slicer
    11. Hierarchy Slicer
    12. Synoptic Panel
  11. Other Powerful Custom Visualizes
    1. Pivot Slicer
    2. Smart Filter
    3. Hierarchy Filter
    4. Card Browser
    5. Visio Visual
    6. Infographic Designer
    7. D3JS Visualizer

Demo: Visualizations, Slicers, and Advanced Interactions

Publishing and Sharing

  1. Print and Export Power BI dashboards
  2. Creating Content Packs
  3. Publishing to Web
  4. Embed in SharePoint
  5. Export to PowerPoint
  6. Power BI Mobile
  7. Creating Workspaces in Power BI

Part 8: Exploring Data

  1. Overview
  2. Use Quick Insights
  3. Create and Configure a Dashboard
  4. Shared Dashboards with your Organization
  5. Display Visuals and Tiles Full-Screen
  6. Edit Tile Details
  7. Get More Space on Your Dashboard
  8. Ask Questions of your Data with Natural Language
    1. Custom Q&A suggestions
    2. Adding Q&A to a Report
    3. Adding a Q&A to a Report
    4. Q&A Tooling
    5. Review Questions
    6. Teach Q&A
    7. Manage Terms
    8. Data Sources for Q&A
    9. Bulk Synonyms
    10. Q&A Best Practices
  9. Bookmarks
  10. Themes

Demo: Quick sights

Demo: Q&A in Dashboards and Reports

Demo: Bookmarks

Administration & Security

  1. Securing Content in Power BI
    1. My workspace
    2. Sharing a Dashboard
    3. Sharing to Web
    4. Admin Access
  2. Row-level Security
  3. Permissions
  4. Defining and Creating toles within Power BI Desktop
  5. Row-Level Security
  6. Managing Data Capacity
  7. Subscriptions
  8. Resources

Introduction to DAX

  1. DAX Calculation Types
    1. Calculated Columns
    2. Calculated Measures
  2. DAX Functions
    1. Aggregation Functions
    2. Counting Functions
    3. Logical Functions
    4. Information Functions
    5. Text Functions
    6. Date Functions
  3. Using Variables in DAX Expressions
  4. Table Relationships in DAX
  5. DAX Tables and Filtering
  6. Quick Measures
  7. What-if Parameters
  8. Dynamic Labeling
  9. Resources

Demo: Quick Measures

Demo: What-if

Demo: Dynamic Labeling

Hands-on Lab Exercises:

  • Retail Sales Exercise
  • Retail Analysis – Overview
  • Retail Analysis – District Monthly Sales
  • Retail Analysis – New Stores
  • Customer Profitability Exercise
  • Customer Profitability – Team Scorecard
  • Customer Profitability – Industry Margin Analysis
  • Customer Profitability – Executive Scorecard
  • Opportunity Analysis: Exercise
  • Opportunity Analysis – Opportunity Count
  • Opportunity Analysis – Revenue Overview
  • Opportunity Analysis – Upcoming Opportunities
  • Opportunity Analysis – Region Stage Counts
  • Opportunity Analysis Data Model

Microsoft Power BI Boot Camp Reviews

Read More

Theodore Krol

Goal Oriented Human Performance Technology

Now that my career has progressed, Infosec Academy was the logical choice for the PMP certification boot camp. The material was expertly presented and I am confident I will be successful in attaining that certification.

Lonnie Fleming

NJVC

I love the Infosec Academy format which handles all of the logistics of the training and allowing the student to focus on the course material and certification test! Infosec Academy helped me to be successful, THE FIRST TIME, for both my PMP and CISSP.

JA

Northrop Grumman

The intent of the training was to help us pass the exam, and make us familiar with the material and types of questions. The instructor did a good job of getting us ready for the exam. I passed the exam!

Mark N

Booz Allen Hamilton

I left the class with a new-found confidence.

TS

Comcast

I believe self-study would have been much much harder to comprehend the information and pass the test on a first try. My colleagues who self-studied flunked the first time they took it. I passed the first time after attending the boot camp.

Need Help Finding The Right Training Solution?

Learn More about our Team Training Options
ill-7

Volume Microsoft Power BI Boot Camp Attendee Pricing

Private training is specifically designed for group training and provides an average price savings of up to 40% compared to individual training.
ill-7

Custom Training Options

Training programs can be tailored to meet the project needs and requirements of your team.
ill-7

Convenient options — either in-person, online, or on-site

Infosec Academy offers flexible solutions for today’s learning environment. Our programs can scale to any format, whether your team is local or spread out across the globe.
ill-7

Dedicated exam scheduling assistance

As our partner, you will have a dedicated support from our team to ensure your exam scheduling works for you.

Microsoft Power BI Training, Together

Fill out a contact form and one of our Enterprise Solutions experts will contact you to discuss the best training solutions for your team. You can also e-mail our team directly at: [email protected]

Get Pricing & Schedule

Microsoft Power BI Resources

Microsoft Power BI Boot Camp Related Courses

View All Courses

Featured on