Power Pivot course - data analysis and modeling in Excel

Index: KRW-18456 EAN: 5903351245968
BOTLAND B. DERKACZ SPÓŁKA JAWNA Opinie z ekomi-pl.com
The Power Pivot - Data Analysis and Modeling in Excelcourse is a comprehensive study of data processing, analysis and modeling in Microsoft Excel spreadsheets. It includes 20 lectures, test questions, assignments and training.
€22.28
€18.11 tax excl.

Available
(Check quantity)
Shipping in 24 hours
30-day returns
PayPal payment
Manufacturer: Strefa kursów

Product description: Power Pivot course - data analysis and modelling in Excel

The Power Pivot - Data Analysis and Modeling in Excel course is a comprehensive study of data processing, analysis and modeling in Microsoft spreadsheets. An intermediate level online course. It touches on the details of the Power Pivot feature and add-in for Excel 2010, 2013 and 2016.

No work without Excel

The capabilities of Excel, popular since the late 1980s, don't need to be introduced to anyone - it's an industry-leading program for a wide range of office tasks. It forms the basis of MS Office skills and is used in countless tasks around the world. The course teaches how to retrieve data from sources such as Excel tables, other Excel workbooks, text and .csv files, and Microsoft Access databases.

You will receive the download instructions and code from us at the email address you provided when placing your order no later than the next business day after receiving your payment.



Power Pivot training presentation.

Przejrzysty układ treści kursu, ułatwiający naukę
A clear layout of the course contents to facilitate learning.

Why organize data?

The reason to clearly classify and organize data is the same as the reason to clean your apartment. Keeping your databases organized and supporting your analytical skills with specialized tools allows you to solve tasks faster and independently. Navigating office, business or IT issues becomes much easier - like navigating a well-organized catalog in a library. It is also hard to deny the general, but still true, statement that the skills related to Excel are still highly demanded on the job market and that the skills declared by candidates are often lower than in reality. With the course you will gain confidence that you really "know how to Excel".

What is Power Pivot?

Power Pivot is a feature of Microsoft Excel. It is available as an add-in in Excel 2010, 2013 in separate downloads and as an add-in included with Excel 2016. Power Pivot extends the local instance of Microsoft Analysis Services Tabular that is embedded directly into an Excel workbook. It remains an invaluable tool for modeling and analyzing data.

Overview of course content

  • Advanced data importing
  • Combining data from multiple sources
  • Creating relationships between tables
  • Organizing Big Data
  • Exporting Data to a Pivot Table
  • Refreshing Changed Data Sets
  • Automatic Relation Detection
  • Analyzing and processing data using DAX language

Power Pivot - a little-known Excel function with enormous possibilities.

Propozycja dla doświadczonych jak i poczatkujących uczestników

The course is a proposal for intermediate users.

For database enthusiasts and those who want to learn it

Prior to the release of Power Pivot, Microsoft relied heavily on SQL Server Analysis Services as the engine for its Business Intelligence suite. Power Pivot complements the core BI components of SQL Server within the vision of the Business Intelligence Semantic Model (BISM). It aims to integrate multidimensional analytics on disk formerly known as the Unified Dimensional Model (UDM) with a more flexible in-memory tabular model. As a self-service product, Power Pivot allows users to create data models and calculations without analytics skills and share them directly or through Microsoft SharePoint document libraries.

Course highlights

  • Unlimited access, including 24/7 mobile access
  • 3 hours of training
  • Tests and assignments
  • 20 lectures
  • 20 test questions
  • Certificate of completion

You can add your recommendations to your LinkedIn profile

Full curriculum

1 Introduction

  • Introduction: 00 m 45 s
  • How to use the materials: 01 m 19 s
  • Data model and running the add-on: 05 m 33 s
  • Excel table: 07 m 38 s

2 Import and visualization

  • Data import: 14 m 59 s
  • Visualization in a pivot table: 05 m 51 s - see free lesson

3. Power Pivot Interface

  • Creating relationships: 15 m 02 s
  • Date operations: 14 m 56 s
  • Calculation columns and measures: 15 m 20 s
  • KPIs: 09 m 18 s

4 DAX languages

  • What is the DAX language: 09 m 49 s
  • Conditional instructions: 15 m 37 s
  • RELATED - "SEARCH VERTICALLY" alternative: 10 m 57 s
  • LOOKUPVALUE - "SEARCH VERTICALLY" alternative: 08 m 05 s
  • Calculate: 14 m 05 s
  • Unique values: 08 m 46 s - see free lesson
  • Date functions: 12 m 15 s
  • Time functions and format: 11 m 07 s
  • Text functions: 12 m 02 s
  • Termination: 00 m 45 s

Same-day shipping

  • Crediting the payment for the order on our account on a business day before 10:00 AM means sending the goods on the same day.
  • All packages are being delivered by GLS Group courier and covered with insurance up to 1200 EUR.
  • You will receive a link to track your package and monitor the progress of delivery as soon as it is shipped.

