Microsoft Power BI Comprehensive 2 Days Training in La Laguna - Nov 2021

-

Course Overview:

Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.

Target Audience:

The Power BI training is for all the professionals who are passionate about business intelligence, data visualization, and data analytics.

  • Business Analysts
  • Business Intelligence Manager
  • Statisticians and Analysts
  • Data Scientists
  • Project Managers

Learning Objectives:

  • Understand primary features of a self-service Power BI solution
  • Utilize Power BI and its data sources
  • Combine, analyze, model, shape, and visualize data
  • Report data using rich dashboards

Prerequisites:

There are no prerequisites for this course.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

No Exam

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Agenda:

Day 1: Power BI for Report Developers

  • Overview of Power BI (Desktop & Service)
  • Architecture modes: Import, Direct Query, Composite and Live
  • Data cleansing, shaping and transformation
  • Using M language in Power Query
  • Dimensional modelling concept – Star schema
  • Power BI data modelling
  • Measure and calculated column
  • DAX aggregator and iterator formulas
  • Developing reports by standard and custom visuals
  • Advanced visualization tricks: Bookmark, Q&A, color themes,
  • Sharing and collaborating reports in Power BI Service
  • Creating Dashboard
  • Hands on lab practices

Day 2: Mastering in DAX and Data Modelling

  • Dimensional modelling
  • Star schema – Snowflakes
  • Data modelling scenarios
  • Tables relationship scenarios
  • Slowly changing dimension
  • Introduction to DAX
  • DAX Evaluation, Filter and Row contexts
  • DAX functions – Aggregator/Iterator
  • Deep dive to Calculate function
  • DAX Time Intelligence
  • DAX table functions
  • Querying data by DAX
  • Hands on lab practices

 

Date and time:

Location:

The venue will be announced soon

Aguascalientes

Aguascalientes, AGU 10119

Mexico

 

Price :  

MX$29,888.12 – MX$36,247.52 

 

Refund policy:

Refunds up to 7 days before event

 

Tickets :  Microsoft Power BI Comprehensive 2 Days Training in La Laguna

Comments

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

-
TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks) ------------------------------ ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.SmoExtended) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Procedure 1: 1. Right click Databases 2. Restore Database... 3. [General] Source from Device, select the bak file 4. [General] Change the Destination database name to a new name 5. [Files] Change mdf and ldf Restore As paths to a different, new path 6. [Options] (unnecessary on the other computer) Check Overwrite the existing database (WITH_REPLACE) 7. [Options] (unnecessary on the other computer) ...
Read more

Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS

-
Error: Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS Solution 1: 1. Right click on source task. 2. click on "Show Advanced editor". -- advanced edit option for source task in ssis 3. Go to "Input and Output Properties" tab. 4. select the output column for which you are getting the error. 5. Its data type will be "String[DT_STR]". 6. Change that data type to "Unicode String[DT_WSTR]". --Changing the data type to unicode string 7. save and close. Solution 2: Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings. You need to do this for all the string columns
Read more