Microsoft Power BI
Updated: Jul 8, 2021
Start Date: 4/Oct/2021
Seats: 20
Language: Spanish
Location: Remote (Zoom)
Duration: 12 hours
Description:
You'll learn all of the features in Power BI that allow you to explore, experiment with, fix, prepare, and present data easily, quickly.
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.
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.
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.

Course content:
1.Starting with Power BI Charts
Connecting Power BI to a Data File - CSV File
Navigating Power BI
Drilling down and up in hierarchies
Advanced drilling in hierarchies
Adding A Calculated Column
Adding Labels and Formatting
2.Timeseries, Aggregation, and Filters
Downloading and connecting to the dataset
Working with timeseries
Understanding aggregation and granularity
Creating an area chart & learning about highlighting
Timeseries, Aggregation, and Filters
3.Maps, Scatterplots and Interactive BI Reports
Joining data in Power BI
Understanding how LEFT, RIGHT, INNER, and OUTER joins work
Joins with duplicate values
Joining on multiple fields
Creating a map, working with hierarchies, lats and lons
Creating a scatter plot
Combining charts, filters and slicers
Adding a Donut Chart
Maps, Scatterplots and Interactive BI Reports
4.Creating an Interactive Business Intelligence Report
Downloading the dataset and connecting Power BI
Mapping: How To Set Geographical Roles
Creating Table Calculations for Gender
Creating Bins and Distributions for Age
Creating Bins and Distributions for Balance
How to create a Treemap chart
Controlling Report Interactivity
Analyzing the Customer Segmentation Dashboard
Creating an Interactive Business Intelligence Report
5.Leveraging Custom Visuals
Installing a Custom Visual for Power BI
Setting up the second Chord Chart
Adding Treemaps
Exploring the visualization

Comments