image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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.










Who this course is for:
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

What you'll learn

Connect Microsoft Power BI to data sources

Create Barcharts

Create Treemaps

Create Donut Charts

Create Waterfall Diagrams

Create Piecharts

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Welcome to the Course
4
1.1-Welcome Challenge!
1.2-Installation
1.3-Get the Datasets here
1.4-Extra Resources
2-Your First Bar Chart
9
2.1-The business Challenge - Who Gets The Annual Reward?
2.2-Connecting Power BI to a Data File - CSV File
2.3-Navigating Power BI
2.4-Drilling down and up in hierarchies
2.5-Advanced drilling in hierarchies
2.6-Adding Colours
2.7-Adding A Calculated Column
2.8-Adding Labels and Formatting
2.9-Your first bar chart
3-Timeseries, Aggregation, and Filters
6
3.1-Downloading and connecting to the dataset
3.2-Working with timeseries
3.3-Understanding aggregation and granularity
3.4-Creating an area chart & learning about highlighting
3.5-Filters and Slicers in Power BI
3.6-Timeseries, Aggregation, and Filters
4-Maps, Scatterplots and Interactive BI Reports
11
4.1-Joining data in Power BI
4.2-Understanding how LEFT, RIGHT, INNER, and OUTER joins work
4.3-Joins with duplicate values
4.4-Joining on multiple fields
4.5-Creating a map, working with hierarchies, latitude and longitudes
4.6-Calculated columns vs. calculated measures - Part 1
4.7-Calculated columns vs. calculated measures - Part 2
4.8-Creating a scatter plot
4.9-Combining charts, filters and slicers
4.10-Adding a Donut Chart
4.11-Maps, Scatterplots and Interactive BI Reports
5-Creating an Interactive Business Intelligence Report
10
5.1-Downloading the dataset and connecting Power BI
5.2-Mapping: How To Set Geographical Roles
5.3-Creating Pie Chart for Gender
5.4-Creating Bins and Distributions for Age
5.5-Creating Bins and Distributions for Balance
5.6-How to create a Treemap chart
5.7-Creating a Customer Segmentation Dashboard
5.8-Controlling Report Interactivity
5.9-Analyzing the Customer Segmentation Dashboard
5.10-Creating an Interactive Business Intelligence Report
6-Leveraging Custom Visuals
7
6.1-The Challenge: Visualizing the European Debt Crisis
6.2-Downloading Power BI Custom Visual Sample
6.3-Mechanics of a Chord Chart
6.4-Setting up the second Chord Chart
6.5-Adding Treemaps
6.6-Exploring the visualization
6.7-THANK YOU Video
7-Congratulations!! Don't forget your Prize :)
2
7.1-Huge Congrats for completing the challenge!
7.2-Bonus: How To UNLOCK Top Salaries (Live Training)