Extract, Transform and Load Data in Power BI

 

What you'll learn

How to set up a data source and explain and configure storage modes in Power BI.

How to prepare for data modeling by cleaning and transforming data.

How to use profiling tools to identify data anomalies.

How to reference queries and dataflows and use the Advanced Editor to modify code. 

Join Free: Extract, Transform and Load Data in Power BI

There are 4 modules in this course

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI.

In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity. 

After completing this course, you’ll be able to: 

• Identify, explain and configure multiple data sources in Power BI  

• Clean and transform data using Power Query  

• Inspect and analyze ingested data to ensure data integrity

This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

Read More

Microsoft Power BI Data Analyst Professional Certificate

Microsoft Power BI Data Analyst Professional Certificate

 

What you'll learn

Learn to use Power BI to connect to data sources and transform them into meaningful insights.  

Prepare Excel data for analysis in Power BI using the most common formulas and functions in a worksheet.     

Learn to use the visualization and report capabilities of Power BI to create compelling reports and dashboards.  

Demonstrate your new skills with a capstone project and prepare for the industry-recognized Microsoft PL-300 Certification exam.  

Join Free: Microsoft Power BI Data Analyst Professional Certificate

Professional Certificate - 8 course series

Learners who complete this program will receive a 50% discount voucher to take the PL-300 Certification Exam. 

Business Intelligence analysts are highly sought after as more organizations rely on data-driven decision-making. Microsoft Power BI is the leading data analytics, business intelligence, and reporting tool in the field, used by 97% of Fortune 500 companies to make decisions based on data-driven insights and analytics.1 Prepare for a new career in this high-growth field with professional training from Microsoft — an industry-recognized leader in data analytics and business intelligence.

Through a mix of videos, assessments, and hands-on activities, you will engage with the key concepts of Power BI, transforming data into meaningful insights and creating compelling reports and dashboards. You will learn to prepare data in Excel for analysis in Power BI, form data models using the Star schema, perform calculations in DAX, and more.

In your final project, you will showcase your new Power BI and data analysis skills using a real-world scenario. When you complete this Professional Certificate, you’ll have tangible examples to talk about in your job interviews and you’ll also be prepared to take the industry-recognized PL-300: Microsoft Power BI Data Analyst certification exam.

1Microsoft named a Leader in the 2023 Gartner® Magic Quadrant™ for Analytics and BI Platforms (April 2023)

Applied Learning Project

This program has been uniquely mapped to key job skills required in a Power BI data analyst role. In each course, you’ll be able to consolidate what you have learned by completing a project that simulates a real-world data analysis scenario using Power BI. You’ll also complete a final capstone project where you’ll showcase all your new Power BI data analytical skills.

The projects will include:

● A real-world scenario where you connect to data sources and transform data into an optimized data model for data analysis. 

● A real-world scenario where you demonstrate data storytelling through dashboards, reports and charts to solve business challenges and identify new opportunities.

A real-world capstone project where you analyze the performance of a multinational business and prepare executive dashboards and reports.

To round off your learning, you’ll take a mock exam that has been set up in a similar style to the industry-recognized Exam PL-300: Microsoft Power BI Data Analyst.

Read More

Power Bi Report Development Crash Course

 

What you'll learn

Create Relationship in PowerBI

Create Visualization in PowerBI 

Publish a report in powerbi service

Join Free: Power Bi Report Development Crash Course

About this Guided Project

Hello,

In this project, we will see in detail the steps required to create a PowerBI report using PowerBI Desktop and also we will publish this report on PowerBI service in the respective workspace. 

This project is designed for beginners who have no idea about PowerBI so they can quickly get a glimpse of how to create a report in PowerBI.

Pre-requisites:

- PowerBI Account

Here is a brief description of the tasks we are going to perform in this project:

Task1: Get Data

In this task we will first see an overview of PowerBI Desktop and then using PowerBI Desktop we will connect to the source data using the Get Data option. At the end of this task we would have imported all the source data in PowerBI Desktop

Task2: Create Relationship & Calculated Columns

In this task, we will create relationships between different source tables imported in PowerBI. In this process of creating relationship, we will also see how to created a calculated column using DAX query language.

Task3: Customize field level properties

In this task, we will explore and customize different field level properties like datatype, summarization, hidden etc.

Task4: Create visualizations in report

In this task, we will see how to create different visualizations in the report. We will also see how to add filters or slicers. We will explore visualizations like line chart, pie chart, table etc.

Task5: Publish report to PowerBI service

In all previous tasks, we have developed the report in PowerBI Desktop which is the local application installed on our desktop. In this task, we will see how to publish the task in power bi service. 

All The Best !!

Read More

Prepare, Clean, Transform, and Load Data using Power BI

 

What you'll learn

Prepare and Clean Data using Power BI

Transform and Load Data using Power BI

Join Free: Prepare, Clean, Transform, and Load Data using Power BI

About this Guided Project

