IBM Data Science Professional Certificate

 

What you'll learn

Master the most up-to-date practical skills and knowledge that data scientists use in their daily roles

Learn the tools, languages, and libraries used by professional data scientists, including Python and SQL

Import and clean data sets, analyze and visualize data, and build machine learning models and pipelines

Apply your new skills to real-world projects and build a portfolio of data projects that showcase your proficiency to employers

Join Free: IBM Data Science Professional Certificate

Professional Certificate - 10 course series

Prepare for a career in the high-growth field of data science. In this program, you’ll develop the skills, tools, and portfolio to have a competitive edge in the job market as an entry-level data scientist in as little as 5 months. No prior knowledge of computer science or programming languages is required. 

Data science involves gathering, cleaning, organizing, and analyzing data with the goal of extracting helpful insights and predicting expected outcomes. The demand for skilled data scientists who can use data to tell compelling stories to inform business decisions has never been greater. 

You’ll learn in-demand skills used by professional data scientists including databases, data visualization, statistical analysis, predictive modeling, machine learning algorithms, and data mining. You’ll also work with the latest languages, tools,and libraries including Python, SQL, Jupyter notebooks, Github, Rstudio, Pandas, Numpy, ScikitLearn, Matplotlib, and more.

Upon completing the full program, you will have built a portfolio of data science projects to provide you with the confidence to excel in your interviews. You will also receive access to join IBM’s Talent Network where you’ll see job opportunities as soon as they are posted, recommendations matched to your skills and interests, and tips and tricks to help you stand apart from the crowd. 

This program is ACE® and FIBAA recommended —when you complete, you can earn up to 12 college credits and 6 ECTS credits.

Applied Learning Project

This Professional Certificate has a strong emphasis on applied learning and includes a series of hands-on labs in the IBM Cloud that give you practical skills with applicability to real jobs.

Tools you’ll use: Jupyter / JupyterLab, GitHub, R Studio, and Watson Studio

Libraries you’ll use: Pandas, NumPy, Matplotlib, Seaborn, Folium, ipython-sql, Scikit-learn, ScipPy, etc.

Projects you’ll complete:

Extract and graph financial data with the Pandas Python library

Use SQL to query census, crime, and school demographic data sets

Wrangle data, graph plots, and create regression models to predict housing prices with data science Python libraries

Create a dynamic Python dashboard to monitor, report, and improve US domestic flight reliability

Apply and compare machine learning classification algorithms to predict whether a loan case will be paid off or not

Train and compare machine learning models to predict if a space launch can reuse the first stage of a rocket

Read More

Prepare for DP-100: Data Science on Microsoft Azure Exam

 

What you'll learn

Outline the key points covered in the Data Science on Microsoft Azure Exam course

Describe best practices for preparing for the Exam DP-100: Designing and Implementing a Data Science Solution on Azure

Demonstrate proficiency in the skills measured in the DP-100: Designing and Implementing a Data Science Solution on Azure

Join Free: Prepare for DP-100: Data Science on Microsoft Azure Exam

There are 6 modules in this course

Microsoft certifications give you a professional advantage by providing globally recognized and industry-endorsed evidence of mastering skills in digital and cloud businesses.​​ In this course, you will prepare to take the DP-100 Azure Data Scientist Associate certification exam. 

You will refresh your knowledge of how to plan and create a suitable working environment for data science workloads on Azure, run data experiments, and train predictive models. In addition, you will recap on how to manage, optimize, and deploy machine learning models into production.

You will test your knowledge in a practice exam​ mapped to all the main topics covered in the DP-100 exam, ensuring you’re well prepared for certification success.

You will also get a more detailed overview of the Microsoft certification program and where you can go next in your career. You’ll also get tips and tricks, testing strategies, useful resources, and information on how to sign up for the DP-100 proctored exam. By the end of this course, you will be ready to sign-up for and take the DP-100 exam.​

This is the fifth course in a five-course program that prepares you to take the DP-100: Designing and Implementing a Data Science Solution on Azure certification exam.

