Power BI AZ HandsOn Power BI Training For Data Science
What you’ll learn
Connect Microsoft Power BI to data sources
Create Donut Charts
Create Waterfall Diagrams
Basic knowledge of computers
Learn data visualization through Microsoft Power BI and create opportunities for you or key decision makers to discover data patterns such as customer purchase behavior, sales trends, or production bottlenecks.
You’ll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly, and beautifully.
Use Power BI to Analyze and Visualize Data So You Can Respond Accordingly
Connect Power BI to a Variety of Datasets
Drill Down and Up in Your Visualization and Calculate Data
Visualize Data in the Form of Various Charts, Plots, and Maps
Convert Raw Data Into Compelling Data Visualizations Using Power BI
Because every module of this course is independent, you can start in whatever section you wish, and you can do as much or as little as you like.
Each section provides a new data set and exercises that will challenge you so you can learn by immediately applying what you’re learning.
Content is updated as new versions of Power BI are released. You can always return to the course to further hone your skills, while you stay ahead of the competition.
Contents and Overview
This course begins with Power BI basics. You will navigate the software, connect it to a data file, and export a worksheet, so even beginners will feel completely at ease.
To be able to find trends in your data and make accurate forecasts, you’ll learn how to work with hierarchies and timeseries.
Also, to make data easier to digest, you’ll tackle how to use aggregations to summarize information. You will also use granularity to ensure accurate calculations.
In order to begin visualizing data, you’ll cover how to create various charts, maps, scatterplots, and interactive dashboards for each of your projects.
You’ll even learn how to join multiple data sources into one in order to combine diverse sources of information in one analytical solution.
Finally, you’ll cover some of the latest and most advanced custom visualizations in Microsoft Power BI, where you will create histograms, brickcharts and more.
By the time you complete this course, you’ll be a highly proficient Power BI user. You will be using your skills as a data scientist to extract knowledge from data so you can analyze and visualize complex questions with ease.
You’ll be fully prepared to collect, examine, and present data for any purpose, whether you’re working with scientific data or you want to make forecasts about buying trends to increase profits.
Section 1: Welcome to the Course
Lecture 1 Installation
Lecture 2 Get the Datasets here
Lecture 3 Extra Resources
Section 2: Your First Bar Chart
Lecture 4 The business Challenge – Who Gets The Annual Bonus?
Lecture 5 Connecting Power BI to a Data File – CSV File
Lecture 6 Navigating Power BI
Lecture 7 Drilling down and up in hierarchies
Lecture 8 Advanced drilling in hierarchies
Lecture 9 Adding Colours
Lecture 10 Adding A Calculated Column
Lecture 11 Adding Labels and Formatting
Section 3: Timeseries, Aggregation, and Filters
Lecture 12 Downloading and connecting to the dataset
Lecture 13 Working with timeseries
Lecture 14 Understanding aggregation and granularity
Lecture 15 Creating an area chart & learning about highlighting
Lecture 16 Filters and Slicers in Power BI
Section 4: Maps, Scatterplots and Interactive BI Reports
Lecture 17 Joining data in Power BI
Lecture 18 Understanding how LEFT, RIGHT, INNER, and OUTER joins work
Lecture 19 Joins with duplicate values
Lecture 20 Joining on multiple fields
Lecture 21 Creating a map, working with hierarchies, lats and lons
Lecture 22 Power BI: Calculated Columns vs Calculated Measures
Lecture 23 Creating a scatter plot
Lecture 24 Combining charts, filters and slicers
Lecture 25 Adding a Donut Chart
Section 5: Creating an Interactive Business Intelligence Report
Lecture 26 Downloading the dataset and connecting Power BI
Lecture 27 Mapping: How To Set Geographical Roles
Lecture 28 Creating Table Calculations for Gender
Lecture 29 Creating Bins and Distributions for Age
Lecture 30 Creating Bins and Distributions for Balance
Lecture 31 How to create a Treemap chart
Lecture 32 Creating a Customer Segmentation Dashboard
Lecture 33 Controlling Report Interactivity
Lecture 34 Analyzing the Customer Segmentation Dashboard
Section 6: Leveraging Custom Visuals
Lecture 35 The Challenge: Visualizing the European Debt Crisis
Lecture 36 Installing a Custom Visual for Power BI
Lecture 37 Mechanics of a Chord Chart
Lecture 38 Setting up the second Chord Chart
Lecture 39 Adding Treemaps
Lecture 40 Exploring the visualization
Lecture 41 THANK YOU Video
Section 7: Special Offer
Lecture 42 ***YOUR SPECIAL BONUS***
You should take this course if want to learn Power BI completely from scratch,You should take this course if you know some Power BI skills but want to get better,You should take this course if you are good with Microsoft Power BI and want to take your skills to the next level and truly leverage the full potential of Power BI
Udemy | English | 4h 21m | 1.50 GB
Created by: Kirill Eremenko