Category: IT

[Ref https://stackoverflow.com/questions/35254852/how-to-change-the-jupyter-start-up-folder] Use the jupyter notebook config file: Open cmd (or Anaconda Prompt) and run jupyter notebook –generate-config. This writes a file to C:\Users\username\.jupyter\jupyter_notebook_config.py. Browse to the file location and open it in an Editor Search for the following line in the file: #c.NotebookApp.notebook_dir = ” Replace by c.NotebookApp.notebook_dir = ‘/the/path/to/home/folder/’ Make sure you use forward slashes in your path and use Read More

Command Prompt: 11 basic commands you should know (cd, dir, mkdir, etc.)

May 31, 2020

[Ref https://www.digitalcitizen.life/command-prompt-how-use-basic-commands] How to change the directory (folder) in Command Prompt (CMD) CD\ command go one folder up, use the “cd..” command How to change the drive in Command Prompt (CMD) “d:” change the drive and the directory at the same time – “cd D:\Python Code” How to view the contents of a directory in Read More

Setting CHROME as Default browser for Anaconda Jupyter Notebook

May 31, 2020

[Ref https://community.simplilearn.com/threads/setting-chrome-as-default-browser-for-anaconda-jupyter-notebook.48667/] Here is the way to override this default config and set chrome as a default browser while launching in simple steps. Step 1: Launch Anaconda command Prompt Step 2: Type the command ” jupyter notebook –generate-config ” step 3: Locate the generated configuration file in the path “C:\Users\XXXX\.jupyter\jupyter_notebook_config.py” and open it with notepad/any text editor. step Read More

Python Lesson 1

May 31, 2020

[Ref Wiki, Youtube, It’s django:用Python迅速打造Web應用!] Python is an interpreted, high-level, general-purpose programming language. Recent years, it has been used more broadly than before. This article is not going to share to much about the history and applications. Instead, let’s take a look on the interface of the language. To “play” this language, we need something. If you have learnt PHP, Read More

Protected: What’s Data Analysis Expressions (DAX)?

May 26, 2020

There is no excerpt because this is a protected post.

Protected: Dimensional modeling, Data Warehousing and Business Intelligence (DW/BI)

May 23, 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” Read More

What’s Data Model?

May 23, 2020

[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. Read More

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 Read More

What’s Data Munging?

May 23, 2020

[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. Read More

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 Read More

« 1 2 3 »