Basics

PART 01 Power BI Basics
Chapter 01: Exploring Power BI
01 What is Power BI?
02 Power BI Product Components
03 Power BI Workflow
04 What is Power BI Desktop?
05 What is the Power BI service?
06 Power BI Content
07 Power BI License
08 Power BI Reference

Chapter 02 Getting Started with Power BI Desktop
01 Download Power BI Desktop
02 Power BI Desktop screen configuration
03 Power BI Options

Chapter 03 Importing Data
01 Importing data
02 Handling tables and columns (fields)
03 Data Refresh
04 Change data source
05 Save file

Chapter 04 Working with the Power Query Editor
01 Getting Started with Power Query Editor
02 Data Conversion
03 Merge and split columns, add columns
04 Close and apply query

Chapter 05 Data Modeling
01 Table Structure
02 Setting and editing relationships
03 Writing DAX Formulas
04 Calculation Column
05 Measurement value
Sort by column 06
07 Data Category
08 Data Group Settings

Chapter 06 Data Visualization
01 Report Page Management
02 Handling Visual Objects
03 Visual Object Options
04 Writing a Report
05 Edit Interactions

PART 02 Leveraging Power BI
Chapter 07 Using the Power Query Editor
01 File Combination
02 Add and combine queries
03 Query replication and reference
04 Row Grouping
05 Refresh query

Chapter 08 Using DAX Functions
01 Creating a Date Table
02 Measurement Value Management
03 Useful DAX Functions
04 Quick Measurements
05 DAX Reference, Quick Measurement Gallery

Chapter 09 Various Visualizations
01 Hierarchy
02 Conditional Formatting
03 Sparkline
04 Various visualizations
05 New parameters
06 Bring in more visual objects

Chapter 10 Various Map Visualizations
01 Power BI Map Visual
02 Tips for Map Visualization
03 Choropleth Area Map
04 Shape Map
05 ArcGIS

Chapter 11 Report Management
01 Filter
02 Report Tool Description
03 Report Theme
04 Creating Page Navigation Buttons
05 Creating a Bookmark

Chapter 12 Power BI Service
01 Explore the Power BI Service
02 Posting and Sharing Reports
03 Export Report
04 Data Refresh
Data Analysis Using Appendix-Generating AI

"Practical Edition"

PART 03 Where do single-person households in Seoul live?
Chapter 01 Analysis Overview
01 Analysis Background
02 Analysis Procedure
03 Analysis Features and Limitations

Chapter 02 Problem Definition
What are the trends in the composition of the 01 generation?
02 What is the spatial distribution of single-person households?
03 What are the mobility patterns of single-person households?

Chapter 03 Data Collection
01 Data on the number of households by generation
02 Population Migration Statistics Data
03 Administrative District Code Data

Chapter 04 Data Preprocessing
01 New data by generation
02 Population movement data
03 Administrative District Code Data
04 Apply final data

Chapter 05 Analysis of Changes in Generational Composition
01 Visualization of changes in the number of generations
Visualizing the changes in the 02 generation composition
03 Exploring visualization results

Chapter 06 Spatial Distribution Analysis of Single-Person Households
01 Prepare analysis data
02 Visualization of single-person households by region
03 Visualizing spatial distribution patterns
04 Exploring visualization results

Chapter 07 Analysis of Mobility Patterns of Single-Person Households
01 Prepare analysis data
02 Analysis of the characteristics of the single-person household population
03 Analysis of spatial distribution of single-person households
04 Exploring visualization results

PART 04 How is fine dust in Seoul changing?
Chapter 01 Analysis Overview
01 Analysis Background
02 Analysis Procedure
03 Analysis Features and Limitations

Chapter 02 Problem Definition
01 What is the relationship between fine dust (PM-10) and ultrafine dust (PM-2.5)?
02 Is Seoul's fine dust situation improving?
03 How do climate factors affect fine dust?
04 What is the concentration of fine dust in each region of Seoul?

Chapter 03 Data Collection

Chapter 04 Data Preprocessing
01 Fine dust measurement data
02 Climate Data
03 Connecting the final data

Chapter 05 The Relationship Between Fine Dust and Ultrafine Dust
01 Data Preparation
02 Correlation Visualization
03 Add measurement date and time
04 Exploring visualization results

Chapter 06: Is Seoul's fine dust situation improving?
01 Data Preparation
02 Visualization of changes in annual average values
Visualization of the number of cases exceeding 3 days
04 Exploring visualization results

Chapter 07 Analysis of the Relationship Between Meteorological Conditions and Fine Dust Concentration
01 Data Preparation
02 Visualization of the relationship between temperature and fine dust/ultrafine dust
03 Visualization of the Relationship between Humidity and Fine Dust/Ultrafine Dust
04 Visualization of the Relationship Between Wind Speed ​​and Fine Dust/Ultrafine Dust
05 Visualization of the Relationship Between Wind Direction and Fine Dust/Ultrafine Dust
06 Exploring Visualization Results

Chapter 08 Analysis of Fine Dust Concentration by Region in Seoul
01 Data Preparation
02 Visualization of fine dust/ultrafine dust concentration by autonomous district
03 Visualizing fine dust concentration on a map
04 Visualization of fine dust/ultrafine dust concentrations
05 Exploring visualization results

