Su	Mo	Tu	We	Th	Fr	Sa
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	1	2	3	4	5

Business Intelligence and Automated Reports using Power BI (11/2020)

Posted By: ParRus

Date: 10 Feb 2021 15:02:15

Business Intelligence and Automated Reports using Power BI

Genre: eLearning Video / Business, Analytics & Intelligence, Microsoft Power BI

Self-service Business Intelligence with complex, insights-rich, interactive reports and dashboards in Power BI Pro

What you'll learn
Microsoft Power BI for data analysis
Business Intelligence
Data Analysis

Requirements
Familiarity with Microsoft Excel
Some basic data analysis exposure

Description
**We give participants access to a shared Power BI pro account so they can practice all the full aspects of Power BI. We also do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**

This course is a fully hands-on one to take you from just having an idea of what Power BI does to being able to create insights-rich and interactive reports/dashboards in Power BI that can drive business process and report automation and take you from just data analysis level to Business Intelligence (BI).

We cover the following aspects:

Get Data (bringing in your data for analysis)

Data Sources in Power BI Desktop

Connect to web data and web apps

Import Excel Workbooks

Connect to enterprise Database

Data Transformation, Power Query and DAX

Get Data

Model section of the report builder (Power BI Desktop)

Creating Relationships

Cardinality

Direction

Data section of the report builder (Power BI Desktop)

Data Type

Data Format

DAX

New Column

New Measure

New Table

Must know DAX formulas

DAX formula reference guide

Row level Security to control report access using roles (dept, function, branch, cost centre etc)

Report section of the report builder (Power BI Desktop)

Report creation

Native Visuals

Custom Visuals

Menu Tools for professional looking reports

Edit Interactions

Report creation from scratch

Power Query

Transforming and Combining Data before loading to Model

Common Power Query tasks

Unpivot

Pivot

Split Column

Append Tables

Merge Tables

Remove rows

Use first row as header

Merge Columns

Add Columns

Group By

Extract

Fill

Transpose

M Code reference resource

Report Publishing, Dashboards and Power BI Service

Understanding the concept of Workspaces

Publishing report (from Power BI desktop to Power BI service for consumption)

Controlling access to aspects of the report by role (region, department or level)

Published Report options

Exporting to PowerPoint or PDF

Embedding in SharePoint

Embedding in a website

Making it available via a web link

Sharing with specific users

Editing the report – adding new visuals, changing visuals used and creating new report pages

Adding comments and tagging users

Scheduling the report to send our daily or weekly to specific people

Creating a Dashboard

Can be created from one or more reports to show management useful analysis

Can incorporate data and visuals from other people’s dashboards or reports shared with you

Set Alerts to be instantly notified when a KPI is reached or an SLA is breached

Add actionable comments

Schedule the dashboard to be sent out daily or weekly to specific people

Share the dashboard with final users

Best practices

Setting automatic/scheduled refresh so new data is ingested automatically

Data Gateway configuration

The type of data sources that require data gateway

AI in Power BI and Settings

Q&A for autogenerating charts and tables in answer to questions

Organization wide settings

Account wide settings

Workspace settings

Dashboard settings

Report settings

Datasets settings

This is the course to solidify your Power BI proficiency.

Who this course is for:
Data Analysts
MIS Analysts
Financial Analysts
Project Managers
Supply Chain Analysts

also You can find my other useful: Business-posts

MediaInfo:

General
Complete name : 1. Data Transformation - part 1.mp4
Format : MPEG-4
Format profile : Base Media
Codec ID : isom (isom/iso2/avc1/mp41)
File size : 73.0 MiB
Duration : 10 min 0 s
Overall bit rate : 1 021 kb/s
Writing application : Lavf58.12.100

Video
ID : 1
Format : AVC
Format/Info : Advanced Video Codec
Format profile : Main@L3.1
Format settings : CABAC / 4 Ref Frames
Format settings, CABAC : Yes
Format settings, RefFrames : 4 frames
Format settings, GOP : M=4, N=60
Codec ID : avc1
Codec ID/Info : Advanced Video Coding
Duration : 9 min 59 s
Bit rate : 884 kb/s
Nominal bit rate : 3 000 kb/s
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 30.000 FPS
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.032
Stream size : 63.2 MiB (87%)
Writing library : x264 core 148
Encoding settings : cabac=1 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=umh / subme=6 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=22 / lookahead_threads=3 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / bluray_compat=0 / constrained_intra=0 / bframes=3 / b_pyramid=2 / b_adapt=1 / b_bias=0 / direct=1 / weightb=1 / open_gop=0 / weightp=2 / keyint=60 / keyint_min=6 / scenecut=0 / intra_refresh=0 / rc_lookahead=60 / rc=cbr / mbtree=1 / bitrate=3000 / ratetol=1.0 / qcomp=0.60 / qpmin=0 / qpmax=69 / qpstep=4 / vbv_maxrate=3000 / vbv_bufsize=6000 / nal_hrd=none / filler=0 / ip_ratio=1.40 / aq=1:1.00

Audio
ID : 2
Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : mp4a-40-2
Duration : 10 min 0 s
Bit rate mode : Constant
Bit rate : 128 kb/s
Channel(s) : 2 channels
Channel positions : Front: L R
Sampling rate : 44.1 kHz
Frame rate : 43.066 FPS (1024 SPF)
Compression mode : Lossy
Stream size : 9.16 MiB (13%)
Default : Yes
Alternate group : 1

Screenshots