Power BI

  • 4.5/5.0
  • 1000+ Enrolled
  • All levels
  • Last updated 1/2025
  • English

Course description

The Power BI course begins with an introduction to business intelligence and the role of Power BI in transforming raw data into meaningful insights. Participants will learn about the Power BI ecosystem, including Power BI Desktop, Power BI Service, and Power BI Mobile. The course covers topics such as data loading, data transformation, creating visualizations, and sharing reports. Practical examples, hands-on projects, and real-world scenarios will be used to reinforce theoretical concepts.

Prerequisites :
  • Basic understanding of data analysis concepts.
  • Familiarity with Microsoft Excel and its functions.
  • Knowledge of relational databases and SQL.
  • Understanding of data visualization principles.
  • Awareness of business intelligence (BI) concepts and tools.
  • Experience with basic data modeling and transformation techniques.
What you’ll learn

  • What is SQL?
  • What is Database?
  • Difference between SQL and Database
  • Types of SQL Commands
  • Relationships in SQL
  • Comments in SQL
  • Alias in SQL
  • Database Commands
  • Datatypes in SQL
  • Table Commands
  • Constraints in SQL
  • Operators in SQL
  • Clauses in SQL
  • Functions in SQL
  • JOINS
  • Set operators
  • Sub Queries
  • Views
  • Synonyms
  • Case Statements
  • Window Functions

  • Power BI Introduction
  • Power BI Desktop (Power Query, Power Pivot, Power View, Data Modelling)
  • Power BI Service
  • Flow of Work in Power BI
  • Power BI Architecture

  • Installation through Microsoft Store
  • Download and Installation of Power BI Desktop

  • Overview of Power Query Editor
  • Introduction of Power Query
  • UI of Power Query Editor
  • How to Open Power Query Editor
  • File Tab
  • Inbuilt Column Transformations
  • Inbuilt Row Transformations
  • Query Options
  • Home Tab Options
  • Transform Tab Options
  • Add Column Tab
  • Combine Queries (Merge and Append Queries)
  • View Tab Options
  • Tools Tab Options
  • Help Tab Options
  • Filters in Power Query

  • What is InMemory Columnar database and advantages
  • What is Traditional database
  • Difference between InMemory Columnar database and Traditional database
  • xVelocity In-memory Analytics Engine (Vertipaq Engine)
  • Data Connectivity modes in Power BI
  • What is Data Modelling?
  • What are a Relationships?
  • Types of Relationships/Cardinalities
  • One-to-One, One-to-many, Many-to-One, Many-to-Many
  • Why do we need a Relationship?
  • How to create a relationship in Power BI
  • Edit existing relationship
  • Delete relationship
  • AutoDetect Relationship
  • Make Relationship Active or Inactive
  • Cross filter direction (Single, Both)
  • Assume Referential Integrity
  • Apply Security Filter in Both Directions
  • Dimension Column, Fact Column.
  • Dimension table, Fact Table
  • What is Schema?
  • Types of Schemas and Advantages

  • What is DAX (Data Analytical Expression)
  • Basic Syntax of DAX
  • Difference between New Column, New Measure and New Table
  • Types of Operators in DAX
  • DAX Functions – 138
    • Text Functions – 15
    • Parent Child Functions – 5
    • Numeric/Stats/Maths/Trig/Financial Functions - 21
    • Aggregate Functions – 10
    • Count Functions – 6
    • Date and Time Functions – 20
    • Time Intelligence Functions – 21
    • Relationship Functions – 4
    • Filter Functions – 7
    • Information Functions – 11
    • Logical Functions – 5
    • Table Manipulation functions – 13

  • Introduction to Power View
  • What and why Visualizations?
  • UI of Report View/Power View
  • Difference between Numeric data, Categorical data, Series of data
  • Difference between Quantitative data and Qualitative data
  • Categorical data Visuals
  • Numeric and Series of Data
  • Tabular Data
  • Geographical Data
  • KPI Data
  • Filtering data
  • Filters in Power View
  • Drill Reports
  • Visual Interactions
  • Grouping
  • Sorting
  • Bookmarks in Power BI
  • Selection Pane in Power BI
  • Buttons in Power BI
  • Tooltips

  • Power BI Architecture
  • How to Sign into Power BI Service account
  • Power Bi Licences (Pro & Premium Licences)
  • Team Collaboration in Power BI using Workspace
  • Sharing Power BI Content using Basic Sharing, Content Packs and Apps
  • Refreshing the Data Source
  • Deployment Pipelines
  • Row Level Security (RLS)
Enroll now
FAQ's
Power BI Desktop is a free application used for creating, analyzing, and visualizing data reports on your local computer. Power BI Service is a cloud-based platform where you can publish, share, and collaborate on those reports online. Desktop is for development; Service is for sharing and collaboration. Both tools work together to provide a complete data analysis and reporting solution.
Yes, Power BI supports connecting to multiple data sources simultaneously. You can integrate data from various platforms such as Excel, SQL Server, SharePoint, cloud services, and many others within a single report. This allows users to create unified dashboards and perform advanced data modeling across different data sets. The ability to combine diverse sources makes Power BI highly effective for comprehensive data analysis and decision-making.
Yes, in this course you will learn how to create interactive dashboards using Power BI. The training covers designing visually appealing reports with slicers, filters, and drill-through features to enhance user interaction. You’ll gain hands-on experience in building dashboards that provide real-time insights and support informed decision-making. By the end of the course, you’ll be able to develop professional-level dashboards tailored to business needs.
No, prior knowledge of Excel or SQL is not mandatory to start Power BI training. The course is designed for beginners and covers all foundational concepts from scratch. However, having basic familiarity with Excel formulas or data handling can be helpful for faster understanding. SQL knowledge can be an advantage but is not required to learn and use Power BI effectively.
You can become proficient in Power BI within 4 to 6 weeks with our structured course, depending on your learning pace and practice. The course is designed with hands-on projects and real-world scenarios to build your skills gradually. Regular practice and application of concepts will help you gain confidence in using Power BI for data analysis and reporting.

Course Information

  • Course Name Looker BI
  • Lectures 30
  • Duration 4h 50m
  • Level Beginner to Expert
  • Course Type Online/Offline
  • Language English
  • Faculty / Exp Keshav / 5yrs
  • Certificate Yes
Enroll a free demo class now

Our Courses