The certification exam is an opportunity to prove knowledge and expertise operate machine learning solutions at a cloud-scale using Azure Machine Learning. This specialization teaches you to leverage your existing knowledge of Python and machine learning to manage data ingestion and preparation, model training and deployment, and machine learning solution monitoring in Microsoft Azure. Each course teaches you the concepts and skills that are measured by the exam. 

This Specialization is intended for data scientists with existing knowledge of Python and machine learning frameworks like Scikit-Learn, PyTorch, and Tensorflow, who want to build and operate machine learning solutions in the cloud. It teaches data scientists how to create end-to-end solutions in Microsoft Azure. Students will learn how to manage Azure resources for machine learning; run experiments and train models; deploy and operationalize machine learning solutions, and implement responsible machine learning. They will also learn to use Azure Databricks to explore, prepare, and model data; and integrate Databricks machine learning processes with Azure Machine Learning.

Read More

Microsoft Azure Data Engineering Associate (DP-203) Professional Certificate

 

Advance your career with in-demand skills

Receive professional-level training from Microsoft

Demonstrate your technical proficiency

Earn an employer-recognized certificate from Microsoft

Prepare for an industry certification exam

Join Free: Microsoft Azure Data Engineering Associate (DP-203) Professional Certificate

Professional Certificate - 10 course series

This Professional Certificate is intended for data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure. 

This Professional Certificate will help you develop expertise in designing and implementing data solutions that use Microsoft Azure data services. You will learn how to integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. 

This program consists of 10 courses to help prepare you to take Exam DP-203: Data Engineering on Microsoft Azure. Each course teaches you the concepts and skills that are measured by the exam. 

By the end of this Professional Certificate, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure.

Applied Learning Project

Learners will engage in interactive exercises throughout this program that offers opportunities to practice and implement what they are learning. They use the Microsoft Learn Sandbox. This is a free environment that allows learners to explore Microsoft Azure and get hands-on with live Microsoft Azure resources and services.

For example, when you learn about integrating, transforming, and consolidating data; you will work in a temporary Azure environment called the Sandbox or directly in the Azure Portal. The beauty about this is that you will be working with real technology but in a controlled environment, which allows you to apply what you learn, and at your own pace.

You will need a Microsoft account. If you don't have one, you can create one for free. The Learn Sandbox allows free, fixed-time access to a cloud subscription with no credit card required. Learners can safely explore, create, and manage resources without the fear of incurring costs or "breaking production".

Read More

Data Engineering with MS Azure Synapse Apache Spark Pools

 

What you'll learn

How to perform data engineering with Azure Synapse Apache Spark Pools to boost the performance of big-data analytic applications

How to ingest data using Apache Spark Notebooks in Azure Synapse Analytics

How to transform data using DataFrames in Apache Spark Pools in Azure Synapse Analytics

How to monitor and manage data engineering workloads with Apache Spark in Azure Synapse Analytics

Join Free: Data Engineering with MS Azure Synapse Apache Spark Pools

There are 3 modules in this course

In this course, you will learn how to perform data engineering with Azure Synapse Apache Spark Pools, which enable you to boost the performance of big-data analytic applications by in-memory cluster computing.

You will learn how to differentiate between Apache Spark, Azure Databricks, HDInsight, and SQL Pools and understand the use-cases of data-engineering with Apache Spark in Azure Synapse Analytics. You will also learn how to ingest data using Apache Spark Notebooks in Azure Synapse Analytics and transform data using DataFrames in Apache Spark Pools in Azure Synapse Analytics. You will integrate SQL and Apache Spark pools in Azure Synapse Analytics. You will also learn how to monitor and manage data engineering workloads with Apache Spark in Azure Synapse Analytics.

This course is part of a Specialization intended for Data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services for anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure (beta). You will take a practice exam that covers key skills measured by the certification exam.

This is the sixth course in a program of 10 courses to help prepare you to take the exam so that you can have expertise in designing and implementing data solutions that use Microsoft Azure data services. The Data Engineering on Microsoft Azure exam is an opportunity to prove knowledge expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. Each course teaches you the concepts and skills that are measured by the exam. 

By the end of this Specialization, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure (beta).

Read More

