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
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