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.
Power BI for Excel Users Work Smarter Grow Faster
File Size :
1.43 GB
Total length :
3h 13m

Instructor

Dr. Nitin Paranjape

Language

Last update

Last updated 12/2022

Ratings

4.4/5

Power BI for Excel Users Work Smarter Grow Faster

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

Power BI for Excel Users Work Smarter Grow Faster

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

ObjectivesHelp you learn Power BI faster using the Excel knowledge you already haveUnderstand how to gather and clean data Make you self-sufficient in applying this knowledge to your workHow to use Power BI and Excel to your advantagePreparationIf 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 courseAnyone 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 impactThis course will enhance your Excel skills as well because Power Query and Data Model are also available in Excel Difficulty Level 200Topics covered:The entire Power BI life-cycle is covered.Power BI – the conceptsImporting data from various sourcesCleaning up data for Analysis in Power BIConsolidating data across sheets and filesCreating a cohesive database (data model)Creating visuals and interactive reportsNatural language Question and AnswerIntroduction to DAX functionsPower BI within ExcelHow to learn and next steps

Overview

Section 1: Introduction to Power BI Desktop

Lecture 1 Important Concepts

Lecture 2 Introduction to Power BI

Lecture 3 Power BI Set up

Lecture 4 Power BI Desktop – Quick Tour (Mar 2022 version)

Lecture 5 Importing Data into Power BI Desktop

Lecture 6 Import from Web – Updated: Jan 2023

Lecture 7 Where is the data stored?

Section 2: Cleaning up the data

Lecture 8 The Eleven Commandments of Good Data

Lecture 9 How to clean up cross-tab data

Lecture 10 Date formatting clean-up

Lecture 11 How to clean up multiple cross-tab data

Lecture 12 Combining Data from multiple Sheets or Files

Lecture 13 Import data from PDF

Section 3: Creating a Cohesive Database

Lecture 14 Eliminating VLOOKUP using Relationships

Lecture 15 Adding Calculated Columns

Section 4: Working with Dates

Lecture 16 Working with Dates Overview

Lecture 17 Creating a custom Date Table

Section 5: Creating Reports in Power BI Desktop

Lecture 18 Creating reports

Lecture 19 Filtering Reports

Lecture 20 Publishing Reports to Power BI Portal

Lecture 21 Keeping the Reports updated

Lecture 22 Viewing the Data behind the Visualization

Lecture 23 Using Decomposition Tree visual

Section 6: Working with DAX

Lecture 24 Calculated Columns

Lecture 25 Text Grouping and RELATEDTABLE

Lecture 26 Bin Analysis

Lecture 27 New Measure or New Column – Which one to use when?

Lecture 28 Time Intelligence – Comparing current data with the past

Section 7: Practical Scenarios

Lecture 29 Comparing Budget vs Actuals

Lecture 30 Use AI to understand rise and fall of business parameters

Section 8: Powerful Features of Power BI

Lecture 31 Natural language Q&A: Just type a question and create a report

Lecture 32 Row Level Security – Controlling who can see what in Power BI

Section 9: Putting it all together

Lecture 33 Excel and Power BI Integration

Lecture 34 Putting it all together

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.

Course Information:

Udemy | English | 3h 13m | 1.43 GB
Created by: Dr. Nitin Paranjape

You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com

New Courses

Scroll to Top