Core Data Pro

Skill Me Up expert on-demand training for data professionals. Get started in your data professional career. Learn core technical skills such as R, Python, SQL Server, T-SQL and More!

learning path
4 (3)
2 Lectures | 0 Labs | 3h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
4 (18)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
0 (0)
1 Lectures | 0 Labs | 1h 49m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

learning path
5 (1)
2 Lectures | 0 Labs | 2h 7m | Intermediate

This track contains a collection of expert talks recorded by Power BI Experts.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
5 (2)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
5 (1)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
5 (1)
1h 1m | Intermediate | May 4 2020 |

Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend an hour on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why redundancy is (not) a bad thing?

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (2)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (2)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
3 (1)
1h 37m | Beginner | Nov 25 2019 |

This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

lecture
5 (2)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
4 (6)
2h 44m | Advanced | Feb 23 2017 |

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

lecture
0 (0)
1h 5m | Beginner | Jul 22 2020 |

Since its birth Power Query has become an easy-to-use ETL tool.However, how can we exploit this ease of use?What is the best practice to do it?In this session you learn about how and what to do to achieve it.

lecture
0 (0)
1h 49m | Beginner | Jul 8 2020 |

In this course, we will take you through the key features of SQL Server 2019. Throughout the course you will learn about intelligent performance, security, availability, Linux, Kubernetes, big data, as well as other topics.

real-time lab
5 (2)
45m | Beginner | Mar 3 2020 |

In this lab, you will create a report that contains multiple visuals as well as text boxes and buttons. You will add bookmarks to allow users to see a particular view.

real-time lab
4 (3)
30m | Beginner | Mar 4 2020 |

In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

real-time lab
4 (1)
40m | Intermediate | Jan 10 2018 |

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

real-time lab
5 (1)
40m | Beginner | Aug 4 2020 |

In this lab, you will learn the basics of importing CSV files into a Power BI model and adjusting query and column properties to prepare them for your data model. Then you will set table and column properties in the data model and create relationships between tables.

real-time lab
5 (1)
40m | Intermediate | Jul 23 2020 |

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

real-time lab
0 (0)
40m | Intermediate | Jul 23 2020 |

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will import Excel and CSV files into Power BI Desktop and then merge queries, group data, and group queries in the query pane. It is common to have to pull data from transactional systems and shape them. It is also common to add data from other sources to provide a more complete picture.First, you will stage the data from the multiple sources. Then you will merge and group data to get final reporting tables to be used in Power BI. Then you will disable staging queries. Finally, you will organize your queries into folders for better organization.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will implement basic row-level security in Power BI Desktop and PowerBI.com. First, you will create roles on a model in Power BI and add filters for each role. Then you will deploy the model and test the row-level security in PowerBI.com. Then you will add members to the role in PowerBI.com.

real-time lab
5 (1)
50m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of time intelligence measures to show year-to-date, quarter-to-date, and month-to-date totals. Then you will use DAX to enhance the data model and build a table that lets users choose which measures they want to see.

learning path
4 (3)
2 Lectures | 0 Labs | 3h 7m | Beginner

This learning path is designed to teach you the fundamentals of relational databases using Microsoft SQL Server. You will learn core concepts such as tables, indexes, and building relationships with foreign keys. From there, you will learn how to write queries using T-SQL to query data as well as make changes to your database.

learning path
5 (10)
4 Lectures | 0 Labs | 5h 30m | Intermediate

In this learning path, you will learn the basics of data science including what data science is, some of the common programming languages used in data science (R and Python) as well as an introduction to machine learning.

learning path
4 (8)
1 Lectures | 3 Labs | 4h 44m | Advanced

In this learning path, you will learn from the fundamentals of SQL Server relational databases to advanced capabilities,

learning path
4 (18)
5 Lectures | 6 Labs | 7h 59m | Beginner | Certification Prep

In this this learning path you will explore Power BI Desktop and the the Power of PowerBI.com deploy datasets and reports as well as deploying, sharing, and securing assets in PowerBI.com. You will learn how to model data using DAX, as well as build reports and visualizations through on-demand courses and interactive hands-on labs.

learning path
0 (0)
1 Lectures | 0 Labs | 1h 49m | Beginner

This learning path contains recordings and hands-on labs based off of the SQL Server 2019 workshop development by the Microsoft SQL Server product team. You will learn about SQL Server intelligent performance features, new security features, modern development capabilities, how to use SQL Server 2019 on Linux + Containers, as well as new features with big data and data virtualization.

learning path
5 (1)
2 Lectures | 0 Labs | 2h 7m | Intermediate

This track contains a collection of expert talks recorded by Power BI Experts.

lecture
5 (2)
1h 37m | Intermediate | Aug 12 2019 |

This course is an introduction to Microsoft Azure Machine Learning Services. In this course you will learn to navigate the AML Services interface, create notebook servers, create compute clusters, manage AML Services from a notebook, deploy models, and create an Automated Machine Learning experiment.

lecture
5 (2)
1h 35m | Beginner | Mar 6 2020 |

In this course we will cover Data Modeling and the xVelocity Engine. We will also discuss DAX Basics along with Advanced DAX and optimizing the data model.

lecture
5 (1)
33m | Beginner | Mar 6 2020 |

This course will cover the basics of acquiringdata in Power BI Desktop andbuilds on the data acquisition basics and adds performance optimization and re-usability techniques.