PART 05 Quit your job and start your own cafe?
Chapter 01 Analysis Overview
01 Analysis Background
02 Analysis Procedure
03 Characteristics and limitations of the analysis

Chapter 02 Problem Definition
01 What is the status of business startups and closures?
02 What are the business closure rates and business periods?
03 How influential is the franchise?
04 Where is a good location to start a business?

Chapter 03 Data Collection
01 Cafe Permit Data
02 Population data

Chapter 04 Permission Data Preprocessing
01 Check the data structure
02 Organizing data for analysis
03 Spatial information organization
04 Finishing with Power BI

Chapter 05 Preprocessing Population Data
01 Administrative district data organization
02 Organizing population data

Chapter 06 Analysis of Trends in Business Startups and Closures
01 Data Preparation
02 Visualization of startup and business closure status
03 Visualization of the increase and decrease in cafes in Seoul
04 Exploring visualization results

Chapter 07 Analysis of Closure Rates and Business Periods
01 Visualization of business closure rates by year
02 Visualization of business period status
03 Visualization Exploration Results

Chapter 08 Analysis of Famous Brand Cafes
01 Data Preparation
02 Market Share Visualization
03 Store Distribution Visualization
04 Visualizing Growth Trends
05 Exploring visualization results

Chapter 09 Cafe Location Analysis
01 Data Preparation
02 Visualization of cafe distribution by region
03 Visualization of population by region
04 Visualizing Cafe-Crowded Areas
05 Exploring visualization results

In the "Practical" section, you will practice analyzing social issues based on public data.
Based on practical and engaging topics such as the distribution and mobility patterns of single-person households in Seoul, the correlation between air quality and climate factors, and analysis of commercial districts related to cafe startups, you can naturally learn the flow of collection, preprocessing, analysis, and visualization.
In particular, each case focuses on how to derive insights from data rather than simply listing numbers.

This book goes beyond a functional explanation of Power BI to help you systematically learn the process of reading, interpreting, and persuasively communicating data.
This guide will be useful to everyone, from beginners new to data to practitioners looking to immediately apply it to real-world tasks or projects.

* Download example/complete file
Youngjin.com homepage (www.youngjin.com) - [Customer Center] - [Appendix CD Download] - [IT Books/Textbooks] - Search for the book title and download

Basics

PART 01 Power BI Basics
Effectively analyzing collected data and achieving desired results requires the use of appropriate analytical tools. In Part 01, we'll focus on Power BI, Microsoft's flagship data analysis tool, and learn the basic workflow from data preprocessing to modeling and visualization.

Power BI is a powerful business intelligence tool that helps you easily connect, visualize, and share unstructured or scattered data.
Its intuitive usage and low barrier to entry allow even beginners to quickly learn, and it offers a variety of features that can be immediately applied in practice.

Additionally, we introduce the main components of Power BI and examine the core processes of data analysis and visualization using it one by one, so that you can build a solid foundation of concepts and fundamentals before engaging in full-scale practice.

PART 02 Leveraging Power BI
PART 02 covers how to effectively utilize Power BI in practice.
We'll cover everything from how to combine multiple files or add data to create a single, unified dataset using the Power Query Editor to implementing various calculations, such as month-over-month and year-over-year growth rates, using DAX functions.

Additionally, by publishing dashboards and reports created in Power BI Desktop to the Power BI service and sharing them with members of your organization, you'll learn how to easily convey information and share analysis results in a collaborative environment.
This is the central part where you can experience the true utilization of Power BI by following the series of processes from data processing, analysis, visualization, and sharing.

"Practical Edition"

PART 03 Where do single-person households in Seoul live?
With four out of ten households in Seoul consisting of one person, "living alone" is no longer a rare phenomenon but a major trend in Korean society. In Part 03, we analyze Seoul's 426 administrative districts, drawing on public data such as resident registration and population movement data from the Ministry of the Interior and Safety, to understand the distribution and mobility characteristics of single-person households.

By leveraging Power BI, you'll gain hands-on experience with the entire process from data collection to preprocessing and visualization, and learn how to interpret life patterns and changes in urban structures, not just simple numbers.
Where do people living alone mostly live? Where are people with what characteristics moving? This section will provide insights into the relationship between cities and people through data.

PART 04 How is fine dust in Seoul changing?
"I'm worried about letting my child outside because of the fine dust." Fine dust has now become a social problem that significantly impacts the daily lives and health of Seoul citizens.


In PART 04, we will analyze air pollution measurement data from Seoul Metropolitan City and climate data from the Korea Meteorological Administration using Power BI, and interpret everyday questions such as, "Is fine dust really getting worse every year?", "How do climate factors such as temperature and precipitation affect fine dust concentration?", and "What is the air quality in the area where I live?" using public data.

PART 05 Quit your job and start your own cafe?
"I'm thinking about quitting my job and opening a cafe, but what if it fails?" This question, commonly seen on social media, isn't just a fantasy; it's a real concern for countless office workers.
Opening a café is a dream for many, but with statistics showing that 70-80% of businesses fail within five years, it's easy to hesitate.

In PART 05, we'll use Power BI as a more advanced analysis tool to analyze data on cafe startups in Seoul.
By combining local government permit information and population data, we visualize cafe distribution by commercial district, closure rates, and survival periods, and intuitively examine the characteristics of areas with high potential for success using various visualization objects.