Experimental Design Basics

 

What you'll learn

By the end of this course, you will be able to:

Approach complex industrial and business research problems and address them through a rigorous, statistically sound experimental strategy

Use modern software to effectively plan experiments

Analyze the resulting data of an experiment, and communicate the results effectively to decision-makers.

Join Free: Experimental Design Basics

There are 5 modules in this course

This is a basic course in designing experiments and analyzing the resulting data. The course objective is to learn how to plan, design and conduct experiments efficiently and effectively, and analyze the resulting data to obtain objective conclusions. Both design and statistical analysis issues are discussed. Opportunities to use the principles taught in the course arise in all aspects of today’s industrial and business environment. Applications from various fields will be illustrated throughout the course.  Computer software packages (JMP, Design-Expert, Minitab) will be used to implement the methods presented and will be illustrated extensively. 

All experiments are designed experiments; some of them are poorly designed, and others are well-designed. Well-designed experiments allow you to obtain reliable, valid results faster, easier, and with fewer resources than with poorly-designed experiments. You will learn how to plan, conduct and analyze experiments efficiently in this course.

Read More

Design of Experiments Specialization

 

What you'll learn

Plan, design and conduct experiments efficiently and effectively, and analyze the resulting data to obtain valid objective conclusions.

Use response surface methods for system optimization as a follow-up to successful screening.

Use experimental design tools for computer experiments, both deterministic and stochastic computer models.

Use software tools to create custom designs based on optimal design methodology for situations where standard designs are not easily applicable.

Join Free: Design of Experiments Specialization

Specialization - 4 course series

Learn modern experimental strategy, including factorial and fractional factorial experimental designs, designs for screening many factors, designs for optimization experiments, and designs for complex experiments such as those with hard-to-change factors and unusual responses. There is thorough coverage of modern data analysis techniques for experimental design, including software.  Applications include electronics and semiconductors, automotive and aerospace, chemical and process industries, pharmaceutical and bio-pharm, medical devices, and many others.

You can see an overview of the specialization from Dr. Montgomery here.

Applied Learning Project

Participants will complete a project that is typically based around their own work environment, and can use this to effectively demonstrate the application of experimental design methodology. The structure of the course and the step-by-stem process taught in the course is designed to ensure participant success.

Read More

Getting Started with Data Analytics on AWS

 

What you'll learn

Explain different types of data analyses – descriptive, diagnostic, predictive, prescriptive

Understand how to perform descriptive data analytics in the cloud with typical data sets

How to build simple visualizations in AWS QuickSight to do descriptive analytics (using S3, Cloudtrail, Athena)

Join Free: Getting Started with Data Analytics on AWS

There is 1 module in this course

Learn how to go from raw data to meaningful insights using AWS with this one-week course. Throughout the course, you’ll learn about the fundamentals of Data Analytics from AWS experts.

Start off with an overview of different types of data analytics techniques - descriptive, diagnostic, predictive, and prescriptive before diving deeper into the descriptive data analytics. Then, apply your knowledge with a guided project that makes use of a simple, but powerful dataset available by default in every AWS account: the logs from AWS CloudTrail. The CloudTrail service enables governance, compliance, operational auditing, and risk auditing of your AWS account. Through the project you’ll also get an introduction to Amazon Athena and Amazon QuickSight. And, you’ll learn how to build a basic security dashboard as a simple but practical method of applying your newfound data analytics knowledge.

Read More

Survey Data Collection and Analytics Specialization

 

Advance your subject-matter expertise

Learn in-demand skills from university and industry experts

Master a subject or tool with hands-on projects

Develop a deep understanding of key concepts

Earn a career certificate from University of Michigan

Join Free: Survey Data Collection and Analytics Specialization

Specialization - 7 course series

This specialization covers the fundamentals of surveys as used in market research, evaluation research, social science and political research, official government statistics, and many other topic domains. In six courses, you will learn the basics of questionnaire design, data collection methods, sampling design, dealing with missing values, making estimates, combining data from different sources, and the analysis of survey data. In the final Capstone Project, you’ll apply the skills learned throughout the specialization by analyzing and comparing multiple data sources.

