Business Intelligence And Automated Reports Using Power Bi - Printable Version +- 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) |
Business Intelligence And Automated Reports Using Power Bi - SKIKDA - 08-06-2023 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. |