|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-power-bi-up-running-with-power-bi-desktop/
课程评论：没有评论
课程名称：微软Power BI桌面商业智能课程 课程概述：欢迎参加销量第一的Power BI桌面课程！如果你是一名数据专业人士或有志于成为分析师，想学习市场上最顶尖的商业智能平台，那么这门课程正是你所需要的。全球有超过250,000个完美的五星好评证明了这一点。 在课程中，你将从Maven Analytics团队的优秀导师那里学习，并通过实际项目和独特的真实世界任务来测试你的技能。你将扮演AdventureWorks Cycles这家虚构制造公司的商业智能分析师，把原始数据转换为专业质量的报告和仪表板，用于跟踪关键绩效指标、比较区域表现、分析产品趋势以及识别高价值客户。我们将全程提供清晰的指导和实用的小贴士，确保你从零起步成为专家。 课程将按照商业智能工作流的关键阶段进行设计，包括数据准备、数据建模、探索性数据分析、数据可视化和仪表板设计，模拟数据专业人士在实际工作中每天会遇到的任务： 第一阶段：连接和整形数据 重点构建自动化工作流程，以使用Power Query提取、清理、转换和加载项目数据，连接常见的数据连接器、存储模式和数据透视等。 第二阶段：创建关系数据模型 回顾数据建模的最佳实践，介绍基数、规范化、过滤流和星形模式等主题，从零开始构建AdventureWorks的数据模型。 第三阶段：使用DAX添加计算字段 介绍数据分析表达式（DAX），创建计算列和措施，探索行和过滤上下文的主题，练习应用强大的筛选函数、迭代器和时间智能模式。 第四阶段：通过报告可视化数据 通过报告和仪表板将数据带入生活，回顾数据可视化的最佳实践，构建基本图表，增加交互性，使用书签、切片面板、参数、工具提示等功能。 课程还将介绍新发布的强大人工智能工具，如分解树、关键影响因子、智能叙述和自然语言问答。 准备好开始学习了吗？立即加入课程，享受以下资源的终身访问： - 17小时高质量视频 - 200多页Power BI电子书 - 25个作业及解决方案 - 可下载的课程项目文件 - 专家问答支持论坛 - 30天退款保证 该课程旨在帮助你建立可以直接应用于工作的Power BI技能。 祝学习愉快！- Chris & Aaron (Maven Analytics)
Welcome to the #1 best-selling Power BI Desktop course!If you're a data professional or aspiring analyst looking to learn the top business intelligence platform on the market, you've come to the right place. With more than 250,000 perfect 5-star reviews from students around the world, this is the course you've been looking for.Throughout the course, you'll learn from top instructors on the Maven Analytics team and put your skills to the test with hands-on projects and unique, real-world assignments.THE COURSE PROJECT:You'll play the role of Business Intelligence Analyst for AdventureWorks Cycles, a fictional manufacturing company. Your role is to transform raw data into professional-quality reports and dashboards to track KPIs, compare regional performance, analyze product-level trends, and identify high-value customers.But don't worry, we'll be here to guide you along every step of the way, with intuitive, crystal clear explanations and helpful pro tips to take you from zero to expert - guaranteed.This course is designed to follow the key stages of the business intelligence workflow (data prep, data modeling, exploratory data analysis, data visualization & dashboard design) and simulate real-world tasks that data professionals encounter every day on the job:STAGE 1: Connecting & Shaping DataIn this stage we'll focus on building automated workflows to extract, clean, transform, and load our project data using Power Query, and explore common data connectors, storage modes, profiling tools, table transformations, and more:Data connectorsStorage & import modesQuery editing toolsTable transformationsConnecting to a databaseExtracting data from the webQA & Profiling toolsText, numerical, date & time toolsRolling calendarsIndex & conditional columnsGrouping & aggregatingPivoting & unpivotingMerging & appending queriesData source parametersImporting Excel modelsSTAGE 2: Creating a Relational Data ModelIn stage 2 we'll review data modeling best practices, introduce topics like cardinality, normalization, filter flow and star schemas, and begin to build our AdventureWorks data model from the ground up:Database normalizationFact & dimension tablesPrimary & foreign keysStar & snowflake schemasActive & inactive relationshipsRelationship cardinalityFilter context & flowBi-directional filtersModel layoutsData formats & categoriesHierarchiesSTAGE 3: Adding Calculated Fields with DAXIn stage 3 we'll introduce data analysis expressions (DAX). We'll create calculated columns and measures, explore topics like row and filter context, and practice applying powerful tools like filter functions, iterators, and time intelligence patterns:DAX vs. MCalculated columns & measuresImplicit, explicit & quick measuresMeasure calculation stepsDAX syntax & operatorsMath & stats functionsConditional & logical functionsThe SWITCH functionText functionsDate & time functionsThe RELATED functionCALCULATE, FILTER & ALLIterator (X) functionsTime intelligence patternsSTAGE 4: Visualizing Data with ReportsStage 4 is about bringing our data to LIFE with reports and dashboards. We'll review data viz best practices, building and format basic charts, and add interactivity with bookmarks, slicer panels, parameters, tooltips, report navigation, and more:Data viz best practicesDashboard design frameworkCards & KPIsLine charts, trend lines & forecastsOn-object formattingTable & matrix visualsConditional formattingTop N filteringMap visualsDrill up, drill down & drillthroughReport slicers & interactionsBookmarks & page navigationNumeric & fields parametersCustom tooltipsImporting custom visualsManaging & viewing roles (RLS)Mobile layoutsPublishing to Power BI ServiceWe'll also introduce brand new features as they are released, powerful artificial Intelligence tools like decomposition trees, key influencers, smart narratives and natural language Q & A, and performance optimization techniques to keep your reports running smoothly at scale.Ready to get started? Join today and get immediate, lifetime access to:17 hours of high-quality video200+ page Power BI ebook25 homework assignments & solutionsDownloadable course project filesExpert Q & A support forum30-day money-back guaranteeIf you're looking for the ONE course to help you build job-ready Power BI skills, you've come to the right place.Happy learning!-Chris & Aaron (Maven Analytics)See why this is one of the TOP-RATED Power BI courses in the world:"I believe this is the best Power BI course out there. I spent £1400 to attend a 3-day Power BI crash course, and have to confess it's nothing compared to the knowledge, skills, expertise and understanding derived from this course. I am forever grateful to Chris and the Maven Analytics team for doing such amazing work and to Udemy for making this available."-Isaac Mensah"Resources are awesome. Presenter is brilliant. I found this course more useful than the official Power BI course from Microsoft. Things are easy to follow, and presentations are high quality."-Jacobus M."Chris is a skilled communicator and does a great job of explaining a complex tool like Microsoft Power BI. His 'pro-tips' are great for new user productivity and gaining a sense of the big picture, and I value his best practices on building and managing Power BI queries and reports. I'm feeling much more confident to dig in and use Power BI on my own projects!"-Bill Jerrow"Simply put, this course is AMAZING! The instructor literally takes you step-by-step from knowing nothing about Power BI into nearly an expert! I have had experience working with Power BI even in a corporate setting in the past, and I was still blown away by the level of granularity Chris was able to casually explain in a way that made sense. The hands-on exercises are THE perfect way to reinforce the concepts you learn throughout the course and connect theory to application. Can't speak enough to how great this course is, I will definitely be coming back to it as a reference guide in my work and would recommend it to anyone looking to learn Power BI!"-Ikenna Egbosimba"I've been in university classrooms for much of my life and Chris is a university level instructor."-Allan SearlLooking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, Tableau, Alteryx & Python!
