<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[chichi_magic的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/chichi_magic</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; chichi_magic]]></copyright><item><title><![CDATA[Python - 异常处理、模块和包]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/125400837</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/125400837</guid><author>chichi_magic</author><pubDate>Sat, 12 Nov 2022 18:33:15 +0800</pubDate><description><![CDATA[Python - 异常处理、模块和包]]></description><category></category></item><item><title><![CDATA[误差逆传播算法（BP算法）5]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/127822846</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/127822846</guid><author>chichi_magic</author><pubDate>Sat, 12 Nov 2022 18:28:25 +0800</pubDate><description><![CDATA[误差逆传播算法（BP算法），详细推导更新公式的过程]]></description><category></category></item><item><title><![CDATA[数理统计：样本及抽样分布7]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/127096627</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/127096627</guid><author>chichi_magic</author><pubDate>Wed, 28 Sep 2022 22:33:32 +0800</pubDate><description><![CDATA[数理统计：样本及抽样分布]]></description><category></category></item><item><title><![CDATA[大数定律及中心极限定理6]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126907148</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126907148</guid><author>chichi_magic</author><pubDate>Mon, 19 Sep 2022 22:40:06 +0800</pubDate><description><![CDATA[大数定律及中心极限定理]]></description><category></category></item><item><title><![CDATA[随机变量的数字特征5]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126824469</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126824469</guid><author>chichi_magic</author><pubDate>Thu, 15 Sep 2022 23:48:42 +0800</pubDate><description><![CDATA[随机变量的数字特征]]></description><category></category></item><item><title><![CDATA[多维随机变量及其分布4]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126810487</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126810487</guid><author>chichi_magic</author><pubDate>Mon, 12 Sep 2022 22:50:29 +0800</pubDate><description><![CDATA[多维随机变量及其分布]]></description><category></category></item><item><title><![CDATA[随机变量的分布函数3]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126793841</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126793841</guid><author>chichi_magic</author><pubDate>Sat, 10 Sep 2022 17:31:38 +0800</pubDate><description><![CDATA[随机变量及其分布]]></description><category></category></item><item><title><![CDATA[离散型随机变量及其分布律2]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126786164</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126786164</guid><author>chichi_magic</author><pubDate>Sat, 10 Sep 2022 09:14:13 +0800</pubDate><description><![CDATA[随机变量及其分布]]></description><category></category></item><item><title><![CDATA[（熟记理解背诵推导）概率论与数理统计的基础知识1]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/126679481</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/126679481</guid><author>chichi_magic</author><pubDate>Tue, 06 Sep 2022 22:15:27 +0800</pubDate><description><![CDATA[背诵熟练]]></description><category></category></item><item><title><![CDATA[怎么下手写SQL？]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/125590688</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/125590688</guid><author>chichi_magic</author><pubDate>Sun, 03 Jul 2022 23:01:06 +0800</pubDate><description><![CDATA[怎么下手写SQL？]]></description><category></category></item><item><title><![CDATA[DAX圣经学习笔记2 - 关于表的基础知识]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/125375884</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/125375884</guid><author>chichi_magic</author><pubDate>Mon, 20 Jun 2022 17:53:11 +0800</pubDate><description><![CDATA[DAX]]></description><category></category></item><item><title><![CDATA[Python - 基础]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/125175890</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/125175890</guid><author>chichi_magic</author><pubDate>Thu, 09 Jun 2022 01:06:44 +0800</pubDate><description><![CDATA[列表为复习快速清单，每一个序号代表一天复习的内容。]]></description><category></category></item><item><title><![CDATA[DAX圣经学习笔记1 - 常用函数]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/124721865</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/124721865</guid><author>chichi_magic</author><pubDate>Thu, 12 May 2022 00:01:21 +0800</pubDate><description><![CDATA[DAX]]></description><category></category></item><item><title><![CDATA[Power BI Paginated Reports分页报表]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122747863</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122747863</guid><author>chichi_magic</author><pubDate>Sat, 29 Jan 2022 23:03:25 +0800</pubDate><description><![CDATA[为什么有时候使用分页报表，不直接使用power bi的报表。在SQL Server Reporting Services(SSRS)里就有分页报表的功能。

分页报表最适合需要为打印或 生成 PDF形式的，高度格式化、像素输出的场景。

Power BI报表则是互动和探索数据应用场景。

目录

一、使用介绍

二、Paginated Report

2.1 数据源、数据集和参数

2.1.1 连接数据源

2.1.2 连接数据集

2.2 数据可视化

2.2.1 画表格

2.2.2 迷你图、指标、条件]]></description><category></category></item><item><title><![CDATA[Power BI 数据建模 Best practice]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122734166</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122734166</guid><author>chichi_magic</author><pubDate>Fri, 28 Jan 2022 18:48:09 +0800</pubDate><description><![CDATA[目录

1、两种方式减少数据集大小和刷新时间

2、数据建模


1、两种方式减少数据集大小和刷新时间


在使用PBI里面带有的Performance Analyzer，会发现DAX query和visual花费的时间已经在可行范围内少了很多，Others的时间是背景加载和依赖其他视图加载时间，所以也无法再优化。这时可以使用下面两种方式，尽可能减少数据集大小和数据集刷新时间。

1.1 勾选掉Auto date/time

最好是在新加载文件下勾选掉，不建议在Global选项下勾选掉。有时会有一些隐藏的.]]></description><category></category></item><item><title><![CDATA[Power BI Service Administration服务管理学习目录]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122710991</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122710991</guid><author>chichi_magic</author><pubDate>Thu, 27 Jan 2022 01:05:43 +0800</pubDate><description><![CDATA[目录

1. Power BI Licensing Options

2. Deployment

3. Sharing and Collaboration

3.1 Creating App Workspaces

3.2 Discovering Workspaces

3.3 Power BI Apps

4. Data Gateway

4.1 Overview

4.2 Installation

4.3 Configuration

4.4 DirectQuery and Live Connect]]></description><category></category></item><item><title><![CDATA[DAX学习目录]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122710985</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122710985</guid><author>chichi_magic</author><pubDate>Thu, 27 Jan 2022 01:00:46 +0800</pubDate><description><![CDATA[目录

1. Data Modeling Basics

2. DAX Basics

3. Creating Calculated Columns

4. Navigation Functions

5. Conditional and Logical Functions

6. Creating Calculated Measures

7. Time Intelligence

7.1 Overview

7.2 Creating Time Intelligence Calculations

8. ]]></description><category></category></item><item><title><![CDATA[Power BI学习目录]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122710889</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122710889</guid><author>chichi_magic</author><pubDate>Thu, 27 Jan 2022 00:50:38 +0800</pubDate><description><![CDATA[目录

1. Data discovery with Power BIdesktop

2. Transforming data

2.1 Basic transform2.2 Add column from example

2.3 Appending queries

2.4 Merging queries

2.5 Combine files

2.6 Reading and understanding M

2.7 Writing basic M

2.8 Parameters and templ.]]></description><category></category></item><item><title><![CDATA[DAX学习笔记]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122659211</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122659211</guid><author>chichi_magic</author><pubDate>Wed, 26 Jan 2022 00:17:01 +0800</pubDate><description><![CDATA[学习地址：https://www.youtube.com/watch?v=QJw4HkagVWc


一、什么是DAX


Data Anlysis Expressions， Power BI, Power Pivot， SSAS Tabular语言


二、Day 1

目录

1、DAX FundamentalsDAX 基础

2、DAX Evaluation Context理解上下文

3、Time Series Analysis时间序列分析

4、Semi-Additive Measure复....]]></description><category></category></item><item><title><![CDATA[DAX Studio学习笔记_2]]></title><link>https://blog.youkuaiyun.com/chichi_magic/article/details/122658122</link><guid>https://blog.youkuaiyun.com/chichi_magic/article/details/122658122</guid><author>chichi_magic</author><pubDate>Sun, 23 Jan 2022 23:02:59 +0800</pubDate><description><![CDATA[你的模型中有什么？消耗了多少空间？每一列有什么？

学习地址：PowerBI.Tips - Tutorial - Model Performance Tuning in DAX Studio - By Marco Russo - YouTube

系列文章

DAX Studio学习笔记_1_chichi_magic的博客-优快云博客



目录

系列文章

一、使用

1、View Metrics

2、Export Metrics

3、Load Perf Data

一、使用

1、View Me]]></description><category></category></item></channel></rss>