Faculty for this specialisation comes from the Michigan Program in Survey Methodology and the Joint Program in Survey Methodology, a collaboration between the University of Maryland, the University of Michigan, and the data collection firm Westat, founded by the National Science Foundation and the Interagency Consortium of Statistical Policy in the U.S.  to educate the next generation of survey researchers, survey statisticians, and survey methodologists. In addition to this specialization we offer short courses, a summer school, certificates, master degrees as well as PhD programs. 

Read More

Applied Data Science with Python Specialization

 

What you'll learn

Conduct an inferential statistical analysis

Discern whether a data visualization is good or bad

Enhance a data analysis with applied machine learning

Analyze the connectivity of a social network

Join Free: Applied Data Science with Python Specialization

Specialization - 5 course series

The 5 courses in this University of Michigan specialization introduce learners to data science through the python programming language. This skills-based specialization is intended for learners who have a basic python or programming background, and want to apply statistical, machine learning, information visualization, text analysis, and social network analysis techniques through popular python toolkits such as pandas, matplotlib, scikit-learn, nltk, and networkx to gain insight into their data.

Introduction to Data Science in Python (course 1), Applied Plotting, Charting & Data Representation in Python (course 2), and Applied Machine Learning in Python (course 3) should be taken in order and prior to any other course in the specialization.  After completing those, courses 4 and 5 can be taken in any order.  All 5 are required to earn a certificate.

Read More

Introduction to AI in the Data Center

 

What you'll learn

What is AI and AI use cases, Machine Learning, Deep Leaning, and how training and inference happen in a Deep Learning Workflow.

The history and architecture of GPUs,  how they differ from CPUs, and how they are revolutionizing AI.    

Become familiar with deep learning frameworks, AI software stack, and considerations when deploying AI workloads on a data center on prem or cloud.

Requirements for multi-system AI clusters and considerations for infrustructure planning, including servers, networking, storage and tools. 

Join Free: Introduction to AI in the Data Center

There are 4 modules in this course

Welcome to the Introduction to AI in the Data Center Course!

As you know, Artificial Intelligence, or AI, is transforming society in many ways. 

From speech recognition to improved supply chain management, AI technology provides enterprises with the compute power, tools, and algorithms their teams need to do their life’s work. 

But how does AI work in a Data Center? What hardware and software infrastructure are needed? 

These are some of the questions that this course will help you address. 

This course will cover an introduction to concepts and terminology that will help you start the journey to AI and GPU computing in the data center. 

You will learn about:

* AI and AI use cases, Machine Learning, Deep Learning, and how training and inference happen in a Deep Learning Workflow. 

* The history and architecture of GPUs,  how they differ from CPUs, and how they are revolutionizing AI.

* Deep learning frameworks, AI software stack, and considerations when deploying AI workloads on a data center on prem, in the cloud, on a hybrid model, or on a multi-cloud environment. ​ 

* Requirements for multi-system AI clusters​​, considerations for infrastructure planning, including servers, networking, and storage and tools for cluster management, monitoring and orchestration. 

This course is part of the preparation material for the NVIDIA Certified Associate - ”AI in the Data Center” certification. 

This certification will take your expertise to the next level and support your professional development.

Who should take this course?

* IT Professionals

* System and Network Administrators

* DevOps

* Data Center Professionals

No prior experience required.

This is an introduction course to AI and GPU computing in the data center. 

To learn more about NVIDIA’s certification program, visit: 

https://academy.nvidia.com/en/nvidia-certified-associate-data-center/

So let's get started!

Read More

Scripting with Python and SQL for Data Engineering

 

What you'll learn

Extract data from different sources and map it to Python data structures.

Design Scripts to connect and query a SQL database from within Python.

Apply scraping techniques to read and extract data from a website.

Join Free:Scripting with Python and SQL for Data Engineering

There are 4 modules in this course

In this third course of the Python, Bash and SQL Essentials for Data Engineering Specialization, you will explore techniques to work effectively with Python and SQL. We will go through useful data structures in Python scripting and connect to databases like MySQL. Additionally, you will learn how to use a modern text editor to connect and run SQL queries against a real database, performing operations to load and extract data. Finally, you will use extracted data from websites using scraping techniques. These skills will allow you to work effectively when data is not readily available, or when spatial queries are required to extract useful information from databases.

