Power BI Hands-On ETL Course 2022 | Real-World Business Case

在本课程中，您将学习 Power BI Desktop 的所有独特功能，以帮助您理解并获得信心 –

数据集成

数据转换

数据建模

数据探索

数据可视化

评书

课程内容

我们将通过首先了解业务案例来采取一种实用的方法，然后根据我们的要求，将采用分步实用的方法来首先清理我们的数据、混搭，然后开始我们的可视化工作。

在这个广泛的实践课程中，您将扮演数据分析师的角色，他正在为首席营销官和首席财务官开发 Power BI 报告，以帮助他们从数据中发现业务洞察力并跟踪主要的销售和财务 KPI .

您将处理和分析销售和市场份额分析数据，您的重点是找出哪些产品类别和制造商产生的收入最多。除此之外，您还将与其他顶级制造商进行竞争分析。

我们将从整合来自多个数据源的数据开始，然后执行大量转换以准备和清理我们的数据，并使其为报告做好准备。

加载后，我们将开始制作数据模型并朝着可视化方向努力。

我们将通过在整个课程中提出重要问题来进行大量数据分析和探索。

我们还将努力回答一些常见问题，同时通过 DAX 计算进行销售分析，并创建我们自己的度量和计算列。

我们的最终目标是设计一个专业的销售分析报告，最终用户可以轻松地使用它来收集见解并帮助他们采取行动。

此外，我们将使用多个基于 AI 的 Power BI 视觉对象对我们的数据进行一些高级分析。

Published 05/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 35 lectures (3h 56m) | Size: 1.93 GB

Master your skills in Power BI reporting and analysis with a complete real-world hands on use case

What you’ll learn
Complete end-to-end Power BI Report development using a real-world business case
Able to implement your BI skills to your professional or personal projects
Power BI’s complete ETL process – data integration, transformation, modelling and visualization
Able to understand and explore your data using AI-Based Power BI visuals
Learning and implementing DAX calculations
Analyze your data for an effective storytelling using unique Power BI features like – drillthrough, custom tooltips, bookmarks

Requirements
A windows PC. Power BI is not supported on Mac or LINUX
A basic to intermediate understanding of data analysis

Description
Learn to design and develop amazing Power BI report as per industrial standards and best practices.

In this course, you’ll learn all the unique features of Power BI Desktop to help you understand and gain confidence in –

Data Integration

Data Transformation

Data Modelling

Data Exploration

Data Visualization

Storytelling

Course content

We’ll be taking a practical approach by first understanding the business case, then as per our requirement will be working step-by-step practical approach to first clean our data, mashup and then start our work on visualizations.

In this extensive hands-on course, you will be under the shoes of a Data analyst who is developing a Power BI report for Chief Marketing Officer and Chief Financial Officer to help them uncover the business insights from their data and track major Sales and Financial KPIs.

You will be working and analyzing a Sales and market share analysis data where your focus would be to find out which product categories and manufacturers are generating the most revenue. Along with that, you will be doing a competitive analysis against other top manufacturers.

We’ll start by integrating the data from multiple data sources and then performing lot of transformations to prepare and clean our data and make it ready for reporting.

Once loaded, we’ll start working on making a data model and working our way towards the visualizations.

We’ll be doing a lot of data analysis and exploration by asking important questions throughout the course.

We’ll also be working our way to answer some of the common questions while doing Sales analysis through DAX calculations and creating our own measures and calculated columns.

Our final goal will be to design a professional sales analysis report that can easily be used by the end users to gather the insights and help them take actions out of it.

Furthermore, we’ll be using multiple AI-based Power BI visuals to do some advanced analysis on our data.

Who this course is for
Anyone who has basic to intermediate understanding of Power BI and is looking to take the reporting to the next level
Anyone who is looking to learn Power BI with a practical use case
Anyone who wants to design and develop professional reports
This course is not for you if your focus in on Power BI Service. This course is intended to improve your development and analytical skills
Anyone who wants to enhance their skillset as a data analyst or BI consultant