К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Foundational Data Access and Reporting · LearnSpace
Назад в каталог
courseraАнализ данных

Foundational Data Access and Reporting

Курс от Coursera
Уровень не указан≈ 28.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Learn how to access, retrieve, and report on data across multiple systems in this comprehensive course within the Data Analytics Skill Path. You will develop essential competencies, including importing and converting flat file data, writing SQL queries to retrieve and filter records, executing pre-written queries for routine data requests, generating operational reports using templates and spreadsheet tools, and applying governance and privacy policies when handling organizational data. Through hands-on practice with Python, SAS PROC SQL, spreadsheets, and Power BI, you will learn to transform raw inputs into structured, accurate, and compliance-ready outputs. This course brings together expertise from IBM, SAS, Google, and Microsoft, offering multiple perspectives on foundational data access and reporting workflows. You will progress from reading and transforming file-based data in Python, to querying relational data with SQL, to generating summaries and reports in spreadsheets, and ultimately to applying governance practices using Power BI. The curriculum balances conceptual understanding with practical exercises, preparing you to confidently retrieve, organize, and report data across modern analytics environments. Perfect for aspiring analysts and learners seeking strong foundational skills in data retrieval, reporting, and governance across widely used industry tools.

Навыки, которые вы освоите

Spreadsheet SoftwareData AccessData AnalysisData ManipulationStored ProcedureExcel FormulasSQLFile I/OPandas (Python Package)Power BIData GovernanceNumPyPivot Tables And ChartsQuery LanguagesSAS (Software)Data SecurityData Management

Программа курса

7 модулей · 159 учебных материалов

01Start Here: Get Oriented and Check Your Skills2 материалов
Start Here: How This Skill-Based Course WorksЧтениеSkill Diagnostic: Find Your Recommended Starting PointЗадание
02Working with Data in Python 23 материалов

Reading and Writing Files with Open

Reading Files with OpenВидео

Учитесь у экспертов

Professionals from the Industry

Преподаватель курса

Foundational Data Access and Reporting
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 28.2 ч

7 модулей

Язык: Английский

Субтитры: Арабский, Французский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Reading: Reading Files with OpenPLUGIN
Hands-On Lab: Reading Files with OpenВнешний инструмент
Writing Files with OpenВидео
Reading: Writing Files with OpenPLUGIN
Hands-On Lab: Writing Files with OpenВнешний инструмент
Practice Quiz: Reading and Writing Files with OpenЗадание

Pandas

Pandas: Loading DataВидеоPandas: Working with and Saving DataВидеоReading: PandasPLUGINPractice Lab: Selecting Data in a DataFrameВнешний инструментHands on Lab: Loading Data with PandasВнешний инструментPractice Quiz: PandasЗадание

Numpy in Python

One Dimensional NumpyВидеоHands-On Lab: One Dimensional NumpyВнешний инструментReading: Matrix MathematicsPLUGINTwo Dimensional NumpyВидеоHands-On Lab: Two Dimensional NumpyВнешний инструментReading: Beginner's Guide to NumPyPLUGINPractice Quiz: Numpy in PythonЗадание

Summary, Cheatsheet and Glossary

Summary: Working with Data in Python ЧтениеCheat Sheet: Working with Data in PythonPLUGINGlossary: Working with Data in Python PLUGIN
03PROC SQL Fundamentals50 материалов

Generating Simple Reports

Filtering Rows Using the WHERE ClauseВидеоActivity 2.01ЗаданиеSpecial WHERE Operators: Missing ValuesВидеоActivity 2.02ЗаданиеDate, Time, and Datetime ValuesЧтениеAdditional Special WHERE OperatorsВидеоSorting the Output with the ORDER BY ClauseВидеоActivity 2.03ЗаданиеOrdering Columns by PositionВидеоEnhancing ReportsВидеоActivity 2.04ЗаданиеDemo: Creating Simple ReportsВидеоCreating a New ColumnВидеоActivity 2.05ЗаданиеSubsetting Calculated ValuesВидеоAssigning Values Conditionally with the CASE ExpressionВидеоDemo: Assigning Values ConditionallyВидеоLevel 1 Practice: Querying a TableЗаданиеLevel 2 Practice: Working with Datetime ValuesЗадание

Summarizing and Grouping Data

Eliminating Duplicate Rows with the DISTINCT KeywordВидеоActivity 2.06ЗаданиеSummarizing DataВидеоCommonly Used Summary FunctionsЧтениеDemo: Using Summary Functions to Analyze a TableВидеоSummarizing Data Using the COUNT FunctionВидео

Creating and Managing Tables

Creating TablesВидеоCreating Tables from a QueryВидеоActivity 2.09ЗаданиеCreating Table StructuresВидеоInserting Rows into TablesВидеоDropping Tables in PROC SQLВидеоActivity 2.10

Using DICTIONARY Tables

