Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Expired

Data Analysis and Business Intelligence with Python & SQL

FREE $19.99 GET THIS DEAL

Requirements

  • Computer and internet access required
  • Basic knowledge of excel advised but not mandatory
  • No need to even have SQL Server downloaded in advance, as we’ll show you how to get it installed for free!
  • None – we will walk you through from an absolute beginner level! No prior knowledge of SQL or PowerBI required

Description

In business, being able to understand, harness, and use data is no longer a skill reserved for a handful of well-paid analysts. It’s becoming an essential part of many roles.

If that sounds daunting, don’t worry. There is a growing set of tools designed to make data analysis accessible to everyone, in this huge-value, four-course Data Analysts Toolbox bundle we look in detail at three of those tools: Excel, Python, and Power BI.

In isolation Excel, Python, and Power BI are useful and powerful. Learn all three and you are well on your way to gaining a much deeper understanding of how to perform complex data analysis.

This Data Analysts Toolbox bundle is aimed at intermediate Excel users who are new to Python and Power BI. All courses include practice exercises so you can put into practice exactly what you learn.


What Can SQL do?

  • SQL can execute queries against a database
  • SQL can retrieve data from a database
  • SQL can insert records into a database
  • SQL can update records in a database
  • SQL can delete records from a database
  • SQL can create new databases
  • SQL can create new tables in a database
  • SQL can create stored procedures in a database
  • SQL can create views in a database
  • SQL can set permissions on tables, procedures, and views

    Power BI

  • What is Power BI and why you should be using it?
  • To import CSV and Excel files into Power BI Desktop.
  • How to use Merge Queries to fetch data from other queries.
  • How to create relationships between the different tables of the data model.
  • All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.
  • All about using the card visual to create summary information.
  • How to use other visuals such as clustered column charts, maps, and trend graphs.
  • How to use Slicers to filter your reports.
  • How to use themes to format your reports quickly and consistently.
  • How to edit the interactions between your visualizations and filter at visualization, page, and report level.

Who this course is for:

  • For those who are interested in Data Analytics and a gateway into Data Science
  • Beginner Business Intelligence Analyst
  • Students who are willing to put in a couple of hours to learn about analytics
  • For those who are new and curious about SQL & Power BI
  • Beginner Data Scientist
Affiliate Disclaimer
This post may have affiliate link & we may get small commission if you make a purchase
Freebies Global
Logo