No cover art

[CourseClub NET] Lynda - Excel Business Intelligence Part 1 Power Query

Size
386 MB
Seeders
0
Leechers
1
Files
53
Category
Added
07/13/18 at 1:46am GMT+1
Infohash
fb313e1a4f539aa672366ac82547d029830f97c6

Description
[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.

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

Rating
Not rated yet
Log in to rate

Comments

No comments yet.