top of page

Microsoft Power BI

Roman Echeverria
Jul 7, 2021
2 min read

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


Commenting on this post isn't available anymore. Contact the site owner for more info.
Data Creed - Black Background.png

©2027 Data Creed

bottom of page