Certified Online Training
Power BI
Turn multiple unrelated data sources into valuable and interactive insights
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
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.
Reviews from students
M S Narendran
Cad desk is one of the best institutes for CAD software....I’m enjoying my online classes. The trainer was experienced and good. The manner in which he taught us is superb. So overall the cad desk i..
Vani G C
I have done my summer training with CAD DESK and Seriously it was great, I enjoyed my training and learned more than I expected...
Sai Varishtha Reddy
CAD DESK is a very good institute. I have learnt AutoCAD, Solidworks, CATIA and ANSYS from this institute. The training quality is amazing. I am fully satisfied with the services they provided me, wh..
Disha Mathur
I did the CAD course from CAD DESK and it gave me amazing experience...faculties are very helpful and they helped me to achieve my goals. Proper guidance and placements are also available which helps ..
Govind Sundesha
I have learned a CAD course from CAD DESK and got comfortable experience with the faculty because they are very supportive and hardworking. Overall I am satisfied with training...
Khatri A R
I have learned AutoCAD and REVIT Architecture, my experience is so good. Thanks to CAD DESK, for giving me best course material.........so guys join CAD DESK and achieve your goals...
Gulshan Sharma
CAD DESK is best CAD institute there are many CAD courses. My overall experience was good. I recommended CAD DESK to others for CAD courses...
B. Dileep Kumar
CAD DESK is best institute for CAD/CAM/CAE training. My overall experience was good. I recommended CAD DESK to others for CAD/CAM/CAE courses...
Ranjan Kumar
CAD DESK is one of the best institutes for CAD courses....I’m enjoying my online classes. The trainer was experienced and good. The manner in which he taught us is superb. So overall CAD DESK is the..
Ankit Tiwari
I have done my summer training with CAD DESK and Seriously it was awesome, facilities are good, awesome atmosphere. Good course content, study material, and highly experienced trainers...