Best Free Business Intelligence Courses

Find the best online Free Business Intelligence Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings.

Introduction to Databases and SQL Querying

A step by step introduction to the concept of Databases and Introduction to SQL Querying.

Created by Rakesh Gopalakrishnan - Over 260,000 Students

"]

Students: 379414, Price: Free

This is an introductory course on Databases and SQL Querying. There are no pre-requisities for this course. If you are looking to get acquainted with the concept of Databases and Queries for maybe your next interview as an analyst, this is the right course for you. All you need is a windows machine and we will walk through step by step, right from setting up your environment to creating your first table to writing your first query. This course is structured in a way that you can follow along with me. At the end of this course, you should be comfortable writing simple queries including queries related to Dates, String manipulation, Aggregation etc.

Foundations of Business Strategy

Foundations of Business Strategy introduces strategic analysis frameworks and their underlying theory.

Created by Michael Lenox - Slover Professor of Business - University of Virginia

"]

Students: 120752, Price: Free

A Faculty Project Course - Best Professors Teaching the World

Strategic analysis is critical for analyzing the competitive context in which an organization operates and for making reasoned and reasonable recommendations for how that organization should position itself and what actions it should take to maximize value creation. In this course, we will explore the underlying theory and frameworks that provide the foundations of a successful business strategy. Managers, entrepreneurs, social entrepreneurs, analysts, and consultants all may find value in mastering these fundamentals.

Power BI – The Ultimate Orientation

Business Intelligence and data is here to stay. Get your Orientation to Self Service BI with Power BI

Created by Paula Guilfoyle CPA & MVP - Microsoft MVP, CPA Accountant, & Life Long Learner

"]

Students: 66892, Price: Free

Business Intelligence and data are here to stay.  Now with Power BI by Microsoft, costs and skills are no longer a barrier to entry.

Power BI is a self service business intelligence system, and best of all, it is free for all to use. 

COURSE OVERVIEW

The aim of this course Power BI - The Ultimate Orientation is to give you a solid orientation of Power BI. First you will learn how to download and install power bi desktop.  We will have a look around the user interface and then we will start to work with some data.

Using an example data set, we will connect to both excel and cvs files and you will get an introduction of the Query editor as we do some transformation on the data.  Then we will move on to a few calculations and you will be introduced to the concept of relationships and dax. Finally in powerbi desktop we will look at the visualisations side.

After we look at visualisations in Power Bi Desktop we will move on to power Bi services.  Its in services that you will get insights, have the ability to share reports, build dashboards and connect to data packs that contains prebuilt dashboards and reports.

 We will not be looking at any of this in detail as, this course is an orientation course, designed to get you familiar and comfortable with the Power BI user interface.  The aim of the course is to get you up and running.  To show you that Power BI offers a real solution, and give you ideas of how it can be used.

Learn Tableau Desktop for Accurate Business Analysis

Hit the ground running with Tableau Desktop - develop 10 core skills for one of the fastest growing job markets in IT!

Created by Jane Crofts - Tableau Partner and Tableau Qualified Associate

"]

Students: 66043, Price: Free

Let's decide if this course is right for you.

  1. Have you recently started, or are you planning to start, using Tableau Desktop in your business?
  2. Are you looking to quickly build your skills in Tableau Desktop?
  3. Are you looking for Tableau Desktop skills that can be immediately put to use in analysing your business?

If you answered ‘yes’ to these questions, then this course is for you!

This course will give you the skills you need to jump straight in to using Tableau Desktop in your business.

Presented in a business context and working step-by-step through an instructor-led case study, this course goes beyond simply teaching the functions of Tableau Desktop. This course uses real-world business problems to give you 10 core skills that business users should have when using Tableau Desktop.

The 10 Tableau Desktop core skills covered by this course are:

    Bar & Line Charts

    Pie Charts

    Geographic Maps

    Scatter Plots

    Groups

    Area Charts

    Filters

    Dual Axis Charts

    Crosstabs and calculations

    Actions

An additional “Bonus Round” provides some more advanced skill development in formatting data, blending data, creating custom design elements and using responsive dashboard elements to build more sophisticated dashboards.

In addition to the video lectures and supporting notes, you will receive a range of workbooks and additional tools that you can use again and again. These tools and templates have been developed and tested over many years of consulting to organisations of all sizes using Tableau Desktop.

