Companies Home Search Profile

Data Analysts Beginner Projects

Focused View

Bluelime Learning Solutions

9:32:46

19 View
  • 001 Introduction.mp4
    00:20
  • 002 What is Python.mp4
    05:16
  • 003 Installing Python on Windows.mp4
    03:38
  • 004 Installing Python on Macs.mp4
    05:28
  • 005 Installing Python On Linux.mp4
    06:40
  • 006 Create a virtual environment on Windows.mp4
    04:22
  • 007 Activate a virtual environment on Windows.mp4
    01:31
  • 008 Create a virtual environment on Macs.mp4
    04:45
  • 009 Activate a virtual environment on Macs.mp4
    02:03
  • 010 Create a virtual environment on Linux.mp4
    04:38
  • 011 Activate a virtual environment on Linux.mp4
    02:08
  • 012 What is Jupyter Notebook.mp4
    01:20
  • 013 Install Jupyter notebook.mp4
    06:45
  • 014 Running Jupyter Notebook Server.mp4
    08:44
  • 015 Create a new notebook.mp4
    06:45
  • 016 Jupyter Notebook Dashboard.mp4
    04:20
  • 017 Text Editor.html
  • 018 Install Visual Studio Code.mp4
    06:00
  • 001 Create a basic house value estimator.mp4
    11:17
  • 002 Using Scikit-learn.mp4
    08:41
  • 003 Loading dataset Part 1.mp4
    08:29
  • 004 Loading dataset Part 2.mp4
    03:05
  • 005 Prediction Analysis part 1.mp4
    07:46
  • 006 Prediction Analysis part 2.mp4
    03:45
  • 001 What is Web Scraping.mp4
    04:24
  • 002 What we will scrape.mp4
    04:04
  • 003 Create and activate a virtual environment.html
  • 004 Install Beautiful soup.mp4
    05:49
  • 005 Build a web scraping script Part 1.mp4
    06:35
  • 006 Build a web scraping script Part 2.mp4
    06:35
  • 007 Prototyping the script Part 1.mp4
    06:23
  • 008 Prototyping the script Part 2.mp4
    04:06
  • 009 Prototyping the script Part 3.mp4
    07:02
  • 010 Prototyping the script Part 4.mp4
    06:36
  • 011 Prototyping the script Part 5.mp4
    11:37
  • 012 Scraping data.mp4
    06:26
  • 001 Using Kaggle Datasets.mp4
    03:06
  • 002 Tabular Data.mp4
    08:00
  • 003 Exploring Pandas DataFrame.mp4
    02:20
  • 004 Manipulating Pandas DataFrame.mp4
    12:57
  • 005 Cleaning Data.mp4
    22:42
  • 006 Qualitative data.mp4
    12:00
  • 007 Quantitative data.mp4
    13:49
  • 001 What is Data Visualization.mp4
    02:35
  • 002 What is Tableau.mp4
    04:13
  • 003 What is Tableau Public Desktop.mp4
    01:17
  • 004 Tableau Online.mp4
    02:38
  • 005 Tableau Public Desktop Overview Part 1.mp4
    06:36
  • 005 World-Bank-CO2.xlsx
  • 006 Tableau Public Desktop Overview Part 2.mp4
    08:49
  • 007 Connecting to data source.mp4
    03:25
  • 008 Join related data sources.mp4
    09:03
  • 009 Join data sources with inconsistent fields.mp4
    06:27
  • 010 Data Cleaning.mp4
    06:27
  • 011 Reordering Visuaization.mp4
    04:14
  • 012 Change Summary.mp4
    02:54
  • 013 Split text into multiple columns.mp4
    04:21
  • 014 Presenting data using stories.mp4
    06:18
  • 001 What is SQL Server.mp4
    02:57
  • 002 What is SQL.mp4
    04:32
  • 003 Download SQL Server.mp4
    04:31
  • 004 Install SQL Server.mp4
    09:43
  • 005 SQL Server Editions.mp4
    04:45
  • 006 Install SSMS.mp4
    05:48
  • 007 Connect SSMS to SQL Server.mp4
    07:46
  • 008 Download Sample Database.mp4
    06:28
  • 009 Create database.mp4
    00:32
  • 001 Data Preparation.mp4
    08:36
  • 002 Importing Datasets into database.mp4
    07:31
  • 002 Queries-to-test-new-tables.txt
  • 003 How many continents do we have data for.mp4
    04:52
  • 003 How-many-continents-do-we-have-covid-data-for.txt
  • 003 List-all-continents-without-duplicates-values.txt
  • 004 What is possibility of dying from COVID.mp4
    06:38
  • 005 What percentage of population is infected with COVID.mp4
    05:00
  • 006 What countries has highest COVID infection per population.mp4
    05:40
  • 006 highest-Covid-infection.txt
  • 007 Countries-with-highest-death.txt
  • 007 What countries has the highest deaths from COVID.mp4
    04:58
  • 008 What continent has highest deaths from COVID.mp4
    02:50
  • 008 continents-with-highest-death-counts.txt
  • 009 What are the global COVID cases and death.mp4
    03:23
  • 009 total-covid-cases-total-covid-death.txt
  • 010 Total-Vacinnated.txt
  • 010 What number of people have been vaccinated against COVID.mp4
    10:13
  • 011 Analysing data with SQL CTE.mp4
    05:43
  • 011 USING-cte-in-sql-server.txt
  • 012 Using temporary tables for data.mp4
    06:17
  • 012 Using-temp-table.txt
  • 013 Using Views for data.mp4
    03:45
  • 013 Using-Views-in-SQL-Server.txt
  • 001 What is Power BI.mp4
    05:47
  • 002 What is Power BI Desktop.mp4
    03:40
  • 003 Install Power BI Desktop.mp4
    02:55
  • 004 Explore Power BI Interface.mp4
    05:02
  • 001 AccessDatabasePowerBI.zip
  • 001 Importing Microsoft Access Database File.mp4
    12:58
  • 002 Change the Locale.mp4
    01:47
  • 003 Connect to data source.mp4
    07:09
  • 004 Power Query Editor and Queries.mp4
    06:49
  • 005 Creating and managing query groups.mp4
    04:35
  • 006 Renaming queries.mp4
    04:54
  • 007 Splitting Columns.mp4
    07:06
  • 008 Changing data types.mp4
    05:47
  • 009 Removing and reordering columns.mp4
    06:54
  • 010 Duplicating and adding columns.mp4
    03:31
  • 011 Creating conditional columns.mp4
    06:18
  • 012 Connecting to files in a folder.mp4
    07:17
  • 013 Appending queries.mp4
    06:58
  • 014 Merge queries.mp4
    05:35
  • 015 Query dependency view.mp4
    04:32
  • 016 Multi-Level-Spreadsheet.xlsx
  • 016 Transform less structured data.mp4
    09:10
    • 012 International
        International
      • CA Sales.csv
      • DE Sales.csv
      • FR Sales.csv
      • MX Sales.csv

    Description


    Gain Real World Data Analyst Skills by building a data analytics portfolio

    What You'll Learn?


    • Perform data exploration and analysis with SQL
    • Write SQL Queries to explore and analyse data
    • Write SQL CTE queries to extract and query data
    • Write SQL temporary table queries to extract and query data
    • Perform data exploration & manipulation with Pandas & Python
    • Transform Data with Power BI
    • Create visualizations with Tableau
    • Scrape data from websites
    • Perform prediction analysis
    • Visualize Qualitative data
    • Visualize quantitative data
    • Present data using stories

    Who is this for?


  • Beginner Data Analyst
  • Beginner Data Engineers
  • Beginner Data Scientist
  • What You Need to Know?


  • Basic knowledge of Excel advised
  • Basic knowledge of SQL advised
  • More details


    Description

    Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

    Data analysts are in high demand across all sectors, such as finance, consulting, manufacturing, pharmaceuticals, government and education.

    The ability to pay attention to detail, communicate well and be highly organised are essential skills for data analysts. They not only need to understand the data, but be able to provide insight and analysis through clear visual, written and verbal communication.



    Some responsibilities of a data analyst includes:


    • Developing records management processes and policies

    • identify areas to increase efficiency and automation of processes

    • set up and maintain automated data processes

    • identify, evaluate and implement external services and tools to support data validation and cleansing

    • produce and track key performance indicators

    • develop and support reporting processes

    • monitor and audit data quality

    • liaise with internal and external clients to fully understand data content

    • gather, understand and document detailed business requirements using appropriate tools and techniques

    • design and carry out surveys and analyse survey data

    • manipulate, analyse and interpret complex data sets relating to the employer's business

    • prepare reports for internal and external audiences using business analytics reporting tools

    • create data dashboards, graphs and visualisations

    • provide sector and competitor benchmarking

    • mine and analyse large datasets, draw valid inferences and present them successfully to management using a reporting tool




    If you’re getting ready to launch a new career as a data analyst, chances are you’ve encountered an age-old dilemma. Job listings ask for experience, but how do you get experience if you’re looking for your first data analyst job?

    This is where your portfolio comes in. The projects you include in your portfolio demonstrate your skills and experience—even if it’s not from a previous data analytics job—to hiring managers and interviewers. Populating your portfolio with the right projects can go a long way toward building confidence that you’re the right person for the job, even without previous work experience.

    As an aspiring data analyst, you’ll want to demonstrate a few key skills in your portfolio. These data analytics project ideas reflect the tasks often fundamental to many data analyst roles.

    The hands on projects covered in this course includes :


    Web scraping

    While you’ll find no shortage of excellent (and free) public data sets on the internet, you might want to show prospective employers that you’re able to find and scrape your own data as well. Plus, knowing how to scrape web data means you can find and use data sets that match your interests, regardless of whether or not they’ve already been compiled.

    We will use  Python and  tools like Beautiful Soup to crawl the web for interesting data.


    Data cleaning

    A significant part of your role as a data analyst is cleaning data to make it ready to analyze. Data cleaning (also called data scrubbing) is the process of removing incorrect and duplicate data, managing any holes in the data, and making sure the formatting of data is consistent.   We will perform  some practical data cleaning .


    Exploratory data analysis (EDA)


    Data analysis is all about answering questions with data. Exploratory data analysis, or EDA for short, helps you explore what questions to ask. This could be done separate from or in conjunction with data cleaning. Either way, you’ll want to accomplish the following during these early investigations.   We will undertake a data exploration project in this course.


    Data Analysis & Transformation


    We will  also perform some data analysis and transformation


    Data Visualization


    Data visualization is an important aspect of data analysis.   As a data analyst you should be able to present

    data in a visual way that will help businesses make important decisions.


    Who this course is for:

    • Beginner Data Analyst
    • Beginner Data Engineers
    • Beginner Data Scientist

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Category
    Bluelime Learning Solutions
    Bluelime Learning Solutions
    Instructor's Courses
    Bluelime is UK based and creates quality easy to understand  eLearning  solutions .All our courses are 100% video based. We teach hands –on- examples  that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 97
    • duration 9:32:46
    • English subtitles has
    • Release Date 2024/01/31