Shulou(Shulou.com)06/03 Report--

Case study of Power BI data Analysis

Learning address: http://www.xuetuwuyou.com/course/194

The course is from www.51.com: http://www.xuetuwuyou.com

Course introduction

On the basis of "getting started with PowerBI data Analysis", this course combines a large number of examples to deeply explain various concepts and operations that seem difficult to understand in PowerBI, and combines typical cases in the industry to run through the primary PivotTable tools, PivotTable options, PivotTable refresh, and sorting in PivotTable. To the creation of the intermediate dynamic PivotTable, the use of the PivotTable function GETPIVOTDATA, the execution of calculation items in the PivotTable, the visual PivotTable slicer and other skill points, and then to the advanced part of the use of SQL statements to import external data sources to create PivotTable, using Microsoft Query to create PivotTable, PowerPivot and PivotTable, PivotChart, and the final one-page Dashboard report presentation, are explained in detail.

This course is suitable for data analysts who want to improve Power BI, especially those who often need to organize a large amount of data.

Course catalogue

Chapter 1: [getting started with Power BI data Analysis] Overview of Power BI, preliminary knowledge of Power Map and Power Query

1. Brief introduction to Power BI

2.Power BI component

DWT of 3.Power BI

Copyright and fee of 4.Power BI

Installation and demonstration of 5.Power BI

The four guardians of 6.Power BI

Static Map of 7.Power Map

Dynamic Map of 8.Power Map

Function loading of 9.Power View

The use of 10.Power View for interactive visual reports

Import pattern data of 11.Power Query

Data merging of 12.Power Query (horizontal merging)

Data merging of 13.Power Query (vertical merging)

M function of 14.Power Query

Chapter 2: [getting started with Power BI data Analysis] detailed explanation of the Power Pivot plug-in for Power BI

Data Import of 15.Power Pivot

Creation of hierarchical structure of 16.Power Pivot

The creation of KPI for 17.Power Pivot

DAX function of 18.Power Pivot (1)

DAX function of 19.Power Pivot (2)

Creation of Multidimensional data Model based on 20.Power Pivot

Chapter 3: [getting started with Power BI data Analysis] Comprehensive case: air quality data Analysis of Power BI

21. Case study _ Air quality (City Information preparation)

twenty-two。 Air quality (import air quality folder data)

23. Air quality (processing data)

24. Air quality (Power View interface)

25. Air quality (based on Power View interface) making dashboard

twenty-six。 Air quality (slicer style processing)

twenty-seven。 Air quality (control binding)

twenty-eight。 Air quality (realization of combinatorial map)

twenty-nine。 Air quality (linkage of completion values)

thirty。 Air quality (bubble mapping)

Chapter 4: practical Application of Power BI Desktop Visualization

thirty-one。 Concept

thirty-two。 Mode of operation

thirty-three。 Install and run

thirty-four。 Three views

thirty-five。 Query Editor

thirty-six。 Connect and adjust data

thirty-seven。 Merge data

thirty-eight。 Create a chart

Chapter 5: Power BI practice: financial indicators-DuPont Analyzer

thirty-nine。 The concept of Financial DuPont Analyzer

forty。 Manufacture of Financial DuPont Analyzer (1)

forty-one。 Manufacture of Financial DuPont Analyzer (2)

forty-two。 Manufacture of Financial DuPont Analyzer (3)

forty-three。 Manufacture of Financial DuPont Analyzer (4)

forty-four。 Financial DuPont Analysis and production instrument (5)

Chapter 6: Power BI practice: data Analysis of sales Operation Management

forty-five。 Sales funnel relationship

forty-six。 Build a multidimensional data model

forty-seven。 Insight into risk

forty-eight。 Preface to the story

forty-nine。 The story unfolds

fifty。 The best part of the story

fifty-one。 End of story

52.P0WER QUERY data processing (1)

53.P0WER QUERY data processing (2)

fifty-four。 P0WER QUERY data processing (3)

55.P0WER PIVOT data processing (1)

56.P0WER PIVOT data processing (2)

57.P0WER PIVOT data processing (3)

fifty-eight。 Work

The course is taken from:

Learn the visual data analyst career course from scratch (9 courses, 26 chapters, a total of 324 class hours! Tableau, Echarts, Power BI, excel)

Course viewing address: http://www.xuetuwuyou.com/course/182

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.