+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Business Intelligence And Automated Reports Using Power Bi (/Thread-Business-Intelligence-And-Automated-Reports-Using-Power-Bi--186335)
Business Intelligence And Automated Reports Using Power Bi - Farid - 10-09-2023
![[Image: PDCz1S.ox1myugv108k.jpg]](https://i.im.ge/2023/10/09/PDCz1S.ox1myugv108k.jpg)
Business Intelligence and Automated Reports using Power BI WEBRip | English || 1280 x 720 | AVC ~884 Kbps | 30 fps
AAC | 128 Kbps | 44.1 KHz | 2 channels | Subs: English (.srt) | ~5.5 hours | 3.09 GB Genre: eLearning Video / Business, Analytics & Intelligence, Microsoft Power BI
Quote:Self-service Business Intelligence with complex, insights-rich, interactive reports and dashboards in Power BI ProWhat 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:
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 : [email protected]
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
Exclusive eLearning Videos ← add to bookmarks
Business Intelligence And Automated Reports Using Power Bi (2.53 GB)
KatFile Link(s)
RapidGator Link(s)