|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-visualization-python-excel-bi-tableau/
课程评论:没有评论
课程名称:数据分析与可视化:Python、Excel、BI、Tableau 课程概述: 在这个信息爆炸的时代,作为数据分析师,您将踏上一段数据探索之旅。组织中每天产生的数据量巨大,包括传统数据库中的事务数据、服务的遥测数据,以及来自社交媒体等不同领域的信号。例如,零售企业收集并存储大量数据,追踪用户浏览和购买的商品、访问的页面以及消费习惯等。数据和信息已成为企业最具战略价值的资产,但组织面临的挑战是如何理解和利用这些数据,从而推动业务的积极变革。 提高数据使用效率的问题使得企业不断挣扎于如何有效利用数据。关键在于能够用数据讲述一个故事。在竞争激烈、节奏快速的商业环境中,撰写能够传达该故事的报告,帮助商业领袖根据数据采取行动。准确的故事能够驱动更好的商业决策,使企业在迅速做出决策时拥有更强的竞争优势。没有故事,数据往往难以被理解和运用。 然而,单有数据并不足够,必须能够基于数据采取适当的行动,这可能涉及到资源的重新分配或识别失败的活动并及时调整。此时,用数据讲述故事的重要性凸显出来。 Python是一种广泛使用的编程语言,适用于网页开发、软件开发、数学、数据分析与可视化、系统脚本等领域。它能有效地进行数据分析和可视化,帮助发现促进更明智业务决策的有价值见解。 数据分析是对数据进行分析与解释的过程,旨在提取出有用信息,简化数据分析流程,而数据可视化则通过图表、图形和地图等可视元素,将信息和数据以图形方式呈现,使得趋势、异值和数据模式一目了然。 Jupyter Notebook是一个开源的网页应用程序,可以用来创建和分享包含实时代码、公式、可视化和叙述文本的文档。它的应用范围包括数据清理与转化、数值模拟、统计建模、数据可视化和机器学习等。 Power BI是一个集合了多种软件服务、应用和连接器的平台,能够将彼此不相关的数据源转化为统一且直观的可视化洞察。无论数据来源于Excel电子表格,还是传统和云端混合数据仓库,Power BI都能帮助用户轻松连接数据源、可视化关键数据并与他人共享。Power BI由多个相互协作的元素组成,包括Windows桌面应用程序、在线SaaS服务和移动应用程序,帮助用户有效地产生和消费商业洞察。 Tableau是一款被许多大型企业信任的商业智能和分析软件,凭借其用户友好的拖放功能,用户可以快速清理、分析和可视化数据。通过学习Tableau,您将掌握如何驾驭其界面,连接并展示数据,最终自信地探索Tableau并构建影响力数据仪表板。 该课程旨在提升您在数据分析与可视化领域的技能,助您在商业决策中取得更大的成功。
As a data analyst, you are on a journey. Think about all the data that is being generated each day and that is available in an organization, from transactional data in a traditional database, telemetry data from services that you use, to signals that you get from different areas like social media.For example, today's retail businesses collect and store massive amounts of data that track the items you browsed and purchased, the pages you've visited on their site, the aisles you purchase products from, your spending habits, and much more.With data and information as the most strategic asset of a business, the underlying challenge that organizations have today is understanding and using their data to positively effect change within the business. Businesses continue to struggle to use their data in a meaningful and productive way, which impacts their ability to act.The key to unlocking this data is being able to tell a story with it. In today's highly competitive and fast-paced business world, crafting reports that tell that story is what helps business leaders take action on the data. Business decision makers depend on an accurate story to drive better business decisions. The faster a business can make precise decisions, the more competitive they will be and the better advantage they will have. Without the story, it is difficult to understand what the data is trying to tell you.However, having data alone is not enough. You need to be able to act on the data to effect change within the business. That action could involve reallocating resources within the business to accommodate a need, or it could be identifying a failing campaign and knowing when to change course. These situations are where telling a story with your data is important.Python is a popular programming language. It is used for:web development (server-side),software development,mathematics,Data AnalysisData VisualizationSystem scripting.Python can be used for data analysis and visualization.Data analysis is the process of analysing, interpreting, data to discover valuable insights that drive smarter and more effective business decisions. Data analysis tools are used to extract useful information from business and other types of data, and help make the data analysis process easier.Data visualisation is the graphical representation of information and data. By using visual elements like charts, graphs and maps, data visualisation tools provide an accessible way to see and understand trends, outliers and patterns in data.The Jupyter Notebook is an open-source web application that allows you to create and share documents that contain live code, equations, visualizations and narrative text. Uses include: data cleaning and transformation, numerical simulation, statistical modelling, data visualization, machine learning, and much more.Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.Power BI consists of several elements that all work together, starting with these three basics:A Windows desktop application called Power BI Desktop.An online SaaS (Software as a Service) service called the Power BI service.Power BI mobile apps for Windows, iOS, and Android devices.These three elements-Power BI Desktop, the service, and the mobile apps-are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.Beyond those three, Power BI also features two other elements:Power BI Report Builder, for creating paginated reports to share in the Power BI service. Read more about paginated reports later in this article.Power BI Report Server, an on-premises report server where you can publish your Power BI reports, after creating them in Power BI Desktop.Tableau is a widely used business intelligence (BI) and analytics software trusted by companies like Amazon, Experian, and Unilever to explore, visualize, and securely share data in the form of Workbooks and Dashboards. With its user-friendly drag-and-drop functionality it can be used by everyone to quickly clean, analyze, and visualize your team's data. You'll learn how to navigate Tableau's interface and connect and present data using easy-to-understand visualizations. By the end of this training, you'll have the skills you need to confidently explore Tableau and build impactful data dashboards.