|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-power-bi-your-data-analytics-visualisation-journey/
课程评论：没有评论
课程名称：SQL与Power BI：您的数据分析与可视化之旅 课程概述： 在这门课程中，您将获得数据分析所需的关键技能，从完全的初学者成长为熟练的用户。课程内容涵盖SQL和Power BI的基础知识，结合实用练习，帮助您逐步掌握数据分析和可视化的技巧。加入课程后，您将获得对微软SQL Server和Power BI全课程内容的终身访问权限，以及执行练习所需的数据文件和脚本。 课程结构采用逐步推进的方法，让您在听讲的同时不断获得新的知识。课程共计超过8小时的清晰结构化内容，帮助您开始数据分析之旅。 课程内容包括： 1. **核心SQL**：深入了解核心SQL功能，包括创建数据库、常用查询、高级过滤、结果分组等。 2. **中级SQL**：学习更高级的SQL函数和概念，如数据转换、数据清洗、运行总计、视图和存储过程等。 3. **SQL查询指导**：一份额外的指导，确保您能够正确编写查询脚本。 4. **Power BI可视化**：学习数据可视化的重要性，如何将数据导入Power BI，并创建有意义的可视化仪表板。 参加这门课程，您将 equipped with the necessary knowledge to conduct data analytics and visualize your data to a professional standard. 无论您是希望提升工作技能还是寻找新的职业方向，这门课程都将为您提供宝贵的学习经验。不要等了，赶快加入我们，开始您的数据学习之旅吧！
Reviews"Excellent course, principles are explained clearly and then demonstrated..." - Mike Pease"The trainer was very comprehensive" - Lyra Aitolya"I just saw the course once in SQL section, then practiced it. Just follow his directions and you will learn the concepts very clearly" - Shital Parikh"Useful Power BI lessons - Helped me make my dashboards. Enjoying SQL sessions as well" - Dan Pearson"They really take you from a beginner to advanced. I am now able to freely use SQL to analyze data and Power BI to visualize it" - Naufil Arshad"The course structure is amazing, the guide is very clear and to the point" - Shuheb Khan"Yes it is a good learning for me and I can relate to it in the work that I do" - Sheldon Pais-------------Join this course and start gaining the key data analytic skills you've always wanted in your tool-belt!This course will walk you through fundamental data concepts, with practical exercises, in order to build you from an absolute beginner to a skilled user, in both analysis and visualisation, working through the examples together to give you live practice.Upon enrolling, you'll gain instant, lifetime access to all sections of the course for Microsoft SQL Server and Power BI, as well as the data files and scripts necessary for the exercises.Our approach is a stepped approach, meaning that you will keep gaining more and more building blocks as you work through the lectures. This means you will be equipped with the necessary knowledge to conduct data analytics and visualise your data to a professional standard.You'll get access to all sections of the course that will teach you the fundamentals from the ground up, supported with over 8 hours of clear, structured content to start your data journey.The course starts with ‘Core SQL', where you will gain an in-depth understanding of the core functions in SQL. You will learn creating databases, to the most frequently used queries, to advanced filtering, to bucketing results:Introduction to the SQL interface and how to navigate and import dataUnderstanding data types and obtaining data from tables by using the SELECT and FROM statementsCreating new tables using the INTO statementApplying basic and complex filters on data sets by using WHILE, IN and LIKE statementsAggregating data to create reports by using the GROUP BY statementUnderstanding how to apply non-aggregation and aggregation filteringCreating new data columns based on constraints and conditions by using the CASE statementAppending tables using UNION and UNION ALL statementsUtilising data from different tables to create master tables by using the JOIN statementThings to look out for when managing databasesNext you'll learn the more advanced SQL functions and concepts in the ‘Intermediate SQL' section of the course. This includes data conversion, data cleansing, running totals, views, variables, stored procedures, and more:Understanding and working with NULL values by using ISNULL and COALESCE statementsUsing the CAST and CONVERT statements to change data typesApplying window functions (such as RANK and ROW_NUMBER) to introduce a row count and ranking to the dataUsing the PARTITION statement to split the window function operations on data (such as running totals)Using the VIEW statement to create virtual tables and manipulate dataUnderstanding variables and stored procedures to make SQL code and queries more dynamicThe next (bonus!) section is a ‘SQL Query Walkthrough Guide' - so you'll never get lost on how to script your queries correctly!The final section of this course covers Microsoft's intuitive ‘Power BI' data visualisation tool. We go into the importance of data visualisation, show how powerful it is, and build multiple dashboards to gain important data insights:Understanding the concepts and importance of data visualisationUnderstanding how to import data into Power BI directly from SQLHow to navigate through the back end of Power BI and manipulate data to satisfy our needsHow to create meaningful visualisations and dashboards which can be used to show relevant findingsOur mission at Data Civilisation is to give you the building blocks for your journey!So what are you waiting for? Jump right in and learn about data!
