Book An Appointment

Microsoft 365 Power BI Report Builder Boot camp

  • Master Power BI Reporting Tools

  • Develop dynamic, data-driven reports with ease and expert guidance.

    • What you'll learn

    • Building and customizing reports efficiently
    • Data visualization best practices
    • Power BI integration with Microsoft 365 tools
    • Creating interactive dashboardsx
    • Data modeling techniques
    • Advanced Data Analysis
    • Sharing reports securely
    • Real-time data connection
    • Optimizing report performance
    • Automating report updates

    Course content

    • Downloading and installing App
      a. Accessing Power BI services
      b. Understanding Data Files
      c. Loading Data Files to Power BI"
    • Basics of Export Builder
      a. Exploring Reports
      b. Row ,Column Groups
      c. Publishing Reports to Service
      d. Reports Planning
    • Data Sources and Semantic Models
      a. Intro to Workspaces
      b. loading Data
      c. Creating Data Source
      d. Dataset Properties
      e. Dataset Filters
    • Data from External Sources
      a. Importing excel ,test and other Data Source
      b. Data From SQL Server
      c. Intro to SQL Server (Basic)
    • Parameters
      a. Introduction to parameters
      b. Controlling Chart Colors with a Parameter
      c. Controlling Rows per Page with a Parameter
      d. Filtering a Dataset with Parameters
      e. Using Multi-value Parameters
    • Expressions Mid Understanding Check Assessment
      a. Understanding Expression b. Using Built in Fields c. object oriented Expressions
      d. Expression Builder
      e. Reports with Expression
      f. Conditional formatting with IIF
      g. Applying Conditional Formatting with SWITCH
      Alternating Colors by Row Using Expressions in a Chart Applying TOP N Filter Expressions Calculating Running Totals
    • Export Paginated Reports
      Understanding Workspaces
      Sharing Reports Using
      Understanding Export Options
      Using Deployment Pipelines
    • Report Layout and Rendering
      Creating a Table with Row Groups with the Wizard
      Editing the Settings Produced by the Wizard
      Sorting Data within a Tablix
      Creating a Table with Row Groups Manually
    • Paginated Report and Accessibility
      Creating a Matrix with the Wizard
      Formatting a Matrix Report
      Understanding Data Regions
      Creating a Table Report Manually
      Creating a Table Report with the Wizard
      Formatting a Report
    • Maps in Paginated Reports
      Creating a Basic Map
      Completing a Map
      Creating a Color Analytical Map
      Creating a Bubble Map
      Creating a Map with ESRI Shapes
    • Headers and Footers in Paginated Reports
      Headers and Footers Repeating Column Headings
    • Visualizations
      Adding a Pie Chart
      Bar And Line Charts
      Scatter Charts
      Map Chart
      Gauge
      Sparkline
      KPI
      Creating Charts Using the Wizard (Column Chart)
      Creating Charts Manually (Bar Chart)
      Modifying Charts
      Creating a Donut Chart
      Creating a Funnel Chart
      Creating a Tree Map
      Creating a Sunburst Chart
      Creating a Line Chart
      Creating a Stacked Area Chart
      Creating a Scatter Plot
    • Filter, Group and Sort Data in Paginated Reports
      Examining Functions
      Reviewing Operator
      Creating Expressions on Field Values
      Group Expressions
      Creating Expressions on Date Values
      Grouping Data with a Hierarchy
      Leveraging Group Headers and Footers
      Interactive Sorting
      Adding Interactive Hierarchies
      Applying Interactive Filtering
      Adding Bookmarks for Navigation
      Creating a Document Map or Table of Contents
    • Drillthrough Paginated reports
      Creating a Matrix with the Wizard
      Formatting a Matrix Report
      Understanding Data Regions
      Creating a Table Report Manually
      Creating a Table Report with the Wizard
      Formatting a Report
    • Design Paginated Reports
      Branding with Logos
      Page Setup
      Test Print Layout
    • Paginated Reports in the Service
      Publish to a Workspace
      Scheduled Report Email
    • Wrapping Up
    • Final Assessment
    • Post Assesment Review and Continious learning

    Requirements

    • You don't need a license to download Power BI Report Builder from the Microsoft Download Center for free.
    • Demo Data will be provided for training

    Description

    The Microsoft 365 Power BI Report Builder Bootcamp is designed to equip participants with the essential skills needed to create, customize, and optimize reports using Power BI. Throughout the course, you will learn to build comprehensive reports and dashboards that effectively communicate data insights and support strategic decision-making. The bootcamp covers data modeling, integration with Microsoft 365 tools, and techniques to enhance report performance. Whether you’re a beginner or an intermediate user, this course ensures that you develop a thorough understanding of Power BI’s functionalities. Our expert-led sessions focus on hands-on learning, providing practical exercises and real-world scenarios. By the end of the bootcamp, participants will be well-versed in creating interactive, real-time dashboards, automating report updates, and connecting to live data sources. Additionally, you’ll learn best practices for data visualization and secure report sharing, making it easier to collaborate with team members. This training empowers you to confidently handle data analysis, turning complex datasets into actionable insights that propel your business forward.

    Search

    Our Services

    +44 7436353049

    support@aitransformers.org

    Contact Us Contact Us
    wpChatIcon
    wpChatIcon