Data Analysis and Business Intelligence with Python & SQL [Free Online Course] - TechCracked

Practical Data Analytics & Business Intelligence with: SQL Matplotlib Python Excel Power BI Pandas

This course includes:

• 10.5 hours on-demand video
• 15 downloadable resources
• Access on mobile and TV
• Full lifetime access
• Closed captions
• Audio description in existing audio
• Certificate of completion

What you'll learn

• Core SQL - the INTO statement for creating new tables and using the CASE statement to compute new columns based on conditions
• Intermediate SQL - using window functions such as ROW_NUMBER, RANK, PARTITION, and learning running totals to increase the functionality of datasets
• Perform Data Analysis with Microsoft SQL
• Intermediate SQL - understanding the importance of subquerying, views, and variables in SQL data analysis as well as the importance of stored procedures
• Core SQL - the SQL interface, navigation, importing data for analysis

Description

In modern business environments, mastering big data analytics is no longer exclusive to highly compensated data scientists. It has become an indispensable skill across various professions.

If this seems overwhelming, rest assured. An expanding arsenal of data analytics tools is tailored for universal accessibility. In this high-value, comprehensive four-course Data Science Toolbox bundle, we delve into three pivotal tools: Microsoft Excel, Python programming, and Microsoft Power BI.

Individually, Microsoft Excel, Python programming, and Microsoft Power BI offer significant utility and power. Mastering all three provides profound insights into executing intricate data analytics tasks.

This Data Science Toolbox bundle caters to intermediate Microsoft Excel practitioners new to Python programming and Microsoft Power BI. Each course incorporates hands-on exercises enabling practical application of acquired knowledge.

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

Microsoft Power BI

What is Microsoft Power BI and why should you utilize it?

To import CSV and Excel files into Microsoft Power BI Desktop.

How to use Merge Queries for data retrieval from other queries.

How to establish relationships among various tables within the data model.

Comprehensive coverage of DAX functions like COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR.

Utilizing card visuals for creating summary information efficiently.

Employing additional visuals such as clustered column charts, maps, and trend graphs effectively.

Using Slicers for precise report filtering.

Implementing themes for swift and consistent report formatting.

Editing interactions among visualizations with filtering capabilities at visualization, page, and report levels.

The bundle covers essential topics such as data visualization techniques, statistical analysis, machine learning algorithms, and business intelligence strategies. By the end of the course, you'll be equipped with the skills to tackle real-world data challenges, perform predictive analytics, and create compelling data stories that resonate with stakeholders.

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

Also See : Python for Data Science: Python Programming & Data Analysis

Course is FREE for Limited Time Only!

Enroll Now