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.
Important Details
Requirements
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.
Important Details
Requirements
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.
Important Details
Requirements
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.
Important Details
Requirements
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.
Important Details
Requirements