Training Courses

Enable BBDD on MV (VMWARE) for access from a DATAFLOW POWERBI (step-by-step)

Leave a comment / BI & Reporting, Training Courses / By RobertoMirelman / 4 June 2020 5 June 2020 Dataflows that can be created within a PowerBI Service Workspace (Pro or Premium licensed), are useful for reusing the logic developed with PowerQuery while making ETL processes (M scripts), so we can have queries with the …

Enable BBDD on MV (VMWARE) for access from a DATAFLOW POWERBI (step-by-step) Read More »

BI & Reporting: What is a Report?

Data-Based Management Reports In my experience as a teacher in BI and Reporting courses, I meet people with various profiles: from technicians to administrative, from operatives to senior managers. The perception of what a report is is different for each profile. For organizations and companies that want data-driven management, the reports represent the foundation for …

BI & Reporting: What is a Report? Read More »

Types of Reports

Depending on their purpose and the profile of their recipients, we can characterize three distinct types of reports. Dashboard Summary report, with clear indicators on the current situation Single page Typical visuals: Traffic lights, KPIs, Indicators (Gauge) Aimed at: command level Analytical Reports Detailed report with ratings Multiple pages Typical Visuals: Line Charts, Correlation, Bar …

Types of Reports Read More »

QlikView Course Content – Level 2: Developer (16 h)

1. Loading Files and Database Data What is a qvd file? Optimized load Using ODBC and OLEDB Script Checking and Debugging Script control flow (conditional, loops) 2. Associating Data from Several Tables Associations Loading and associating a second table Renaming fields Qualify / Unqualify Mappings Save table to file Resident data source 3. Concatenating Tables …

QlikView Course Content – Level 2: Developer (16 h) Read More »

QlikView Course Content – Level 1: Designer (16h)

1. Introduction What is QlikView? QlikView Basics Document 2. Query editor: simple data load from file 3. QV Objects 4. Making Queries in a QlikView Document Basic QlikView terminology / colors Associative selections Stepping back or forward in the list of selections Locking and unlocking selections Searching values Selection bookmarks 5. Script Editor Basics: Loading …

QlikView Course Content – Level 1: Designer (16h) Read More »