Protected: Dimensional modeling, Data Warehousing and Business Intelligence (DW/BI)
There is no excerpt because this is a protected post.
How to transform a table into “Number of Count Rows”
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] Enter Power Query mode “Transform” >> “Count Rows”
What’s Data Model?
[Ref Beginning Microsoft Power BI ISBN 978-1-4842-5619-0] a data model is made up of tables, columns, data types, and table relations.
Creating the Data Model
[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
What’s Data Munging?
[Ref Wiki] Data munging, sometimes referred to as Data wrangling, is the process of transforming and mapping data from one “raw” data form into another format with the intent of making it more appropriate and valuable for a variety of downstream purposes such as analytics.
Importing Data into Power BI Desktop
[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”
[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)
[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
Urgency Surrounds Growing Space Debris Threat
[Ref aviationweek.com] HOUSTON—An estimated 5,000 spent rocket bodies and retired multinational spacecraft that circle the Earth—some with a mass of up to several tons—are part of a growing orbital debris population that poses a lingering collision threat to national security and civil space assets. Among those assets are the International Space Station and the connectivity
PolyU – web seminar 2020 May 5 1700 – 1800LT
Price discrimination is common. To gain customer loyalty- Frequent Flyer Program (FFP) FFP offers “miles” which allow you to get free flights or discounts – switching costs FFP usually has tier levels because airlines don’t want to create switching costs for those who don’t fly a lot.
What music (soundtrack) do I like?
foreboding music 預感 Eerie music ominous music tense music suspenseful music and pop music like this? https://www.youtube.com/watch?v=kGKkUN50R0c
The road to become a professional bus driver before being an airline pilot
2020 Apr 17, around 3 months past since the outbreak of COVID-19 , I wake up at 0500LT. This first thing I am going to do is to type a simply “diary” to record my recent status. I like writing blog since I can review what I did in the past and I can check
Aircraft identification
This is an article to help myself and share how can we distinguish different type of aircraft. Actually, we can identify by the features in different part. Firstly, we should know that there are two major aircraft manufacturers dominating the civil aviation industry, at least, you should have heard 1) Airbus and 2) Boeing. The
ICAO Eng Revision 2020 03 13
[Fire] Where’s the source? How far back is the location where getting warm? (Vocab) fumes smokes fire extinguisher [Collisions] Did you hear anything? (Vocab) The Airbus 320 has taxied into the Boeing 777 The Boeing 777 has been pushed back into the Airbus The Airbus 320 is lodged under the Boeing 777
AOM Course Revision
Airport Landside road management is needed to ensure safe and efficient operations of both passenger and cargo. Also, it is customer-oriented. Since the better the road management, the less the incident and so there is less disruption on the overall airport operations. ///////////////////// During the starting of an incident or aftermath of a crisis, IAC
Learning English: A Fall from Grace
pushy (adj.) behaving in an unpleasant way by trying too much to get something or to make someone do something 咄咄逼人的 a pushy salesman拼命勸別人買東西的推銷員 giddy (adj.) feeling silly, happy, and excited and showing this in your behaviour 飄飄然的 I was smiling and giddy. flirt + with (v.) to behave as if sexually attracted
