Power BI

In this course, we will guide you through the comprehensive landscape of Power BI, starting from the basics and gradually progressing to advanced techniques. Whether you’re a beginner seeking to grasp the fundamentals or an experienced user aiming to refine your skills, this course is tailored to meet your learning needs.

Our journey begins with an exploration of Power BI’s intuitive interface, where you’ll learn to connect to various data sources, transform and clean your data, and create visually compelling reports and dashboards. We’ll dive into the world of data modeling, helping you understand how to design robust data models that lay the foundation for meaningful analysis.

As we advance, we’ll delve into DAX (Data Analysis Expressions), a powerful formula language used in Power BI, enabling you to create sophisticated calculations and metrics. You’ll discover how to leverage Power BI’s capabilities to derive insights, make data-driven decisions, and present your findings in a compelling and accessible manner.

Throughout the course, hands-on exercises and real-world scenarios will reinforce your learning, ensuring that you gain practical skills that can be immediately applied in professional settings. Whether you’re a business analyst, data professional, or decision-maker, the Power BI Syllabus Course aims to equip you with the knowledge and proficiency to navigate the world of business intelligence confidently.

Get ready to transform your data into actionable intelligence, visualize trends, and uncover hidden insights. Join us on this journey, and let’s unlock the full potential of Power BI together.

Power BI Syllabus

  • Module 1: Introduction to Power BI (Duration-5hrs)
    Get Started with Power BI
    Overview: Power BI concepts
    Sign up for Power BI
    Overview: Power BI data sources
    Connect to a SaaS solution
    Upload a local CSV file
    Connect to Excel data that can be refreshed
    Connect to a sample
    Create a Report with Visualizations
    Explore the Power BI portal
    Module 2: Viz and Tiles (Duration-5hrs)
    Overview: Visualizations
    Using visualizations
    Create a new report
    Create and arrange visualizations
    Format a visualization
    Create chart visualizations
    Use text, map, and gauge visualizations and save a report
    Use a slicer to filter visualizations
    Sort, copy, and paste visualizations
    Download and use a custom visual from the gallery
    Module 3: Reports and Dashboards (Duration-10hrs)
    Modify and Print a Report
    Rename and delete report pages
    Add a filter to a page or report
    Set visualization interactions
    Print a report page
    Send a report to PowerPoint
    Create a Dashboard
    Create and manage dashboards
    Pin a report tile to a dashboard
    Pin a live report page to a dashboard
    Pin a tile from another dashboard
    Pin an Excel element to a dashboard
    Manage pinned elements in Excel
    Add a tile to a dashboard
    Build a dashboard with Quick Insights
    Set a Featured (default) dashboard
    Ask Questions about Your Data
    Ask a question with Power BI Q&A
    Tweak your dataset for Q&A
    Enable Cortana for Power BI
    Module 4: Publishing Workbooks and Workspace (Duration-5hrs)
    Share Data with Colleagues and Others
    Publish a report to the web
    Manage published reports
    Share a dashboard
    Create an app workspace and add users
    Use an app workspace
    Publish an app
    Create a QR code to share a tile
    Embed a report in SharePoint Online
    Module 5: Other Power BI Components and Table Relationship (Duration-5hrs)
    Use Power BI Mobile Apps
    Get Power BI for mobile
    View reports and dashboards in the iPad app
    Use workspaces in the mobile app
    Sharing from Power BI Mobile
    Use Power BI Desktop
    Install and launch Power BI Desktop
    Get data
    Reduce data
    Transform data
    Relate tables
    Get Power BI Desktop data with the Power BI service
    Export a report from Power BI service to Desktop
    Module 6: DAX functions (Duration-5hrs)
    New Dax functions
    Date and time functions
    Time intelligence functions
    Filter functions
    Information functions
    Logical functions
    Math & trig functions
    Parent and child functions
    Text functions