Business Intelligence And Automated Reports Using Power Bi

[SKIKDA]

Last updated 11/2020
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 2.53 GB | Duration: 5h 42m

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 DesktopConnect to web data and web appsImport Excel WorkbooksConnect to enterprise DatabaseData Transformation, Power Query and DAXGet Data Model section of the report builder (Power BI Desktop)Creating RelationshipsCardinalityDirectionData section of the report builder (Power BI Desktop)Data TypeData FormatDAXNew ColumnNew MeasureNew TableMust know DAX formulasDAX formula reference guideRow level Security to control report access using roles (dept, function, branch, cost centre etc)Report section of the report builder (Power BI Desktop)Report creationNative VisualsCustom VisualsMenu Tools for professional looking reportsEdit InteractionsReport creation from scratchPower QueryTransforming and Combining Data before loading to ModelCommon Power Query tasksUnpivotPivotSplit ColumnAppend TablesMerge TablesRemove rowsUse first row as headerMerge ColumnsAdd ColumnsGroup ByExtractFillTransposeM Code reference resourceReport Publishing, Dashboards and Power BI ServiceUnderstanding the concept of WorkspacesPublishing 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 optionsExporting to PowerPoint or PDFEmbedding in SharePointEmbedding in a websiteMaking it available via a web linkSharing with specific usersEditing the report - adding new visuals, changing visuals used and creating new report pagesAdding comments and tagging usersScheduling the report to send our daily or weekly to specific peopleCreating a DashboardCan be created from one or more reports to show management useful analysisCan incorporate data and visuals from other people's dashboards or reports shared with youSet Alerts to be instantly notified when a KPI is reached or an SLA is breachedAdd actionable commentsSchedule the dashboard to be sent out daily or weekly to specific peopleShare the dashboard with final usersBest practicesSetting automatic/scheduled refresh so new data is ingested automaticallyData Gateway configurationThe type of data sources that require data gatewayAI in Power BI and SettingsQ&A for autogenerating charts and tables in answer to questionsOrganization wide settingsAccount wide settingsWorkspace settingsDashboard settingsReport settingsDatasets settingsThis is the course to solidify your Power BI proficiency.

Overview
Section 1: Introduction and Power BI Setup

Lecture 1 Introduction to the Course

Lecture 2 Power BI Value Proposition - part 1

Lecture 3 Power BI Value Proposition - part 2

Lecture 4 Setting up an account and installing Power BI

Lecture 5 Shared Account You Can Use for Power BI Service

Lecture 6 Important Information on Extensive Support and Live Virtual Sessions

Section 2: Bringing In Data into Power BI

Lecture 7 Get Data to bring in the practice data files

Lecture 8 Connecting to Databases, web sources and cloud apps.

Section 3: Data Transformation using Power Query

Lecture 9 Data Transformation - part 1

Lecture 10 Data Transformation - part 2

Section 4: Data Modeling

Lecture 11 Data Modeling - part 1

Lecture 12 Data Modeling - part 2

Lecture 13 Data Modeling - part 3

Lecture 14 Data Modeling - part 4

Section 5: Report Creation and DAX

Lecture 15 Report Creation - part 1

Lecture 16 Report Creation - part 2

Lecture 17 Report Creation - part 3

Lecture 18 Report Creation - part 4

Lecture 19 Report Creation - part 5

Lecture 20 Report Creation - part 6

Lecture 21 Report Creation - part 7

Lecture 22 Report Creation - part 8

Lecture 23 Turn on Search for Power BI Slicers

Section 6: Power BI Service

Lecture 24 Power BI Service - part 1

Lecture 25 Power BI Service - part 2

Lecture 26 Power BI Service - part 3

Lecture 27 Power BI Service - part 4

Lecture 28 Power BI Service - part 5

Lecture 29 Power BI Service - part 6

Lecture 30 Power BI Service - part 7

Section 7: Report Refresh and Scheduling Refresh

Lecture 31 Report Refresh and Scheduling Refresh - part 1

Lecture 32 Report Refresh and Scheduling Refresh - part 2

Section 8: More DAX formulas

Lecture 33 SUMMARIZE

Lecture 34 CALENDAR

Lecture 35 VALUES

Lecture 36 CALCULATE

Lecture 37 CROSSJOIN

Lecture 38 UNION

Section 9: Special Skills

Lecture 39 Importing Data from Google Sheets

Lecture 40 Installing SQL Server for Practice with Adventure Works Company Database

Lecture 41 Setting up Adventure Works Database on your local SQL Server

Data Analysts,MIS Analysts,Financial Analysts,Project Managers,Supply Chain Analysts

Buy Premium Account From My Download Links & Get Fastest Speed.

[To see links please register or login]

[To see links please register or login]

[To see links please register or login]