IT-kurs
Kurs i programvare og applikasjoner
Microsoft Power BI
Akershus
Du har valgt: Bærum
Nullstill
Filter
Ferdig

-

2 dager 8 000 kr
Nærmere beskrivelse kommer senere. [+]
Audience This course is intended for developers who would like to develop custom applications for the Power BI platform. Participants should have a basic understanding of Power BI Desktop and the Power BI Service. Participants should be experienced software developers.   Course Outline Module 1: Introduction to Power BI Development This module provides students with a quick overview of the Power BI Desktop client application and Power BI cloud service and where the extension points of Power BI are as a developer. The modules introduces developers to the Power BI Service API, writing custom Visuals and embedding Power BI in custom applications Overview of Power BI Desktop and Power BI Service How can developers extend Power BI? Introducing Power BI Service API Overview of Power BI Embedded Overview of developing custom Visuals   Module 2: The Power BI Service API The Power BI Service API is a Web API by which developers interact with the Power BI Service. Students will learn how the authenticate users against the Power BI Service API using Azure Active Directory (ADAL). Students will learn how to work with App Workspaces, Datasets, Tables and the data from code. The module also explains how the Power BI Service API can be used to automate the publishing of PBIX files and configuring data source settings. Overview of Power BI Service API Registering applications with Azure Active Directory Authenticate with the Power BI Service API using OAuth 2.0 and ADAL Working with App Workspaces Working with Datasets Pushing rows into dataset tables Publishing Power BI Desktop PBIX files Configuring data sources and dataset refresh settings   Module 3: Streaming data and Power BI This module teaches students how they to work with streaming data in Power BI. Students will learn how data can be pushed into a streaming dataset. To end the chapter students will see how real-time dashboards can be created using streaming tiles. What are streaming datasets Different types of streaming datasets Creating and using streaming datasets in the Power BI Service UI Creating and using streaming datasets using the Power BI Service API Creating streaming datasets using the Azure Stream Analytics Creating real-time dashboards   Module 4: Power BI Embedded In this module, students will learn how Power BI Embedded can be used to embed Power BI Reports and Dashboards into custom applications. The module introduces the different licensing models for Power BI and how users and/or applications can be authenticated. Next you will see how the Power BI Embedded JavaScript API can be used to embed Power BI content in your custom application. Also, topics like filtering, printing, event handling using the JavaScript API are covered. Overview of Power BI Embedded Power BI Embedded licensing models Authentication scenarios for Power BI Embedded The Power BI Embedded JavaScript API Embedding dashboards Embedding reports Event handling on embedded reports and dashboards   Module 5:   Programming with TypeScript This module provides students with an introduction to the TypeScript language using Visual Studio Code. Students will learn the basics of defining modules, classes, interfaces, ... in TypeScript. What is TypeScript? Working with classes and interfaces in TypeScript Using external JavaScript libraries with TypeScript   Module 6: Developing Custom Visuals In this module students will first learn how to setup a development environment for building custom Visuals. Next, students will learn how to use the Power BI Custom Visual Tool (PBIVIZ) to create, test and package a custom Visual. Students will also learn about the structure of a custom Visual project in Visual Studio Code. Installing Node.js Working with the Node Package Manager Installing developer certificates Installing and using the Power BI Visual Tools (pbiviz) Creating your first Power BI custom Visual Overview of the Power BI Visual project structure Testing and debug a custom Visual Working with external JavaScript libraries and Typed Definition Files   Module 7: Developing custom Power BI Visuals This module teaches students step by step how custom Visuals are build. It first introduces the custom Visual Object Model. Next, students will see how Objects and Properties can be defined on a custom Visual and how you work with them in code. Students will also be introduced to the different data view mappings and how to retrieve the data that the Visual should display using the DataView object model. Students also learn how to display tooltips on Visuals, how to use the formatting utility classes to format numbers, dates, ... To end the chapter, students will see how custom Visuals can be packaged and used in Power BI Desktop or the Power BI Service. Overview of the Power BI custom Visual object model Define capabilities and data view mappings Define custom properties How to format numbers, dates, ... in a custom Visual Package and deploy a custom Visual [-]
Les mer
2 dager 8 000 kr
Nærmere beskrivelse kommer senere.  [+]
Module 1: SQL Server Analysis Services (SSAS) Tabular Introduction In a world where self-service business intelligence becomes more and more important it becomes crucial to understand the power of Online Analytical Processing (OLAP). In this introduction we show the key importance of OLAP systems and discuss the key differences between two OLAP systems that Microsoft Analysis Services provides: Tabular and multi-dimensional. What is Online Analytical Processing? Microsoft Analysis Services Difference between multi-dimensional and tabular   Module 2: Building Semantic Tabular models Tabular models are developed in a Visual Studio add-in named SQL Server Data Tools (SSDT). We can start creating models from scratch or we can use models business people already made in Excel and import them in SSDT. Not only do you learn to build a basic model, this module also discuss how to extend the model with objects such as display folders, key performance indicators, meta-data translations and more! SQL Server Data Tools Importing PowerPivot databases Creating databases from scratch Linking tables Building hierarchies Extending the model with KPIs, translations, ... Working with Direct Query   Module 3: DAX Expressions in SSAS Tabular A tabular model becomes more useful to the business if it already contains business concepts such as year-to-date calculations, percentage of parent calculations and similar pieces of derived data often used in reports and analysis. In tabular Analysis Services models we have to encode this derived calculations using the Data Analysis eXpression language: DAX. This module shows you how DAX can be used to encode many business concepts into your model. Why do we need DAX? Deriving columns with DAX Referencing columns and tables Related and RelatedTable Building DAX measures Row versus filter context Using CALCULATE Implementing Time intelligence   Module 4: SSAS Administration For an enterprise solution it is crucial that what has been build by the developers is well maintained as well. This involves taking backups of the deployed models, applying row level security such that business users can only see the objects relevant to their job, refreshing the data in the models (also called processing) and monitoring the models using Extended events, profiler, performance counters and dynamic management views. Backup and restore Securing the tabular model Processing Monitoring   Azure Analysis Services Running Analysis Services Tabular requires a server with a lot of fast memory, software licenses and some maintenance and administration. Unless you run it in the cloud, then you're up and running in minutes! Why running SSAS in the cloud? Analysis Services: IaaS versus PaaS Setup and deployment in Azure Analysis Services Creating models in the browser Administration of Azure Analysis Services [-]
Les mer
16 timer 19 500 kr
Avansert kurs for de som ønsker å lage avanserte datamodeller og analyser for innsikt og visualisering – kan skreddersys til å kjøre kurs basert på intern data i bedrift... [+]
I dette kurset lærer du følgende: Forstå hvordan du oppretter datakilder og masserer data med Desktop Power BI (PowerQuery). Lær hvordan du enkelt lager flotte rapporter og publisere dette. Lær deg språket i Power BI som gir deg muligheten til å lage beregninger som f.eks marginer – DAX. Deling av dashboards med andre interessenter. Lær deg å utvikle interaktive dashboard som gir deg muligheten til å filtrere og drille ned i dataen din. Lær hvordan du rensker og transformerer dataen din ved hjelp av funksjoner og paramterte, slik at du kan begynne å analysere og få innsikt i dataen din på riktig måte – Power Query. Lær deg avanserte kalenderfunksjoner som YTD, LastYear, NextMonth, LastMonth– DAX. Lær hvordan du kan bygge en kraftig data modell som gir deg muligheten til å koble til flere datakilder i en og samme rapport, slik at du kan begynne å bygge kraftige rapporter og automatisere rapporteringen, i din organisasjon – Datamodellering. Lage gode rapporteringsfiltre med bokmerker og slicere. Lær deg hvordan du kan dele dashboardet ditt med dine kollegaer, samt muligheten til å å gi restriksjoner på tilgang til dataen basert på f.eks regioner, roller til kollegaene dine. Vi har sertifisering i Power BI. Vår kursholder har dybdekunnskap i Power BI og har også god erfaring i det å holde kurs fra både mindre og større selskaper. Vi har utviklet en sterk metode og kunnskap om beste praksis innenfor business intelligence kursing, og forstår at alle våre kunder er forskjellig. Vi har derfor høy tilpasningsdyktighet med tanke på kursinnhold.Vi er Microsoft Power BI Partner og har sertifisering i Power BI. Våre kursholdere har dybdekunnskap i Power BI og har også god erfaring i det å holde kurs for både mindre og større selskaper. [-]
Les mer
2 dager 8 000 kr
Nærmere beskrivelse kommer senere.  [+]
Prerequisites and basic training Attendees will need a solid grasp of Power BI Desktop's basic functionality We can provide full basic training "Dashboard in a Day" or short-session refreshers   Module 1: Data Modeling Overview and purpose Facts and dimensions Relationship direction and cardinality Associative entities ("many-to-many" relationships) Preparing for row-level security   Module 2: Power Query "M" and the Query Editor Data cleanup and transformation Pulling structured and unstructured data from Excel spreadsheets, application exports, and websites Connecting to relational databases, such as SQL Server, MySQL, SAP HANA, and Oracle Creating your own dimensions from flat-file data Common operators and functions Creating your own custom functions Leveraging data from document-oriented sources (e.g. JSON and XML) Mashing up data from different sources   Module 3: DAX Relational measures and calculations When to use calculated columns vs measures Leveraging quick measures Time intelligence patterns on calendar periods and fiscal periods Implementing row-level security   [-]
Les mer

Lukk Denne siden benytter seg av informasjonskapsler (cookies).
Du kan fortsette å bruke siden som vanlig hvis du godtar dette. Les mer om bruk av informasjonskapsler i vår personvernerklæring.