|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/powerbi-dax-a-complete-course-basic-to-advance-25-hours/
课程评论：没有评论
课程名称：PowerBI与DAX完全课程（基础到高级-29小时） 课程概述： 本BI课程分为多个部分，涵盖了BI可视化、DAX、数据建模、仪表板以及云端报告分享等内容。完成本课程后，您将成为PowerBI的完全专家。课程内容包括BI桌面、DAX、数据建模、仪表板和BI服务。同时，课程也介绍了PowerQuery的基础知识，帮助学员更好地掌握相关概念。学员将学习到如何从不同来源导入数据、使用聚簇柱形图、堆叠柱形图、条形图等可视化工具。 课程还详细讲解了数据可视化的高级功能，包括使用工具提示、制作表格和矩阵、Slicers、卡片和主题。学员将了解如何利用PowerBI的形状、书签和选择功能，极大提升报告的专业性。课程中还涉及BI服务的创建、工作空间的管理以及如何设置用户权限以限制数据访问。学员将深入了解数据模型中的不同关系类型，如一对一、一对多和多对多，并熟悉DAX的基本概念和其在PowerBI中的重要作用。 课程包括DAX测量值与计算列的差异、DAX函数的编写（如SUM、AVERAGE、COUNT等）、以及如何使用CALCULATE、SWITCH等关键DAX功能来应对各种数据分析的需求。此外，课程还提供了时间智能DAX函数的应用，如累计总和等。 最后，学员将通过移动应用程序了解如何在手机上查看报告，课程全面覆盖BI桌面与BI服务之间的主要区别。 适合对象： 该课程适合希望系统学习PowerBI及DAX的初学者，或希望提高数据分析与可视化技能的专业人士。 完成此课程后，学员将具备在PowerBI中进行高级数据建模和报告创建的能力，成为业务智能领域的专业人士。
This BI course is divided into various sections starting from BI Visuals, DAX, Data Modelling, Dashboards and sharing of the the reports on Cloud. I have covered everything in this Course for you. You will be a FULLY PRO after finishing it.We have covered BI Desktop, DAX ,Data modelling, Dashboards and BI service in this big course for you.Also, Covered basic level information on PowerQuery for your better grip on fundamental.Relationship between Powerquery and PowerBI - Why it is important to understand.Clustered Column , Stacked Column Chart , Bar charts familyHow to import data and things to be taken care of from different sources like a folder.Drill down - off and on.Stylish Drill-Through feature.Line & Pie Visualizations.Tool-tip and Tool Tips features - Why you need them and what is the difference.How to make Tables and Matrix. Their role in reports.Difference between them. Advantages and disadvantages.Slicers (Old and latest)What are Cards and Themes in BI - Simple awesome.Learn not so much explored Analytical feature in Visualizations- A full detailed discussion on each feature. Why and where you need this. Cross Filtering feature, Drill Through, Soriting axis labels and customizing themArea Chart Visualization ,Line and Column visualization - including stacked.Complete discussion on KPI , Tree Map , Decomposition tree visualization, Ribbon Chart.How to use shapes ,bookmarks and selections in power-bi to take the reports to extreme level. Use of Slicers in navigating pages.How to Create a Dashboard in Powerbi Using above points.What is a BI Service and what is the relationship between Desktop and Service when it comes to dashboards.Create Workspaces, Reports in power BI ServiceHow to provide Admin or Viewer rights to team members who can read or edit the reports and you don't have to email.How to link Local excel files or files shared on server with BI service.How to prevent or put data restrictions on users so they can not see other reports.What is a difference between datasets, dashboards, Reports in BI service.Learn how we have made a incredible dashboard - Sales DashboardTypes of relationships - Data Modelling - One to One , One to Many, Many to ManyTypes of Cardinality. - Single direction and both directionsWhat is a Dax and its role in PowerBI.What is DAX Measure and Calculated Column (This is Part1 series of DAX)What is the difference between Measure and Calculated Columns in terms of functioning and fundamentals.Which one is better or which one to choose while writing DAX Formula in PowerBI How to write SUM,AVERAGE,COUNT,MAX,MIN,DIVIDE. Its different from excel in terms of fundamental.Learn amazing DAX functions like SUMX, COUNTX,FILTERHow to use One DAX into another DAX ,If situation demands.Most versatile and used DAX in POWERBI - CALCULATE - From basic to advanceUtmost important DAX like - ALL , ALL SELECTED, ALL EXCEPTMixing of ALL with CALCUALTE to yield powerful resultsHow to write IF dax as a calculated columnHow to write IF as a measure. Its fundamentals which is important.Use of DISTINCT and DISTINCTCOUNT and what is the difference between them.How to handle multiple conditions in a simpler manner using SWITCH Dax. Its alternate to your IF Dax.What is IN and NOT dax. Check out their use.Discussing Basic DAX like SUM, COUNT, COUNTBLANK, DISTINCT COUNT.How to use Calculated field and what are measures.Which one better - Calculated column DAX or Measure DAX - with scenariosHASONEVALUE Get ready for a DAX Surprise Test.Related DAX - Vlookup wayTime Intelligence DAX functions Cumulative SUMs - yearly, monthy , dailyWhy we should know SUMMARIZE DaxCALCULATETABLE Dax and its use with Summarize daxSelectedValue and VALUES, ConctenateXUserRelationship DAXBI Mobile apps - how to see reports via mobile - android phones and why it is called next level in bi.Major differences between BI Service and BI Desktop
