Udemyallen

Data Analysis by Excel, SQL, Python and Power BI

Learn Data Analysis & Business Analysis! Master data mining, wrangling & cleaning. Become a skilled data professional with this comprehensive course.

3.5(86)
283students
13h
Certificate
Sparky Academy
Sparky AcademyData Science

Course Content

Data Analysis by Excel, SQL, Python and Power BI is an all-levels Udemy course taught by Sparky Academy. It runs 13h, is taught in English, and includes a certificate of completion. Learners rate it 3.5 out of 5 from 86 reviews, with 283 students enrolled. It is a paid course, last updated October 2023.

Data analytics is a rapidly expanding field, and mastering key tools is essential for uncovering valuable insights. This comprehensive course provides a structured, step-by-step approach to data analysis, starting with the fundamentals and progressing to advanced techniques using industry-standard software. Gain practical skills through hands-on exercises and real-world examples to manipulate data, perform statistical analysis, and create impactful visualizations and dashboards.

What You'll Learn:

Excel for Data Analysis:

  • Excel Functions: Master essential Excel functions for powerful data analysis.
  • Fundamental Excel Concepts: Become proficient with sorting, filtering, statistical functions, and text manipulation.
  • PivotTable Slicers: Create interactive filters using PivotTable slicers for dynamic data exploration.
  • Time-Series Data Analysis: Analyze data trends over time with slicers and date-based filtering.
  • Data Connection Management: Refresh and update data connections to ensure your analysis is always current.
  • Data Combination: Combine data from multiple Excel workbooks and external sources.
  • External Data Analysis: Import and analyze data from various external datasets.
  • Data Visualization: Construct a wide variety of chart types (bar, line, pie, etc.) to effectively communicate your findings.
  • Chart Customization: Customize chart elements like titles, axes, and data labels for professional presentations.

SQL for Database Analysis:

  • SQL Queries: Learn to write SQL queries to efficiently retrieve data from databases for analysis.
  • Subqueries (Inner Queries): Understand and utilize subqueries for complex data retrieval.
  • Table Joins: Join tables to combine data from multiple sources.
  • SQL Commands: Master DDL, DML, and DQL commands for data manipulation.
  • Data Manipulation: Apply different conditions to datasets using SQL.
  • Case Study: Discover these concepts through a practical case study.

Python for Data Science:

  • Python Fundamentals: Grasp core Python concepts, including object-oriented programming.
  • Jupyter Notebooks: Become comfortable working with Jupyter Notebooks for interactive coding.
  • NumPy & Pandas: Introduction to the powerful NumPy and Pandas libraries for data manipulation and analysis.
  • Data Cleaning: Learn techniques for data cleaning and handling missing values.
  • Descriptive Statistics: Calculate and interpret descriptive statistics to understand your data.
  • Correlation Analysis: Analyze relationships between variables using correlation analysis.
  • Data Storytelling: Create compelling data visualizations with Matplotlib and Seaborn.
  • Hands-on Projects: Apply your skills through practical, hands-on projects.

Power BI for Business Intelligence:

  • Power BI Ecosystem: Understand the Power BI ecosystem and its capabilities.
  • Power BI Setup: Install and set up Power BI Desktop.
  • Power BI Interface: Navigate the Power BI interface with ease.
  • Data Transformation: Transform and clean data within Power BI.
  • Data Modeling: Learn data modeling basics for creating efficient data structures.
  • Data Visualization: Create simple visualizations like tables and charts.
  • Filters & Slicers: Utilize filters and slicers to interactively explore your data.
  • Interactive Reporting: Build interactive reports and dashboards to share insights.
  • Data Integration: Combine data from multiple sources into a single Power BI report.
  • Real-world Applications: Apply your skills to real-world business scenarios through hands-on projects.

Through practical exercises and engaging projects, you'll develop the skills to become a proficient data analyst. Enroll now and unlock the power of data!

$ whoami — the devs behind tutorialsearch.io

Want AI in your product? Hire the team behind TutorialSearch.io

LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.

5.0
53m
beginner
pluralsight
5.0
1h 28m
intermediate
pluralsight
5.0
2h 21m
expert
pluralsight
5.0(413)
3h 45m
beginner
skillshare