ITDA - Western Technical College

210 bookmarks
Newest
Pivot columns (Power Query) - Microsoft Support
Pivot columns (Power Query) - Microsoft Support
In Power Query, you can create a table that contains an aggregate value for each unique value in a column. Power Query groups each unique value, performs an aggregate calculation for each value, and pivots the column into a new table.
·support.microsoft.com·
Pivot columns (Power Query) - Microsoft Support
Chapter 11 Data visualization principles | Introduction to Data Science
Chapter 11 Data visualization principles | Introduction to Data Science
This book introduces concepts and skills that can help you tackle real-world data analysis challenges. It covers concepts from probability, statistical inference, linear regression and machine learning and helps you develop skills such as R programming, data wrangling with dplyr, data visualization with ggplot2, file organization with UNIX/Linux shell, version control with GitHub, and reproducible document preparation with R markdown.
·rafalab.dfci.harvard.edu·
Chapter 11 Data visualization principles | Introduction to Data Science
OLAP Cubes in SQL Server
OLAP Cubes in SQL Server
This article covers the basics of OLAP Cubes implementation using the SQL Server Analysis Service.
·sqlshack.com·
OLAP Cubes in SQL Server
SSAS Multidimensional or SSAS Tabular
SSAS Multidimensional or SSAS Tabular
Download a free trial of our On-Demand Training Platform: http://pragmaticworks.com/Training/On-Demand-Training?hsCtaTracking=6bdedee8-b89b-420b-883d-37d9e6d...
·youtube.com·
SSAS Multidimensional or SSAS Tabular
TYPES OF RELATIONSHIPS IN DATA MODELLING
TYPES OF RELATIONSHIPS IN DATA MODELLING
Start by learning the meaning of the relational database. A relational database is a type of database that stores and provides access to…
and usage phases. Entity-Relationship (ER) Model helps understanding
·medium.com·
TYPES OF RELATIONSHIPS IN DATA MODELLING
Data Modeling: Conceptual vs Logical vs Physical Data Model
Data Modeling: Conceptual vs Logical vs Physical Data Model
Data modeling is a technique to document a software system using entity relationship diagrams (ER Diagram) which is a representation of the data structures in a table for a company’s database. It is a very powerful expression of the company’s business requirements. Data models are used for many purposes, from high-level conceptual models, logical to …
·online.visual-paradigm.com·
Data Modeling: Conceptual vs Logical vs Physical Data Model
CBDA Competencies | IIBA®
CBDA Competencies | IIBA®
Competencies and Proficiency Levels per Knowledge Area Definitions of skill and knowledge levels used. Practical Knowledge or General Awareness: Limited practical experience. Expertise is developed in a safe, structured environment (small, less complex efforts) where guidance is both sought and provided. Basic Knowledge: Has a fundamental awareness of basic skills and knowledge involved in the work. Understands: Recognizes the key elements of the work and why they are important. However, not expected to have the experience nor skill to execute. Follows Rules: Adheres to prescribed ways to complete the work but needs rules and guidelines to successfully execute. The competency elements are grouped into six Knowledge Areas: Five of the knowledge areas are practitioner-based domains as discussed in IIBA’s Introduction to Business Data Analytics: A Practitioners View; and one is an organizational-based domain from IIBA’s Introduction to Business Data Analytics: An Organizational View.
·iiba.org·
CBDA Competencies | IIBA®