Obtain all recordsdata to observe together with video and do homework is zipped folder right here:
To obtain particular person recordsdata, go to class web page right here:
Pdf notes:
Methods to get Free Energy BI Desktop:
i. Microsoft Obtain Web page:
1. Whenever you wish to replace every month, it’s a must to re-download and re-install.
ii. Microsoft Home windows Retailer:
1. This obtain will routinely replace every month.
This video is an introduction to Information Modeling and Visualization in Energy BI Desktop. Discover ways to use Energy Question to import Excel Recordsdata from a Folder. Discover ways to construct DAX Formulation. Lean methods to create a complete Information Mannequin after which construct Information Mannequin Visualizations.
This class : Information Evaluation & Enterprise Intelligence Made Simple with Excel Energy Instruments – Excel Information Evaluation Fundamentals = E-DAB Class – Sponsored by YouTube and taught by Mike Girvin, Highline School Teacher, Microsoft Excel MVP and founding father of the excelisfun channel at YouTube. It is a free academic useful resource for individuals how wish to be taught concerning the Fundamentals of Information Evaluation and Enterprise Intelligence utilizing Microsoft Energy Instruments akin to, PivotTables, Energy Question, Energy Pivot, Energy BI Desktop and extra.
Matters:
1. (00:15) Introduction to Energy BI and Interactive Visuals
2. (01:14) Obtain Recordsdata
3. (01:56) Overview of Energy BI challenge
4. (02:38) Excel PowerPivot or Energy BI Desktop?
5. (04:20) Energy BI Historical past
6. (04:51) Completely different Variations of Energy BI
7. (06:33) Obtain Free Energy BI
8. (07:07) Open Clean File and title “.pbix” file.
9. (07:39) First Take a look at Energy BI Desktop Person Interface.
10. (08:45) Import Information into Energy BI Desktop. Import many Excel recordsdata from a folder. Use Excel.Workbook Operate.
11. (15:21) Import Dimension tables from single Excel Workbook.
12. (15:57) Create Relationships between Dimension & Truth Tables
13. (16:11) Create Date Desk with DAX Formulation. See the DAX Features: CALENDAR, MIN, YEAR, DATE, MAX,
14. (21:30) Create DAX Measures for Whole Income, Whole COGS, Whole Gross Revenue, and Whole Items. See the DAX Features, SUMX, ROUND, RELATED and SUM.
15. (27:20) Conceal Tables and Fields that aren’t utilized in Experiences and Visualizations
16. (28:10) Add new Tabs, Sheets, Pages (all synonyms)
17. (28:26) Create Gross Revenue Interactive Visualization
18. (33:29) Create Items Evaluation Interactive Visualizations.
19. (33:39) Create Hierarchy
20. (36:17) Abstract
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.