Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Transition from Excel to Power BI - Your 1st Step to PowerBI
Rating: 4.2 out of 5(34 ratings)
153 students

Transition from Excel to Power BI - Your 1st Step to PowerBI

Get yourself comfortable with Power BI Environment and take a step by step approach for building stunning visualizations
Created byAbhishek Agarwal
Last updated 12/2017
English

What you'll learn

  • How to get data in Power BI
  • How to create charts and metrics
  • How to write conditional statements in Power BI
  • How to create reports in Power BI
  • How to create dashboards in Power BI
  • How to create analytical reports in Power BI
  • How to mimic operations like vlookup in power BI

Course content

1 section • 18 lectures • 1h 25m total length

  • Introduction10:13
  • Loading data from Excel into Power BI6:07

    Import data from Excel into Power BI, loading multiple sheets such as orders, returns, and users; verify loaded data and establish or review relationships, then save the project.

  • Creating Custom Calculations in Power BI3:29
  • Creating Visualization in Power BI7:22
  • Creating "If" Conditions in Power BI3:07

    Learn how to create if conditions in Power BI by adding a new column that classifies values based on a 10 percent threshold, mirroring Excel logic.

  • Doing Vlookup in Power BI4:07
  • Creating Simple Table / Metric in Power BI3:33
  • Creating Pivot Table in Power BI3:46
  • Filtering Data in Power BI2:28
  • Formatting Data in Power BI3:26
  • Conditional Formatting in Power BI3:33
  • Text Validation in Power BI6:30

    Apply data validation in Power BI by creating a validation column and enforcing rules on order quantity and data types, using checks like is blank, is text, and is numeric.

  • How to achieve Excel's "Text to Columns" functionality in Power BI4:53
  • What if Anlaysis in Power BI8:27
  • Inserting and Utilizing Images in Power BI for Professional Look3:05
  • Creating Reports or Dashboards in Power BI6:37
  • Top 10 Rows Analysis in Power BI3:24

    Explore how to show top 10 rows in Power BI with dynamic ranking and selections, using table visuals and flexible sorting for sales, quantity, or customer segment.

  • Thank You!!!1:25

    Celebrate completing the course on transitioning from Excel to Power BI and apply real-time data practicals to build dashboards, showcase your expertise to management, and seek feedback.

Requirements

  • Basic Knowledge of Computer and Microsoft Excel
  • Basic understanding of how to create table and charts in excel
  • Motivation for creating automated report and dashboards
  • Excitement to learn Power BI

Description

Do you want to learn a new skill to increase your chance of employability?

Are you stuck with excel reports and dashboards, and looking for a new tool to increase the effectiveness and efficiency?

Do you want to take your skills to next level in report and dashboard development?

Do you want to learn Power BI but confused with hard hitting technical courses?


If the answer of any of above question is yes, then you should take this course.


You should take this course to come out of your comfort zone of excel report and dashboard development and do amazing things in Power BI

You should take this course to see how Power BI is changing the entire scenario of reports and dashboard development.

You should take this course to increase your skills and your chance for better employment.

You should take this course for a life long learning of an ever evolving tool Power BI.

This course is for absolute beginners in Power BI and you just need to have a good understanding of how you can develop the reports and dashboards in excel. 

Who this course is for:

  • Reporting Analyst
  • Excel User
  • Business Analyst
  • BI Developer
  • Business User of Power BI
  • Business User of Excel

Report abuse