Power BI Desktop - Face to Face online course

Location type
Total time
Trainer
M Holten
Logo Mr Data Business School
Provider rating: starstarstarstarstar_half 9 Mr Data Business School has an average rating of 9 (out of 3 reviews)

Tip: need an in-house course at your organisation? We will help you get the right quotes!

Description

Lesmethode :

Klassikaal Learning credits kunt u flexibel studeren Avond, Overdag, Zaterdag, Zondag

Algemeen :

Business Intelligence (BI) bestaat uit de verzameling hulpprogramma's en processen die mensen gebruiken om gegevens te verzamelen en deze om te zetten in zinvolle informatie. Het omzetten van deze gegevens stelt je in staat om betere beslissingen te nemen. Microsoft Excel bevat diverse BI-mogelijkheden, waarmee je op eenvoudige wijze op gegevens van verschillende databronnen kunt koppelen en visualiseren. Met deze extra mogelijkheden is Microsoft Excel nu een echte self service Power BI functionaliteit geworden.

In deze praktijkgerichte 2-daagse cursus Power BI leer je o.a. een kop…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. Send an Email to info@springest.com

Didn't find what you were looking for? See also: Microsoft Excel, SQL, Hour of Code, Social Media, and Time management.

Lesmethode :

Klassikaal Learning credits kunt u flexibel studeren Avond, Overdag, Zaterdag, Zondag

Algemeen :

Business Intelligence (BI) bestaat uit de verzameling hulpprogramma's en processen die mensen gebruiken om gegevens te verzamelen en deze om te zetten in zinvolle informatie. Het omzetten van deze gegevens stelt je in staat om betere beslissingen te nemen. Microsoft Excel bevat diverse BI-mogelijkheden, waarmee je op eenvoudige wijze op gegevens van verschillende databronnen kunt koppelen en visualiseren. Met deze extra mogelijkheden is Microsoft Excel nu een echte self service Power BI functionaliteit geworden.

In deze praktijkgerichte 2-daagse cursus Power BI leer je o.a. een koppeling maken op tabellen van een SQL Database en met die gegevens een Data model (PowerPivot) te maken. Vervolgens ga je met berekeningen de gegevens uitbreiden tot bruikbare informatie (DAX berekeningen). Daarna maak je met deze gegevens draaitabellen op basis van een relationeel tabellen systeem (het data model). Door de sterke comprimeer techniek kunnen miljoenen regels informatie worden benaderd. Verder worden met de gegevens van het data model visualisaties gemaakt met PowerView en PowerMap. In deze training komt ook PowerQuery aan bod om gegevens uit verschillende data bronnen te bewerken en die bewerkte gegevens toe te voegen aan het data model. Het laatste onderdeel van deze training is het maken van visualisaties uit diverse bronnen met Power BI Desktop.

De praktische insteek van deze training bestaat uit theorie en oefeningen met de techniek, waardoor je een optimaal resultaat haalt uit Power BI.

Doelgroep :

Deze cursus Power BI Microsoft Excel is bestemd voor BI-specialisten, analisten, power users, IT-professionals en geavanceerde MS Excel gebruikers die kennis willen maken met de selfservice Power BI toepassingen van MS Excel. De training richt zich op personen die, met de gekoppelde gegevens uit andere bronnen, data modellen maken en onderhouden

Voorkennis :

Vaardigheden op het niveau van MS Excel op gevorderd of expert.
Ervaring met van database techniek met draaitabellen.
Indien deze vaardigheden ontbreken, adviseren wij je om eerst de cursus MS Excel Gevorderd te volgen.
En de volgende cursussen:

  • Excel Gevorderd

Onderwerpen :


