Skip to main content

The 2021 Advanced Data Analyst Bundle for $29 October 29, 2020 at 02:00AM



Checkout Now

Expires October 30, 2120 06:59 PST
Buy now and get 93% off

Introduction to Python


KEY FEATURES

Data is king in the modern business world. Being able to harness, analyze, and draw insight from that data is one of the most sought-after skills in today’s job market. Enter Python - one of the most popular languages for data analysis and business intelligence. In this introductory course, we assume no prior knowledge and guide you through getting set up and started. With practice exercises and mini-projects to complete as you go through the course, you’ll quickly get to grips with this powerful programming language.

  • Access 67 lectures & 6 hours of content 24/7
  • Know what Python is & why it was created
  • Learn the basic data types in Python — Strings, Integers, Floats, & Boolean
  • Understand how Python fits into the diverse ecosystem of programming languages
  • Write your first script in Python

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Any device with basic specifications

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Advanced PivotTables


KEY FEATURES

In this Advanced PivotTables in Excel course, you'll learn how to make the most of this powerful data analysis function. PivotTables are ideal if you are looking to perform data analysis tasks quickly and efficiently in Excel. You'll get a PivotTable refresher and move onto some of the advanced features of this tool including Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting. This course is aimed at intermediate users of Excel who are comfortable using the PivotTable function.

4.7/5 average rating: ★ ★ ★ ★
  • Access 48 lectures & 7.5 hours of content 24/7
  • Do a PivotTable (a quick refresher)
  • Combine data from multiple worksheets for a PivotTable
  • Group, ungroup & deal with errors
  • Format a PivotTable, including adjusting styles
  • Use the Value Field Settings
  • Learn Advanced Sorting & Filtering in PivotTables
  • Use Slicers, Timelines on multiple tables
  • Create a Calculated Field
  • Learn all about GETPIVOTDATA
  • Create a Pivot Chart & add sparklines and slicers
  • Use 3D Maps from a PivotTable
  • Update your data in a PivotTable & Pivot Chart
  • Learn all about Conditional Formatting in a PivotTable
  • Create a basic macro to refresh PivotTable data
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Microsoft Excel 2016, 2019, 365
  • Intermediate knowledge of Microsoft Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Power BI


KEY FEATURES

Power BI is the powerful, Business Intelligence (BI) tool from Microsoft. Power BI is perfect for people with a limited technical background as it allows you to perform complex analysis in just a few clicks. This course will start by looking at Power Query, and how to use this tool to organize and clean our data. If you’ve used Power Query in Excel, then you’ll find it simple moving to Power BI. You will then move on to Data Models, DAX, charts, graphs, and more.

  • Access 45 lectures & 4 hours of content 24/7
  • Understand what Power BI is & why you should be using it
  • Import CSV & Excel files into Power BI Desktop
  • Use Merge Queries to fetch data from other queries
  • Create relationships between the different tables of the data model
  • Learn all about DAX including using the COUTROWS, CALCULATE, & SAMEPERIODLASTYEAR functions
  • Edit the interactions between your visualizations and filter at visualization, page, & report level
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: beginner

Requirements

  • Power BI Desktop
  • Good knowledge of MS Excel is helpful but not necessary

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Power Pivot, Power Query & DAX in Excel






KEY FEATURES

This advanced Excel course will look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases. You'll first learn how to bring your data together, merge, and clean it using Power Query. You'll then perform calculations on your data model using DAX, and finally, look at displaying your analysis using PivotTables and PivotCharts. This course also includes practice exercises and follow-along files so you can build your data models as you learn.

4.2/5 average rating: ★ ★ ★ ★
  • Access 47 lectures & 4 hours of content 24/7
  • Get started with Power Query
  • Connect Excel to multiple workbooks
  • Merge & append queries using Power Query
  • Set up & manage relationships in a data model
  • Create a PivotTable to display your data
  • Use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Microsoft Excel
  • Good understanding of MS Excel

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.

Advanced Excel 2019


KEY FEATURES

Get beyond the basics and supercharge your current skill level in Excel. With this 8-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis, and reporting of financial information.

4.4/5 average rating: ★ ★ ★ ★
  • Access 57 lectures & 8 hours of content 24/7
  • Learn advanced charting & graphing in Excel 2019
  • Use detailed formatting tools
  • Use lookup & advanced lookup functions
  • Know financial functions including calculating interest & depreciation
  • Connect to other workbooks & datasets outside of Excel
Note: Software NOT included.

PRODUCT SPECS

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Certificate of completion included
  • Redemption deadline: redeem your code within 30 days of purchase
  • Updates included
  • Experience level required: intermediate

Requirements

  • Access to Microsoft Excel 2019

THE EXPERT

StreamSkill.com
4.4/5 Instructor Rating: ★ ★ ★ ★

Stream Skill is part of the Simon Sez IT family and has been in business for 10+ years and taught over 400,000 students at that time. They've created over 90 software training courses, 5,000+ video tutorials, and have helped thousands of people across the world learn how to use Microsoft.




Checkout Now

Comments

Popular posts from this blog

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code - January 01, 2019 at 01:18AM

2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! Make 2019 the year you rise to your potential and achieve all your New Year resolutions, with the most popular courses from leading instructors, for as low as $9.99 each! *New Year’s Sale: Get Udemy courses for as low as $9.99 […] The post 2019’s Udemy *New Year’s Sale: Get Udemy courses for as low as $9.99 now! W/ Coupon code appeared first on CouponRim . from CouponRim https://cpr.im/2An4ERS

SyncMate 7: Lifetime Expert License for $14 January 02, 2019 at 02:00AM

Checkout Now Expires April 02, 2019 23:59 PST Buy now and get 71% off Checkout Now KEY FEATURES If you jump between Apple and non-Apple devices, you understand the hassle that is keeping your data synced across the board. That's why there's SyncMate, the ingenious tool that lets you synchronize data between your Mac and other devices all in a single, convenient application. From contacts and calendars to folders and iTunes, SyncMate makes it easy to keep all of your data synchronized, and with an Expert license, you'll enjoy even more syncing options, like automatic syncing, backups, and more. Keep your data in sync between your Mac & other platforms, including Android, iCloud and Dropbox Sync your Mac w/ multiple devices simultaneously Automatically keep data on your devices up to speed with Autosync Use hassle-free w/ invisible background syncing Sync your contacts, calendars, folders & more Seamlessly sync multimedia files in

$59 Lifetime access to Standuply’s Program Manager Plan - March 17, 2019 at 02:04PM

Checkout Now Standuply is a full-featured digital scrum master for Slack that automates asynchronous stand-up meetings via text, voice, and video and tracks team performance. Arrange asynchronous stand-ups on your own schedule via text, voice, and video Customize questions and determine schedule type — no more time zone confusion Sort through historical messages, track analytics, snooze questions,... More The post $59 Lifetime access to Standuply’s Program Manager Plan appeared first on CouponRim .