本书由资深数据分析师精心编写,循序渐进地介绍了Microsoft Power BI在数据建模和数据可视化中的应用。本书主要内容包括:Microsoft Power BI数据建模与数据可视化、相关分析及其视图、回归分析及其视图、聚类分析及其视图、时间序列及其视图、决策树及其视图、神经网络及其视图、社交网络及其视图、文本分析及其视图。全书以案例为主线,既包括软件应用与操作的方法和技巧,又融入了可视化的基础知识,使读者通过学习本书,能够轻松快速地掌握数据建模与可视化的方法与技巧。
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.000931s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000666s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000536s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000379s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.001443s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000616s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000474s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000408s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000892s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000914s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.001640s ]
SELECT * FROM `ls_goods` WHERE `id` = 138204 AND `status` = 1 LIMIT 1 [ RunTime:0.000903s ]
UPDATE `ls_goods` SET `click_count` = 104 , `update_time` = 1763671181 WHERE `id` = 138204 [ RunTime:0.000778s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 138204 LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000622s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000694s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000574s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`is_show`,`is_recommend` FROM `ls_goods_category` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000462s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 1 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000773s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 2 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.000583s ]
SELECT `id`,`name`,`pid`,`image`,`level`,`link`,`module`,`is_show`,`is_recommend` FROM `ls_nav` WHERE `is_show` = 1 AND `del` = 0 AND `level` = 3 ORDER BY `sort` DESC [ RunTime:0.000607s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000582s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000758s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000486s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1763671121 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.294188s ]