Read More

Data Engineering Foundations Specialization

 

What you'll learn

Working knowledge of Data Engineering Ecosystem and Lifecycle. Viewpoints and tips from Data professionals on starting a career in this domain.

Python programming basics including data structures, logic, working with files, invoking APIs, using libraries such as Pandas and Numpy, doing ETL.

Relational Database fundamentals including Database Design, Creating Schemas, Tables, Constraints, and working with MySQL, PostgreSQL & IBM Db2.

SQL query language, SELECT, INSERT, UPDATE, DELETE statements, database functions, stored procs, working with multiple tables, JOINs, & transactions.

Join Free:Data Engineering Foundations Specialization

Specialization - 5 course series

Data engineering is one of the fastest-growing tech occupations, where the demand for skilled data engineers far outweighs the supply. The goal of data engineering is to make quality data available for fact-finding and data-driven decision making. This Specialization from IBM will help anyone interested in pursuing a career in data engineering by teaching fundamental skills to get started in this field. No prior data engineering experience is required to succeed in this Specialization.

 The Specialization consists of 5 self-paced online courses covering skills required for data engineering, including the data engineering ecosystem and lifecycle, Python, SQL, and Relational Databases.  You will learn these data engineering prerequisites through engaging videos and hands-on practice using real tools and real-world databases. You'll develop your understanding of data engineering, gain skills that can be applied directly to a data career, and build the foundation of your data engineering career.

 Upon successfully completing these courses, you will have the practical knowledge and experience to delve deeper into data engineering and work on more advanced data engineering projects. 

Applied Learning Project

All courses in the Specialization contain multiple hands-on labs and assignments to help you gain practical experience and skills.    

The projects range from working with data in multiple formats to transforming and loading that data into a single source to analyzing socio-economic data with SQL and working with advanced SQL techniques. 

You will work hands-on with multiple real-world databases and tools including MySQL, PostgresSQL, IBM Db2, PhpMyAdmin, pgAdmin, IBM Cloud, Python, Jupyter notebooks, Watson Studio, etc.

Read More

Introduction to R Programming for Data Science

 

What you'll learn

Manipulate primitive data types in the R programming language using RStudio or Jupyter Notebooks.

Control program flow with conditions and loops, write functions, perform character string operations, write regular expressions, handle errors. 

Construct and manipulate R data structures, including vectors, factors, lists, and data frames.

Read, write, and save data files and scrape web pages using R. 

Join Free:Introduction to R Programming for Data Science

There are 5 modules in this course

When working in the data science field you will definitely become acquainted with the R language and the role it plays in data analysis. This course introduces you to the basics of the R language such as data types, techniques for manipulation, and how to implement fundamental programming tasks. 

You will begin the process of understanding common data structures, programming fundamentals and how to manipulate data all with the help of the R programming language. 

The emphasis in this course is hands-on and practical learning . You will write a simple program using RStudio, manipulate data in a data frame or matrix, and complete a final project as a data analyst using Watson Studio and Jupyter notebooks to acquire and analyze data-driven insights.  

 

No prior knowledge of R, or programming is required.

Read More

Data Science with R - Capstone Project

 

What you'll learn

Write a web scraping program to extract data from an HTML file using HTTP requests and convert the data to a data frame.

Prepare data for modelling by handling missing values, formatting and normalizing data, binning, and turning categorical values into numeric values.

Interpret datawithexploratory data analysis techniques by calculating descriptive statistics, graphing data, and generating correlation statistics.

Build a Shiny app containing a Leaflet map and an interactive dashboard then create a presentation on the project to share with your peers.

Join Free:Data Science with R - Capstone Project

There are 6 modules in this course

In this capstone course, you will apply various data science skills and techniques that you have learned as part of the previous courses in the IBM Data Science with R Specialization or IBM Data Analytics with Excel and R Professional Certificate.

