|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-charts-pivots-plus-tableau-for-beginners-2-in-1/
课程评论：没有评论
**Excel Charts & Pivots Plus Tableau For Beginners (2合1课程)** 这门课程专为初学者设计，旨在教授Microsoft Excel中的图表和数据透视表功能，以及Tableau入门知识。 **Excel部分：** Excel是一款灵活且多功能的工具，可用于数据分析、清洗和可视化。它能够帮助用户深入理解数据趋势，整合不同来源的数据，并支持多人协作。Excel还提供密码保护功能，确保文件安全。然而，Excel在处理海量数据、大型文件时可能会遇到性能瓶颈，导致程序运行缓慢甚至崩溃。尽管如此，Excel在企业中仍扮演着核心角色，是无法忽视的重要工具。 **Excel课程结构：** * 图表制作 * 数据透视表 * 报表 * 数据透视图 **Tableau部分：** Tableau是领先的数据可视化和商业智能工具。Gartner将其评为分析和商业智能领域的领导者。Tableau的优势包括强大的数据可视化能力，能够快速创建交互式视图，易于实施，并且可以处理大量数据。此外，Tableau支持与其他脚本语言集成，提供移动端支持和响应式仪表板，并具有报告调度和通知功能。 **Tableau入门课程结构：** **第一部分：入门** * 课程介绍 * 软件下载与安装 * 数据库连接 * Tableau Live与Extract * 表格视图 * 数据类型 * Tableau工作表界面 * 数据类型符号 * 添加新工作表 * 产品类别与销售数据分析 * 维度与度量 * 分组 * 数据粒度 * 将表格转换为图表 * 筛选器 * 日期筛选器 **第二部分：图表** * 创建图表 * 折线图 * 柱状图 * 饼图 * 树状图 * 堆叠树状图 * 柱状图的颜色与度量设置 * 柱状图的大小设置 * 柱状图的尺寸与颜色组合设置 * 带有双轴的柱状图 * 堆叠柱状图（分两部分讲解） * 热力图（分四部分讲解） * 散点图 * 带有双轴的折线图 * 折线图的大小度量设置 * 多维度和度量的折线图 **第七部分：Tableau筛选器** * （此处列出了筛选器相关内容，但具体细节未在提供的信息中详述）
Bundled 2 in 1 Course. Learn Excel Charts & Pivots + Tableau For Beginners.Software1: MS Excel 2007 to 2021.Software2: Tableau 2022 (recommended) else anyWHO'S THIS FOR?This course is designed specifically for Beginners.MS ExcelExcel is flexible and versatile tool for data analysis, data cleaning and data visualization. It is up to person imagination and creativity to capture utilization potential of Excel can offer. Flexibility means you can represent or format data as per your need and can do same task in more than one way.Advantages of ExcelExcel helps to analyze data. Today companies have large data. It becomes easy to analyze and interpret large with the help of excel.It helps to know the trend in the data with the help of charts, graphs, 3-D images, etc.Excel helps in bringing data together. It is possible to import files and documents in excel.We can work with others simultaneously with the help of an excel web app.It helps to store data, do calculations, organize, and format the cells.Excel file is secured with a password, therefore, security is assured.Disadvantages of ExcelCan't handle large amounts of data.File hanging, Corrupting issue if size is large.Excel becomes slow or crashes when you have lots of data, formatting and Charts inside a workbook.My Opinion on ExcelExcel will always be a heart of organization. we have Tableau, Power BI tools which are becoming the backbone of Industry but Excel will always be a Part of the the industry. we can't ignore it.COURSE STRUCTUREExcel Charts Pivots TablesReportsPivot ChartsTableau For Beginners.WHO'S THIS FOR?This course is designed specifically for freshers and absolute beginners.Tableau is a leading data visualization tool used for data analysis and business intelligence. Gartner's Magic Quadrant classified Tableau as a leader for analytics and business intelligence.Advantages of TableauData visualization.Quickly Create Interactive visualizations.Ease of Implementation.Tableau can handle large amounts of data.Use of other scripting languages in Tableau.Mobile Support and Responsive Dashboard.Tableau Company Strategy.Scheduling or notification of reports.Tableau For BeginnersSection 1:IntroductionLecture 1:Introduction(Preview enabled)Lecture 2:DownloadLecture 3:InstallLecture 4:Connect with DatabaseLecture 5:Tableau Live & ExtractLecture 6:View tablesLecture 7:Data TypesLecture 8:Tableau Work Sheet InterfaceLecture 9:Data Types Symbol(Preview enabled)Lecture 10:Adding new SheetLecture 11:Product Category & SalesLecture 12:Dimension & MeasuresLecture 13:GroupingLecture 14:GranularityLecture 15:Table into chart formLecture 16:FilteringLecture 17:Date FilterSection 2:ChartLecture 18:Create a ChartLecture 19:Line ChartLecture 20:Bar ChartLecture 21:Pie ChartLecture 22:Tree mapLecture 23:Stacked Tree MapLecture 24:Bar Chart Color MeasureLecture 25:Bar Chart size MeasureLecture 26:Bar Chart Size and color MeasureLecture 27:Bar Chart with dual axisLecture 28:Bar Stacked Part1Lecture 29:Bar Stacked Part2Lecture 30:Heat Map1Lecture 31:Heat Map2Lecture 32:Heat Map3Lecture 33:Heat Map4Lecture 34:Scattered chartLecture 35:Line Chart Dual AxisLecture 36:Line Char Size MeasureLecture 37:Line Chart multidimension and measuresSection 7: Tableau Filters Filters
