مسلسلات رمضان 2018 12 دراماBluRay مشاهدة مسلسل طريق الحلقة 4 اون لاين hd مشاهدة مسلسل... | Ayanna Berkshire | Star Trek III The Search For Spock 1984

[Lynda] Excel Business Intelligence Part 1: Power Query

  • Category Other
  • Type Tutorials
  • Language English
  • Total size 386.5 MB
  • Uploaded By CourseClub
  • Downloads 193
  • Last checked 41 minutes ago
  • Date uploaded 2 days ago
  • Seeders 8
  • Leechers 5

Infohash : FB313E1A4F539AA672366AC82547D029830F97C6



[Lynda] Excel Business Intelligence Part 1: Power Query

Microsoft Excel includes a powerful feature called Power Query—also known as Get & Transform or Get Data—which provides fast and powerful data gathering and cleansing capabilities. In this course—the first installment in the Excel Business Intelligenceseries—follow along with experienced Excel trainer Chris Dutton as he shows you the robust capabilities of Power Query. Chris kicks off the course by outlining the power Excel landscape and spelling out when to use business intelligence tools like Power Query, Power Pivot, and DAX.

Files:

[CourseClub.NET] Lynda - Excel Business Intelligence Part 1 Power Query 1.Introduction
  • 01.Welcome.en.srt (1.4 KB)
  • 01.Welcome.mp4 (16.3 MB)
2.1. Getting Started
  • 02.Important - Versions and compatibility.en.srt (5.6 KB)
  • 02.Important - Versions and compatibility.mp4 (11.4 MB)
  • 03.Download the course exercise files.en.srt (2.4 KB)
  • 03.Download the course exercise files.mp4 (3.7 MB)
  • 04.Set expectations.en.srt (3.1 KB)
  • 04.Set expectations.mp4 (5.0 MB)
3.2. Intro to the Power Excel Series
  • 05.The power Excel workflow.en.srt (6.7 KB)
  • 05.The power Excel workflow.mp4 (10.0 MB)
  • 06.The best thing to happen to Excel in 20 years.en.srt (15.1 KB)
  • 06.The best thing to happen to Excel in 20 years.mp4 (23.3 MB)
  • 07.When to use Power Query and Power Pivot in Excel.en.srt (1.2 KB)
  • 07.When to use Power Query and Power Pivot in Excel.mp4 (2.3 MB)
4.3. Power Query
  • 08.Power Query introduction.en.srt (0.9 KB)
  • 08.Power Query introduction.mp4 (2.5 MB)
  • 09.Meet Power Query aka Get & Transform.en.srt (4.7 KB)
  • 09.Meet Power Query aka Get & Transform.mp4 (7.3 MB)
  • 10.The Query Editor.en.srt (5.8 KB)
  • 10.The Query Editor.mp4 (8.9 MB)
  • 11.Options for loading data in Excel.en.srt (3.0 KB)
  • 11.Options for loading data in Excel.mp4 (4.3 MB)
  • 12.Basic Power Query table transformations.en.srt (14.5 KB)
  • 12.Basic Power Query table transformations.mp4 (24.9 MB)
  • 13.Text-specific query editing tools.en.srt (17.9 KB)
  • 13.Text-specific query editing tools.mp4 (32.0 MB)
  • 14.Number-specific query editing tools.en.srt (13.3 KB)
  • 14.Number-specific query editing tools.mp4 (23.2 MB)
  • 15.Date-specific query editing tools.en.srt (13.3 KB)
  • 15.Date-specific query editing tools.mp4 (22.5 MB)
  • 16.Create a rolling calendar with Power Query.en.srt (9.1 KB)
  • 16.Create a rolling calendar with Power Query.mp4 (13.7 MB)
  • 17.Add index and conditional columns with Power Query.en.srt (12.7 KB)
  • 17.Add index and conditional columns with Power Query.mp4 (21.6 MB)
  • 18.Group and aggregate data with Power Query.en.srt (11.4 KB)
  • 18.Group and aggregate data with Power Query.mp4 (18.9 MB)
  • 19.Modify Excel workbook queries.en.srt (7.7 KB)
  • 19.Modify Excel workbook queries.mp4 (12.4 MB)
  • 20.Merge queries.en.srt (13.7 KB)
  • 20.Merge queries.mp4 (22.6 MB)
  • 21.Append queries.en.srt (9.9 KB)
  • 21.Append queries.mp4 (16.8 MB)
  • 22.Connect Excel to a folder of files.en.srt (16.8 KB)
  • 22.Connect Excel to a folder of files.mp4 (27.7 MB)
  • 23.Excel Power Query best practices.en.srt (5.0 KB)
  • 23.Excel Power Query best practices.mp4 (7.5 MB)
  • 24.Pivot and unpivot data with Power Query.en.srt (16.0 KB)
  • 24.Pivot and unpivot data with Power Query.mp4 (23.7 MB)
5.Conclusion
  • 25.Next steps.en.srt (0.9 KB)
  • 25.Next steps.mp4 (2.0 MB)
Exercise Files
  • Ex_Files_Excel_Business_Intelligence_Part_1_Power_Query.zip (21.5 MB)
  • [CourseClub.NET].txt (1.2 KB)
  • [CourseClub.NET].url (0.1 KB)
  • [FreeCourseSite.com].txt (1.1 KB)
  • [FreeCourseSite.com].url (0.1 KB)

There are currently no comments. Feel free to leave one :)

Code:

  • udp://62.138.0.158:6969/announce
  • udp://87.233.192.220:6969/announce
  • udp://88.198.231.1:1337/announce
  • udp://151.80.120.113:2710/announce
  • udp://111.6.78.96:6969/announce
  • udp://90.179.64.91:1337/announce
  • udp://51.15.4.13:1337/announce
  • udp://191.96.249.23:6969/announce
  • udp://35.187.36.248:1337/announce
  • udp://123.249.16.65:2710/announce
  • udp://127.0.0.1:6969/announce
  • udp://210.244.71.25:6969/announce
  • udp://78.142.19.42:1337/announce
  • udp://173.254.219.72:6969/announce
  • udp://51.15.76.199:6969/announce
  • udp://91.212.150.191:3418/announce
  • udp://103.224.212.222:6969/announce
  • udp://92.241.171.245:6969/announce
  • udp://51.15.40.114:80/announce
  • udp://37.19.5.139:6969/announce