Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Power BI Course for Beginners - Practical Course..
Rating: 4.5 out of 5(2,023 ratings)
32,406 students

Microsoft Power BI Course for Beginners - Practical Course..

Project Oriented Course about Microsoft Power Bi -----------------------------------------------------------------------
Created byMohammed Shahin
Last updated 6/2021
English

What you'll learn

  • Trainees will be able to start creating their own visual reports
  • Trainees will be able to do Data Transformation
  • Will learn how to import data into power bi
  • Will learn power bi structure
  • Will learn how to publish reports
  • Will learn how to share the final report
  • Will learn how to create relationships between tables

Course content

1 section • 16 lectures • 1h 16m total length

  • Introduction3:55
  • Bi Structure4:15
  • Installation3:16
  • Importing from My SQL Database3:55
  • Importing CSV Files Into Power Bi2:03
  • Points For Clarifications1:48

    Connect to a single database to import multiple tables at once. Explore importing from folders of similarly structured files and extract data efficiently in Power BI for beginners.

  • Power Query Editor Overview4:07

    Explore the Power Query editor in Power BI, navigate data sources and tables, use the formula bar to apply actions, and manage applied steps with transform and add column options.

  • Appending Tables & Conditional Columns6:18
  • Points For Clarifications - part23:39
  • Why we need to create a Relationships?5:45
  • Creating Relationships3:16
  • DAX Using (Calculated Column & Measures)16:24

    Explore DAX to create a margin calculated column (price minus cost), then build a total profit measure and display it via a card and slicer for time intervals.

  • Using Bar Chart Visual7:05
  • Using Map Visual4:48
  • Publishing & Sharing The Report4:11
  • Way Forward1:18

    Demonstrate a Power BI workflow—from data import and transformation to creating a relationship, building reports with visuals, and publishing—sharing the report with PowerPoint, and start building your own visual reports.

Requirements

  • No prerequisite

Description

Free Course which cover all the basics for creating a report


COURSE DESCRIPTION:

Power Bi is a tool which allows you to create a visual reports to interpret data, you can get a conclusion from your historical data which can help you to take a better business decision to improve from your business performance.

In this course we are going to explore different features of Power Bi tool and we will learn the workflow to create a visual report by building a solution for a certain customer requirement.

In this course we will cover the followings:

  1. Power BI Structure

  2. Power BI Installation & Overview

  3. Data Transformation

  4. Create relationships between tables.

  5. Using DAX to write some Formulas.

  6. Create Reports using multiple visuals.

  7. Sharing the report using Power BI service.

We will build a visual report for the below customer requirements:                                           

  • Orders Quantity per product name.

  • Total Quantity orders per product sub-category/product category.

  • Return Quantity per product name.

  • The territory which is having more orders.

  • The total revenue/profit for a certain time interval.


Who this course is for:

  • Anyone looking for a practical session to learn Microsoft Power BI.

  • Data Engineers who want learn about business intelligence.

  • Students who want a comprehensive, engaging, and highly interactive approach to training

  • Anyone looking to enter data analysis or business intelligence field.


About the instructor : 

Mohammed Marwan is a Certified ILM Instructor having more than 10 years of experience in Training and Development (for both Technical and Non-Technical fields) with an excellent communication /presentation skills and developing training materials for multinational organizations.

He is delivering currently the below courses:

1- Internet of things (IoT), (Duration : 1 days)

2- Artificial Intelligence (AI), (Duration: 2 days)

3- Machine Learning using Microsoft Azure (2 days)

4- Data Science using Python (2 Days)

5- Basics of Python Programming (Duration : 3 days)

6- Advanced Python Programming (Duration : 3 days)

7- Robotics Process Automation (RPA) using UiPath (Duration : 2 days)

8- Chatbot designing using Python & Dialog flow.( Duration: 1 day)

9- Augmented Reality , (Duration: 1 days)

10- Thingworx IoT Application platform (Duration : 5 days)

11- Machine learning using Python

12- Deep learning using Python

13- Microsoft Power Bi

14- Raspberry pi mini computer 

Who this course is for:

  • Beginners
  • Students
  • Any one interested about creating visual reports

Report abuse