Team Academy/Microsoft Fabric - Data Engineering & Analytics Professional

  • $495

Microsoft Fabric - Data Engineering & Analytics Professional

Includes 7 Case studies & CPD Accredited Certification

100 % Instructor Guided Training Program
Apply Power BI in the Business Lifecycle
Explore Real-World Power BI Case Studies in Business and Data Analysis

Target Audience

  • Data Analysts

  • Data Engineers

  • Analytics Engineers

  • Data Architects

  • Business Intelligence Professionals

  • Data Administrators

  • IT Professionals Managing Data Solutions

  • Power BI Professionals

  • Microsoft Fabric Administrators

  • Data Governance & Compliance Professionals

  • Security & Access Control Specialists

  • Professionals Working with Data Warehouses, Lakehouses & Semantic Models

  • Performance Monitoring & Optimization Experts

  • Stakeholders Collaborating on Data Analytics & Engineering Solutions

Course Features

✅ Live Instructor Led Coaching Sessions : Via Zoom or Face to Face at Specific Locations.

✅ Lifetime E Learning Access: Enjoy unlimited access to all course Videos, including future updates, Along with Live Instructor Guided Workshops.

✅ Comprehensive Curriculum: From beginner to advanced topics, master every aspect of Data & Business Analysis in Power BI

✅ Real-World Projects: Work on hands-on projects that mimic real business challenges to build practical experience.

✅ Community Engagement: Join a network of learners and professionals to share insights and collaborate.

Mr.Dinesh R M - Microsoft Power BI Specialist

Program Mentor - Team Academy

Certified Microsoft Trainer

Specialized in Applying AI, Tech & Power BI For Enterprise Project & Portfolio Management, Enterprise Risk Management - ISO 31000, Enterprise Financial Modelling & Aviation Commercial Reporting

Authorized Training Partner Instructor - PMI

Microsoft Certified Trainer - PL 300 & Azure Open AI Services

CompTIA CTT+ Certified Trainer

Technical Certifications : PL-300, IBM - Gen AI, AI - 900, Design Thinking Practitioner

Leadership Accolades : MBA, PMP, ITIL,

Lesson Plan

Getting Started