SAP BusinessObjects Business Intelligence – An Introduction

Information Design Tool (IDT) and Web Intelligence (WebI)

Created by Phillip Burton - Best Selling Instructor - over 340,000 students so far

"]

Students: 49401, Price: Free

In this course, we will Install SAP BusinessObjects programs, namely Information Design Tool (IDT) and Web Intelligence (WebI) - for free.

We will create a sample database in Access 2010 (although you may already have your own database that you want to use), and then create a database connection to it.

We will then create a "universe" in IDT, with a database Relational Connection, Data Foundation and Business Layer.

We will then export this universe from IDT and open it in WebI.

We will then create some tables and graphs.

This is a quick overview of these two programs, following which you will have the programs on your machine, and can experiment for yourself.

Power Pivot Workshop Beginner

Learn how to start using Power Pivot for Excel creating your own data models.

Created by Marco Russo - Business Intelligence expert at SQLBI - SSAS Maestro & MVP

"]

Students: 45049, Price: Free

The Beginner course introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics.

The course includes almost 3 hours of video in 30 lectures. You do not need any previous experience in Power Pivot to take this course.

Sections included in this course:

  • Introduction to Self-Service Business Intelligence
  • Introduction to Power Pivot
  • Loading Data
  • Data Modeling

After this course, we suggest you to take the Power Pivot Workshop Intermediate one.

What Is Business Analysis for Information Technology (IT)

An Overview of Business Analysis Activities and Current Business Analysis Techniques

Created by Tom and Angela Hathaway - BA-EXPERTS: Business Analysis for Anyone Wearing the BA Hat

"]

Students: 26710, Price: Free

Business Analysis in the Real World

A Buddhist proverb warns, “Be mindful of intention. Intention is the seed that creates our future.” In a very real sense, this statement expresses the reason for business analysis. This discipline is really all about choosing and defining a desired future because without intention (expressed in business analysis terms, “requirements”), no future is more or less desirable than another.

In reality, every organization does some form of business analysis whether it uses the term or not. For many (especially larger organizations), it is an extremely structured, managed process while others thrive on change and only do business analysis when and as needed. The perception that business analysis is only needed to develop IT solutions is inaccurate. Actually, it is a critical component of any change initiative within an organization whether software is involved or not.

Current Business Analysis Techniques and Methods

The course defines how business analysis is currently practiced. The authors provide insight into this fast-growing field by distinguishing strategic, tactical, and operational business analysis. It provides surveys of what Business Analysts really do and what business analysis techniques people use most often when they are the one “wearing the BA hat”. You will learn what “requirements” really are and what different types of requirements exist. Because many requirements define future information technology (IT) solutions, the authors share their experience on how Waterfall, Iterative, Agile, and Experimental (aka "Chaotic") Software Development methodologies impact the business analysis responsibility.

Who Needs Business Analysis Skills?

Although the field of Business Analysis offers great career opportunities for those seeking employment, some level of business analysis skill is essential for any adult in the business world today. Many of the techniques used in the field evolved from earlier lessons learned in systems analysis and have proven themselves to be useful in every walk of life. We have personally experienced how business analysis techniques help even in your private life.

We created this course for everyday people in the real world to give you a basic understanding of some core business analysis methods and concepts. If this course answers some of your questions, great. If it raises more questions than it answers (implying that it piqued your curiosity), even better. If it motivates you to learn more about this emerging and fascinating topic, it has served its purpose well.

SQL Crash Course : PostgreSQL for Beginners

SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) for Beginners

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 20462, Price: Free

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  2. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  3. SQL is one of the most sought-after skills by hiring employers.

  4. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What are the steps I should follow to learn SQL?

  1. Start learning from the basics of SQL. The first 10 sections of the course cover the basics.

  2. Once done with the basic try your hands on advanced SQL. Next 10 sections cover Advanced topics

  3. Next few sections will cover help you with interviews and Vivas.

  4. Practice your learning on the exercise provided in every section.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

What's special about this course?

The course is created on the basis of three pillars of learning:

  1. Know (Study)

  2. Do (Practice)

  3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.

Do

We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.

Bonus Lectures

Apart from this, their is a bonus section which covers important topics from the view of job interviews and Vivas.

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of SQL in today's corporate world.

