Power BI - Online Program

Visit Us : www.fandsindia.com

Follow us on LinkedIn

Top Trending Trainings from Fands

DevOps -

DevOps with different tools like Docker, Jenkins, Golang, Kubernetes, Chef, Puppet, Ansible, GITHub, GitLab, Kotlin

Micro Services -

Developing micro services using Spring Boot and Spring cloud Netflix Eureka, Zuul and Ribbon etc.

Different JavaScripts and Frameworks -

AngularJS/Angular, Mean, ExtJS, Durandal , Knockout, ReactJS, BackboneJS.

Cloud -

Cloud Primer / Essentials and advance administration and deployment on major cloud platforms namely AWS, Google Cloud Platform, Azure, Oracle etc.

Big Data and Analytics -

Big data & Hadoop, Pig, Hive, Sqoop, Splunk, MongoDB, R Programming, SAS.

IoT, Machine Learning and Artificial Intelligence -

Raspberry PI, Arduino, different protocol implementations for CoAP, MQTT, AMQP, Deep Learning, Business Analysis.

Glimpse of Fands

  • 21 years of success in IT and ITES industry and still moving ahead.
  • Served 500+ customers pan India.
  • We follow the principle ‘Think Global Act Local’.
  • Trainers with 20+ years of experience in corporate sector.
  • ‘One Stop Training Solutions’ for your training queries.
  • PAN India presence with set ups in Pune, Hyderabad, Bengaluru & Mumbai.
About the Instructor

Fands Certified Corporate Trainer

The trainer has over 10 years of Corporate Training experience in Data Visualization, Dashboard, Reporting, Self Service Business Intelligence (BI), Key Performance Indicators (KPI). He has been training and consulting across skills which include Tableau, Power BI, Alteryx, Google Looker, Yellowfin BI, QlikView Designer. He has delivered training for SAAMA, ROLL’S ROYCE, VOLKSWAGEN, Laures Solution, BOSCH, Harman, ABP Network, Bharat Serums. CAVOTEC. Participants who have attended his training participants have rated his/her training very high and they come back asking for more.

Workshop Objective
  • Design impactful projection.
  • Comparing with other BI Tools.
  • Hands on practice.
Workshop Contents

1. Introduction to Power BI

  • Connecting to Database.
  • Different Products of Power BI.
  • What is Power BI.

2. Introduction to Power Query

  • Import from Excel file, Csv, Text Files.
  • Import from Web, PDF, Exchange.
  • Loading from Power Query back to Excel sheet.
  • Import from MS Access & PDF

3. Power Query - Data Transformation

  • Text Functions.
  • Number Functions.
  • Empty / duplicate rows, filter rows.
  • Perform Arithmetic

4. Power Query - Multiple Sources

  • No Manual Process.
  • Duplicate/reference a Power Query.
  • Sharing files.

5. Charts

  • Column, Bar & Pie.
  • Heat Map & Tree Map.
  • Drill down Charts.
  • Clustered Column & Bar.
  • Sunburst
  • Waterfall
  • Scatter
  • Combo
  • Dual Axis
  • Map Chart
  • Geographical Chart

6. Starting with 99 Functions (Text, Date, Number)

  • Text Functions - Upper, Lower, Proper, Left, Right, Trim Text Functions - Concatenate, Split, Suffix, Prefix.
  • Extract Text Using Delimiter, First, Last, Mid.
  • Working with Date functions.

7. Appending Clean Data in Power Query

  • Append Multiple CSV files from a folder in 3 clicks.

8. Case Study

Date : 16 & 23 July 2022

Time : 2:00 PM To 6.00 PM

Last date for Registration : 13th July 2022

Fees & Registration : Rs. 6,000/- plus Tax per participant inclusive of course material payable by cheque in favor of ‘Fands Infonet Pvt. Ltd.'

Group Discount : 5% will be applicable to group of 3 and 7.5% for group of 5 or more participants.

Early Bird Discount : Pay by 1st July 2022 and get 5% discount.

For more details contact Ms. Natasha Deokule on
Mobile : +91 9823509442
Mail : natasha@fandsindia.com

Offices in Pune, Mumbai, Hyderabad.
Redg. off. :- 1, "Sheshadri" 1, Rambaug Colony, Opp. Rupee Bank, Paud Rd. Pune - 411038, India.