Power BI - Live online training

Power BI Training Highlight

Instructor Led Live Training

Join our Instructor Led Live Training and gain valuable knowledge from industry experts in a dynamic and interactive learning environment.

Live Doubt clearing Session

Attend our Live Doubt Clearing Session to receive prompt answers to your questions from our experienced educators.

Lifetime Access to Recorded Video Lectures

Get unlimited access to our recorded video lectures for a lifetime, empowering you to learn on your schedule, anytime.

Offline Revision Facility

Benefit from our offline revision facility, allowing you to access course materials even without an internet connection, ensuring uninterrupted learning.

Lifetime Login Access to Student Panel

Enjoy the convenience of lifetime login access to your personalized student dashboard, enabling you to track progress and access resources.

Study Material, Assignments & Projects

Access comprehensive study material, engaging assignments, and exciting projects to enhance your learning experience and apply your knowledge effectively.

Course Summary

About Course

Power BI is a business intelligence and data visualization application that transforms information from many data sources into interactive dashboards and reports. Power BI desktop, Power BI service based on SaaS, and mobile Power BI apps accessible for various platforms are all part of the Power BI package, which offers a variety of products, connectors, and services. Business customers utilize this group of services to gather data and create BI reports.

Reports are created using the Power BI desktop programme, published using the Power BI Services (Software as a Service - SaaS), and viewed using the Power BI mobile app.

Topics Include

  • Introduction to Business Intelligence
    • Introduction to Tools and Terminology
    • Overview of Dashboard
    • Data Visualization & Reporting
    • Business Intelligence (BI), Traditional BI, Self-Serviced BI
    • Power BI Desktop (Power Query, Power Pivot, Power View)
    • Power BI Report Server, Power BI Service, Power BI Mobile Flow
    • Work in Power BI / Power BI Architecture.
  • Basics of Excel and Database(Microsoft SQL Server)
    • Basics of Excel
    • Basics of SQL Server
    • Data from multiple Data Sources
  • Power Query
    • Data Transformation, Benefits of Data Transformation
    • Overview of Power Query / Query Editor, Query Editor User Interface
    • Ribbon (Home, Transform, Add Column, View Tabs)
    • The Data View / Results Pane, The Query Settings Pane, Formula Bar.
    • Data types, changing the Data type of a Column Filter.
    • Auto Filter / Basic Filtering
    • PIVOT, UNPIVOT Columns
    • Transpose Columns
    • Header Row or Use First Row as Headers
    • Group Rows / Group By
  • M Language
    • IF and ELSE Conditions, Transform Column () Types
    • Remove Columns (), Split Columns (),Replace Value()
    • Distinct Options and GROUP BY Options Table
    • Group (), Table. Sort () with Type Conversions PIVOT
    • Operation and Table. Pivot (). List Functions
    • Parameters with M Language.
  • Data Modeling
    • Data Modeling Introduction
    • Relationship, Need of Relationship
    • One-to-One, One-to-Many (or Many-to-One), Many-to-Many.
    • AutoDetect the relationship, Create a new relationship, Edit existing relationships
    • Make Relationship Active or Inactive.
  • DAX
    • What is DAX, Calculated Column, Measures
    • DAX Table and Column Name Syntax
    • Creating Calculated Columns, Creating Measures Calculated.
    • DAX Syntax & Operators
    • DAX Operators
  • DAX Function
    • Date and Time Functions
    • Logical Functions
    • Math & Statistical Functions
    • Filter Functions
  • Date and Time Functions
    • YEAR, MONTH, DAY
    • WEEKDAY, WEEKNUM
    • FORMAT (Text Function) à Month Name, Weekday Name
    • DATE, TODAY, NOW
    • HOUR, MINUTE, SECOND, TIME
    • DATEDIFF, CALENDAR
  • Text Functions
    • LEN, CONCATENATE
    • LEFT, RIGHT, MID UPPER
    • LOWER
    • TRIM, SUBSTITUTE, BLANK
  • Logical Functions
    • IF
    • TRUE, FALSE NOT
    • OR, IN, AND
    • IFERROR SWITCH
  • Visualizations
    • Visualizing Data, Why Visualizations
    • Visualization types, Create and Format Bar and Column Charts
    • Create and Format Stacked Bar Chart Stacked Column Chart Create
    • Create and Format Scatter Charts
    • Create and Format Table Visual, Matrix Visualization
    • Create and Format Line Chart, Area Chart, Stacked Area Chart
    • Create and Format Line and Stacked Column Chart, Line and Clustered Column Chart
Course Duration: 45 days

Meet Our Instructors

How will you get your certificate?

CAD DESK is a pioneer in CAD/CAM/CAE training and most of the industries give great recognition to its certificate throughout India and abroad. CAD DESK Certificates are ISO verified which makes it highly reputed comparing to the other local brands and helps the student get prioritize while going for job opportunities in the industry. CAD DESK Online Software Training is conducted by highly knowledgeable trainers which helps students to enhance their skill set by putting great emphasizes on project-based learning. After the successful completion of the course, students can get their certificates by logging into their dashboard, which makes the certificates completely secure and authorized.

search_plus

Reviews from students

Training highlights Course Highlights Training certificate Course Summary Projects
×