Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js HTML5 PHP Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel

Power BI for Excel Users - Work Smarter, Grow Faster

Learn Power BI using your Excel knowledge. Fast, in-depth, practical, useful. No tips & tricks. Pure Empowerment.
Rating: 4.5 out of 54.5 (4,804 ratings)
13,034 students
Created by Dr. Nitin Paranjape
Last updated 4/2022
English
English

What you'll learn

  • Understand what is good and bad data. Good data allows you to analyze it without wasting time in clean-up.
  • Identify incoming data as good or bad and clean it up very fast. (unimaginably fast)
  • Understand how to detect inefficiency while working and how to find the most efficient approach.
  • Combine transnational data with master data without using VLOOKUP
  • Import millions of rows of data and analyze it quickly
  • Learn which type of visualization to use depending upon business reuqirements
  • Create interactive and easy to understand dashboards using Power BI tools
  • Use Power BI capabilities to find out interesting but usually unseen insights about data using "Quick Insights"
  • Share the dashboards and reports with others in a secure manner

Requirements

  • You must know how to use Excel. You must also know how to use Pivot Tables.
  • If you do not know Pivot Tables well, you can check my "Pivot Tables: Second Honeymoon" course.

Description

Objectives

  1. Help you learn Power BI faster using the Excel knowledge you already have

  2. Understand how to gather and clean data

  3. Make you self-sufficient in applying this knowledge to your work

  4. How to use Power BI and Excel to your advantage

Preparation

If you use Excel, you are good to go.

No special preparation is required.

Just dive into the course and start learning.

No Power BI license required.

Use Power BI Desktop - which is completely free.

No knowledge of any programming language or database is necessary.

Who should take this course

Anyone who is using Excel will benefit from this course.

If you want to learn Power BI directly, that is also fine. Because the concepts are common.

Even if you are an expert, you will find new concepts and ideas which will amplify your impact

This course will enhance your Excel skills as well because Power Query and Data Model are also available in Excel

Difficulty Level

200

Topics covered:
The entire Power BI life-cycle is covered.

  1. Power BI - the concepts

  2. Importing data from various sources

  3. Cleaning up data for Analysis in Power BI

  4. Consolidating data across sheets and files

  5. Creating a cohesive database (data model)

  6. Creating visuals and interactive reports

  7. Natural language Question and Answer

  8. Introduction to DAX functions

  9. Power BI within Excel

  10. How to learn and next steps

Who this course is for:

  • Do you spend lot of time in getting data, cleaning it up and creating reports? Then this course is for you.
  • This course is NOT for developers or SQL / Database programmers.

Instructor

Dr. Nitin Paranjape
Microsoft Most Valuable Professional for Office System
Dr. Nitin Paranjape
  • 4.5 Instructor Rating
  • 4,886 Reviews
  • 13,366 Students
  • 2 Courses

Microsoft’s Most Valuable Professionals for Office 

Microsoft Regional Director (honorary title)

Written 2 books and 1000+ blog articles 

Coached 273,000+ professionals in 2100+ organizations across 18 countries

Covers the entire Office 365 platform including Excel, Power BI, Exchange, Skype for business, OneDrive, SharePoint, Yammer.

My sessions are often referred to as "Magic Show" or "Eye Openers"

CEOs, CFOs and other senior leaders love my sessions and the only question they ask is "Why did I know all this earlier". They can see the loss of efficiency potential in their past lives after my session. 

Unfortunately, there is no UNDO button for past life. However, after attending my sessions, you are yourself the magician. Office is a catalyst to your growth. 

I am fully aware that nobody wants Office as their revenue mechanism. However, you must realize that irrespective of your area of specialization, most probably, you are using Office for 2 to 8 hours every day. If you do not know Office and especially Excel, your talent and expertise will not be able to express itself fully. It may even hinder your growth. 

There are thousands of experts. Most of them specialize in a particular area. In my case, I have taken a lot of effort (12 years of my life) to ensure that I understand all tools from the Office 365 platform. That knowledge coupled with hundreds of thousands of actual interactions with users gives me a unique insight into the minds of users and what technology has to offer. All this is not my achievement. It is a great platform made available to the world by Microsoft. 

Unfortunately, I don't know of a single person who has attempted to understand and utilize this powerful platform to her advantage. 

It is my passion to share what I know with the world - in a simplistic yet powerful way so that you can grow in your career and business beyond your imagination. 

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.