SAP Lumira – Building Data Visualizations from Scratch

Your Guide to SAP Business Intelligence using the Lumira Tool to Generate Data Reports

Created by Dhruv Bais - Master Programmer and Machine Learning Robot

"]

Students: 17729, Price: Free

You are interested in learning SAP Lumira and getting into the wide realm of programming and intense Tech Entrepreneurship. You have probably wondered what is the most practical way of learning SAP Lumira (which to be frank, gives you the key to ruling the technology industry)

Since technology is changing every day, I have to learn something new every time. The best way that you can learn how to catch up is "to work on it".

Yet, nobody teaches in this manner and I suffer from the same pain when learning something new every time. Most courses are not designed to help you learn by example (immersion is the most potent way of learning in humans). Rather they bathe you with inapplicable information that you have to learn over and over again anyways.

This course is designed to cover all the basic concepts of SAP Lumira and the syntax necessary for learning the advanced topics in SAP Lumira. Even though SAP Lumira can open the door to working with SAP HANA, SAP FIORI, and SAP BASIS and basically everything else with the word "SAP" attached to it, it has some new functionality and nuances that you have to cover and learn.

My job is to make this class a great and fun learning experience so that I can help you progress though your path to learning advanced SAP (whether it be just programming logic...classes....backends (boring) or doing fun stuff like Data Dictionaries).

In this course, I will walk you though SAP Lumira Installation, and you will learn about data structures (we hear a lot about data, but how do we store it?),

However, only a few videos per section are focused on information. I develop the rest of the details of the data structures and syntax through exercises that I walk you through in the course. There are 2-3 lectures on solving tough exercises on each subject so that you can understand not only the syntax and how to the configure SAP Lumira, but also what the crux of SAP Functional is: POWER of SAP Lumira.

There is no risk for you as a student in this course. I have put together a course that is not only worth your money, but also worth your time. This course encompasses the basics of SAP Lumira finance and I urge you to join me on this journey to learn how to dominate the SAP world with the one of the most popular SAP Modules: SAP Lumira.

SQL for Data Analysis: Solving real-world problems with data

A simple & concise mySQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.

Created by Max SQL - Data and Insights Manager

"]

Students: 16662, Price: Free

Note on the Short Version of the Course

I have launched the course as a free, shortened version. It is an excellent introduction to the basics of handling data. Two points I want you to know:

1. The course so far is an in-depth view on a small & important part of SQL, rather than a light-touch overview of everything.

2. Technically, the full paid version is on the way. But I am finding it very difficult to find the time to complete the lessons (between other projects and work).

Therefore for those who need a comprehensive course now, I'd suggest signing up to a couple of courses now including this one while it's free. That way you can learn now but also enjoy all the additional lessons for free when they arrive.

Note on the Communicating

Udemy prevents instructors of Free courses from answering any questions from students. Therefore for now I cannot provide any feedback or respond to comments.

Summary

Forget the dry, old, textbook approach to learning code. Forget endlessly drilling syntax.

This course puts SQL in context and gets you solving real-world business problems from Day 1.

You'll play the role of a data analyst at Australia's largest fictional consumer bank, with a uniquely rich relational database at your fingertips. This context brings SQL to life and makes it easier for you to understand deeply and quickly.

With this new approach, you'll be surprised to see that SQL is fun and simple to learn. My course guarantee is that you'll go from zero to functional SQL coder within the weekend.

Best features in a nutshell

  • In plain English, with business context and fun analogies to explain the otherwise dry syntax.

  • Unique database, using a fictional bank relational database with incredibly rich transaction data to keep the course interesting and relevant.

  • Focuses deep on the absolute basics, to get you the strong foundations required for a data career.

  • Doesn’t cost money! If you sign up now while it’s free, you have lifetime free access, even as the course grows and becomes paid.

Read on for more detail

My story and building the course

My SQL learning experience was not ideal. When I started work I hadn’t the slightest idea what data was, let alone the power it brings to those who wield it skillfully. I took probably a year longer than necessary to master the SQL for data analytics. Even though I was practicing everyday on the job, I was slow to understand new concepts and struggled to remember new syntax.

Now as a full-time data analytics and insights manager, I have the hindsight to know it should have been much easier.