Terms of delivery 

GLS - zone 1

Austria, Belgium, Croatia, The Czech Republic, Denmark, Germany, Netherlands, Poland, Slovakia 

  • Delivery time: 2-4 days
  • Delivery cost: from 4.18 EUR
  • Insurance: 1200 EUR
GLS - zone 2

Bulgaria, Estonia, France, Hungary, Italy, Latvia, Lithuania, Luxembourg, Portugal, Romania, San Marino, Slovenia

  • Delivery time: 2-5 days
  • Delivery cost: from 5.35 EUR
  • Insurance: 1200 EUR
GLS - zone 3

Finland, Greece, Ireland, Lichtenstein, Spain, Sweden 

  • Delivery time: 2-7 days
  • Delivery cost: from 7.67 EUR
  • Insurance: 1200 EUR

Payment methods

Card image cap
PayPal
  • Botland is a PayPal verified seller. Protect your financial information with this fast, safe and secure online payment system.

Card image cap
PayU
  • Choose easy and quick PayU e-payment method. Your financial information will stay secure.

Products from the same category

Arduino StarterKit from scratch - with Arduino Uno module

A set of electronic components used in the video course "Arduino from scratch". The kit includes i.a.: LEDs, resistors, sensors, chips, and LCD display, the chassis of the...
Index: ARD-02596
Index: ARD-02596
In stock, shipping 24 hours!
(Check quantity)
Regular price €51.73 Price €51.73

Arduino video course - from the ground up - ON-LINE version

Video course is intended for novice Arduino users. Includes practical exercises on electronic circuits, the performance of which does not require a soldering iron. Electronic...
Index: KRW-02506
Index: KRW-02506
Available online!
(Check quantity)
Regular price €22.28 Price €22.28

Basic programming course for PLC controllers - ON-LINE version

The course is designed for people who know the basics of electrical engineering and want to master the basics of ladder language and enter the PLC world. In this course you...
Index: KRW-12702
Index: KRW-12702
Available online!
(Check quantity)
Regular price €20.03 Price €20.03

SketchUp course + V-Ray from scratch - ON-LINE version

This video course is designed for interior designers or those who are just planning to make a future for them.
Index: KRW-09614
Index: KRW-09614
Available, 24h shipping!
(Check quantity)
Regular price €31.28 Price €31.28

Video course Programming school in C language - ON-LINE version

The course is designed for beginners who want to quickly understand all the important C concepts and start creating their own programs. Classical C is a popular, versatile and...
Index: KRW-03303
Index: KRW-03303
Available
(Check quantity)
Regular price €22.28 Price €22.28

Android applications for non-programmers - ON-LINE

A video course showing the basics of creating Android applications. It does not require programming knowledge. It allows for the creation of games and programs from ready-made...
Index: KRW-08727
Index: KRW-08727
In stock, shipping 24 hours!
(Check quantity)
Regular price €17.78 Price €17.78

Android course - creating applications in practice - ON-LINE version

The course is designed for people who have finished the basic course of creating an application in Android, and want to expand their knowledge. This course describes how to,...
Index: KRW-09977
Index: KRW-09977
Czas oczekiwania: ok. 10-30 dni
Regular price €24.53 Price €24.53

Python programming foundations course - ON-LINE version

This course is designed for people who start programming in Python. With this course you will learn the basics of Python syntax, programming in the current version 3, the right...
Index: KRW-12225
Index: KRW-12225
Available, 24h shipping!
(Check quantity)
Regular price €20.03 Price €20.03

Java Foundation course - ON-LINE version

With this course, you will learn the most important elements of the language, you will see how to properly configure IDE and text editor, you will learn to use the basic...
Index: KRW-09288
Index: KRW-09288
In stock, shipping 24 hours!
(Check quantity)
Regular price €26.78 Price €26.78

GIMP course from scratch - ON-LINE version

A video course explaining the use of Gimp and the secrets of editing graphics. It will learn how to edit and improve images, show how to work with layers, masks, filters and...
Index: KRW-08607
Index: KRW-08607
Available, 24h shipping!
(Check quantity)
Regular price €20.03 Price €20.03

Basic computer course - ON-LINE version

Video course allows you to learn basic computer and Internet maintenance, it is for all people, regardless of age, who have a problem with that.
Index: KRW-09276
Index: KRW-09276
In stock, shipping 24 hours!
(Check quantity)
Regular price €11.03 Price €11.03

Unity course - making 2D games - ON-LINE version

The course allows you to learn and understand the process of creating games in 2D and to build the game on mobile devices using the Unity environment.
Index: KRW-09998
Index: KRW-09998
In stock, shipping 24 hours!
(Check quantity)
Regular price €20.03 Price €20.03