MindMap Gallery PowerBI.Basics
Suitable for novices or people with a little basic knowledge, Power BI is a business intelligence (BI) tool launched by Microsoft. It can help users easily obtain, organize and analyze data, and transform the data into visual charts. Help users better understand data.
Edited at 2023-12-14 17:39:21This strategic SWOT analysis explores how Aeon can navigate the competitive online landscape, highlighting strengths, weaknesses, opportunities, and threats. Strengths include strong brand recognition (trusted Japanese heritage, quality), omnichannel capabilities (stores + online + mall integration), customer loyalty programs (Aeon Card, points, member pricing), and physical footprint (extensive store network for pickup/returns). Weaknesses encompass digital maturity gaps (e-commerce penetration, app functionality, personalization vs. Amazon, Alibaba), cost structure challenges (store-heavy, real estate, labor), and supply chain complexity (fresh food, frozen logistics for online). Opportunities include enhancing e-commerce competitiveness (faster delivery, wider assortment, lower minimum order), leveraging data-driven strategies (purchase history, personalized offers, inventory optimization), expanding omnichannel integration (buy online pick up in store, ship from store), and private label growth (Topvalu, localized brands). Threats involve online-first players (Amazon, Alibaba, Sea Limited) with lower costs, wider selection, faster delivery, market dynamics (changing consumer behavior post-COVID, discount competitors), and regulatory risks (data privacy, cross-border e-commerce rules). Aeon can strengthen market position by investing in digital capabilities, leveraging store assets for omnichannel, and using customer data for personalization, while addressing cost structure and online competition.
This analysis explores how Aeon effectively tailors offerings to meet the diverse needs of family-oriented consumers through a comprehensive Segmentation, Targeting, and Positioning (STP) framework. Demographic segmentation examines family life stages (young families with babies, school-aged children, teenagers, empty nesters), household sizes (small vs. large), income levels (mass, premium), and parent age bands (millennials, Gen X). This identifies distinct consumer groups with different spending patterns. Geographic segmentation highlights store catchment types (urban, suburban, rural), community characteristics (density, income, competition), and local preferences (fresh food, halal, Japanese products). Psychographic segmentation delves into family values (health, safety, education, convenience), lifestyle orientations (busy professionals, home-centered, eco-conscious). Behavioral segmentation focuses on shopping missions (daily grocery, weekly stock-up, seasonal shopping), price sensitivity (value seekers, premium), channel preferences (in-store, online, pickup). Needs-based segmentation reveals core family needs related to value (good-better-best pricing), budget considerations (affordability, promotions, member pricing), safety (food quality, product recall), convenience (one-stop shopping, parking, store hours). Targeting prioritizes young families with school-aged children, budget-conscious households, and convenience-seeking shoppers. Positioning emphasizes Aeon as a family-friendly, value-for-money, one-stop destination with Japanese quality and local relevance. These insights enhance family shopping experiences through tailored assortments (kids’ products, school supplies), promotions (family bundles, weekend events), and services (nursing rooms, kids’ play areas).
This Kream Sneaker Consumption Scene Analysis Template aims to visualize purchasing and consumption journeys of sneakers, identifying key demand drivers and obstacles. User behavior within Kream includes searching, bidding, buying, selling, authentication, and community engagement. External influences include brand drops (Nike, Adidas), social media (Instagram, TikTok), influencer hype, and cultural trends. Target categories: limited editions, collaborations, retro releases, performance sneakers, and general releases. Timeframes: launch day, first week, first month, long-term (seasonal, yearly). Regions: North America, Europe, Asia (Korea, China, Japan). User segments: Collectors: value rarity, condition, completeness (box, accessories). KPIs: collection size, spend, authentication rate. Resellers: value profit margin, volume, turnover. KPIs: sell-through rate, average profit, listing frequency. Sneakerheads: value hype, trends, community validation. KPIs: purchase frequency, social engagement, wishlist adds. Casual trend followers: value style, convenience, price. KPIs: conversion rate, average order value, repeat purchases. Gift purchasers: value ease, presentation, brand trust. KPIs: gift message usage, return rate. Consumption journey: Awareness: social media, email, push notifications. Search: browse, filter, search by brand, model, size. Purchase: bid, buy now, payment, shipping. Authentication: inspection, verification, certification. Resale: list, price, sell, transfer. Sharing: review, unboxing, social post, community discussion. Key performance indicators: conversion rate, sell-through rate, average order value, customer lifetime value, authentication pass rate, return rate, Net Promoter Score. This framework helps understand sneaker trading dynamics, user motivations, and touchpoints for engagement and satisfaction.
This strategic SWOT analysis explores how Aeon can navigate the competitive online landscape, highlighting strengths, weaknesses, opportunities, and threats. Strengths include strong brand recognition (trusted Japanese heritage, quality), omnichannel capabilities (stores + online + mall integration), customer loyalty programs (Aeon Card, points, member pricing), and physical footprint (extensive store network for pickup/returns). Weaknesses encompass digital maturity gaps (e-commerce penetration, app functionality, personalization vs. Amazon, Alibaba), cost structure challenges (store-heavy, real estate, labor), and supply chain complexity (fresh food, frozen logistics for online). Opportunities include enhancing e-commerce competitiveness (faster delivery, wider assortment, lower minimum order), leveraging data-driven strategies (purchase history, personalized offers, inventory optimization), expanding omnichannel integration (buy online pick up in store, ship from store), and private label growth (Topvalu, localized brands). Threats involve online-first players (Amazon, Alibaba, Sea Limited) with lower costs, wider selection, faster delivery, market dynamics (changing consumer behavior post-COVID, discount competitors), and regulatory risks (data privacy, cross-border e-commerce rules). Aeon can strengthen market position by investing in digital capabilities, leveraging store assets for omnichannel, and using customer data for personalization, while addressing cost structure and online competition.
This analysis explores how Aeon effectively tailors offerings to meet the diverse needs of family-oriented consumers through a comprehensive Segmentation, Targeting, and Positioning (STP) framework. Demographic segmentation examines family life stages (young families with babies, school-aged children, teenagers, empty nesters), household sizes (small vs. large), income levels (mass, premium), and parent age bands (millennials, Gen X). This identifies distinct consumer groups with different spending patterns. Geographic segmentation highlights store catchment types (urban, suburban, rural), community characteristics (density, income, competition), and local preferences (fresh food, halal, Japanese products). Psychographic segmentation delves into family values (health, safety, education, convenience), lifestyle orientations (busy professionals, home-centered, eco-conscious). Behavioral segmentation focuses on shopping missions (daily grocery, weekly stock-up, seasonal shopping), price sensitivity (value seekers, premium), channel preferences (in-store, online, pickup). Needs-based segmentation reveals core family needs related to value (good-better-best pricing), budget considerations (affordability, promotions, member pricing), safety (food quality, product recall), convenience (one-stop shopping, parking, store hours). Targeting prioritizes young families with school-aged children, budget-conscious households, and convenience-seeking shoppers. Positioning emphasizes Aeon as a family-friendly, value-for-money, one-stop destination with Japanese quality and local relevance. These insights enhance family shopping experiences through tailored assortments (kids’ products, school supplies), promotions (family bundles, weekend events), and services (nursing rooms, kids’ play areas).
This Kream Sneaker Consumption Scene Analysis Template aims to visualize purchasing and consumption journeys of sneakers, identifying key demand drivers and obstacles. User behavior within Kream includes searching, bidding, buying, selling, authentication, and community engagement. External influences include brand drops (Nike, Adidas), social media (Instagram, TikTok), influencer hype, and cultural trends. Target categories: limited editions, collaborations, retro releases, performance sneakers, and general releases. Timeframes: launch day, first week, first month, long-term (seasonal, yearly). Regions: North America, Europe, Asia (Korea, China, Japan). User segments: Collectors: value rarity, condition, completeness (box, accessories). KPIs: collection size, spend, authentication rate. Resellers: value profit margin, volume, turnover. KPIs: sell-through rate, average profit, listing frequency. Sneakerheads: value hype, trends, community validation. KPIs: purchase frequency, social engagement, wishlist adds. Casual trend followers: value style, convenience, price. KPIs: conversion rate, average order value, repeat purchases. Gift purchasers: value ease, presentation, brand trust. KPIs: gift message usage, return rate. Consumption journey: Awareness: social media, email, push notifications. Search: browse, filter, search by brand, model, size. Purchase: bid, buy now, payment, shipping. Authentication: inspection, verification, certification. Resale: list, price, sell, transfer. Sharing: review, unboxing, social post, community discussion. Key performance indicators: conversion rate, sell-through rate, average order value, customer lifetime value, authentication pass rate, return rate, Net Promoter Score. This framework helps understand sneaker trading dynamics, user motivations, and touchpoints for engagement and satisfaction.
PowerBI basics
Data cleaning
PowerQuery
Data loading
format conversion
title boost
2D to 1D
reverse perspective
fill down
Transpose
Merge and split
categorize
Fixed function
Modify M function
Batch summary Excel
Same as workbook
Excel import
single choice sheet
Delete navigation
Expand source data
Do not use original column names as prefixes
Delete other columns
different workbooks
Folder import
Delete other columns
Add custom columns
M function calls Excel data
Expand custom columns
Expand data
Delete other columns
Filter out titles
M function
Conceptual points
Format: called function package/class.function()
Main points
Each function call must have a function package/class
Capitalize the first letter when calling a function
{}List
[]record
Commonly used functions
Table
List
List.Sum()
List.Min()
List.Average()
Text
Text.Remove()
Text.Select()
Text.Length()
Text.Start()
Text.End()
Text.Trim() removes text spaces
other
{"A".."Z"}
{"A".."z"}
{"0".."9"}
{"一".."turtle"}
Extract data
Excel.Workbook()
Csv.Document()
conditional function
if then else
other
Advantages: Flexible, you need to learn to rewrite the M function
Help documentation: #shared
Data modeling
Establish an association
dimension table
list
metric
Can customize context
Calculated column
row context
Need to use CALCULATE to change the filter context
DAX
How to use
metric
Create new column
Create new table
basic grammar
'Table name'[field]
[metric]
Basic operations
shift enter to wrap and indent
alt enter newline without indentation
ctrl [indent left
ctrl ] indent right
important function
CALCULATE
(expression, filter1, filter2, ...)
Change context through filters and aggregate operations in expressions
return value
Row context can be automatically converted to filter context
Commonly used functions
FILTER
(table, filter condition)
Multi-condition filtering: && and, || or
Return table
Usually used as a filter for the CALCULATE function, tables that meet the filtering conditions are returned, and the CALCULATE function performs the aggregation operation of the first parameter.
ALL
Clear external context filtering
VALUES
Returns a unique list of a certain column, often used to build dimension tables from fact tables
Create filter
time intelligence function
There must be a complete and standardized date table: including dates throughout the year without repetition
date table
How to make a search date table in the public account PowerBI planet
VAR variable
VAR variable name=expression RETURN result expression
You can use VAR to define multiple variables, but only one RETURN
Improve code readability and computation
Interactive functions
Edit interaction
Select component
Format
Edit interaction
none
filter
highlight
Tooltips/Jumps
Edit a component page
Page format
Page information
Open tooltip
name
page size
type
tooltip
Select component
Format
tooltip
Type: report page
Page number: Tooltip
Drill
Structural drilldown
Drilling across reports
Button/shape jump
bookmark
Switch dynamic chart
parameter
Apply with metrics
Synchronized slicers
Select slicer
view
Synchronized slicers
Operation skills
Sort by column
Add number column
Auxiliary irregular sorting
Measurement value classification storage
1. Enter data
Create new table
Change naming
2.Move metric values
Change measure master table
Hide column 1
3.Measurements folder
model view
Select multiple measures
Enter folder name
Draggable measure values into
Secondary folder input: first-level folder\secondary folder