Get $1 credit for every $25 spent!

The Complete Big Data & Power BI Bundle

Ending In:
Add to Cart - $39.99
Add to Cart ($39.99)
$475
91% off
wishlist
Courses
5
Lessons
254
Enrolled
123

What's Included

Product Details

Access
Lifetime
Content
4.0 hours
Lessons
45

Power BI

Beginners Guide to Analyzing Data & Creating Beautiful Dashboards

By Stream Skill | in Online Courses

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.
StreamSkill.com | Simon Sez IT Family
4.4/5 Instructor Rating: ★ ★ ★ ★

The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious cultural institutions, LACMA. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In their first five years alone, we serviced hundreds of thousands of satisfied customers in over 100 countries.

445,863 Total Students 38,401 Reviews

Important Details

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

Requirements

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

Access
Lifetime
Content
4.0 hours
Lessons
47

Power Pivot, Power Query & DAX in Excel

Analyze Data at Scale with These Advanced Excel Functions

By Stream Skill | in Online Courses

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 w/ 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.
StreamSkill.com | Simon Sez IT Family
4.4/5 Instructor Rating: ★ ★ ★ ★

The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious cultural institutions, LACMA. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In their first five years alone, we serviced hundreds of thousands of satisfied customers in over 100 countries.

445,863 Total Students 38,401 Reviews

Important Details

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

Requirements

  • Microsoft Excel
  • Good understanding of MS Excel

Access
Lifetime
Content
8.0 hours
Lessons
57

Advanced Excel 2019

Delve Into High-Level Consolidation, Analysis & Financial Reporting

By Stream Skill | in Online Courses

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.
StreamSkill.com | Simon Sez IT Family
4.4/5 Instructor Rating: ★ ★ ★ ★

The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious cultural institutions, LACMA. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In their first five years alone, we serviced hundreds of thousands of satisfied customers in over 100 countries.

445,863 Total Students 38,401 Reviews

Important Details

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

Requirements

  • Access to Microsoft Excel 2019

Access
Lifetime
Content
7.5 hours
Lessons
59

Access 2019: Beginners

Start Your Database Journey by Learning the Fundamentals of MS Access 2019

By Stream Skill | in Online Courses

Microsoft Access remains a fantastic tool for when your data outgrows spreadsheets. Unlike many other database tools, it’s far more user-friendly and ideal if you’re not a developer. In this course, you'll learn from the very beginning and learn as you progress by building your project out. By the end of this Access 2019 course, you will have built out your database with proper functionality.

4.4/5 average rating: ★ ★ ★ ★

  • Access 59 lectures & 7.5 hours of content 24/7
  • Know where to start in Microsoft Access & whether to use a template or not
  • Modify Access to suit your needs
  • Learn all about importing data & the datasheet view
  • Understand how tables work in Access & how to create relationships between them
  • Set up validations & calculations using expressions in Access
Note: Software NOT included.
StreamSkill.com | Simon Sez IT Family
4.4/5 Instructor Rating: ★ ★ ★ ★

The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious cultural institutions, LACMA. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In their first five years alone, we serviced hundreds of thousands of satisfied customers in over 100 countries.

445,863 Total Students 38,401 Reviews

Important Details

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

Requirements

  • Microsoft Access 2019

Access
Lifetime
Content
7.0 hours
Lessons
46

Access 2019: Advanced

The Next Step to Supercharge Your Microsoft Access & Data Analysis Skills

By Stream Skill | in Online Courses

This Microsoft Access advanced course picks up where the beginner's course finished and dives straight into more advanced Access features. This course assumes you know the basics of Access, including how to set up your database, how tables work, how to create forms, and how to run simple queries. You will look at using ODBC and SQL Server and will learn about Macros and VBA in Access, splitting databases, and advanced form creation.

4.3/5 average rating: ★ ★ ★ ★

  • Access 46 lectures & 7 hours of content 24/7
  • Know about Primary Keys &d Indexes in Access
  • Customize & filter data on the Datasheet View
  • Link to other databases
  • Properly use ODBC & SQL Server
  • Split an Access database into front & back-end
  • Do basic VBA in Access including code & error handling
Note: Software NOT included.
StreamSkill.com | Simon Sez IT Family
4.4/5 Instructor Rating: ★ ★ ★ ★

The “IT” in Simon Sez IT stands for “Information Technology.” They offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon” Calder, Director of IT operations for one of Los Angeles’ most prestigious cultural institutions, LACMA. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That’s how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In their first five years alone, we serviced hundreds of thousands of satisfied customers in over 100 countries.

445,863 Total Students 38,401 Reviews

Important Details

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

Requirements

  • Microsoft Access 2019


Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.