ScenarioВидеоDICTIONARY TablesВидеоActivity 2.11ЗаданиеDemo: Using DICTIONARY TablesВидеоPractice Level 1: Counting the Number of Tables in a LibraryЗаданиеPractice Level 2: Counting the Number of Tables in All LibrariesЗадание

Additional Resources

SQL Order of Execution Cheat Sheet (optional)ЧтениеLearning More (optional)Чтение
04Perform data calculations 32 материалов

Get started with data calculations

Data calculations ВидеоCommon calculation formulas ВидеоFunctions and conditionsВидеоFunctions with multiple conditionsЧтениеHands-On Activity: Work with conditionsЗаданиеComposite functions ВидеоTest your knowledge on data calculations Задание

Pivot...pivot...pivot...

Start working with pivot tables ВидеоPivot tables continuedВидеоElements of a pivot tableЧтениеUse pivot tables in analysis ЧтениеHands-On Activity: Explore movie data with pivot tablesЗаданиеTest your knowledge on pivot tables Задание

Learn more SQL calculations

Queries and calculationsВидеоUpload the avocado dataset to BigQueryЧтениеStep-by-Step: Embed simple calculations with SQLЧтениеEmbed simple calculations with SQLВидеоCalculations with other statements ВидеоHands-On Activity: Calculations with SQL Задание

The data-validation process

Check and recheckВидеоTypes of data validationЧтениеHands-On Activity: From spreadsheets to BigQueryЗаданиеStart validatingPLUGIN

SQL and temporary tables

Temporary tablesВидеоHands-On Activity: Create temporary tables ЗаданиеMultiple table variationsВидеоWork with temporary tables ЧтениеYour intermediate guide to SQL ЧтениеUse Connected Sheets with BigQueryЧтение
05Intermediate SQL19 материалов

Refining your Results

Using String Patterns and RangesВидеоSorting Result SetsВидеоGrouping Result SetsВидеоHands-on Lab: String Patterns, Sorting and GroupingВнешний инструмент[Optional] Hands-on Labs Using IBM Db2ЧтениеSummary: Refining Your ResultsЧтениеPractice Quiz: Refining Your ResultsЗаданиеSQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BYPLUGIN

Functions, Multiple Tables, and Sub-queries

Built-in Database FunctionsВидеоDate and Time Built-in FunctionsВидеоHands-on Lab: Built-in functionsВнешний инструментSub-Queries and Nested SelectsВидеоHands-on Lab: Sub-queries and Nested SelectsВнешний инструментWorking with Multiple TablesВидео
06Security and monitoring31 материалов

Sharing information in Power BI

Safely sharing informationВидеоSharing via linksВидеоData sensitivity labelsВидеоExercise: Applying sensitivity labelsЧтениеSelf-review: Applying sensitivity labels ЗаданиеExemplar: Applying sensitivity labelsЧтениеLeaking of sensitive dataВидеоKnowledge check: Sharing information in Power BI ЗаданиеAdditional resources: Sharing information in Power BIЧтение

Organizations and permissions

Dataset permissionsВидеоConfiguring dataset permissionsВидеоPermissions cheatsheetЧтениеSharing outside your organizationВидеоKnowledge check: Organizations and permissions ЗаданиеAdditional resources: Organizations and permissionsЧтение

Row-level security

What is row-level security?ВидеоStatic versus dynamic row-level securityЧтениеConfiguring static row-level securityВидеоDynamic row-level security with DAXВидеоKnowledge check: Row-level security ЗаданиеAdditional resources: Row-level securityЧтение

Subscriptions and alerts

Subscribing to reports and dashboardsВидеоConfiguring data alertsВидеоExercise: Configuring a data alertЧтениеSelf-review: Configuring a data alert ЗаданиеExemplar: Configuring a data alertЧтениеHow data alerts prevented trading lossesВидео
07Assessment2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
Activity 2.07Задание
Grouping DataВидео
Demo: Analyzing Groups of DataВидео
Summarizing Date and Time DataВидео
Activity 2.08Задание
Counting Rows Using a Boolean ExpressionВидео
Demo: Summarizing Data Using a Boolean ExpressionВидео
Level 1 Practice: Eliminating DuplicatesЗадание
Level 2 Practice: Grouping and Summarizing DataЗадание
Задание
Additional Statements to Maintain TablesЧтение
Test your knowledge on SQL calculations Задание
GlossaryЧтение
Test your knowledge on using SQL with temporary tables Задание
Hands-on Lab: Working with Multiple TablesВнешний инструмент
[Optional] Hands-on Labs Using IBM Db2Чтение
Summary: Functions, Multiple Tables, and Sub-queriesЧтение
Practice Quiz: Functions, Multiple Tables, and Sub-queriesЗадание
SQL Cheat Sheet: FUNCTIONS and Implicit JOINPLUGIN
Implementing Security measures and Alerting in a Power BI ReportDIALOGUE
Knowledge check: Subscriptions and alerts Задание
Summary: Security and monitoringВидео
Additional resources: Subscriptions and alertsЧтение