|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dax-power-pivot-data-modelling-in-excel-2016-and-exercises/
课程评论：没有评论
课程名称：DAX Power Pivot - 初学者的10个简单步骤 课程概述：如果你的目标是进入商业智能(BI)、数据挖掘或数据分析的领域，这门课程绝对是你的首选。Microsoft PowerPivot是Excel的一个扩展，提供了商业智能功能和报告，使用户能够在熟悉的Excel环境中处理数亿行数据，从而为企业提供洞察，缩短决策周期。这门课程强调了Power Pivot在数据建模和分析中的重要性，帮助你掌握数据转换、计算列和DAX相关概念。通过创建数据模型和DAX度量，学员能够有效生成商业洞察，助力商业决策。 学员评价：许多学员对课程的授课风格表示高度赞赏，尤其对讲师的热情和教学方法感到满意。学员们普遍认为，该课程内容丰富，易于理解，并提供了大量的示例和实践练习，非常适合初学者。此外，课程还附有详细的用户指南，涵盖了步骤和练习的解决方案，帮助学员巩固所学知识。 学习内容： - 导入数据到Power Pivot以创建数据模型。 - 理解计算列和其他DAX相关概念。 - 创建数据表之间的关系，减少对VLOOKUP的依赖。 - 掌握DAX度量，通过数据分析表达式生成商业洞察。 课程适合对象：本课程适合在财务、统计、项目管理、商业及市场分析或任何数据报告角色工作的人士，尤其是那些希望创建商业智能风格的仪表板报告的初学者。 课程示范将使用Excel 2016进行，学员也可在Excel 2010和2013中进行学习，讲师将指出可能的差异。学完后，学员将具备更加深入了解和应用Excel的能力，为未来的职业发展打下坚实的基础。 欢迎点击页面右上角的“开始这门课程”按钮，迈出发展新技能的第一步！
If your goal is to enter the world of BI, Data Mining and or Data Analysis you have to take this course. All of these environments and roles demand the skills you are about to learnMicrosoft PowerPivot is an add on for Excel that provides Business Intelligence functionality and reporting within the familiar environment of Excel.This capability enables manipulation of hundreds of millions of rows of data with the capacity to provide business insights and shorter decision making cycles laughing in the face of the million row threshold of regular ExcelHere's what others had to say about the course:"This instructor is unbelievable. Not only were the course materials plentiful, but her instruction was full of enthusiasm and encouragement. The format was perfect for me. I never felt like I was being left behind. I'll take any course by Gilly Dow, if it's not completely relevant to something I'm working with at the moment. This course was really amazing." - Mickey Thorpe"I purchased your two courses as a review to brush up on my skills Dax Power Pivot 10 Easy Steps for beginners Dax Power Pivot Time intelligence 10 easy steps Both wonderfully explained with very good demonstrated examples. Great refresher courses. You really have a gift for teaching. I took PowerPivot Pro a couple of years back and I find your walk through and demonstrations of the Dax measures so much clearer and to the point. It has been a fun enjoyable refresher for me. This is great course for everyone getting started in PowerPivot Thanks well done." - Stephen Davanzo"Thank you so much for making DAX so simple and efficient. This is perfect for everyone would like to start their journey in DAX." - Ravi Vijay"she is too good. I would like to do other courses even if they are not available on Udemy. Request Udemy to get all her works small or big on the site. Every slide I see my learning and understanding increases by leaps and bounds. I simply love this instructor and my highest regards for her way of explaining the things."- Vinay Kumra"Great course, good testing, good exercises, easy to follow lessons. I'm about 60% complete and the further I go the better it gets. Love the practice exercises and how the instructor goes through the answers in video detail about how the solution was arrived at...great teaching techniques all around. And then, there is the 70+ page guide that is integrated into the lesson plan, makes following the videos and working independently on the practice sessions easy as everything is organized to just follow along and learn by doing. So, watch, listen read do, test, feedback, move to next lesson. Right pace, right tone, right encouragement. Excellent course! Looking forward to the advanced. Marty"- Martin Rini"I really loved this course because it gave a nice (IMHO) overview for a beginning DAX / Power Pivot course. The Instructor was very very good. She took time to walk-through each step. If she keeps that approach in the upcoming Intermediate and Advanced courses, they will be winners. (She even gave some "top-tips" for regular Excel which jogged my memory banks anyway.) I am eagerly looking forward to the release dates her subsequent courses."- Walt LiermanWhat You'll LearnTo start with the course focuses on importing data into Power Pivot to create the Data Model. You will learn about calculated columns and other DAX related concepts that will show you how to "shape" the data. Next, you will create relationships between tables of data negating the need for VLOOKUP. Reducing the time it takes to "shape" your data - is one of the major benefits of this awesome tool.With the data model in place, next you delve into the world of DAX measures. These are Data Analysis EXpressions functions that build the formulas to provide the business insights that decision makers and stakeholders dream of.There is no programming involved with DAX - your Excel formulas experience has set you up nicely for the next step in your Excel journey.Throughout the course we work together building the data model and measures. At the end of each step you have an opportunity to practice creating your own measures to help you consolidate, embed and reinforce everything you have learned. I provide a solutions video lecture before moving on to ensure you're on track and ready to move on.I provide all the files you need to follow along and a fully supporting, screen-shot enriched 78 pg. user guide pdf packed with all the steps and practice exercises with solutions.Power Pivot is the perfect tool for those working in finance, statistics, project, business and market analysis or any data reporting role who have a need to create and produce Business Intelligence style dashboard reports.Thanks for taking the time to check out my course. I can't wait to help you take the next step in developing your Excel skills. I have used Excel 2016 to demonstrate this fantastic tool but you can follow along in Excel 2010 & 2013 - I'll do my best to point out the differences. If you have any questions about the course, feel free to message me here or check out the FREE preview lectures to learn more.Take the first steps to a new and rewarding future by clicking on the TAKE THIS COURSE button, located on the top right corner of the page.
