课程详情

Learn to create stunning Dashboards and Reports using Microsoft's free Business Intelligence / Analytics tool, Power BI.Do you want to build professional-quality Business Intelligence Reports from the ground up ? Do you want to blend and transform raw data into beautiful Interactive Dashboards ? Do you want to learn design and implement the same B.I. tools used by professional analysts and data scientists ? Do you want to understand the Business Intelligence workflow from end-to-end. Then Microsoft Power BI is the right tool for you and this comprehensive course will teach you everything you need to know to use Power BI. This hands on (Beginner to Intermediate) course will prepare you to start your data analytics career and also will prepare you to Successfully implement Power BI in your organization. Absolutely no experience is required. 25+ hours of HD videos of building 18 interactive Business Intelligence Reports and Dashboards (real-world examples) from scratch to finish. Files for Start and Finished projects also included to challenge you so you can learn by immediately applying what you're learning. You will have gained the knowledge and confidence to apply these same concepts to real-word to solve the Business problems or Business requirements. By the time you complete this course, You'll be a highly proficient Power BI user. You'll be fully prepared to collect, clean, model and present data for any purpose. You will be using your skills as a Business Intelligence Professional to extract knowledge from data so you can analyze and visualize complex Business Problems/Requirements with ease. Why should you consider a career as a Business Data Analyst? Salary. A Business Data Analyst is a well-paid career Stable Career. As most corporations gathering more and more data. There will never be shortage of Jobs for Business Data Analyst. Advancement in Career: Since you will be building different reports for different departments. You will never be bored and always be valued. Which will bring you more opportunities in your career. Business Data Analyst get very visibility in corporations. Whole management depends on them. #microsoft #powerbi #data #business #intelligence #analysisCourse Curriculum:Section 1: Business intelligence -Introduction to Power BIBusiness Analysis - Course IntroductionThank you for enrolling - Must watchDashboard-in-a-day & Power BI Best Practices IntroductionPower Bi Introduction - 0Power Bi Introduction - 1Power Bi Introduction - 2Why Microsoft Power BIPower BI FamilyPower BI DesktopPower BI Service 1Power BI Service 2Descriptive-Predictive-Prescriptive AnalyticsIT Challenges 0IT Challenges 1How to take the quizzesSection 2: Data Analysis and Business Intelligence - Collect , Injest and Import DataDownload Data files firstImport data from CSV filesImport data from Excel filesImport data from Web 1Import data from Web 2Import Real-time Streaming DataDownload and Install SQL Server ExpressDownload and Install Sample DatabasesImport data from SQL ServerImport data from OData feed REST-APIImport Data from FolderDataflows - IntroductionDataflows - Create Gateway from ScratchDataflows - Create Entities from CSV fileDataflows - Create Entities Using SQL ServerSection 3: Prep, Clean and Shape DataDownload resources for this section.Remove RowsRemove ColumnsMake first row as headersHow to create calculate columnsHow to remove duplicates, Unpivot columns and split columnsChange Data type, Replace Values and Rearrange the columnsAppend QueriesMerge QueriesSection 4: Power BI VisualsDownload resources for this section.Visuals IntroVisuals-Bar ChartsVisuals-Line ChartsVisuals-Pie ChartStacked bar ChartClustered Column ChartVisuals-Area Chart and Analytics Tab Explained-0Visuals-Area Chart and Analytics Tab Explained-1Visuals-Combo ChartVisuals-Scatter ChartVisuals-Treemap ChartVisuals-funnel ChartVisuals-Card and Multi-Row CardVisuals-Gauge CardVisuals-KPIsVisuals-MatrixVisuals-TableVisuals-Text boxes - Shapes - ImagesVisuals-SlicersVisuals-MapsCustom Visuals - Word CloudVisualization interactionsSection: AI Visuals - ChatGPT and Microsoft CoPilot AI Visuals - ChatGPT and Microsoft CoPilot (2min)Decomposition Tree Visual (15 min)Key Influencers Visual (16 min)Smart Narrative (12 min)Q & A Visual (17 min)Quick Measures with CoPilot (16 min)Column from Examples (15 min)New Calculation - Model Tab (25 min)Field Parameters (7 min)Bravo Tool (24 min)ChatGPT - Power BI CoPilot DAX Example (17 min)ChatGPT - Power BI CoPilot M Code Example (13 min)Section 5: Data ModelingOur First Report-0Our First Report-1Our First Report-2Our First Report-3Publishing and Sharing your first reportTheme Download fileModeling Basics-0Modeling Basics-1Modeling Basics-2Modeling and Relationships-0Modeling and Relationships-1Other ways to create RelationshipNormalization - Denormalization-0Normalization - Denormalization-1OLTP vs OLAPStar Schema vs Snowflake Schema-0Star Schema vs Snowflake Schema-1Section 6: Introduction to DAXDAX101 - Importing Data for Dax LearningDAX101 - Resources for Dax LearningDAX101 - What is DaxDAX101 - Dax Data TypesDAX101 - Dax Operators and SyntaxDAX101 - M vs DaxDAX101 - Create a ColumnDAX101 - Rules to Create MeasuresDAX101 - Calculated Columns vs Calculated Measures-0DAX101 - Calculated Columns vs Calculated Measures-1DAX101 - Sum()DAX101 - AVERAGE()-MIN()-MAX()DAX101 - SUMX()DAX101 - DIVIDE()DAX101 - COUNT()-COUNTROWS()DAX101 - CALCULATE()-0DAX101 - CALCULATE()-1DAX101 - FILTER()DAX101 - ALL()DAX101 - Time Intelligence - Create Date Table in M (important)DAX101 - Time Intelligence - Create Date Table in DAX-0DAX101 - Time Intelligence - Create Date Table in DAX-1DAX101 - Time Intelligence - PREVIOUSMONTH()DAX101 - Time Intelligence - SAMEPERIODLASTYEAR()DAX101 - Time Intelligence - TOTALYTD()DAX101 - Display Last Refresh DateDAX101 - Time Intelligence - DATEADD()DAX101 - Quick MeasuresSection 7: Hands-on Real-world ProjectsDelicious PizzaAmerican BankFinancial ReportProductivity in 2017Personality Tough Sport by SkillNatural DisastersTerrorism in WorldProcurement-spend AnalysisProducts AnalysisRegional AnalysisIT Tickets AnalysisHuman Resources 1Human Resources 2Human Resources 3Financial Data ReportSales AnalysisBank ReportSection 8: Personal - Enterprise GatewayOn-Premises GatewayPersonal vs Enterprise GatewayInstall and Configure Personal GatewayInstall and Configure Enterprise GatewayManage SQL Server Data Source thru Enterprise GatewaySection 9: Power BI Service and DashboardsPowerBI ReportsPowerBI WorkspacesPowerBI DatasetsWhat are DashboardsHow to create Workspace and Publish ReportCreate dashboards 6 different ways-0Create dashboards 6 different ways-1Favorite dashboards, reports, and apps in Power BISubscribe to a Report or DashboardRename Workspace or Report or DashboardDisplay Reports or Dashboards in Full screen modeDelete Reports or DashboardsDashboard MenusQuick InsightsSetting up Alerts on CardsQ-A in Power BIAnalyze in ExcelFile and View OptionsPrinting Dashboard and ReportsRow level securityAccess Reports Dashboards using Mobile DevicesReport page tooltip-0Report page tooltip-1Filter- Page-Report-Visualization level-0Filter- Page-Report-Visualization level-1Section 10: Sharing and CollaborationSharing and CollaborationSharing DashboardSharing WorkspacesSharing AppPublish To WebSection 11: Bonus LecturesDownload MaterialsPower BI: Best Practices, Tips and Tricks 0Power BI: Best Practices, Tips and Tricks 1Power BI: Best Practices, Tips and Tricks 2Power BI: Best Practices, Tips and Tricks 3Power BI: Best Practices, Tips and Tricks 4Power BI: Best Practices, Tips and Tricks 5Dashboard-in-a-day: Download Material linkDashboard-in-a-day: IntroductionDashboard-in-a-day: Accessing DataDashboard-in-a-day: Data Preparation 0Dashboard-in-a-day: Data Preparation 1Dashboard-in-a-day: Data modeling and Exploration 0Dashboard-in-a-day: Data modeling and Exploration 1Dashboard-in-a-day: Data modeling and Exploration 2Dashboard-in-a-day: Data modeling and Exploration 3Dashboard-in-a-day: Data modeling and Exploration 4Dashboard-in-a-day: Data Visualizations 0Dashboard-in-a-day: Data Visualizations 1Dashboard-in-a-day: Publishing ReportDashboard-in-a-day: Creating Dashboards 0Dashboard-in-a-day: Creating Dashboards 1Dashboard-in-a-day: 6 ways to create Dashboards 0Dashboard-in-a-day: 6 ways to create Dashboards 1

课程标签

0人关注该课程

主题相关的课程