请登录后使用此功能。 您可以使用此功能将商品添加到您的收藏列表。
关闭
您已经添加该商品到您的收藏列表。 查看我的收藏
关闭
从您收藏列表中删除此商品。
关闭
请登录后使用此功能。 您可以使用此功能将公司添加到您的收藏夹列表。
关闭
这家公司已成功添加。 查看我的收藏
关闭
这家公司已从你的收藏夹列表中删除。
关闭
请登录后使用此功能。 您可以使用此功能将公司添加到您的询问车。
关闭
这家公司已被添加到您的询问车。
关闭
这家公司已从询价车中删除。
关闭
该商品已被添加到您的询问车。
关闭
该商品已经从您的询价车中删除。
关闭
商品/公司已达到添加至询价车的数量。
关闭
Iconic Training Solutions Sdn Bhd
Iconic Training Solutions Sdn Bhd 1217801-A
营业
时间
星期一 - 星期五 8:30 AM - 6:00 PM
星期六 - 星期日 休息
我们在 公共假期休息
获取最新的
Iconic Training Solutions Sdn Bhd
应用程序 iOSAndroid
营业 休息
Featured Merchant
+60123980802
社交媒体链接
  • facebook
  • wordpress

18-Sep-2019

Mastering Microsoft Power Pivot & Power Query

Duration: 3 Days
Date: 25-27 November 2019
Time: 9am-5pm
Venue: SVOFO, Sunway Nexis Kota Damansara

Best Things That Power Pivot Brings to Excel

Unlike the traditional pivot table and Excel sheets, the user is limited to analyze data within a million row of data at a time, per table at a time (it is extremely slow). With the capability of Power Pivot, add-ins of Business Intelligent engine to Excel, it has since supercharged your excel into owning superpower to analyst more than a million rows of data (safely 100 million rows). Creating reports by connection to a relational data source(Multiple tables with relationship) created within excel using Power Pivot easily. With the fast performing processing engine, DAX(Data Analysis Expression) the functions used in Power Pivot allow users to customize any calculation whether to add in the calculated column or measure faster than ever.
 
Power Query is a very powerful tool that can help you find and connect to data from a wide variety of sources, from physical files to relational databases and even from the web. Perform and automate data cleansing and reshaping without having to do the same tedious work repeatedly. 

Course Outline:

Module 1 – Things you should know before getting into reporting

  • What to do when a big data bomb drops onto your hand?
  • ​How Excel behave when it comes to keeping too many unwanted, inconsistent and untidy data?

Module 2 – How to Build your first report with Pivot Table

  • 3 Steps in creating a report
  • Facelift the report
  • Organizing and sort out useful info
  • Using Pivot Table Value outside pivot table
  • Slicing and dicing data using Slicer and Timeline

Module 3 – Visualizing reports using Pivot Chart

  • Displaying the trends and comparison of data with Pivot Chart
  • Formatting Pivot Charts
  • How to use Pivot Chart to make the decisions easily

Module 4 – What is Power Pivot?

  • Difference in between Power Pivot and Pivot Table
  • Why should you use Power Pivot while analysing data.

Module 5 – Where should you begins with Power Pivot?

  • Import data from various sources
  • Why need to create relational database?
  • Why Power Pivot Better then Vlookup?

Module 6 – Adding calculated column using existing information from tables

  • How to use DAX function as faster calculation 
  • Define hierarchy
  • Differences in between Calculate Column and Measure

Module 7 – Say NO more to reporting routine

  • How to Create Reports by connecting to External Data Source
  • How to Create a report from multiple tables
  • How to Visualize Report
  • View dashboard base on latest updated data and by one click

Module 8 – What is Power Query?

  • How can it help to automate their tasks
  • Installing and enabling Power Query
  • Familiarize with Power Query Interface

Module 9 – How to loading and connect to different external data source?

  • Connect and load data from the internet
  • Getting data from Excel file
  • Extracting data from text files (.txt, .csv, etc)

Module 10 – Consolidating and merging all sources

  • How to Merging queries
  • How to Connecting all the files from the same folder
  • NO more traditional way of copy, cut and paste to gather all the sources into one place

Module 11 – Transforming and reshaping data

  • Editing Queries
  • Fixing data problem
  • Extracting date component with date time intelligent capability in Power Query

Module 12 – Loading and refreshing cleansed data

  • Loading transformed data into workbook
  • Load queries as connection only

Register online here -->> https://bit.ly/2m4SSqF

发信息至 Iconic Training Solutions Sdn Bhd
谢谢您的询问!
我们的客服会尽快联络您。
您的名字 *
您的公司名字
您的邮件 *
您的联络号码 *
标题 *
信息 *
验证码 *
总办事处

Iconic Training Solutions Sdn Bhd (1217801-A)
S1-30-12, D’sara Sentral, Jalan Welfare, Sungai Buloh, 40160, Shah Alam, Selangor, Malaysia.

电话:

邮件:
网址: http://www.iconictraining.com.my
网址: https://iconictraining.newpages.com.my/
网址: http://iconictraining.n.my/

1
Hello! Thanks for visiting my site. Please press Start button to Contact with Admin :)

Start

游览 : 首页 - 分类 - 公司 - 地区 - 标签 - 商品 - 消息与促销 - 工作征聘 - 手机版 - 谷歌 - 搜索引擎优化结果

All Shop List from NEWSTORE in Malaysia

  • MY 631
  • CN 260
  • US 160
  • RU 76
  • IE 23
  • UA 9
  • SG 7
  • IN 7
人 在线
Brochure
Download
Our PackageContact Us