The main ingredients missing for me were:

  1. Structure

    1. What is important, what isn't, and why.

  2. Context

    1. Analogies, interesting examples, and plain English explanations. Bringing it to life!

So I’ve taken what was lacking in my learning experience and build a course around it. Specifically, here’s why my course stands out:

  • Structured

    • We learn what you need for on the job data analysis using SQL, no more less.

    • The topics are covered in an order that makes sense and helps you build on past learning.

    • You understand why each lesson is important, where it sits in the grand scheme of SQL.

  • In context

    • SQL shouldn’t have to be dry or boring, so I have used realistic business problems and analogies.

    • You’ll be playing the role of a data analyst at the largest fictional company in Australia, the Royal Bank of Australia, solving problems to drive sales, improve marketing reach, and manage customers.

    • Knowing why you’re learning the syntax, you’ll learn faster.

  • Hands on/practical

    • You’ll practice writing SQL in every single lesson.

We are going to have fun too, investigating cryptocurrency trading among customers, and even learning about Australian animals!

Why learn SQL?

Most successful companies today are data-driven.

  • They record every bit of information about their business (e.g. customers, sales).

  • They store that information (called data) in complex databases.

  • And they draw insights from the data to improve their business.

That’s where SQL comes in.

The only way to gather data and transform it into valuable business insights is to combine SQL and a smart analyst like you.

It's with SQL that companies know answers all sorts of where do my customers prefer to shop? Who was incorrectly charged fees? Why are sales going down?)

And as you may have noticed in the Promo, SQL is a great skill to build your career

Data careers, in data analysis (business analysis), data science, & data visualisation (business intelligence).

  1. SQL is needed to actually find and handle data in most organisations.

  2. The data handling and management skills learned via SQL are fundamental to understanding data in general, and are useful even if you don't use the SQL language (rare).

  3. Access to data can make you powerful in organisations. It's hard to argue with an analyst armed with well-prepped data and a solid numbers-based argument.

Marketing, product management, and tech sales:

  1. SQL (and the accompanying data skills) are a great way to stand out in marketing and product.

  2. Marketers and product managers propose changes to improve the business.

  3. Nowadays, any proposed change needs a strong case to support it.

  4. Data is the foundation of any strong business case.

  5. Therefore marketers and product managers with data skills can put together stronger cases, get more initiatives approved, and grow their career faster.

Why start with mySQL? mySQL is:

  • Very common, used by major companies and organisations across the world, such as Uber, Netflix, Spotify, and JPMorgan.

  • Free and easy to set up.

  • Similar to other forms of SQL like Microsoft SQL Server, PostGre SQL, Oracle SQL, Teradata SQL.

Become a Stronger and More Productive Business Analyst

Sharpening your business analysis skill set to produce high quality deliverables quickly and efficiently.

Created by Angelo Kalevela - Certified Business Analyst

"]

Students: 16451, Price: Free

A study done by IAG, has shown that only about half of major projects with average level business analysts succeed (56% to be exact). That number increases to 88% when skilled or above average business analysts are involved. Being average is not enough to get the job done anymore.

This course gives techniques and practice drills to help gain the most essential skills to quickly be an above average business analyst. Our goal isn't to develop every skill a business analyst should have; instead, I am to give you the most productive skills and the ability to use them in days instead of decades.

The purpose of this course is NOT to explain or walk you through all the different parts of what being a business analyst is. The purpose of this course is to give you skills that you can learn and use today that will make you a better business analyst tomorrow.

Note: When I say tomorrow, I do not mean next month or next year. I mean the day after today.

Knowledge Management Tools for SMEs

Learn about a variety of Knowledge Management Tools for SMEs and how they can enhance SMEs' performance.

Created by Dynamic SME - 

"]

Students: 14154, Price: Free

Target groups for this course on Knowledge Management (KM) tools for SMEs are students, practitioners from SMEs and SME support institutions, trainers, consultants, coaches and all other people interested in innovative SME management.

Various KM tools exist to manage knowledge effectively within a company. By bringing together all the information available in a systematic manner, knowledge is capable, when managed and utilized as an important organizational asset, to significantly augment people's output and efficiency.

The course on KM tools for SMEs will consist of eight sections and 24 lectures. The first section will serve as an introduction to the course including a short presentation concerning the course layout and the course objectives. Moreover, the first section shall give a general overview on the area of KM and various KM toolsets. After the lectures of the first section, a quiz has to be taken to test the basic concepts on KM toolkits.

