本书由资深数据分析师精心编写,循序渐进地介绍了Microsoft Power BI在数据建模和数据可视化中的应用。本书主要内容包括:Microsoft Power BI数据建模与数据可视化、相关分析及其视图、回归分析及其视图、聚类分析及其视图、时间序列及其视图、决策树及其视图、神经网络及其视图、社交网络及其视图、文本分析及其视图。全书以案例为主线,既包括软件应用与操作的方法和技巧,又融入了可视化的基础知识,使读者通过学习本书,能够轻松快速地掌握数据建模与可视化的方法与技巧。
SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.000670s ]
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.000532s ]
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.000588s ]
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.000490s ]
SHOW FULL COLUMNS FROM `ls_nav` [ RunTime:0.000821s ]
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.000494s ]
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.000472s ]
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.000392s ]
SHOW FULL COLUMNS FROM `ls_friendly_link` [ RunTime:0.000667s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000795s ]
SELECT * FROM `ls_goods` WHERE `id` = 138204 AND `status` = 1 LIMIT 1 [ RunTime:0.000546s ]
UPDATE `ls_goods` SET `click_count` = 172 , `update_time` = 1791628372 WHERE `id` = 138204 [ RunTime:0.000450s ]
SELECT `name`,`first_category_id`,`second_category_id` FROM `ls_goods` WHERE `id` = 138204 LIMIT 1 [ RunTime:0.001225s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.001023s ]
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.001159s ]
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.000539s ]
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.000467s ]
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.000425s ]
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.000481s ]
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.000424s ]
SELECT * FROM `ls_friendly_link` WHERE `is_show` = 1 AND `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000368s ]
SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.000720s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 10 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000765s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000764s ]
SELECT `id`,`name` FROM `ls_goods_category` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000299s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 11 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000493s ]
SELECT `a`.*,`ap`.`width`,`ap`.`height` FROM `ls_ad` `a` INNER JOIN `ls_ad_position` `ap` ON `a`.`pid`=`ap`.`id` WHERE `pid` = 14 AND `ap`.`client` = '2' AND `a`.`status` = '1' AND `a`.`del` = '0' AND `ap`.`status` = '1' AND `ap`.`del` = '0' ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000505s ]
SELECT * FROM `ls_goods` WHERE `del` = 0 AND `status` = 1 AND `create_time` <= 1791628312 ORDER BY `create_time` DESC LIMIT 5 [ RunTime:0.320598s ]