本书由资深数据分析师精心编写,循序渐进地介绍了Microsoft Power BI在数据建模和数据可视化中的应用。本书主要内容包括:Microsoft Power BI数据建模与数据可视化、相关分析及其视图、回归分析及其视图、聚类分析及其视图、时间序列及其视图、决策树及其视图、神经网络及其视图、社交网络及其视图、文本分析及其视图。全书以案例为主线,既包括软件应用与操作的方法和技巧,又融入了可视化的基础知识,使读者通过学习本书,能够轻松快速地掌握数据建模与可视化的方法与技巧。
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.000610s ]
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.000363s ]
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.000319s ]
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.000216s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.000433s ]
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.000244s ]
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.000196s ]
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.000166s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000370s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000237s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000423s ]
SELECT * FROM `ls_goods` WHERE `id` = 138204 AND `status` = 1 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `ls_goods` SET `click_count` = 89 , `update_time` = 1736607136 WHERE `id` = 138204 [ RunTime:0.000303s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 138204 LIMIT 1 [ RunTime:0.000232s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000150s ]
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.000268s ]
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.000292s ]
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.000231s ]
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.000276s ]
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.000171s ]
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.000175s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000228s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000207s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000137s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1736607076 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.187937s ]