Subsequent lectures will present each week one of the KM tools: Competence Matrix, International Communication, Lessons Learned, Idea Competitions, Business Intelligence and finally Knowledge Market.

The sections covering the KM tools each consist of one video, a written documentation on how to implement the respective tool. Subsequently, a case study is presented at the end, in which students see how this tool can be applied in practice. External resources or downloadable material for further reading will be provided. Quizzes will test the participants know how.

KM is particularly of great importance for SMEs as they are stronger influenced by increasing global competition, fast shifts in technology, economic uncertainties, times of instability and market turbulences than bigger enterprises.

In this respect, offering valuable information about KM tools can help SMEs to understand, evaluate and apply these tools into their daily routine and in particular during turbulent times.

Six Figure Career Plan – Land Your Dream Job in Technology

Achieve a high paying & rewarding profession in Information Technology and start your path towards a six figure career!

Created by Perry Underdown - Instructor, Director, Digital Transformation

"]

Students: 10922, Price: Free

Every month in the United States, hundreds of thousands of high paying Information Technology jobs go unfilled.

There are not nearly enough trained workers to fill the available roles, which is ridiculous because most of these lucrative positions can be achieved without huge amounts of education.

The Technology Profession Six Figure Career Plan will provide a concise, focused and achievable program that will empower you to transition to your new lucrative IT career, often in as little as six months. This program will empower you to achieve a lucrative, rewarding, scalable, and stable career in Information Technology in the shortest possible time.

Our program will provide you with a quick and comprehensive overview of the great opportunities related to a career in Information Technology.

The goal is to help you quickly identify and train for your new career while ensuring that you are set up for success.

Business Requirements Document for Beginner Business Analyst

Recommended for the Beginner BA Who Speaks English as a Second Language

Created by Miriam Halberstam - Business Analyst/Online Content Developer

"]

Students: 9036, Price: Free

This is a concise course that simplifies the creation of a Business Requirements

Document (BRD) for a project in Information Technology. BRD requirements are

sketched and defined in 2 steps: 1) the first step - Part One - identifies the 6 key project

areas for a project that is not IT-related; and 2) the second step - Part Two - describes the

6 key project areas for an IT project.  

Colorful graphics animate the text, and quizzes based on real-life scenarios engage

the student in the processes of Business Analysis. A final exercise guides the student

in selecting requirements for his/her first BRD.

The course includes a glossary of IT-related terms.  

Power BI Dashboard Step by Step

Business Intelligence, Data Connectiion, Power Query Basic, Creating Visuals, DAX, Dashboards.

Created by Asif Hafeez - Microsoft Certified Trainer | MCSA (BI Reporting)

"]

Students: 8299, Price: Free

Try not to become a man of success, but rather try to become a man of value. – Albert Einstein

Data analysis is an exciting field to get into and the career prospects are amazing. You don’t need to be a math/computer science/coding whiz to land a job in data analysis.

Data Analysis in demand and we normally use Excel to create beautiful Charts and Graphs to show the results. But Power BI is the ultimate choice to prepare quick Reports and Dashboards and easy to understand that is the reason it has become the first choice of a Data Analysis.

In this Course I will teach you to create some beautiful Dashboards/Reports by simple techniques in few minutes. Power BI was generally made available in 2015 and by the time it is has become the Leader in the market for Business Intelligence (source: Gartner Report).

WHAT YOU WILL LEARN

  • Simple methods to prepare Power BI Dashboards

  • Quick way to create Reports and Dashboards

PREREQUISITES

  • Basic Excel Knowledge

WHO THIS COURSE IS FOR?

  • Power BI beginners

  • Data Analyst

  • Dashboards lovers

  • Business Intelligence professionals

Gold Nuggets For Business & Life, Experience-Based Learning

Collection of my Business & Life's experiences and business intelligence over the past several decades

Created by Nasser Lukmani - Businessman and Deal Maker

"]

Students: 7203, Price: Free

NOTE:  IF YOU ARE IN A STRICTLY TECHNICAL FIELD SUCH AS IT AND HAVE NO INTEREST DIVERSIFYING, THIS COURSE IS NOT FOR YOU.  THIS COURSE IS FOR PEOPLE WHO WANT TO SUCCEED IN BUSINESS AND LIFE BY HONING THEIR SOFT SKILLS.