For this project, you will assume the role of a Data Scientist who has recently joined an organization and be presented with a challenge that requires data collection, analysis, basic hypothesis testing, visualization, and modeling to be performed on real-world datasets. You will collect and understand data from multiple sources, conduct data wrangling and preparation with Tidyverse, perform exploratory data analysis with SQL, Tidyverse and ggplot2, model data with linear regression, create charts and plots to visualize the data, and build an interactive dashboard.

The project will culminate with a presentation of your data analysis report, with an executive summary for the various stakeholders in the organization.

Read More

Data Science Methodology

 

What you'll learn

Describe what a data science methodology is and why data scientists need a methodology.

Apply the six stages in the Cross-Industry Process for Data Mining (CRISP-DM) methodology to analyze a case study.

Evaluate which analytic model is appropriate among predictive, descriptive, and classification models used to analyze a case study.

Determine appropriate data sources for your data science analysis methodology.

Join Free:Data Science Methodology

There are 4 modules in this course

If there is a shortcut to becoming a Data Scientist, then learning to think and work like a successful Data Scientist is it. In this course, you will learn and then apply this methodology that you can use to tackle any Data Science scenario. You’ll explore two notable data science methodologies, Foundational Data Science Methodology, and the six-stage CRISP-DM data science methodology, and learn how to apply these data science methodologies. Most established data scientists follow these or similar methodologies for solving data science problems.

Begin by learning about forming the business/research problem Learn how data scientists obtain, prepare, and analyze data. Discover how applying data science methodology practices helps ensure that the data used for problem-solving is relevant and properly manipulated to address the question. Next, learn about building the data model, deploying that model, data storytelling, and obtaining feedback You’ll think like a data scientist and develop your data science methodology skills using a real-world inspired scenario through progressive labs hosted within Jupyter Notebooks and using Python.

Read More

Communicating Data Science Results

 

Build your subject-matter expertise

This course is part of the Data Science at Scale Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts

Gain a foundational understanding of a subject or tool

Develop job-relevant skills with hands-on projects

Earn a shareable career certificate

Join Free:Communicating Data Science Results

There are 3 modules in this course

Important note: The second assignment in this course covers the topic of Graph Analysis in the Cloud, in which you will use Elastic MapReduce and the Pig language to perform graph analysis over a moderately large dataset, about 600GB. In order to complete this assignment, you will need to make use of Amazon Web Services (AWS). Amazon has generously offered to provide up to $50 in free AWS credit to each learner in this course to allow you to complete the assignment. Further details regarding the process of receiving this credit are available in the welcome message for the course, as well as in the assignment itself. Please note that Amazon, University of Washington, and Coursera cannot reimburse you for any charges if you exhaust your credit.

While we believe that this assignment contributes an excellent learning experience in this course, we understand that some learners may be unable or unwilling to use AWS. We are unable to issue Course Certificates for learners who do not complete the assignment that requires use of AWS. As such, you should not pay for a Course Certificate in Communicating Data Results if you are unable or unwilling to use AWS, as you will not be able to successfully complete the course without doing so.

Making predictions is not enough!  Effective data scientists know how to explain and interpret their results, and communicate findings accurately to stakeholders to inform business decisions.  Visualization is the field of research in computer science that studies effective communication of quantitative results by linking perception, cognition, and algorithms to exploit the enormous bandwidth of the human visual cortex.  In this course you will learn to recognize, design, and use effective visualizations.

Just because you can make a prediction and convince others to act on it doesn’t mean you should.  In this course you will explore the ethical considerations around big data and how these considerations are beginning to influence policy and practice.   You will learn the foundational limitations of using technology to protect privacy and the codes of conduct emerging to guide the behavior of data scientists.  You will also learn the importance of reproducibility in data science and how the commercial cloud can help support reproducible research even for experiments involving massive datasets, complex computational infrastructures, or both.

Learning Goals: After completing this course, you will be able to:

1. Design and critique visualizations

2. Explain the state-of-the-art in privacy, ethics, governance around big data and data science

3. Use cloud computing to analyze large datasets in a reproducible way.

Read More

Excel to MySQL: Analytic Techniques for Business Specialization

 