- PowerPivot
   - Verbindingen maken en aanpassen met een SQL database, waarmee een datamodel wordt gemaakt. Tabellen toevoegen vanuit een bestaande verbinding of andere bron. Gegevens typen en regionale instellingen. Een Excel werkblad koppelen met het data model. Hiërarchieën maken met behulp van DAX berekeningen. Gegevens toevoegen aan het model met behulp van DAX berekeningen (bijvoorbeeld: YTD omzet, KPI's).
- PowerView
   - Het maken van visualisaties met behulp van het gemaakte data model. Standaard veldenset, tabelgedrag aanpassen. Een visueel rapport (dashboard) maken met verschillende objecten zoals: Titel en logo, Slicer/filters, Tabel, Grafieken
- PowerMap
   - Het maken van geanimeerde visualisaties. Een PowerMap tour maken, waarmee ook een video (MP4) gemaakt kan worden.
- PowerQuery
   - Gegevens inlezen uit een SQL database. Query Folding. Gegevens bewerken: Kolommen verbergen en aanpassen, Query's samenvoegen (Joins). Een gegevens bron hergebruiken. Gegevens typen aanpassen. Null waarden verwijderen. Kolommen samenvoegen/splitsen. Gegevens inlezen vanuit Excel. Functies waaronder: NumberToText. Csv/tekst-bestanden inlezen en aanpassen (enkelvoudig of vanuit een map). Een functie maken met M-script. Query gegevens aan een data model toevoegen.
- Power BI Desktop (applicatie)
   - Gegevens ophalen vanuit een SQL Server database. Query's samenvoegen, Excel gegevens toevoegen, relaties van het model controleren en aanpassen, Visualisaties maken van verschillende bronnen

Start Business Management Courses Today.

XADAT.COM offers a range of short courses in London and Amsterdam including ERP for beginners, performance management, kpi, business intelligence tools, data warehousing, bi roadmap, analytics, big data, become a business analyst, become a data analyst, BI systems, BI Architecture, information visualization, business intelligence competency Center, Scrum methodology, Mobile BI, individual courses. Apply today!

 

Business Management Courses 1: ERP

This course is designed beginners working with and around ERP system. This material approaches real-world ERP system topics using an integrated process perspective of an organisation. Click “here” Download brochure ERP systems. Or contact XADAT.COM.

 

Business Management Courses 2: Performance management

This Course combines technical and social know-how to give you a solid framework for designing, configuring, and managing performance improvement initiatives with sustainable results. Managing Business Performance offers a unique blueprint for achieving organisational excellence through improved productivity, and efficiency.

Click “here” Download brochure Performance management. Or contact XADAT.COM.

 

performance management key performance indicators 2016

Business Management Courses 3: Business Intelligence Tools

Business Intelligence is a technology, system that provide managers to makeing desscions based on Data. End rsults ar performance dashboards, performance tools. companies with usefull visual guide to developing an effective business intelligence (BI) decision-support application. This book outlines a methodology that takes into account the complexity of developing applications in an integrated BI environment.

Business Management Courses 4: Data warehousing

This course focuses on how and why to modenize your data warehousing architecture. Also we will discuss workloads, what they mean in the world of data warehousing and Big Data. This is one of the most important and critical aspects of the future architecture of data management solution. Especially we discuss the data warehouse appliance, cloud computing, introduction of data visualization, and in-memory.

data warehousing what is data warehousing

Business Management Courses 5: Business Intelligence Strategy

business intelligence strategy-bi strategy

 

Business Management Courses 6: Business analyst

In course you will learn to be a Business Analyst. The business analyst is liaison between business stakeholders and the technical team (vendors. software developers, etc.) This course will deliver you usefull methodics, tools, tables, interview questions, checklist, templates that business analyst can use by day-to-day business .

business analyst business analyst course

 

Business Management Courses 7: Data visualization

This course will help you turn your data into high impact visual stories that stick with your audience. Epecifically, you’ll learn how to understand the importance of context and audience. Also we will focuss on determine the appropriate type of graph for your situation. Get started with direct attentions on your audience’s attention to the most important parts of your data. You will learn think like a designer and utilize concepts of design in data visualization.

 

Data visualization BI tools

Business Management Courses 8: Business Intelligence Competency Center Dashboard

  • Business Intelligence Organizations Trends
  • How Design Data driven Business Intelligence Organisation ?
  • What is Business Inteligence Competency Center?
  • Implementing Business Intelligence Competency Center Information Evolution Model
  • Change Management & BICC
    • Human Capital
    • Culture
    • Infrastucture
    • Customer Services
  • Best Practice Business Cases

Business Intelligence Competency Center Dashboard

 

Business Management Courses 9: Scrum Methdology

In this course you will learn about most popular agile methodologies today in 2016.

In this course you will understanding IT project management methodic for example: Agile, Scrum, XP, Lean, and, Kanban.

  • On time delivery of Agile projects
  • Deliver high-quality software system via Agile
  • Working in Agile teams

 

Business Management Courses 10: Mobile Analytics, Mobile App Analytics

mobile analytics
mobile app analytics

 

Business Management Courses skills

ERP, Performance management, Business Intelligence Tools, Data warehousing, Business Intelligence Strategy, Business analyst, Data visualization, Business Intelligence Competency Center, Dashboard, Scrum, Mobile Analytics, leadership, training, business ideas, communication skills, small business ideas, earn money online, dale, online courses, business administration, business management, leadership skills, small business, business development, carnegie learning online, carnegie learning, starting a business, online business, business class, training and development, business opportunities, presentation skills, business strategy, business school, business studies, management skills, business consultant, sales training, business degree, management courses, business management courses, online training, leadership training, customer service training, business coach, leadership development, business planning, business consulting, executive coaching, training courses, project management training, management training, business coaching, business courses, business opportunity, corporate training, business skills, communication skills training, business administration courses, business management course, training course, online training courses, online business courses, leadership courses, business degrees, business analyst training, hr training, training programs, train the trainer courses, train the trainer course, presentation skills training, business schools, business advice, staff training, management training programs, skills training, business course, business administration course, business education, business training, employee training, corporate trainer, business colleges, professional training, small business courses, business classes, management training courses, business courses online, change management training, leadership training programs, sales training courses, sales training programs, communication training, business leadership, business college, risk management training, manager training, training companies, corporate training companies, negotiation skills training, leadership course, business certificate, business analysis training, business study, supervisor training, business programs, leadership development training, business seminars, leadership seminars, degree in business, business universities, executive training, negotiation training, management classes, training development, business development courses, training company, business management skills, sales management training, corporate training programs, training skills, online business classes, training providers,

Business Management Courses Regio

Shanghai Pudong, China, Pakistan, Beijing, Municipality, Delhi, India. Lagos, Nigeria, Tianjin, China, Istanbul, Metropolitan, Turkey, Tokyo, Japan, Guangzhou, China, Mumbai, Moscow, Russia, São Paulo, Brazil, Shenzhen, Jakarta, Indonesia, South Korea, Kinshasa Democratic Republic, Congo, Egypt, Lahore, Badshahi, Mosque, Pakistan, Mexico, Lima, Peru, New York, United States London, UK, United Kingdom, Bengaluru, India, Bangkok, Thailand, Amsterdam

Amsterdam, Badshahi, Bangkok, Beijing, Bengaluru, Brazil, business administration, business administration course, business administration courses, business advice, business analysis training, business analyst, business analyst training, business certificate, business class, business classes, business coach, business coaching, business college, business colleges, business consultant, business consulting, business course, business courses, business courses online, business degree, business degrees, business development, business development courses, business education, business ideas, Business Intelligence Competency Center, business intelligence strategy, business intelligence tools, business leadership, business management, business management course, business management courses, business management skills, business opportunities, business opportunity, business planning, business programs, business school, business schools, business seminars, business skills, business strategy, business studies, business study, business training, business universities, carnegie learning, carnegie learning online, change management training, China, communication skills, communication skills training, communication training, Congo, corporate trainer, corporate training, corporate training companies, corporate training programs, customer service training, dale, Dashboard, Data visualization, data warehousing, degree in business, Delhi, earn money online, Egypt, employee training, ERP, executive coaching, executive training, Guangzhou, hr training, India, India. Lagos, Indonesia, Istanbul, Jakarta, Japan, Kinshasa Democratic Republic, Lahore, leadership, leadership course, leadership courses, leadership development, leadership development training, leadership seminars, leadership skills, leadership training, leadership training programs, Lima, london, management classes, management courses, management skills, management training, management training courses, management training programs, manager training, Metropolitan, Mexico, Mobile Analytics, Moscow, Mosque, Mumbai, Municipality, negotiation skills training, negotiation training, New York, Nigeria, online business, online business classes, online business courses, online courses, online training, online training courses, Pakistan, performance management, Peru, presentation skills, presentation skills training, professional training, project management training, risk management training, Russia, sales management training, sales training, sales training courses, sales training programs, São Paulo, Scrum, Shanghai Pudong, Shenzhen, skills training, small business, small business courses, small business ideas, South Korea, staff training, starting a business, supervisor training, Thailand, Tianjin, Tokyo, train the trainer course, train the trainer courses, training, training and development, training companies, training company, training course, training courses, training development, training programs, training providers, training skills, Turkey, UK, United Kingdom, United States LondonEdit

Search for:Recent Posts

  • Performance Management
  • Mobile Analytics Amsterdam London
  • Data warehousing Amsterdam London
  • Business intelligence tools Amterdam London
  • Performance management Amsterdam London

Recent Comments

Archives

  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • November 2015

Categories

  • 2016
  • agile bi methodology
  • Amsterdam
  • analytics
  • bi consultant
  • bi objects
  • bi reporting tools
  • bi sap
  • big data
  • big data etl tools
  • bobj
  • bobj business objects
  • Business Analyst
  • business analytics courses
  • Business Intelligence Analyst
  • business intelligence applications
  • Business Intelligence Competency Center
  • business intelligence consultants
  • business intelligence courses
  • business intelligence implementation plan
  • business intelligence purpose
  • business intelligence reporting
  • Business intelligence resume
  • business intelligence strategy
  • business intelligence support
  • business intelligence system
  • business intelligence system components
  • business intelligence systems
  • business intelligence systems definition
  • business intelligence team
  • business intelligence tools
  • business intelligence vision statement examples
  • business object
  • business object sap
  • business objects 4.1
  • business objects partners
  • business objects reporting
  • business objects reporting software
  • business objects reporting tutorial
  • business objects universe
  • business objects web intelligence
  • BUSINESS-OBJECTS-TUTORIAL
  • Dashboard
  • Data Analyst
  • data business intelligence
  • data etl
  • data integration tools
  • data integrator tool
  • Data visualization
  • data visualization service
  • Data warehousing
  • data warehousing tools
  • datastage etl
  • ERP
  • etl architecture
  • etl concepts
  • etl data quality
  • etl datastage
  • etl definition
  • etl developer
  • etl development
  • etl for big data
  • etl full form
  • etl job
  • etl meaning
  • etl means
  • etl process
  • etl programmer
  • etl software
  • etl sql
  • etl sql server
  • etl systems
  • etl testing
  • etl tools
  • etl tools list
  • free sap training
  • how to build a business intelligence system
  • key performance indicators
  • list of data integration tools
  • London
  • Mobile Analytics
  • performance management
  • sap
  • sap bi
  • sap bi bo
  • sap bi bw
  • sap bi certification
  • SAP BI Consultant Amsterdam
  • sap bi on hana
  • sap bi reporting tools
  • sap bi reports
  • sap bi training
  • sap bi tutorial
  • sap bi versions
  • sap bo
  • sap bo mobile
  • sap bo web intelligence
  • sap bobj
  • sap business intelligence software
  • sap business object
  • sap businessobjects
  • sap bw 7.4
  • sap bw basics
  • sap bw hana
  • sap bw on hana
  • sap bw reporting tools
  • sap bw training
  • sap bw tutorial
  • sap course
  • sap is retail
  • sap query
  • sap reporting
  • Scrum
  • sql etl
  • Uncategorized
  • use of business intelligence
  • what does etl stand for
  • What is Business Intelligence
  • What is data analysis
  • what is etl
  • what is etl testing
  • what is sap
  • what is sap bi
  • what is sap bw
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.
M Holten - SAP BI, BO
M Holten
SAP BI, BO
9

There are no frequently asked questions yet. Send an Email to info@springest.com