Видео 376
Просмотров 3 586 687

Power BI in Python | Workspace Security Settings

11:18

Power BI in Python | Dashboards & Datasets

27:04

Power BI in Python | Authentication

30:30

Rethinking the TD Ameritrade Library

32:59

Getting Started with Python on Windows | GitHub

39:39

Getting Started with Python on Windows | Installing Git & VS Code

24:11

Power BI in Python | Reports

In this video, we will cover the topic of reports and how to access them, delete, them, create them and how to export them. We will also discuss some of the limitations when it comes to exporting reports depending on the type of licenses you have.
Chapters:
--------------------------------------------------
00:00 - Introduction
00:30 - What are reports?
02:20 - Using the Reports Client
11:00 - Exporting Reports
14:30 - Limitations
16:25 - Closing Statements
Video Resources:
--------------------------------------------------
github.com/areed1192/power-bi-python-api
Resources:
--------------------------------------------------
Facebook Page: codingsigma
Facebook Group: groups/sig...

Видео

Power BI in Python | Workspace Security Settings

11:18

Power BI in Python | Workspace Security Settings

Просмотров 1,2 тыс.3 года назад

Okay so now that we have an app registered and see how to access a specific resource like a Dashboard, we are going to spend some more time on authentication and licenses. The reason, we need to cover this more is because the Power BI REST API makes certain endpoints available only if you have certain license. This video will cover the different licenses, how it will impact your experience with...

Power BI in Python | Dashboards & Datasets

27:04

Power BI in Python | Dashboards & Datasets

Просмотров 7 тыс.3 года назад

Now that we have an application registered with the Power BI Rest API and it authenticated with the service, we can move on to the next topic, dashboards & datasets. The contents of this video will focus initially on how to retrieve and create dashboards using the API and how they are organized in a Power BI account. Additionally, we will spend some time on how to upload data in the form of a r...

30:30

Power BI in Python | Authentication

Просмотров 14 тыс.3 года назад

Power BI is a business intelligence tool developed by Microsoft that allows you to create highly dynamic and interactive dashboards for users. Along with dashboarding capabilities, Power BI allows for powerful data transformations and effective data modeling that will allow you to capture the power of your data. In this series, we will explore the Power BI REST API from the perspective of Pytho...

32:59

Rethinking the TD Ameritrade Library

Просмотров 3,5 тыс.3 года назад

It's hard to believe, but the TD Ameritrade Library is almost 2 years old! A lot has changed since the library came out and it's time for the TD library to go through a little bit of revamp. In this video, we are going to discuss some of the pain points of the old library and how we plan to fix them in the latest version of the TD library. Video Resources: github.com/areed1192/td-ameritrade-api...

Getting Started with Python on Windows | GitHub

39:39

Getting Started with Python on Windows | GitHub

Просмотров 2,9 тыс.3 года назад

Now that we have Git installed on our system we can start talking about GitHub and how it fits into the bigger picture. With GitHub we can store our repositories on the internet where other individuals can find it and contribute to your potential project. We will spend a significant amount of time seeing how GitHub is laid out, how to create a new repository, and how to clone a repository to ou...

Getting Started with Python on Windows | Installing Git & VS Code

24:11

Getting Started with Python on Windows | Installing Git & VS Code

Просмотров 3,2 тыс.3 года назад

In this video, we will walk through how to install Git and Visual Studio Code. Git will serve as our source control manager to help track our code files as we write them, and VS Code will be our code editor. With VS Code we can customize the application with different extensions that help with a range of tasks like formatting Python scripts all the way to interacting with GitHub. Chapters: 00:0...

Getting Started with Python on Windows | Installing Python

14:00

Getting Started with Python on Windows | Installing Python

Просмотров 1,4 тыс.3 года назад

Now, that we have an overview of the project we can proceed to the first step which is installing Python. In this video, I'll show you how to download Python, install it on the Windows operating system, and verify that the installation happened correctly. Chapters: 00:00 - Introduction 01:40 - Download Python 03:40 - Exploring the Different Versions 06:50 - Installing Python 09:30 - Verifying t...

Getting Started with Python on Windows | Introduction

15:35

Getting Started with Python on Windows | Introduction

Просмотров 3,2 тыс.3 года назад

Python is a popular language for those who are interested in learning programming. It's an easy language to read and it allows users to get up and running with their code quick and efficiently. However, there is more to learning python than just writing code. It takes learning the tools you'll use when you write your, debug, test, and share your code. That's why in this series not only will we ...

29:34

Using Pathlib in Python

Просмотров 13 тыс.3 года назад

Pathlib is a powerful library that makes working with file paths quick and easy. Along with allowing you to manipulate paths, you can also do different I/O operations right from your python script. In this video, we will talk about the Pathlib library, the objects it offers, and some of the common methods and properties of those objects. Video Resources: github.com/areed1192/sigma_coding_youtub...

Building a Trading System in Python | Azure Data Factories

23:38

Building a Trading System in Python | Azure Data Factories

Просмотров 7 тыс.3 года назад

Now that we have the project overview done, we will start with our first mini-project, building a data factory. Like the last video, we won't be doing any coding but instead focus on the user interface, how it's laid out, the different features it offers, and some common terminology that will be helpful when we go through the process. Video Resources: None Resources: Facebook Page: facebook.com...

Building a Trading System in Python | Project Overview

29:38

Building a Trading System in Python | Project Overview

Просмотров 13 тыс.3 года назад

A common theme in the channel is that trading can be reduced to automated procedures that follow pre-defined rules. However, trading is just one component of the bigger picture. To make a full-fledge trading system we need to make sure that we have access to adequate data, a user interface to manage our system, and pipelines that we can use to clean and organize our data. In this series, we wil...

Access VBA | Import Excel Tables to Access Pt. 2

21:59

Access VBA | Import Excel Tables to Access Pt. 2

Просмотров 1,9 тыс.3 года назад

In part two of our series, we will write the main section of our code that will loop through our list object and import the data into our newly defined Access Table. Additionally, we will walk through using the column headers in our table to specify the field we want to insert the value into. That way, we can replicate exactly how the table is structured in Excel and transfer it over to Access....

Access VBA | Import Excel Tables to Access Pt. 1

19:55

Access VBA | Import Excel Tables to Access Pt. 1

Просмотров 3,9 тыс.3 года назад

Excel is a commonplace to store data that is used in a wide range of activities. However, if we want to ensure our data is accurate and safe, we should store it in a database to ensure certain quality controls when it comes to our data. This series will show you how to import an Excel Data Table (List Object) into an Access Database using only VBA. With this technique, you can take all your sca...

Access VBA | Working with Query Definitions

29:42

Access VBA | Working with Query Definitions

Просмотров 4,4 тыс.3 года назад

Inside of Access, we store data in a structured format so that we can easily retrieve it when needed. When it comes to retrieving, creating, and modifying data we use scripts called queries to execute those instructions. Inside of VBA, we can create those queries and add additional information to them so that we can easily customize them to meet our unique needs. In this video, we will cover th...