Microsoft Fabric Program Brochure
    Preview
    View Trainer Profile
      Preview

      Get started with Microsoft Fabric

      Introduction to end-to-end analytics using Microsoft Fabric
        Understand data warehouse fundamentals
          Understand data warehouses in Fabric
            Data teams and Microsoft Fabric
              Enable Microsoft Fabric
                Fabric Lakehouse
                  OneLake
                    Data Factory
                      Data Flow – Gen 2
                        Understand Data pipelines
                          Real-Time Intelligence in Microsoft Fabric
                            Lab Exercise- Explore Real-Time Intelligence in Fabric
                              Power BI Workspace Administration– Modelling, Visualization & reporting
                                Data Activator – Real-time insights and automation
                                  Fabric Monitor hub
                                    Data Governance in Fabric with Purview Compliance Manager

                                      Ingest Data with Microsoft Fabric

                                      Ingest Data with Dataflows Gen2 in Microsoft Fabric
                                        Understand Dataflows Gen2 in Microsoft Fabric
                                          Explore Dataflows Gen2 in Microsoft Fabric
                                            Integrate Dataflows Gen2 and Pipelines in Microsoft Fabric
                                              Orchestrate Process and data movement
                                                Understand pipelines
                                                  Use the Copy Data activity
                                                    Use pipeline templates
                                                      Run and monitor pipelines

                                                        Implement a Data Warehouse with Microsoft Fabric

                                                        Get Started with data warehouses in Microsoft Fabric
                                                          Prepare data for analysis and reporting
                                                            Secure a Microsoft Fabric Data warehouse
                                                              Monitor a Microsoft Fabric Datawarehouse
                                                                Load data into Microsoft Fabric
                                                                  Query a data warehouse
                                                                    Explore data load strategies
                                                                      Use data pipelines to load a warehouse
                                                                        Load and transform data with Dataflow Gen2

                                                                          Implement a Lakehouse with Microsoft Fabric

                                                                          Get Started with Lakehouses in Microsoft Fabric
                                                                            Explore end to end analytics with Microsoft Fabric
                                                                              Work with Delta Lake tables in Microsoft Fabric
                                                                                Explore and transform data in a lakehouse
                                                                                  Organize a Fabric lakehouse using Medallion Architecture
                                                                                    Lab Exercise - Organize your Fabric lakehouse using a medallion architecture
                                                                                      Describe Medallion Architecture
                                                                                        Implement a Medallion Architecture in Fabric
                                                                                          Considerations for managing your lakehouse

                                                                                            Work with Semantic Models in Microsoft Fabric

                                                                                            Add measures to Power BI Desktop models
                                                                                              Create simple measures
                                                                                                Create compound measures
                                                                                                  Create quick measures
                                                                                                    Compare calculated columns with measures
                                                                                                      Design scalable semantic models
                                                                                                        Lab Exercise - Design a scalable semantic model
                                                                                                          Choose the best storage mode
                                                                                                            Configure semantic models for large data
                                                                                                              Work with relationships
                                                                                                                Write DAX for readability with complex calculations
                                                                                                                  Lab Exercise - Create DAX Calculations in Power BI Desktop
                                                                                                                    Create dynamic calculation elements
                                                                                                                      Optimize a model for performance in Power BI
                                                                                                                        Use variables to improve performance and troubleshooting
                                                                                                                          Reduce cardinality
                                                                                                                            Optimize DirectQuery models with table-level storage
                                                                                                                              Create and manage aggregations
                                                                                                                                Create and manage Power BI assets
                                                                                                                                  Create reusable Power BI assets
                                                                                                                                    Manage development lifecycle for Power BI assets
                                                                                                                                      Use lineage view and endorse data assets
                                                                                                                                        Manage a Power BI semantic model using XMLA endpoint
                                                                                                                                          Enforce Power BI model security
                                                                                                                                            Lab Exercise: Enforce model security
                                                                                                                                              Restrict access to Power BI model data
                                                                                                                                                Restrict access to Power BI model objects
                                                                                                                                                  Apply good modeling practices
                                                                                                                                                    Work with Power BI Workspace and Co-Pilot
                                                                                                                                                      Manage Power BI workspaces
                                                                                                                                                        Collaborate using Power BI shared datasets
                                                                                                                                                          Enhancing Reports with Copilot

                                                                                                                                                            Implement Real-Time Intelligence with Microsoft Fabric

                                                                                                                                                            Get Started with Real - Time Intelligence
                                                                                                                                                              What is real-time data analytics?
                                                                                                                                                                Real-Time Intelligence in Microsoft Fabric
                                                                                                                                                                  Ingest and transform real-time data
                                                                                                                                                                    Store and query real-time data
                                                                                                                                                                      Visualize real-time data
                                                                                                                                                                        Automate actions
                                                                                                                                                                          Work with Real -Time data in a Microsoft Fabric Eventhouse
                                                                                                                                                                            Get started with an eventhouse
                                                                                                                                                                              Materialized views and stored functions
                                                                                                                                                                                Use Real -Time Eventstreams
                                                                                                                                                                                  Components of eventstreams
                                                                                                                                                                                    Eventstream sources and destinations
                                                                                                                                                                                      Eventstream transformations
                                                                                                                                                                                        Create Real Time Dashboards
                                                                                                                                                                                          Get started with real-time dashboards
                                                                                                                                                                                            Lab Exercise - Get started with Real-Time Dashboards in Microsoft Fabric-
                                                                                                                                                                                              Advanced features
                                                                                                                                                                                                Real-Time Dashboard best practices

                                                                                                                                                                                                  Administer and Govern Microsoft Fabric

                                                                                                                                                                                                  Administer a Microsoft Fabric environment
                                                                                                                                                                                                    Understand the Fabric Architecture
                                                                                                                                                                                                      Understand the Fabric administrator role
                                                                                                                                                                                                        Manage Fabric security
                                                                                                                                                                                                          Govern data in Fabric
                                                                                                                                                                                                            Secure data access in Microsoft Fabric
                                                                                                                                                                                                              Lab Exercise - Secure data access in Microsoft Fabric
                                                                                                                                                                                                                Understand the Fabric security model
                                                                                                                                                                                                                  Configure workspace and item permissions
                                                                                                                                                                                                                    Secure a Microsoft Fabric data warehouse
                                                                                                                                                                                                                      Lab Exercise - Secure a warehouse in Microsoft Fabric
                                                                                                                                                                                                                        Explore dynamic data masking
                                                                                                                                                                                                                          Implement row-level security
                                                                                                                                                                                                                            Implement column-level security
                                                                                                                                                                                                                              Govern data in Microsoft Fabric with Purview
                                                                                                                                                                                                                                Govern data in Microsoft Fabric
                                                                                                                                                                                                                                  Why use Microsoft Purview with Microsoft Fabric?
                                                                                                                                                                                                                                    Govern data in the Microsoft Purview hub

                                                                                                                                                                                                                                      Manage & Monitor Microsoft Fabric Evironment

                                                                                                                                                                                                                                      Manage a Microsoft Fabric Environment
                                                                                                                                                                                                                                        Monitor activities in Microsoft Fabric
                                                                                                                                                                                                                                          Understand monitoring
                                                                                                                                                                                                                                            Use Microsoft Fabric Monitor Hub
                                                                                                                                                                                                                                              Take action with Microsoft Fabric Activator

                                                                                                                                                                                                                                                Power BI FAQs

                                                                                                                                                                                                                                                Is this program 100 % Instructor Guided ?

                                                                                                                                                                                                                                                Yes, the Power BI program is fully guided by Microsoft Certified Instructors with more than 15 years of experience in Business Intelligence and Data Analytics. All our sessions are conducted via Online Video Conferencing Platforms, offering an immersive learning experience. Upon enrollment, students are granted a 120-day access pass to attend any scheduled program. Additionally, participants receive instant and lifelong access to our Learning Management System (LMS) for ongoing education and resource access.

                                                                                                                                                                                                                                                How do i find out the schedule for this program

                                                                                                                                                                                                                                                The course schedule is prominently displayed in the designated section above, carefully adjusted to your local time zone. You can easily navigate the calendar to find the specific dates and times for the program offerings. Should you have any inquiries or require further details, our course counselors are always available to assist. Feel free to reach out to us through the "Contact Us" link provided.

                                                                                                                                                                                                                                                How do I apply for my Power BI Certification Exam?

                                                                                                                                                                                                                                                Our course counselors are dedicated to making the exam application process as seamless as possible for you. By purchasing the Power BI Certification Exam Voucher through us, you can focus on your studies while we handle the administrative details of your exam application. This arrangement ensures that you can concentrate on mastering Power BI with the peace of mind that the logistical aspects are taken care of.

                                                                                                                                                                                                                                                What is LMS & What does it contain?

                                                                                                                                                                                                                                                The Learning Management System (LMS) is a comprehensive platform where students can access course materials, study guides, sample Power BI dashboards, and recorded video lectures. We offer instant and lifelong access to our LMS, which is loaded with valuable resources including powerful pre-built dashboards and extensive data sets for practice, ensuring a rich learning experience in data visualization and business analytics.

                                                                                                                                                                                                                                                How does this program prepare me for real-world Power BI applications?

                                                                                                                                                                                                                                                Our Power BI program is designed with a strong emphasis on practical, hands-on learning. Through project-based assignments, case studies, and real-world scenarios, participants develop their skills in creating dynamic reports and dashboards, data modeling, and data analysis using Power BI. This approach ensures that graduates are well-prepared to apply Power BI tools effectively in their professional roles, making data-driven decisions with confidence.

                                                                                                                                                                                                                                                Can I access Power BI tools and software through the program?

                                                                                                                                                                                                                                                Yes, participants in our Power BI program will have access to the latest Power BI tools and software. Our LMS provides comprehensive tutorials and resources on utilizing these tools for creating advanced reports, performing data analysis, and sharing insights across organizations. This access is designed to ensure that participants are proficient in using Power BI for a wide range of business intelligence tasks.

                                                                                                                                                                                                                                                What support services are available to participants?

                                                                                                                                                                                                                                                We offer extensive support services to ensure your success throughout the Power BI program. This includes access to our course counselors for any administrative questions, technical support for navigating the LMS or troubleshooting Power BI tools, and academic assistance from our expert instructors. Our community forums also provide a vibrant space for participants to connect, share experiences, and collaborate on Power BI projects, fostering a supportive learning environment.