Advance your subject-matter expertise

Learn in-demand skills from university and industry experts

Master a subject or tool with hands-on projects

Develop a deep understanding of key concepts

Earn a career certificate from Duke University

Join Free:Excel to MySQL: Analytic Techniques for Business Specialization

Specialization - 5 course series

Formulate data questions, explore and visualize large datasets, and inform strategic decisions.

In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process.

The Capstone Project focuses on optimizing revenues from residential property, and Airbnb, our Capstone’s official Sponsor, provided input on the project design. Airbnb is the world’s largest marketplace connecting property-owner hosts with travelers to facilitate short-term rental transactions. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion.

Read More

Increasing Real Estate Management Profits: Harnessing Data Analytics

 

Build your subject-matter expertise

This course is part of the Excel to MySQL: Analytic Techniques for Business Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts

Gain a foundational understanding of a subject or tool

Develop job-relevant skills with hands-on projects

Earn a shareable career certificate

Join Free:Increasing Real Estate Management Profits: Harnessing Data Analytics

There are 7 modules in this course

In this final course you will complete a Capstone Project using data analysis to recommend a method for improving profits for your company, Watershed Property Management, Inc. Watershed is responsible for managing thousands of residential rental properties throughout the United States. Your job is to persuade Watershed’s management team to pursue a new strategy for managing its properties that will increase their profits. To do this, you will: (1) Elicit information about important variables relevant to your analysis; (2) Draw upon your new MySQL database skills to extract relevant data from a real estate database; (3) Implement data analysis in Excel to identify the best opportunities for Watershed to increase revenue and maximize profits, while managing any new risks; (4) Create a Tableau dashboard to show Watershed executives the results of a sensitivity analysis; and (5) Articulate a significant and innovative business process change for Watershed based on your data analysis, that you will recommend to company executives. 

Airbnb, our Capstone’s official Sponsor, provided input on the project design. The top 10 Capstone completers each year will have the opportunity to present their work directly to senior data scientists at Airbnb live for feedback and discussion.

Read More

Excel Skills for Data Analytics and Visualization Specialization

 

Advance your subject-matter expertise

Learn in-demand skills from university and industry experts

Master a subject or tool with hands-on projects

Develop a deep understanding of key concepts

Earn a career certificate from Macquarie University

Join Free:Excel Skills for Data Analytics and Visualization Specialization

Specialization - 3 course series

As data becomes the modern currency, so the ability to quickly and accurately analyse data has become of paramount importance. Therefore, data analytics and visualization are two of the most sought after skills for high paying jobs with strong future growth prospects. According to an 

IBM report

, the Excel tools for data analytics and visualization are among the top 10 competencies projected to show double-digit growth in their demand. This course will help you develop your analytical and visualization skills so that you not only improve your current work performance but also expand your future job prospects. For those in business and data analysis who want to master advanced Excel and beginner Power BI

, that will add an asset to your employability portfolio.

Upon completing this specialization, you will be able to bring data to life using advanced Excel functions, creative visualizations, and powerful automation features. These courses will equip you with a comprehensive set of tools for transforming, linking, and analysing data. You will master a broad range of charts and create stunning interactive dashboards. Finally, you will explore a new dimension in Excel with PowerPivot, Get and Transform, and DAX.  Harnessing the power of an underlying database engine, we will remove the 1,048,576 row limitation, completely automate data transformation, create data models to effectively link data, and open the gateway to Power Business Intelligence.

Applied Learning Project

Working with datasets similar to those typically found in a business, you will use powerful Excel tools to wrangle the data into shape, create useful visualizations, and prepare dashboards and report to share your results. You will learn to create a data workflow to automate your analysis and make the results flexible and reproducible.

Read More

check your knowledge of numpy in python

a. Numpy library gets installed when we install Python.

Answer

False

b. Numpy arrays work faster than lists.

Answer

True

c. Numpy array elements can be of different types.

Answer

False

d. Once created, a Numpy arrays size and shape can be changed

dynamically.

Answer

True

e. np.array_equal(a, b)) would return True if shape and elements of a and

b match.

Answer

True

Read More