Usually, tidy data is a mirage in a real-world setting. Additionally, before quality analysis can be done, data need to be in a proper format. This project-based course, "Prepare, Clean, Transform, and Load Data using Power BI" is for beginner and intermediate Power BI users willing to advance their knowledge and skills. 

In this course, you will learn practical ways for data cleaning and transformation using Power BI. We will talk about different data cleaning and transformation tasks like splitting, renaming, adding, removing columns. By the end of this 2-hour-long project, you will change data types, merge and append data sets. By extension, you will learn how to import data from the web and unpivot data.

This project-based course is a beginner to an intermediate-level course in Power BI. Therefore, to get the most of this project, it is essential to have a basic understanding of using a computer before you take this project.

Read More

Build an Income Statement Dashboard in Power BI

 

What you'll learn

Build an Income statement dashboard in Power BI

Visualize the income statement using cards, table and column charts

Transform & clean data in the Power Query editor

Join Free: Build an Income Statement Dashboard in Power BI

About this Guided Project

In this 1.5 hours long project, we will be creating an income statement dashboard filled with relevant charts and data. Power BI dashboards are an amazing way to visualize data and make them interactive.  We will begin this guided project by importing the data and transforming it in the Power Query editor. We will then visualize the Income Statement using a table, visualize total revenue, operating income and net income using cards and in the final task visualize the year on year growth using clustered column charts. This project is for anyone who is interested in Power BI and data visualization and specially for those who work in accounts and finance departments. By the end of this course, you will be confident in creating financial statement dashboards with many different kinds of visualizations.

Read More

Create a Sales Dashboard using Power BI

 

What you'll learn

Build an attractive and interactive sales dashboard with all the necessary visualizations in a black and blue theme

Visualize sales data using bar charts & pie charts

Create interactive maps to visualize sales data by countries and markets

Join Free: Create a Sales Dashboard using Power BI

About this Guided Project

In this 1 hour long project, you will build an attractive and eye-catching sales dashboard using Power BI in a black and blue theme that will make your audience go "wow". We will begin this guided project by importing data. We will then create bar charts and pie charts to visualize the sales data and then position the graphs on the dashboard. In the final tasks, we will create interactive maps to visualize sales data by countries and markets. By the end of this course, you will be confident in creating beautiful dashboards with many different kinds of visualizations.

Read More

HR Analytics- Build an HR dashboard using Power BI

 

What you'll learn

Build an attractive and eye-catching HR dashboard

Visualize gender & racial diversity using graphs & charts in Power BI

Explore buttons, themes, filters & slicers to make the dashboard interactive & smart

Join Free: HR Analytics- Build an HR dashboard using Power BI

About this Guided Project

In this 1 hour long project, you will build an attractive and eye-catching HR dashboard using Power BI. We will begin this guided project by importing data & creating an employee demographics page that gives us the overall demographic outlook of the organization. We will then create pie charts and doughnut charts to visualize gender & racial diversity. In the final tasks, we will create an employee detail page that will provide you with all the important information about any employee with just a click. We will also explore buttons, themes, slicers & filters to make the dashboard more interactive & useful. By the end of this course, you will be confident in creating beautiful HR dashboards that you can use for your personal or organizational purpose.

Read More

Data-Driven Decisions with Power BI

 

There are 5 modules in this course

New Power BI users will begin the course by gaining a conceptual understanding of the Power BI desktop application and the Power BI service. Learners will explore the Power BI interface while learning how to manage pages and understand the basics of visualizations.  Learners can download a course dataset and engage in numerous hands-on experiences to discover how to import, connect, clean, transform, and model their own data in the Power BI desktop application.

Join Free: Data-Driven Decisions with Power BI

 Learners will investigate reports, learn about workspaces, and practice viewing, creating, and publishing reports to the Power BI service. Finally, learners will become proficient in the creation and utilization dashboards.

Read More

Build Dashboards in Power BI

 

What you'll learn

Build a Dashboard in Power BI by building a report and visuals.

Build a report with visuals.

Create a dashboard and pin visuals.

Join Free: Build Dashboards in Power BI

About this Guided Project

In this project, you will create a Dashboard in Power BI. You will get data to bring into a model, build several reports, generate informative charts from each report, then choose powerful visuals to highlight on a Dashboard. Your new skills will help you efficiently summarize important information on a one-page dashboard with visual data.

Read More

Getting Started with Power BI Desktop

 

What you'll learn

Import and Transform Data with Power BI Desktop

Visualize Data with Power BI Desktop

Join Free: Getting Started with Power BI Desktop

About this Guided Project

In this 2-hour long project-based course, you will learn the basics of using Power BI Desktop software. We will do this by analyzing data on credit card defaults with Power BI Desktop. Power BI Desktop is a free Business Intelligence application from Microsoft that lets you load, transform, and visualize data. You can create interactive reports and dashboards quite easily, and quickly. We will learn some of the basics of Power BI by importing, transforming, and visualizing the data.

This course is aimed at learners who are looking to get started with the Power BI Desktop software. There are no hard prerequisites and any competent computer user should be able to complete the project successfully.

Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Read More