lecture
5 (2)
1h 29m | Beginner | Mar 19 2019 |

The course will teach you the fundamentals of the relational database model and how to access data stored in relational databases. The course will give students an understanding of relational database concepts and teach the practical application of these concepts through the T-SQL programming language for Microsoft SQL Server and Azure SQL Database.

lecture
5 (1)
1h 1m | Intermediate | May 4 2020 |

Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend an hour on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why redundancy is (not) a bad thing?

lecture
5 (5)
45m | Beginner | Jan 14 2019 |

This course covers the necessary tools and concepts used in the data science industry to include machine learning, statistical inference, working with data at scale and much more.

lecture
5 (2)
32m | Beginner | Mar 6 2020 |

Welcome to this introduction to Power BI for data professionals. In this course, we will have an overview of the Power BI ecosystem. Then we will have a tour of Power BI Desktop.

lecture
5 (1)
1h 8m | Beginner | Sep 9 2019 |

This course is an introduction to Python. In this course you will learn which IDE is right for you, print statements, data types, control flow, Python functions and anonymous functions, methods, file io, and an introduction to Python packages.

lecture
5 (2)
1h 59m | Intermediate | Jul 2 2019 |

This course covers introduction to the R Language. We start off with an introduction to R verisons and R Editions then move to R the language. From there will dive into one of R’s strongest features, Graphics. Using base R graphics and GGPlot you will learn how to get started, and learn how to create your own visualizations.

lecture
5 (2)
56m | Beginner | Mar 6 2020 |

In this course we will discuss an overview of the Power BI Service. We will also cover sharing and securing your report and designing Enterprise Solutions in Power BI.

lecture
3 (1)
1h 37m | Beginner | Nov 25 2019 |

This course serves as an introduction to the T-SQL programming language. This course is designed to give students a strong foundation in the T-SQL language which is used by all variants of SQL Server both on-premises and in the cloud.

lecture
5 (2)
36m | Beginner | Mar 9 2020 |

In this course you will learn about building interactive reports. We will also discuss helpful data visualization techniques in Power BI.

lecture
4 (6)
2h 44m | Advanced | Feb 23 2017 |

This course covers In-Memory OLTP, Columnstore Indexing, Real-time Analytics, Query Store, JSON data in SQL Server and Extended Events with Availability Groups.

lecture
0 (0)
1h 5m | Beginner | Jul 22 2020 |

Since its birth Power Query has become an easy-to-use ETL tool.However, how can we exploit this ease of use?What is the best practice to do it?In this session you learn about how and what to do to achieve it.

lecture
0 (0)
1h 49m | Beginner | Jul 8 2020 |

In this course, we will take you through the key features of SQL Server 2019. Throughout the course you will learn about intelligent performance, security, availability, Linux, Kubernetes, big data, as well as other topics.

real-time lab
5 (2)
45m | Beginner | Mar 3 2020 |

In this lab, you will create a report that contains multiple visuals as well as text boxes and buttons. You will add bookmarks to allow users to see a particular view.

real-time lab
4 (3)
30m | Beginner | Mar 4 2020 |

In this lab, you will learn the basics of acquiring data using Power BI Desktop. You will import Excel files into Power BI Desktop and transform the data. You will use Power Query/M to connect to data sources such as SQL Databases, Excel files, text files, JSON files, and websites and then cleanand shape the data with Power Query/M.

real-time lab
4 (1)
40m | Intermediate | Jan 10 2018 |

In this lab, you will explore columnstore indexes in SQL Server 2016. You will evaluate the performance improvements you will get when you implement columnstore indexes on tables for your analytical workloads.

real-time lab
5 (1)
40m | Beginner | Aug 4 2020 |

In this lab, you will learn the basics of importing CSV files into a Power BI model and adjusting query and column properties to prepare them for your data model. Then you will set table and column properties in the data model and create relationships between tables.

real-time lab
5 (1)
40m | Intermediate | Jul 23 2020 |

In this lab, you will explore the new SQL Server 2016 In-Memory OLTP feature. You will evaluate the performance improvements you will get when you migrate disk-based tables and interpreted T-SQL stored procedures into memory-optimized tables and natively-compiled stored procedures, respectively.

real-time lab
0 (0)
40m | Intermediate | Jul 23 2020 |

In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will import Excel and CSV files into Power BI Desktop and then merge queries, group data, and group queries in the query pane. It is common to have to pull data from transactional systems and shape them. It is also common to add data from other sources to provide a more complete picture.First, you will stage the data from the multiple sources. Then you will merge and group data to get final reporting tables to be used in Power BI. Then you will disable staging queries. Finally, you will organize your queries into folders for better organization.

real-time lab
5 (1)
30m | Beginner | Mar 3 2020 |

In this lab, you will implement basic row-level security in Power BI Desktop and PowerBI.com. First, you will create roles on a model in Power BI and add filters for each role. Then you will deploy the model and test the row-level security in PowerBI.com. Then you will add members to the role in PowerBI.com.

real-time lab
5 (1)
50m | Beginner | Nov 28 2019 |

In this lab, you will learn the basics of time intelligence measures to show year-to-date, quarter-to-date, and month-to-date totals. Then you will use DAX to enhance the data model and build a table that lets users choose which measures they want to see.