By Stream Skill | in Online Courses
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.
Important Details
Requirements
By Stream Skill | in Online Courses
This course will teach you the basics of this impressive programming language. It starts by introducing you to R, why it’s used by data scientists, and what it’s capable of. After that, you'll be set up in R Studio and show you how to prepare the R Workspace, and then launch into Data Types in R, Coding Style in R. It will also show you how to import data into R Studio from various file formats before launching into the essential R components - Vectors, Matrices, Arrays, Lists, Factors, Loops, Functions, Dataframes and so much more. The course ends with a mini-project where you'll pull everything you have learned together and set you an R Programming challenge.
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
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 teaches you 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. It will then show you how to build a Data Model and relate separate tables - this allows us to start to combine huge amounts of data. After that, it will teach you all about the powerful data analysis language DAX. Finally, you'll look at how to present this data using the huge number of charts and graphs available.
Important Details
Requirements
By Stream Skill | in Online Courses
A dashboard is a great way to visualize your data. An interactive dashboard allows you to change what results you see at the click of a button. This in-depth course will prepare your data for analysis, some essential formulas you’ll need to help you create dashboards in Excel, Pivot Tables, Pivot Charts, Form Controls and so much more. It takes you through how to combine all those skills to create a Sales Dashboard and an HR Dashboard in two, end of course projects. If you need to analyze and present data in Excel, then this course will show you step-by-step how to create jaw-dropping Excel dashboards that leave people wondering how you became that good in Excel!
Important Details
Requirements
By Stream Skill | in Online Courses
Qlik Sense is an amazing data visualization tool. In this comprehensive beginners course, we teach you how to become a Qlik Sense designer from scratch. You’ll start by learning how to load data into Qlik Sense, how to create stunning Qlik Sense apps, how to create and edit your first visualization, how to use the various charts, graphs, and tools available in Qlik Sense. After that, the course moves on to using scripting in Qlik Sense, numeric functions, string functions, date and time, and Geo Analytics. This comprehensive Qlik Sense course talks you through this analytics and Business Intelligence platform and will set you on your way to becoming a Qlik Sense designer.
Important Details
Requirements
By Stream Skill | in Online Courses
Microsoft Excel remains one of the best tools for Data Analysis. In this course, you'll learn the specific functions, formulas, and tools that Excel has to help conduct business or data analysis. You'll take a look at raw data, tools, functions, and advanced techniques. This course also includes practice exercises so you can immediately put into practice the new data analysis techniques that you learn.
Important Details
Requirements
By Stream Skill | in Online Courses
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 on to 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.
Important Details
Requirements
By Stream Skill | in Online Courses
There is no getting away from it. We now live in a world where data dominates. Decisions in business, government, the economy, which music to listen to or new shows to watch, it's all about data. Happily, there is a growing number of tools to help make sense of the volume of raw data now available. Alteryx is one of those. In this course, you'll get started with the Alteryx Designer and set you on a path to becoming an Alteryx developer. You don't need any previous knowledge of Alteryx to take this course. An intermediate to advanced Excel understanding is useful.
Important Details
Requirements