Power BI - Live online training

Training Highlights

Instructor Led Live Training

Live Doubt clearing Session

Lifetime Access to Recorded Video Lectures

Offline Revision Facility

Lifetime Login Access to Student Dashboard

Study Material, Assignments & Projects

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

Commonly Asked Questions

No such prerequisite, however a basic knowledge to the subject is preferable.

The training mode is Instructor led online training. You have the facility to watch the recorded daily lectures anytime.

No worry. You will get recorded lectures on the mobile/web application, which you can download and see it later.

You can search CAD DESK at Google play store or IOS App store. Else you can download using the link here https://play.google.com/store/apps/details?id=co.thor.dntfq

The batch start dates are mentioned with every course module. You can select the preferred start date at the time of registration.

Training timings have been mentioned along with the training start date. Everyday recorded lectures can be watched as per your suitability and your learning pace.

You shall get the assignment and tests on the App/Web interface. You can upload you test from there.

The average lecture duration shall be average 1hour, however you may required another 1 hour to for practice at home.

There shall be a doubt solving session at the end of everyday class. You may discuss your doubts with the trainer then.

Yes, the study material is inclusive in the course. You will have lifetime access for training material (Study material, practice book, tutorials, quizzes) from your login access.

There is no such procedure although you may be allowed to reschedule the batch or shifting of course on request.

You may join the next batch on a request made at training.online@caddeskindia.com

Yes, it can be arranged for individual or a set of people. The pricing and other terms shall be different as mentioned here.

You don’t require to purchase the software. On registration, we shall send the link of the official software website and you can download the trial software from there.

You can download CADDESK App on mobile where join live classes or watch recorded videos. However, you require Laptop or desktop for the practice and assignments.

Any system with i3 and 2GB RAM and above shall work.

We will solve your problem if it is related to the software and we will give you the assistance for installation once only through the remote access.

You may try a different card or payment method. Even if the problem persists then you make the payment via a different link given here and send the details on WhatsApp at +91 7378123128. In the availability of such options, the candidate can make offline payment.

If done so then send us the complete details including payment proof at +917378123128. We would process the refund within a week period.

The certificate shall be provided in digital form once you complete the training. The certificate shall be displayed in you login after you complete the training. The physical certificate can be delivered in physical on request at certificate@caddeskindia.com on extra payment of Rs. 500/- (in India) and $20 + logistic charges for abroad.

Cad desk is pioneer in CAD CAM training and most of industries and Universities/college recognise its certificate by reputation, though I may depend on case to case basis. As off now there is not such authorising body in India for short term online courses so it all works on the virtue of reputation.

This is lifetime access to your login and all its benefits.

Definitely, CAD DESK being the leader in CAD, receives many opening on day to day basis, and registered students shall be able to access that information.

Apart from the best learning practice, the biggest advantage is the candidate can choose for offline doubt revision through any of 170 centers in India. The special coupon for offline training can get you a big discount on advanced courses.

To avail the weekly free training offer Sign up Now.