Welcome to my course, Gold Nuggets For Business & Life, Experience-Based Learning based on my Business Intelligence

In this course, I have shared with you my decades of business and life's experiences which has honed my business intelligence.  While most courses concentrate on hard skills such as creating a massive Excel sheet, few courses teach the soft skills necessary to succeed in business and life.

This is my collection of decades of learning and business intelligence in the professional and personal worlds through short and focused videos in a no-nonsense clear format.  Being a business savvy individual, I believe that you will be able to fine-tune your personality and behavior to position yourself for success and acquire the business intelligence you need to succeed. 

These teachings are, in some ways more important in life than whipping out a massive Excel sheet.  I hope you are able to extract value from the course which it has.  Those who are not wired for this learning, will move on in search of that illusive magic pill.  Don't dismiss the content.  There is no question this is valuable content.  I am always here to help you succeed.   If you have any questions or need assistance in your ventures, please feel free to reach out to me.  Good luck.

Business Intelligence Development using Python 3

Automate and build a marketing data and user behaviour pipeline.

Created by Christoph Odermatt - Data manager

"]

Students: 6532, Price: Free

Interested in automating your marketing pipeline or your business intelligence? Then this is your course! Learn how to relieve yourself of repetitive work by programming it. All this in less than 2 hours!

There are many Business Intelligence, Python beginners or Data Analytics courses out there. I combine these subjects to create a course that connects and automates your Data tracking tools to your Business Intelligence tool.

We will Extract real-life data from Google Analytics and Facebook with Python and Transform these data points into a useful format and then Load them to Google Sheets => ETL (Extract, Transform, Load)

Python is the best language to automate these processes and will be used in this course. This course is truly step-by-step as we made the course so you can code along with us. We extract data from 4 different sources and then use those data points to be able to decide on our future business strategy. And all is done through live examples. I am using my previous teaching experience as a lecturer to create this easy to understand course.

As a bonus, this course includes all the Python code templates we created for you to download and use on your own projects.

I and my team are constantly available to support you in your learning and to answer questions.

I'll see you on the inside!

Yours sincerely,

Christoph Odermatt

What are the requirements?

  • A minimum understanding of any computer language and some marketing experience.
  • Any computer running Mac, Windows, or Linux, all is shown on a Mac.
  • All the tools used in the course are free, except for your Marketing you are using.
  • Preferably you already have data from your Marketing on Facebook or Google AdWords.
  • And passion to learn.

What am I going to get from this course?

  • Understand a Data Pipeline, Marketing Analytics, Data Automation and the basics of Data Engineering.
  • Learn how to use Python Libraries to create your data automation process.
  • How to make powerful analysis.
  • Create strong added value to your business. This will help you for your next job interview or your Performance Review and salary negotiations.

Create a Sales Dashboard in Google Data Studio

Learn how to leverage Business Intelligence to Visualize your Data in a more Meaningful Way

Created by Dobromir Dikov - FCCA, FMVA

"]

Students: 1868, Price: Free

There's an ever-growing demand for financial analysts with a sound understanding of Business Intelligence in today's world.

This course will teach you the fundamentals of Google Data Studio, one of the best free data visualization platforms!

You will start with an empty report and then learn how to link Data Sources. We will look at essential elements and the interface and build a full Sales Dashboard, much like the ones financial analysts prepare in their daily job!

What you'll get out of this course?

In the Create a Sales Dashboard in Google Data Studio course, I will guide you through the most common functions and elements of Google Data Studio and show you the practical process of creating your reports and dashboards, step by step. We will define a clear structure and build our project, which you can reuse repeatedly. I will help you understand the main principles of Business Intelligence, which you can then apply in any data visualization software.

After you take the Create a Sales Dashboard in Google Data Studio course, you will have a solid understanding of functions and principles applied within Business Intelligence. This will allow you to add benefit to your workplace by preparing insightful reports for the company's management. Or, if you have your own business, this knowledge will help you analyze your data in a more meaningful way, supporting your strategy and decision-making.

What should you know to take the course?

As long as you understand that profit is what's left of sales, after deducting the cost of sales, you are all set to follow along! No prerequisite knowledge is required for this course.

What do you need to follow along?

