|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-bi-step-by-step-tutorials/
课程评论：没有评论
课程名称：Power BI逐步教程 课程概述： 本课程将定期更新，涵盖从基础到高级的所有Power BI主题。每周或定期会添加新视频，非常适合希望通过真实的实践场景学习Power BI的用户。Power BI是全球领先的商业智能工具，市场对Power BI专业人士的需求巨大，学习Power BI将为您的职业发展带来巨大的帮助。 本课程内容： 通过Power BI，您可以连接到各种数据源（如文本、CSV、SQL分析服务等），使用简单直观的工具构建复杂的关系模型，并从零开始设计引人入胜的互动式仪表板。课程包含以下几个部分： 第一部分：Power BI简介和基础知识 - 商业智能概述 - Power BI的安装与界面介绍 - 数据连接（文本/CSV文件和Excel数据的加载与格式化） - 使用Power Query编辑器处理和转换数据 第二部分：数据处理技术 - 数据透视与反透视 - 处理参数和查询合并/附加 第三部分：数据模型和优化 - 数据模型、事实表和维度表的概念 - 优化PBIX文件及数据库规范化 第四部分：DAX函数和计算 - DAX的基础与进阶应用，包括数学、逻辑与文本函数 - 过滤器、计算列与计算度量的使用 第五部分：高级DAX功能与应用 - 理解上下文、时间智能函数和排名 - GROUPBY与SUMMARIZE函数的对比和应用 本课程以实践为导向，旨在帮助您掌握数据分析技能，为数据分析或商业智能的职业生涯做好准备。通过学习，您将获得适合就业的技能，提升自己的职业竞争力。
[Update] This course will be progressively updated (on regular basis) and we will try to cover all Power BI topics from basic to advance level, New videos will be added weekly or regularly.If you are looking for complete practical based step by step Power BI course, you've come to right place. This course for those users looking to learn Power BI using real time practical based scenarios and want to take their Power BI skills to next level.Learning power bi will be the smartest move in your career because among all other BI tools available in a market, Power BI standout as a No 1 BI tool in the world right now and not only that there is a huge demand and big job market available for Power BI professionals in most MNCs and in bigger firms. So to boost your career by learning Power BI Step by Step.With Power BI you can connect to hundreds of data sources like text, CSV, SQL analysis services, SQL server, MySQL, build complex relational models using simple and intuitive tools, and design stunning, interactive awesome dashboards from scratch, You can turn your raw data into visualization and many more.This hands on course will prepare you to start your data analytics career.If you're looking to build expert level data analysis skills using DAX and Power BI, this is the course for you and this course will prepare you prepare you to build job-ready skills for a career in Data Analysis or Business Intelligence.Part 1 - What is Power BI, Linked Reports, Power BI Installation, Power Query.Chapter 1:- What is Business Intelligence, Power BI and Why Power BI ?Chapter 2:- How to Download and Install Power BI Chapter 3:- Interface Tour of Power BI DesktopChapter 4:- Connecting to Text/CSV Source FileChapter 5:- Power Query Editor: Shaping up CSV Data, Working with Applied Steps, Renaming Data Table, Headers and Removing Blank Rows, Error Data, Replacing Values.Chapter 6:- Loading Multiple Data: Excel Data with CSV DataChapter 7:- Creating Duplicating Columns For Creating Relationship in Data Model.Chapter 8:- Loading and Formatting Data in Stacked Bar Visual, Creating & Duplicating PagesChapter 9:- Working with Clustered Bar Chart, Pie Chart, Line Chart and Funnel ChartChapter 10:- Working with Slicers, Table, Donut Charts, Maps, CardsChapter 11:- Understand types of filters, Data Filters, TopN, types of filters in power bi?Chapter 12:- Conditional Formatting in ChartsChapter 13:- Linked Reports (Drill Through Report) Chapter 14:- Working with Bookmarks and ButtonsChapter 15:- Exploring Data with QnA ComponentChapter 16:- Connecting SQL Server Database and creating visualChapter 17:- Connecting Website URL and Creating VisualsChapter 18:- What is Power Query ?Chapter 19:- Understanding Data Types and Creating Custom TablesChapter 20:- Keep rows and remove rowsChapter 21:- Removing Special Characters (Rupee Symbol) From Strings (M-Function)Chapter 22:- Basic Calculations (Standard and Scientific), Conditional Columns and Creating IndexPart 2 - Explain Pivot vs Unpivot, Parameters, Merge and append Queries.Chapter 23:- Pivot and UnpivotChapter 24:- Working with Parameters (Simple, List, Query)Chapter 25:- Merge Queries and Append Queries.Part 3 - Joins and Join Kind, Optimize PBIX File , Database Normalization.Chapter 26:- Types of Join or Types of Join Kind in Power BI.Chapter 27:- How to optimize PBIX file using Load Feature.Chapter 28:- Understand Database Normalization.Part 4 - Explain Data Model, OLTP, Star Schema & Snowflake Design. Dax FunctionChapter 29:- What is Data Model, Fact Table, Dimension Table?Chapter 30:- OLTP VS OLAP, Star Schema and SnowFlake designs.Chapter 31:- Explain DAX and how to Create Measure Table.Chapter 32:- Calculated Columns vs Calculated Measures.Chapter 33:- Dax Function - SUM vs SUMX.Part 5: Maths DAX Function, Logical DAX Function, Text DAX Function in Power BI.Chapter 34:- Maths DAX Functions: MIN, MAX, AVERAGE, DISTINCT, COUNTChapter 35:- Logical DAX Functions: IF, AND, OR, TRUE, FALSE, ISTEXT, ISERROR, ISBLANK, SWITCH.Chapter 36:- Text DAX Functions: TRIM, LEN, LOWER, UPPER.Part 6:- Understand Filter Dax Functions in Power BI.Chapter 37:- Filter DAX Functions - Value, Filter, Calculate & Related.Part 7:- Explain ALL, ALLExcept, AllSelected Table Joins-Crossjoin, Union.Chapter 38: Explain ALL, ALLExcept, Chapter 39: AllSelected Table Joins-Crossjoin, Union, Except & Intersect?Part 8:- Explain Fields in Power BI, Numeric range parameter and difference between DateAdd and ParallelPeriod.Chapter 40:- What are Fields, Numeric Range (What-if) Parameter in Power BI?Chapter 41:- Date and Time: DateAdd vs ParallelPeriodPart 9:- LookupValue DAX Function and Date & Time Function in Power BI.Chapter 42:- What is LookupValue DAX Function in Power BI?Chapter 43:- Date & Time: Datesbetween, DatesinPeriod, DatesQTD, DatesMTD, DatesYTD.Part 10:- DAX Variables, Power DAX USERELATIONSHIP & TREATAS.Chapter 44:- Understand DAX Variables(VAR).Chapter 45:- Power DAX USERELATIONSHIP, TREATAS.Part 11:- Explain the difference between TotalMTD & DatesMTD, what is SAMEPERIODLASTYEAR function in DAX.Chapter 46:- TotalMTD vs DatesMTD, TotalQTD vs DatesQTD and TotalYTD vs DatesYTD (DAX).Chapter 47:- Understanding SAMEPERIODLASTYEAR function and SAMEPERIODLASTYEAR vs PARALLELPERIOD (DAX).Chapter 48:- Import Query vs Direct Query in Power BI.Part 12:- What is RELATED & RELATEDTABLE, Calculate Top N Values Dynamically, Rank using DAX RANKX.Chapter 49:- Understand RELATED and RELATEDTABLE in Power BI Dax.Chapter 50:- Understand DAX TOPN and how to dynamically calculate Top N Values.Chapter 51:- How to rank using DAX RANKX in Power BI?Part 13:- Explain SELECTEDVALUE DAX function, SELECTCOLUMNS vs ADDCOLUMNS.Chapter 52:- Using the SELECTEDVALUE DAX function in Power BI?Chapter 53:- SELECTCOLUMNS vs ADDCOLUMNS and how to use these functions to generate new tables in Power BI?Part 14:- Use GROUPBY without DAX, Explain SUMMARIZE vs GROUPBY.Chapter 54:- How to use GROUPBY in Power BI without DAX?Chapter 55:- Power BI DAX SUMMARIZE vs GROUPBY.Chapter 56:- Calculating work days using DAX Networddays.
