4 out of 5
4
6 reviews

Data Analyst with Microsoft Power BI

Microsoft Power BI is a business intelligence platform that provides tools for aggregating, analyzing, displaying, and sharing data with non-technical business users. 

33 students enrolled

Microsoft Power BI is a business intelligence platform that provides tools for aggregating, analyzing, displaying, and sharing data with nontechnical business users. 

Exploratory Data Analysis(EDA) in Power BI can help you improve your reports. To begin, we’ll take you through the use of descriptive statistics to discover outliers, locate missing data, and fill in any gaps in your dataset with imputation techniques. Then we’ll see how EDA in Power BI may help you identify links between categorical and continuous variables. You’ll also discover how to analyze time series, visualize data, and recognize trends. Finally, you’ll learn how to use Power BI’s decomposition trees and key influencers to figure out which variables have the biggest impact on the target variable.

1. Getting started

1
Introducing Power BI
2
Using Power BI
3
The building blocks of Power BI
4
A quick look at the Power BI service
5
Review

2. Getting data

1
Overview of Power BI Desktop
2
Connect to data sources in Power BI Desktop
3
Clean and transform your data with the Query Editor
4
More advanced data sources and transformation
5
Cleaning irregularly formatted data

Modeling

1
Introduction to modeling your data
2
How to manage your data relationships
3
Create calculated columns
4
Optimizing data models
5
Create calculated measures
6
Create calculated tables
7
Explore your time-based data

Visualizations

1
Introduction to visuals in Power BI
2
Create and customize simple visualizations
3
Combination charts
4
Slicers
5
Map visualizations
6
Matrixes and tables
7
Scatter charts
8
Waterfall and funnel charts
9
Gauges and single-number cards
10
Modify colors in charts and visuals
11
Shapes, text boxes, and images
12
Page layout and formatting
13
Group interactions among visualizations
14
Duplicate a report page
15
Show categories with no data
16
Summarization and category options
17
Z-order
18
Visual hierarchies and drill-down
19
R integration in Power BI Desktop

Exploring data

1
Introduction to the Power BI service
2
Quick insights in Power BI
3
Create and configure a dashboard
4
Ask questions of your data with natural language
5
Create custom Q&A suggestions
6
Share dashboards with your organization
7
Display visuals and tiles full-screen
8
Edit tile details and add widgets
9
Get more space on your dashboard
10
Install and configure a personal gateway

Power BI and Excel

1
Introduction to using Excel data in Power BI
2
Upload Excel data to Power BI
3
Import Power View and Power Pivot to Power BI
4
Connect OneDrive for Business to Power BI
5
Excel in Power BI – summary

Publishing and sharing

1
Introduction to content packs, security, and groups
2
Publish Power BI Desktop reports
3
Print and export dashboards and reports
4
Manually republish and refresh your data
5
Introducing Power BI Mobile
6
Create groups in Power BI
7
Build content packs
8
Use content packs
9
Update content packs
10
Integrate OneDrive for Business with Power BI
11
Publish to web
12
Completion of Power BI Guided Learning

Introduction to DAX

1
Introduction to DAX
2
DAX calculation types
3
DAX functions
4
Using variables in DAX expressions
5
Table relationships and DAX


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Get course
30-Day Money-Back Guarantee

Includes

15 hours
Full lifetime access
Access on mobile and TV

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed
Data Analyst with Microsoft Power BI
Category:
4 out of 5
4
6 reviews
Price:
$250