You need access to Google Sheets and Google Data Studio, which you can get with a free Gmail account.

Who is this course for?

I made the Create a Sales Dashboard in Google Data Studio course to serve as a practical guide on how Business Intelligence concepts are applied in real companies. The course is most suitable for:

  • Junior financial analysts;

  • Business owners and entrepreneurs who want to know more about their company;

  • Students in Finance and Accounting majors who wish to get a head start.

I hope you are ready to upgrade yourself, learn how to create your own Business Intelligence reports, and propel in your career!

Are you excited to start?

Then enroll in the course, and I'll see you in class!

Basic Course on Financial Intelligence

Financial Intelligence with insights of Guru Chanakya

Created by Rahul Jain - Educator and Entrepreneur

"]

Students: 1701, Price: Free

Financial intelligence is required in all fields of the business. Most decisions taken by various managers/executives are in fact financial decisions. Sales manager should have awareness about the financials so that she can make decisions about discounts, credit terms etc. A decision as to the levels of stock to be maintained by the stores manager is a financial decision. Marketing manager should know about the product profitability to decide about the marketing campaigns. An HR decision as to the kind of people to recruit as per

the business priorities is also a financial decision.

So what is financial intelligence ?

Financial intelligence for business is understanding of how financial success is measured and how they have an impact on the company’s performance. For example we need to know the difference between profit and cash. Need to know why the balance sheet balances. The numbers neither scare nor mystify us.

Do you know that one of the major reasons of failure of the organization is

lack of financial intelligence ?

It may sound strange but probability that a company listed in Fortune 100 in 1960 is still listed is just 17%.  Greater financial intelligence, we’ve learned, helps people feel more involved and committed. They understand better what they are a part of, What the organization is trying to achieve, and how they affect results. Trust increases, turnover decreases, and financial results improve.

AI foundations for business professionals

A code-free intro to artificial intelligence, ML, & data science for professionals, marketers, managers, & executives

Created by Marshall Lincoln - Chief Data Scientist, FluentInAI.com | Teaching AI literacy

"]

Students: 1145, Price: Free

Full course outline:

---

Module 1: Demystifying AI

Lecture 1

  • A term with any definitions

  • An objective and a field

  • Excitement and disappointment

Lecture 2: 

  • Introducing prediction engines

  • Introducing machine learning

Lecture 3

  • Prediction engines

  • Don't expect 'intelligence' (It's not magic)

Module 2: Building a prediction engine

Lecture 4: 

  • What characterizes AI? Inputs, model, outputs

Lecture 5:

  • Two approaches compared: a gentle introduction

  • Building a jacket prediction engine

Lecture 6:

  • Human-crafted rules or machine learning?

Module 3: New capabilities... and limitations

Lecture 7

  • Expanding the number of tasks that can be automated

  • New insights --> more informed decisions

  • Personalization: when predictions are granular... and cheap

Lecture 8:

  • What can't AI applications do well?

Module 4: From data to 'intelligence

Lecture 9

  • What is data?

  • Structured data

  • Machine learning unlocks new insights from more types of data

Lecture 10

  • What do AI applications do?

  • Predictions and automated instructions

  • When is a machine 'decision' appropriate?

Module 5: Machine learning approaches

Lecture 11

  • Three definitions

Machine learning basics

Lecture 12

  • What's an algorithm?

  • Traditional vs machine learning algorithms

  • What's a machine learning model?

Lecture 13

  • Machine learning approaches

  • Supervised learning

  • Unsupervised learning

Lecture 14

  • Artificial neural networks and deep learning

Module 6: Risks and trade-offs

Lecture 15:

  • Beware the hype

  • Three drivers of new risks

Lecture 16

  • What could go wrong? Potential consequences

Module 7: How it's built

Lecture 17

  • It's all about data

Oil and data: two similar transformations

Lecture 18

  • The anatomy of an AI project

  • The data scientist's mission

Module 8: The importance of domain expertise

Lecture 19:

  • The skills gap

  • A talent gap and a knowledge gap

  • Marrying technical sills and domain expertise

Lecture 20: What do you know that data scientists might not?

  • Applying your skills to AI projects

  • What might you know that data scientists' not?

  • How can you leverage your expertise?

Module 9: Bonus module: Go from observer to contributor

Lecture 21

  • Go from observer to contributor