About Digital Lync

Digital Lync

Power BI Training

  • Get Certified at the Best Power Bi Training Institute.
  • Get trained by industry experts.
  • Power Bi Classroom and Online training.
  • 20+ Real-time projects
  • Real time projects, Interviews and Job Support
25000+ Students Enrolled
4.7 Rating (500) Ratings
45 Days Duration

Course Preview

Roles for Power Bi Course
  • Power Bi Engineer
  • Power Bi Architect
  • Technology Consultant ReactJs
  • Systems Engineer
  • System Administrator

Course Curriculum

It stretches your mind, think better and create even better.

Introduction to Excel

Customizing tabs, options in excel

Name managers

Data validation: Options in data validation for list, whole numbers, dates

Using name manager for data validation

Sorting

Custom sorting

Subtotals

Sorting left to right

Advanced sorting with multiple options

Advanced filter options

Sorting and filtering with color options

Pivot tables

Short cuts to create pivot tables

Changing row and column labels

Custom format tables and default tables

Changing number formats

Value field settings and summarizing values by 11 different options

Value field settings and showing values as different options

Grouping of continuous fields

Pivot charts, compared regular charts

Slicers, Slicer settings, advanced slicer

Calculated fields in pivot tables

Vlookup and Hlookup

Syntax for Vlookup

What-if there are errors

Vlookup with data validation

Approximation for Vlookup

Using column function for dynamic column numbers

Using Choose function to select a table for Vlookup

Using Match function to identify column number

Locking cells for absolute and relative cells

Formulae

Auto sum functions

Logical functions

Text functions

Date and Time functions

Lookup and reference functions

Information functions

Charts

Column charts

Line charts

Pie charts, Pie in pie and Bar of pie, Donut

Stacker bar and clustered bar charts

Area

Scatter charts

Radar charts

Tree maps

Histogram

Waterfall

Funnel

Combo

Conditional formatting

Duplicate values

Alternate rows

Multiple criteria

Negative numbers

Gantt charts and Formula

Advanced topics

What-if analysis

Text to columns

Flash fill

Remove duplicates, Consolidate

Grouping, ungrouping and sub-totals

Freezing and unfreezing panes

Intro

Connecting to database, basic transformation

Managing queries, splitting columns

Modifying data types

Dates

Re-ordering columns, conditional columns

Connecting to folders

Merge queries

Query dependency

Transform data

Enter data

Query parameter

Data modeling

Data relationships

Calculated columns

Quick measures

Optimize models

Calculated measures

Hierarchies

Calculated tables

Time intelligence

Insert new data tables

Include/Exclude

Grouping and Binning

Create and format visualizations

Hierarchical axis and concatenating

Filters

Combo charts

Forecasting

Clustering data

Slicers

Data behind visualization

Date slicers

Maps, ESRI maps

Tables and matrixes

Table style

Scatter charts

Waterfall and funnel charts

Gauge, cards and KPIs

Coloring charts

Shapes, grid lines, page settings

Duplicates, categories with no data

Aligning, hierarchies

Combo charts

Custom visual store

Date slicer

Waterfall and funnel charts

Grouping and binning

Map visualizations

Report measures

Tables and matrices

Turn off visual headers

Persistent filters

Sync slicers

Buttons

Custom date tables

Default summarization

Measure filtering

Upload an excel table

Excel data with BI content

Pinning excel tables

Analyze in excel

Workspaces

Overview of dashboards

Publish from Power BI

Get insights

Pinning on dashboards, dashboard tiles, display options

Adding widgets

Navigating content

Filter the list in navigating pane

Dashboard settings

Sharing, print and export dashboards

Focus mode

Export to csv or excel or ppt

Notifications, alerts

Subscriptions

Publishing

Intro

Syntax

Select

Distinct

Where

And Or Not

Order By

Insert into

Null values

Update

Delete

Top

Min and Max

Count, Avg, sum

Like

Wildcards

In

Between

Alias

Joins

Inner

Left

Right

Full

Self

Union

Group By

Having

Exists

Create table

Drop table

Alter table

Not null

Unique

Primary key

Default

Views

Operators

Power BI Real Time Projects

Project : 1

HR Analytics for Attrition Prediction using Logistic Regression

Employee Attrition is an important subject to gauge the satisfaction of the employee in a company. HR departments take various measures to arrest employee attrition. In this project we will use Logistic regression to predict who is the potential employee who is in a verge of leaving the company.


Skills Required for the project
Logistic Regression Sklearn Numpy Pandas Matplotlib Churn Analysis in Telecommunication
Author: Ravi Krishna Director: Manikanta Kona Duration: 3 Hours
Project : 2

Predicting Housing prices using Regression

Predict the sales price for each house based on input features provided for the house.


Skills Required for the project
Linear RegressionMulti Linear Regression Sklearn Pandas Numpy Matplotlib
Author: Anil Kumar Director: Ramesh Babu Duration: 3 Hours

Case Studies

Verizon implementation
Adobe

Adobe uses global cloud to create, deliver, and manage better digital experiences

Sales force implementation
GE HealthCare

GE Healthcare develops medical analytics solution in the cloud for better clinical outcomes

CERTIFICATION
Our training is based on latest cutting-edge infrastructure technology which makes you ready for the industry. Digital-Lync will Present this certificate to students or employee trainees upon successful completion of the course which will encourage and add to trainee’s resume to explore a lot of opportunities beyond position
CERTIFICATION

Power Bi Upcoming Batch Schedule

Week Day Batches
(Mon-Fri)
  • Week Day Batches 13th Dec 2021 Monday
  • Week Day Batches8 AM (IST) 1hr-1:30hr / Per Session
Get Course Fees
Week Day Batches
(Mon-Fri)
  • Week Day Batches 15th Dec 2021 Wednesday
  • Week Day Batches10 AM (IST) 1hr-1:30hr / Per Session
Get Course Fees
Week Day Batches
(Mon-Fri)
  • Week Day Batches 17th Dec 2021 Friday
  • Week Day Batches12 PM (IST) 1hr-1:30hr / Per Session
Get Course Fees
Week End Batches
(Sat-Sun)
  • Week Day Batches 18th and 19th Dec 2021 Sat-Sun
  • Week Day Batches8 AM (IST) 1hr-1:30hr / Per Session
Get Course Fees
AWS Upcoming Batch Schedule
Can’t find a batch you were looking for?
Request A Batch

Inspiring Student Stories.

Here are stories of real knowldege, real people,
under real innovation.

Have a Question?

we help you go farther than you ever dreamed, 24/7.
Have a Question
LIVE CHAT

LIVE CHAT

Locations

Come and chat with us about your goals over a cup of coffee
Locations
Gachibowli-Hyderabad

2nd floor, Khajaguda Main Road next to Andhra Bank, Khajaguda - Nanakramguda Rd, near DPS, Gachibowli, Hyderabad, Telangana 500008

Locations
USA

#23664, Richland Grove Dr, Ashburn, VA 20148

Call Us