Protected: Fevaworks: Big Data Course 15 Jun 2020
June 15, 2020
There is no excerpt because this is a protected post.
How to transform a table into “Number of Count Rows”
May 23, 2020
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] Enter Power Query mode “Transform” >> “Count Rows”
Creating the Data Model
May 23, 2020
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] After Importing Data and performing data data munging, the third step in creating the Power BI model is creating the Data Model. “Normalization” is the process of organizing the data to make data querying easier and more efficient. There are a number of “rules/principles”: Don’t mix attributes of unrelated
Importing Data into Power BI Desktop
May 23, 2020
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] The first step in creating the Power BI model is importing data. We can import data from a variety of data sources: Relational Databases Online sources Web services [online analytical processing (OLAP) database] SQL Server Analysis Service (SSAS) Text Files (Here are only few examples, there are far
Gray in “Data View”
May 23, 2020
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] Notice that it’s grayed out. This means it’s hidden in the Report view. You can verify this by switching back to the Report view and verifying that you cannot see the field in the field list.
Auto date/time for new files option (Global Data Load Setting)
May 23, 2020
[Ref Microsoft] Auto date/time tables are permanently hidden, even from modelers. They cannot be seen in the Fields pane or the Model view diagram, and its rows cannot be seen in Data view. Also, the table and its column cannot be directly referenced by DAX expressions. Further, it’s not possible to work with them when using Analyze in
