Course Study Address: http://www.xuetuwuyou.com/course/194
The course out of self-study, worry-free network: http://www.xuetuwuyou.com
Power-bi is a (BI) business intelligence software, Zhuhai ao Wei Software Technology Co., Ltd. independent research and development of software products, the full name is: Power-bi decision-making analysis system.
Course Introduction
This course, based on the quick start of Power BI data analysis, combines a number of examples to delve into the seemingly difficult concepts and operations of Powerbi, and to combine the typical cases in the industry with the basic PivotTable tools, PivotTable options, PivotTable refreshes, and sorting in the PivotTable report. To Intermediate dynamic pivot table creation, pivot table function GETPIVOTDATA Use, perform calculated items in a PivotTable report, visual pivot slicer skills points, and then to the Advanced section using SQL statements to import external data sources to create a pivot table, using Microsoft Query creates a pivot table, PowerPivot and pivot tables, PivotChart reports, and a final page of paper Dashboard report presentation, all in a detailed explanation. This course is ideal for data analysts who want to improve Power BI, especially those who often need to organize large amounts of data.
Course Catalogue
1th: "Power BI data analytics Quick Start" Power bi overview, Power Map, power query
1. Introduction to Power Bi
2.Power BI Components
DWT for 3.Power Bi
Copyrights and fees for 4.Power BI
Installation and demonstration of 5.Power BI
6.Power bi Four Protectors
Static map of 7.Power map
Dynamic map of 8.Power map
9.Power View function loading
10.Power View High Interactive visual report usage
11.Power query's Pattern data import
12.Power query Data Merge (horizontal merge)
13.Power Query Data Merge (vertical merge)
The M function of 14.Power query
2nd: "Power BI Data Analysis Quick Start" Power Bi's power pivot plugin details
Data import of 15.Power pivot
16.Power Pivot Hierarchy Creation
17.Power Pivot Creation KPI
18.Power pivot Dax function (i)
19.Power Pivot's DAX function (ii)
Creation of multidimensional data model for 20.Power pivot
3rd: "Power BI Data Analysis Quick Start" Comprehensive case: analysis of the atmospheric quality data of power BI
21. Case study _ Atmospheric quality (City information preparation)
22. Atmospheric quality (Import Air quality folder data)
23. Atmospheric quality (processing data)
24. Atmospheric quality (Power view interface)
25. Air quality (based on Power View interface) making dashboards
26. Atmospheric mass (slicer style processing)
27. Atmospheric quality (Control binding)
28. Atmospheric quality (combination chart implementation)
29. Air quality (completion value linkage)
30. Atmospheric quality (bubble map making)
4th: Power BI Desktop Visualization Application Combat
31. Concept
32. How it works
33. Install and run
34. Three different views
35. Query Editor
36. Connect and adjust the data
37. Merging data
38. Create a chart
5th: Power BI Combat: Financial indicators-DuPont Analyzers
39. The concept of financial DuPont analyzers
40. Financial DuPont Analyzer production (1)
41. Financial DuPont Analyzer production (2)
42. Financial DuPont Analyzer production (3)
43. Financial DuPont Analyzer production (4)
44. Financial DuPont Analysis Maker (5)
6th: Power BI Combat: Sales Operations Management Data analysis
45. Sales Funnel Relationship
46. Building a multidimensional data model
47. Insight into risk
48. Chapter sequence of the story
49. The story unfolds
50. Story Climax
51. The end of the story
52.p0wer Query data processing (1)
53.p0wer Query data Processing (2)
P0wer Query data Processing (3)
55.p0wer Pivot Data Processing (1)
56.p0wer Pivot Data Processing (2)
57.p0wer Pivot Data Processing (3)
58. Job
Power Bi Video Tutorials
